Focal Point
[CLOSED] Adding Dynamic Titles to ACROSS FIELDS

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

March 03, 2009, 12:56 AM
<B_B>
[CLOSED] Adding Dynamic Titles to ACROSS FIELDS
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


Laure


Prod: WebFOCUS 7.7.03 - MRE, BID, - WindowsXP - Oracle 9i, SQLServer, DevStudio 7.7.3 - Apache Tomcat , Output: HTML, Excel 2013 and PDF