Focal Point
Position row-total in report

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

January 22, 2008, 09:18 AM
Atilla
Position row-total in report
I wonder if there is a way to position the row-total column on a different position then at the end of a report.
F.e.
C1 C2 C3 Total
xxxxxx 1 1 1 3

Can I position the Total column as the first column.
Total C1 C2 C3
xxxxxx 3 1 1 1

Atilla

This message has been edited. Last edited by: Atilla,


Member of Benelux
Usergroup
January 22, 2008, 09:35 AM
Alan B
Try this:
TABLE FILE CAR
SUM RCOST DCOST ROW-TOTAL
BY COUNTRY
ON TABLE SET STYLE *
TYPE=REPORT, COLUMN=C3, SEQUENCE=1,$
TYPE=REPORT, COLUMN=C1, SEQUENCE=9,$
TYPE=REPORT, COLUMN=C2, SEQUENCE=8,$
TYPE=REPORT, COLUMN=B1, SEQUENCE=12,$
ENDSTYLE
END



Alan.
WF 7.705/8.007
January 22, 2008, 09:43 AM
Francis Mariani
Use the SEQUENCE style attribute:

TABLE FILE CAR
SUM
SALES
RETAIL
ROW-TOTAL
BY COUNTRY
BY MODEL

ON TABLE SET STYLESHEET *
FONT='ARIAL', SIZE=8, $
TYPE=REPORT, COLUMN=ROWTOTAL, COLOR=RED, SEQUENCE=1, $
END



Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
January 23, 2008, 05:02 AM
Atilla
Hi Francis, Alan,

None of the solutions you provided works.

What I did not tell you (I just forgot it) is that it is an ACROSS report.

Your suggestions are welcome


Member of Benelux
Usergroup
January 23, 2008, 05:40 AM
Alan B
You might have to be a bit more creative then. If it is a simple across, then this approach may work:
TABLE FILE CAR
SUM RCOST AS 'TOTAL' BY COUNTRY
SUM RCOST
BY COUNTRY
ACROSS SEATS
ON TABLE SET STYLE *
TYPE=REPORT, COLUMN=C1, SEQUENCE=1,$
ENDSTYLE
END


Otherwise we might have to rely on Francis to come up with something from his repertoire.


Alan.
WF 7.705/8.007