[SOLVED] Display BY column

Focal Point

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

March 03, 2011, 05:09 PM

[SOLVED] Display BY column

Hi,
Is there a way to display the BY column in the middle of the columns like below


NAME  DEPT  SAL
AA    10    100
BB          200
CC          300
DD    20    400
EE          500
FF          600

Thanks Alot,
Ram.

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

WebFocus 7.7.01
Desktop: Windows and Server: Unix
Excel, HTML, PDF

March 03, 2011, 05:28 PM

Francis Mariani

Use SEQUENCE to change the column order:

TABLE FILE CAR
SUM
SALES
BY COUNTRY
BY CAR

ON TABLE SET STYLE *
TYPE=REPORT, COLUMN=COUNTRY, SEQUENCE=3, $
ENDSTYLE
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

March 03, 2011, 06:33 PM

Thanks Francis!! It worked.

WebFocus 7.7.01
Desktop: Windows and Server: Unix
Excel, HTML, PDF