Focal Point
How to display a title among columns..???

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2671011071

May 31, 2006, 05:43 PM
MARIELOS
How to display a title among columns..???
Hi, I need to display a title among three columns, would you like to help me.

Thanks...!
May 31, 2006, 05:52 PM
Nightowl
Sure I would like to help you Wink
Can you supply a bit more information or perhaps provide a small sample of the output?


Using: WF 7.1.5, XP Pro, Tomcat, Self Serve
May 31, 2006, 05:58 PM
MARIELOS
Thanks Nightowl I need an output something like this:

GENERAL EMPLOYEE INFORMATION
AGE SALARY HIRE_DATE
--- ----- ---------

So I have three columns and I need to display the title refering to this columns...!
May 31, 2006, 06:09 PM
Nightowl
Are you using HTML, PDF or EXCEL for your output format? It looks to me like you could use the last line in the header area to accomplish this.


Using: WF 7.1.5, XP Pro, Tomcat, Self Serve
May 31, 2006, 06:10 PM
MARIELOS
PDF...!!
May 31, 2006, 06:13 PM
Nightowl
Have you tried the last line in the header area.
Example:
HEADING
"COMPANY"
"REPORT NAME"
" "
"GENERAL EMPLOYEE INFORMATION"


Using: WF 7.1.5, XP Pro, Tomcat, Self Serve
May 31, 2006, 06:19 PM
MARIELOS
In fact I'm using a general heading refering the name of the report, so I need this title like join with the columns title...!!

Excuse me I would like to send you a file specifying details...may I..?? your e-mail..?? of course if you let me...!!

Thank you...!!
June 01, 2006, 09:04 AM
Kamesh
Hi Marielos,
I believe this is the one you are looking for.

TABLE FILE CAR
HEADING
"TEST COMMON HEADING"
"FIRST 3 COLUMNS<+0>SECOND 2 COLUMNS"
PRINT CAR COUNTRY BODYTYPE MODEL DEALER_COST
ON TABLE SET STYLE *
TYPE=REPORT, GRID=OFF,$
TYPE=HEADING,HEADALIGN=BODY,$
TYPE=HEADING,LINE=2,OBJECT=TEXT,ITEM=1,COLSPAN=3,COLOR=GREEN,$
TYPE=HEADING,LINE=2,OBJECT=TEXT,ITEM=2,COLSPAN=2,COLOR=RED,$
ENDSTYLE
END
-EXIT

Hope this helps,


WFConsultant

WF 8105M on Win7/Tomcat
June 01, 2006, 10:58 AM
Nightowl
That will work for HTML but not PDF Frowner


Using: WF 7.1.5, XP Pro, Tomcat, Self Serve
June 01, 2006, 11:24 AM
Kamesh
For PDF, you can directly mention the column position. Like,

TABLE FILE CAR
HEADING
"TEST COMMON HEADING"
-IF &DISPFORMAT EQ 'PDF' THEN GOTO SHOWPDF ELSE GOTO SHOWHTML;
-SHOWPDF
"<1FIRST 3 COLUMNS<30>SECOND 2 COLUMNS"
-GOTO ENDSHOW;
-SHOWHTML
"FIRST 3 COLUMNS<+0>SECOND 2 COLUMNS"
-ENDSHOW
PRINT CAR COUNTRY BODYTYPE MODEL DEALER_COST
ON TABLE SET STYLE *
TYPE=REPORT, GRID=OFF,$
-IF &DISPFORMAT EQ 'PDF' THEN GOTO SKIPTHIS;
TYPE=HEADING,HEADALIGN=BODY,$
TYPE=HEADING,LINE=2,OBJECT=TEXT,ITEM=1,COLSPAN=3,COLOR=GREEN,$
TYPE=HEADING,LINE=2,OBJECT=TEXT,ITEM=2,COLSPAN=2,COLOR=RED,$
-SKIPTHIS
ENDSTYLE
END
-EXIT

Hope this helps,


WFConsultant

WF 8105M on Win7/Tomcat