Focal Point
[solved]Is it possible to move BY field to the right of the ACROSS columns?

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

March 07, 2013, 07:26 AM
bug
[solved]Is it possible to move BY field to the right of the ACROSS columns?
Let's say I have a table like this:

COL_A, COL_B, COL_AMOUNT, COL_REGION

I want the output to be


         (ACROSS REGION)
COL_A    (COL_AMOUNT)    COL_B

How can I do that?

Thanks

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


7.66 and 7.704
System: Windows / AIX / Linux
Output: Mostly HTML, with some PDF, Excel and Lotus(!)
March 07, 2013, 10:34 AM
Rao D
Not sure if this is an effective way or not but this works.

TABLE FILE CAR
SUM
SALES
BY COUNTRY
BY CAR
ACROSS SEATS
ON TABLE HOLD AS AAA
END
?FF AAA
TABLE FILE AAA
PRINT
E01
E03
E04
E05
E02
END


WebFOCUS - ver8201
[ReportingServers: Windows 64bit;
Client: tomcat and IIS on windows 2012
AppStudio

March 07, 2013, 11:14 AM
Francis Mariani
Look at

Changing Column Order

Syntax: How to Change Column Order
This syntax applies to PDF, PS, HTML, and EXL2K reports.

[TYPE=REPORT,] COLUMN=identifier, SEQUENCE=sequence, $

==========================================================

Example:

SET BYDISPLAY=ON
TABLE FILE CAR
SUM
SALES
ACROSS COUNTRY
BY CAR
BY MODEL

ON TABLE SET STYLE *
TYPE=REPORT, SQUEEZE=ON,
FONT='ARIAL', SIZE=9, $

TYPE=REPORT, COLUMN=MODEL, SEQUENCE=99, $
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 07, 2013, 12:11 PM
Rao D
Augh! Sequence that's a took technique. Used it long back.

Forums are a good memory refreshers too! Smiler


Rao.


WebFOCUS - ver8201
[ReportingServers: Windows 64bit;
Client: tomcat and IIS on windows 2012
AppStudio

March 07, 2013, 12:59 PM
bug
Oh the first time I know of sequence! Big thanks!


7.66 and 7.704
System: Windows / AIX / Linux
Output: Mostly HTML, with some PDF, Excel and Lotus(!)