Focal Point
Change column order in a cross-tab multi-verb report

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

May 13, 2008, 02:22 PM
<Steven>
Change column order in a cross-tab multi-verb report
I have a cross-tab report created using the multi-verb technique as shown below:

TABLE FILE CAR
SUM DEALER_COST
BY COUNTRY
SUM SALES
BY COUNTRY
ACROSS BODYTYPE AS 'BODYTYPE' ACROSS-TOTAL AS 'Total Sales'
ON TABLE COLUMN-TOTAL AS 'Total'
END

I want to figure out how to get the DEALER_COST column to position besides the 'Total Sales' column. In addition, I need to have another compute field based on the values of the DEALER_COST column and the values of the 'Total Sales' column.

Please help.

Thanks
May 13, 2008, 02:32 PM
Darin Lee
throw this in before the END statement:
ON TABLE SET STYLE *
TYPE=REPORT, COLUMN=N2, SEQUENCE=99,$
ENDSTYLE


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
May 13, 2008, 02:36 PM
Darin Lee
As for the next question, you could do this with a simple compute in the first verb phrase:

COMPUTE PROFIT/D12.2=SALES - DEALER COST;


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