Focal Point
[SOLVED] Wide ACROSS Report

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

June 13, 2011, 03:34 PM
vaayu
[SOLVED] Wide ACROSS Report
Gurus,
I was wondering if anyone had encountered an idea if you have a report with too many across columns so it can continue on the page over and then down continuing forward...almost like a multi-pane report. I have a report that SUMs three columns ACROSS YEAR since 1990.

Please advise..
  
TABLE FILE CAR
SUM SALES DEALER_COST
BY COUNTRY
ACROSS CAR
END


thanks!

This message has been edited. Last edited by: vaayu,
June 13, 2011, 06:22 PM
Waz
What format output ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

June 13, 2011, 08:08 PM
Jim Morrow
You can compute a column number and row number. when the column number reaches the maximum, increment the row number and set the column number back to one.

Hold the data and then do a table by column noprint across column noprint.


Jim Morrow
Web Focus 7.6.10 under Windows 2003
MVS 7.3.3



June 14, 2011, 04:54 PM
vaayu
Sorry for the delay..The output right now is PDF.

@Jim/ Do you have a sample. I am not sure I followed your idea. Please elaborate with a sample.
June 14, 2011, 05:52 PM
Waz
I assume you can't just let the report panel ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

June 17, 2011, 01:45 PM
vaayu
@WAZ, Thanks for the tip..I have never used this option and it seems like this is a good fit..

 

SET PANEL=130, LINES=10, PAGE=OFF
TABLE FILE CAR
SUM DEALER_COST SALES
BY CAR
ACROSS COUNTRY
ON TABLE SET ONLINE-FMT STANDARD
END