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.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
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.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
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