[SOLVED] Compound Report - Page Break between reports - PDF
Can you create a page break between compound reports, so that each report starts on a new page? I am using a TOC in a compound report (3 reports) and when I click to select the 2nd report my page header ends on the page of the previous report, which makes it so that you have to page down to see the top set of data.This message has been edited. Last edited by: Jay Potter,
WebFocus 8.1.5 iSeries/Windows DB2/SQL/Access Dev Studio App Studio Maintain ReportCaster
March 13, 2012, 03:30 PM
Jay Potter
FYI
I do not have a NOBREAK anywhere in my code.
WebFocus 8.1.5 iSeries/Windows DB2/SQL/Access Dev Studio App Studio Maintain ReportCaster
March 13, 2012, 05:24 PM
Venkat-
Hi Jay,
Try the example code below. Hope this what you're looking for. It runs in PDF format.
SET PAGE = OFF SET COMPOUND = ON -RUN TABLE FILE CAR BY CAR BY MODEL SKIP-LINE BY MPG BY DCOST BY RCOST BY RPM BY COUNTRY HEADING "REPORT 1" ON TABLE PCHOLD FORMAT PDF OPEN ON TABLE SET STYLE * ORIENTATION=LANDSCAPE, UNITS=IN, PAGESIZE='LETTER', LEFTMARGIN=0.25, RIGHTMARGIN=0.25, TOPMARGIN=0.1, BOTTOMMARGIN=0.1,$ ENDSTYLE END -RUN TABLE FILE CAR BY CAR BY MODEL SKIP-LINE BY MPG BY DCOST BY RCOST BY RPM BY COUNTRY HEADING "REPORT 2" ON TABLE PCHOLD FORMAT PDF OPEN ON TABLE SET STYLE * ORIENTATION=LANDSCAPE, UNITS=IN, PAGESIZE='LETTER', LEFTMARGIN=0.25, RIGHTMARGIN=0.25, TOPMARGIN=0.1, BOTTOMMARGIN=0.1,$ ENDSTYLE END -RUN SET COMPOUND = OFF TABLE FILE CAR BY CAR BY MODEL SKIP-LINE BY MPG BY DCOST BY RCOST BY RPM BY COUNTRY HEADING "REPORT 3" ON TABLE PCHOLD FORMAT PDF CLOSE ON TABLE SET STYLE * ORIENTATION=LANDSCAPE, UNITS=IN, PAGESIZE='LETTER', LEFTMARGIN=0.25, RIGHTMARGIN=0.25, TOPMARGIN=0.1, BOTTOMMARGIN=0.1,$ ENDSTYLE END
Regards, Venkat
product release:8203 o/s: windows 10 expected o/p formats: HTML,EXCEL,PDF
March 13, 2012, 05:26 PM
Waz
quote:
SET COMPOUND = ON
I thought it was SET COMPOUND = OPEN|CLOSE|NOBREAK
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!
March 13, 2012, 05:36 PM
Venkat-
Hi Waz,
Initially, I thought the same..but SET COMPOUND = ON seems to be working without any issue..
product release:8203 o/s: windows 10 expected o/p formats: HTML,EXCEL,PDF
March 13, 2012, 06:05 PM
Waz
I guess this is an undocumentated feature.
I would always suggest following what is documented, as if it fails one day, IBI won't support it.