To get your detail band to span across two pages, you have to fudge the data. Basically, you have to create a cursor that has two records for each record in your source data. Add an additional field to the cursor called RECTYPE and set it to "1" for the first copy of the source and to "2" for the second copy of the source. Then make sure the cursor is sorted by whatever normal field(s) you want, plus the RECTYPE field.

When you design the report, you have to add all the fields for the "1st" page to the report and set the print when logic to RECTYPE = "1". Then add all the fields for the "2nd" page to the same detail band and change the print when logic to RECTYPE = "2". It gets real ugly when all your fields for both pages are on top of each other. To make it easier, I usually create the "1st" page .. then start a new report and create the "2nd" page. When I'm done with the second page, I cut and paste those onto the first report.

Cathy



>Hi all, the subject title describes my problem.
>
>I have a report which I want to split onto two pages. I would like to create both sets of pages within the detail band (the layout is fixed and should never go above 2 pages). Hence, it would be cool to be able to add a page break to the report.
>
>Thanks in advance
>
>Clint