I have a subfoot with a st.cnt to count the number of rows for a given column.
However, I don't want this to appear at the BOTTOM of the break, but rather the top. So the summary shows first, and then the detail.
Anyone have any idea how I can achieve this?This message has been edited. Last edited by: Kerry,
Version: 8.0.0.6 Windows platform All output formats will probably be used.
July 29, 2009, 02:09 PM
jimster06
on sortbreak subhead comes to mind
jimster06 DevStu WF 7.6.11 W7 HTML, PDF, EXL2K
July 29, 2009, 02:15 PM
Darin Lee
It would have to go in a subhead as jimster suggests, but you would have to calculate the totals using a multiverb request first - otherwise you would just get the value of the first line. Here's an example:
-* File car.fex
TABLE FILE CAR
SUM RCOST NOPRINT
COMPUTE ST_RCOST/D12.2=RCOST; NOPRINT
COMPUTE CT_MODEL/I9=CNT.MODEL; NOPRINT
BY COUNTRY
PRINT CAR MODEL RCOST ST_RCOST NOPRINT
BY COUNTRY NOPRINT
ON COUNTRY SUBHEAD
"Number of Models for Country <COUNTRY =<CT_MODEL Total Cost:$<ST_RCOST"
END
Regards,
Darin
In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat