Focal Point
[SOLVED] Set PAGESIZE issue

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

September 25, 2012, 03:39 PM
May
[SOLVED] Set PAGESIZE issue
Hi,

I have a compound report, which contains over 10 reports. Most of reports are letter size, there is one report with legal size. I used the SECTION DECLARATION, but didn't put PAGESIZE. So, does it mean the PAGESIZE will be picked within ON TABLE SET STYLE session?

As per following example should I get Sales COMPONENT in letter size and the Fuel COMPONENT in Legal size?

Here is the example:

SET PAGE-NUM=OFF
COMPOUND LAYOUT PCHOLD FORMAT PDF
SECTION=S1, LAYOUT=ON, MERGE=ON, ORIENTATION=LANDSCAPE, $
PAGELAYOUT=1, $
COMPONENT=Sales, TYPE=REPORT, POSITION=(1 1), DIMENSION=(4 4), $
COMPONENT=Fuel, TYPE=REPORT, POSITION=(6.25 1), DIMENSION=(4 4), $
END
SET COMPONENT=Sales
TABLE FILE CAR
"Sales report for " "
SUM SALES
BY COUNTRY NOPRINT
BY CAR BY MODEL
ON TABLE HOLD FORMAT PDF
ON TABLE SET STYLE *
UNIT=IN, PAGESIZE='Letter',$
TYPE=REPORT, FONT=HELVETICA, COLOR=RED, SQUEEZE=ON, $
END
SET COMPONENT=Fuel
TABLE FILE CAR
"Fuel efficiency report for " "
BY COUNTRY NOPRINT
BY HIGHEST MPG
BY CAR BY MODEL
ON TABLE HOLD FORMAT PDF
ON TABLE SET STYLE *
UNIT=IN, PAGESIZE='Legal',$
TYPE=REPORT, FONT=HELVETICA, COLOR=BLUE, SQUEEZE=ON, $
END
COMPOUND END


Thanks

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


May

WebFOCUS 7.6.8 Servlet
- MRE/BID/Self Service/ReportCaster
- MS Windows Server 2003
- MS SQL Server 2005
- DataMigrator 7.6.9
September 25, 2012, 05:56 PM
Waz
I had a similar issue recently, and IBI said that they currently do not support multiple page sizes in a compound report.

Our solution was to use PDFBox to concat two separate reports together,


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!

September 27, 2012, 08:54 AM
May
Thanks Waz.


May

WebFOCUS 7.6.8 Servlet
- MRE/BID/Self Service/ReportCaster
- MS Windows Server 2003
- MS SQL Server 2005
- DataMigrator 7.6.9