I try to develop a COMPOUND report with 2 subreports printing alternatively as below:

[newpage]
Report-1
Report-2
[newpage]
Report-1
Report-2
[newpage]
Report-1
Report-2

Report-1 is a summary with a few lines in the body and Report-2 is a detail list with many lines some group goes on for pages.

The issue is how can I do a conditional page break for Report-2 in case the list run over a page?

Report-1
Report-2 (first part fit in the remaining space of the report-1 page)
[force a conditional page break]
print title line for Report-2
print the following portion fit in a page
new page until the end of the detail list in the current group.
[newpage]
Report-1 for next group
Report-2 for next group

I'd tried the code below, seems there is no effort on the subreport within a COMPOUND report.

TABLE FILE CAR
SUM
QTY/D20 AS ''
PGBREAK/D1 AS ''
BY LIC_NO NOPRINT
WHERE GRP EQ '&A_GRP'

ON PGBREAK PAGE-BREAK

ON TABLE PCHOLD FORMAT &OUTPUT NOBREAK

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

What sort of COMPOUND report is it ?

Your sample indicates the old compound type.

For your sample, you need to have PGBREAK as a sort field.

I'm new to compound report. Where could I found the documentation for the new compound type?

I just noticed you are on WebFOCUS 5 ?

You will only have the old one.

SET COMPOUND OPEN/NOBREAK/CLOSE

1. You need to educate yourself with the manual or IBI classes.
2. You can only PAGE-BREAK on a SORT column
3. WebFOCUS 5? Geez, you are using an outdated product.
4. QUANTITY from CAR file - not a valid column
5. PGBREAK from CAR file - not a valid column
6. LIC_NO from CAR file - not a valid column
7. GRP from CAR file - not a valid column

Compound Example:

  
APP PREPENDPATH IBISAMP
-RUN

TABLE FILE CAR
HEADING CENTER
"Report 1"
" "
SUM
    DEALER_COST
    RETAIL_COST
  BY COUNTRY PAGE-BREAK
  BY CAR
  BY MODEL
ON TABLE PCHOLD FORMAT &OUTPUT OPEN NOBREAK 
ON TABLE SET STYLE *
UNITS=IN, SQUEEZE=ON, FONT=ARIAL, SIZE=8,$
TYPE=TITLE, STYLE=BOLD, $
ENDSTYLE
END
-RUN
TABLE FILE GGSALES
HEADING CENTER
"Report 2"
" "
SUM
   UNITS          
   DOLLARS        
  BY CATEGORY 
  BY REGION                 
  BY PRODUCT  
  BY DATE            
ON TABLE PCHOLD FORMAT &OUTPUT
ON TABLE SET STYLE *
UNITS=IN, SQUEEZE=ON, FONT=ARIAL, SIZE=8,$
TYPE=TITLE, STYLE=BOLD, $
ENDSTYLE
END
-RUN
TABLE FILE CAR
HEADING CENTER
"Report 3"
" "
SUM
    DEALER_COST
    RETAIL_COST
  BY COUNTRY PAGE-BREAK
  BY CAR
  BY MODEL
ON TABLE PCHOLD FORMAT &OUTPUT NOBREAK
ON TABLE SET STYLE *
UNITS=IN, SQUEEZE=ON, FONT=ARIAL, SIZE=8,$
TYPE=TITLE, STYLE=BOLD, $
ENDSTYLE 
END
-RUN
TABLE FILE GGSALES
HEADING CENTER
"Report 4"
" "
SUM
   BUDUNITS      
   BUDDOLLARS     
  BY CATEGORY
  BY REGION                 
  BY PRODUCT   
  BY DATE           
ON TABLE PCHOLD FORMAT &OUTPUT
ON TABLE SET STYLE *
UNITS=IN, SQUEEZE=ON, FONT=ARIAL, SIZE=8,$
TYPE=TITLE, STYLE=BOLD, $
ENDSTYLE
END
-RUN
TABLE FILE CAR
HEADING CENTER
"Report 5"
" "
SUM
    DEALER_COST
    RETAIL_COST
  BY COUNTRY PAGE-BREAK
  BY CAR
  BY MODEL
ON TABLE PCHOLD FORMAT &OUTPUT NOBREAK 
ON TABLE SET STYLE *
UNITS=IN, SQUEEZE=ON, FONT=ARIAL, SIZE=8,$
TYPE=TITLE, STYLE=BOLD, $
ENDSTYLE
END
-RUN
TABLE FILE GGSALES
HEADING CENTER
"Report 6"
" "
SUM
   DOLLARS        
   BUDDOLLARS     
  BY CATEGORY
  BY REGION                 
  BY PRODUCT  
  BY DATE      
ON TABLE PCHOLD FORMAT &OUTPUT CLOSE
ON TABLE SET STYLE *
UNITS=IN, SQUEEZE=ON, FONT=ARIAL, SIZE=8,$
TYPE=TITLE, STYLE=BOLD, $
ENDSTYLE
END
-EXIT

Sorry for the code sample, my compound report runs okay, an produce what I expected except on report-2 when there is a lot of detail lines, I want to force a page break and print a report and column headings before continue on. The sample code just to illustrate waht I did in report-2 trying to force a page break under certain condition, But it simply does work at all.

Tom, you're right, I forgot to include the PAGE-BREAK column as a SORT column, and it breaks accordingly after declaring as a SORT column.

I finally able to control my page break and format my compound report nicely after searching the forum and share the idea from Susannah, Thankyou!

http://forums.informationbuild...571093952#6571093952

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