I have a complex compound report where i am putting multiple reports together. But i am not just appending them one behind the other. I have 3 individual report processes that work fine and print 3 separate reports. They break on department.

OLD Rreports Look Like this:
>dept #100 from report 1
>page-break
>dept #200 from report 1
>page-break
>dept #300 from report 1
>end of report

>dept #100 from report 2
>page-break
>dept #200 from report 2
>page-break
>dept #300 from report 2
>end of report

>dept #100 from report 3
>page-break
>dept #200 from report 3
>page-break
>dept #300 from report 3
>end of report

I am trying to combine these 3 reports by grouping the department data from each report together.
For example: all 3 reports for dept #100 will be on the first page, all 3 reports for dept #200 will be on the second page, etc. Of course, each dept could have multiple pages.

>dept #100 from report 1
>dept #100 from report 2
>dept #100 from report 3
>page-break
>dept #200 from report 1
>dept #200 from report 2
>dept #200 from report 3
>page-break
>dept #300 from report 1
>dept #300 from report 2
>dept #300 from report 3
...etc.

The problem is that i can't get the page-break between the departments in the compound report to work. If i choose not to have a Format on the PCHOLD the report will display in the webbrowser with no page-breaks at all. It is all back to back. I guess that is because it defaults to HTML which does not have page-breaks???
But when i choose PCHOLD FORMAT PDF, i get page breaks on every report section. Each Dept can have multiple sections and should not have a page-break between them. Each change in dept should have a page-break. Hard to explain.

Has anyone run into this issue?
We are on WebFocus 7.69.

Code looks like this:
****MAIN PROCESS*****
SET COMPOUND = OPEN NOBREAK
-REPEAT :RPTSBYDEPT &LOOPLINES TIMES
-SET &LINECNT = &LINECNT + 1;

-READ DEPTLIST &HSPA3.A3 &DEPTS.A5
-INCLUDE REPORT1
-INCLUDE REPORT2
-IF &LINECNT NE &LOOPLINES THEN GOTO :NOCLOSE;
SET COMPOUND = CLOSE
-:NOCLOSE
-INCLUDE REPORT3
-:RPTSBYDEPT
*****END MAIN PROCESS****

*****REPORT1*****
TABLE FILE FILE1
PRINT
X1 AS 'FEB 2011'
X2 AS 'MAR 2011'
X3 AS 'APR 2011'
BY DEPTS NOPRINT
BY MAJ_CATG NOPRINT
BY MAJ_SUB NOPRINT
ON MAJ_CATG SUBTOTAL AS '*TOTAL MAJ_CATG'
ON MAJ_SUB SUBTOTAL AS 'TOTAL'

ON DEPTS PAGE-BREAK

HEADING
""DETAIL"
IF DEPTS EQ &DEPTS
ON TABLE PCHOLD FORMAT PDF
*****END REPORT1*****

*****REPORT2*****
TABLE FILE FILE2
PRINT
Y1 AS 'FEB 2011'
Y2 AS 'MAR 2011'
Y3 AS 'APR 2011'
BY DEPTS NOPRINT
BY MAJ_CATG NOPRINT
BY MAJ_SUB NOPRINT
ON MAJ_CATG SUBTOTAL AS '*TOTAL MAJ_CATG'
ON MAJ_SUB SUBTOTAL AS 'TOTAL'

HEADING
""SUMMARY2"
IF DEPTS EQ &DEPTS
ON TABLE PCHOLD FORMAT PDF
*****END REPORT2*****

*****REPORT3*****
TABLE FILE FILE3
PRINT
Z1 AS 'FEB 2011'
Z2 AS 'MAR 2011'
Z3 AS 'APR 2011'
BY DEPTS NOPRINT
BY MAJ_CATG NOPRINT
BY MAJ_SUB NOPRINT
ON MAJ_CATG SUBTOTAL AS '*TOTAL MAJ_CATG'
ON MAJ_SUB SUBTOTAL AS 'TOTAL'

HEADING
""SUMMARY2"
IF DEPTS EQ &DEPTS
ON TABLE PCHOLD FORMAT PDF
*****END REPORT3*****


Thanks,
Duane

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

WebFocus 7.6
Windows Server
PDF output

A quick thought: put -RUN statements in the locations as suggested here:

SET COMPOUND = OPEN NOBREAK
-RUN
-REPEAT :RPTSBYDEPT &LOOPLINES TIMES
-SET &LINECNT = &LINECNT + 1;

-READ DEPTLIST &HSPA3.A3 &DEPTS.A5
-INCLUDE REPORT1
-INCLUDE REPORT2
-RUN
-IF &LINECNT NE &LOOPLINES THEN GOTO :NOCLOSE;
SET COMPOUND = CLOSE
-RUN
-:NOCLOSE
-INCLUDE REPORT3
-RUN
-:RPTSBYDEPT

i have had those "-RUN" statements at the bottom of each report with no success...., but i do know that the "-RUN" has helped in other processes.
i didnt have it in the locations you have specified, so i might revisit that logic.

thanks.