Focal Point
[CLOSED] Subtotal on Top?

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

July 29, 2009, 12:50 PM
Kowens
[CLOSED] Subtotal on Top?
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