Hi My code is TABLE FILE CAR SUM SEATS AS 'DYNAMIC TITLE AS COUNTRY' ACROSS COUNTRY NOPRINT BY CAR END
I need to print the dynamic country where it says 'DYNAMIC TITLE AS COUNTRY' How can i achieve this so that i get 'DYNAMIC TITLE AS COUNTRY' in the same row as CAR Title?
Please suggest.This message has been edited. Last edited by: Kerry,
March 03, 2009, 04:04 AM
Danny-SRL
-* File BB1.fex TABLE FILE CAR SUM SEATS/I6 AS 'DYNAMIC TITLE AS COUNTRY' ACROSS COUNTRY NOPRINT BY CAR END
Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
March 03, 2009, 05:54 AM
GamP
Explanation: If you do an across with one SUM or PRINT field, then the column heading for that field will be omitted, since you are always sure what the values represents (it's always sales, or profit or ...). By recomputing the field (SEATS/I6) a second field is introduced forcing the column heading to appear for both fields. But, since the original database field is recomputed, it automatically becomes NOPRINTed.
GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
March 03, 2009, 08:38 AM
BarryS
Try this and see if its good for you: TABLE FILE CAR SUM SEATS AS 'DYNAMIC TITLE AS COUNTRY' ACROSS COUNTRY NOPRINT BY CAR AS ' ' HEADING "<+0> CAR <+0> DYNAMIC TITLE AS COUNTRY"
ON TABLE PCHOLD FORMAT HTML ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * TYPE=HEADING, HEADALIGN=BODY, $ TYPE=HEADING, OBJECT=TEXT, ITEM=1, POSITION=N1, $ TYPE=HEADING, OBJECT=TEXT, ITEM=2, POSITION=N3,COLSPAN=5,$ ENDSTYLE END
WebFOCUS 8103, Windows, App Studio
March 03, 2009, 09:19 AM
Laure
B_B, Please try this. SET ASNAMES=ON TABLE FILE CAR SUM SEATS AS '' BY CAR ACROSS COUNTRY ON TABLE HOLD AS ACROSSH FORMAT ALPHA END TABLE FILE ACROSSH PRINT * END