I am using Crystal Reports XI R2.
I have a report that prints all
the work orders for our shop. I have one Group and it has 22 Details
sections. I have the Group set to 'Reset Page Number After' so that when printing
multiple work orders each work order will say 'Page 1 of 1' or 'Page 1
of 2' and 'Page 2 of 2' rather than printing 'Page 1 of 13', Page 2 of
13', 'Page 3 of 13', etc.
In one of the Details sections I have placed a subreport that prints special instructions if special instructions have been given for the selected part/customer combo. This is the last Details section on the report.
I discovered this section can cause a second blank page if prior sections have enough data in them to push it far enough down the page. So I decided to suppress the section if the subreport is blank. To do this, I have performed the following steps.
- Right-click subreport > Edit Subreport
- Click File > Report Options
- Tick the 'Suppress Printing If No Records' checkbox
- Click 'OK' and return to Main report
- Right-click subreport > Format Subreport
- Click 'Subreport' tab
- Tick the 'Suppress Blank Subreport' checkbox.
- Click 'OK'
When I do this and preview the report in Crystal Reports, I can see that the Details section is no longer showing. However, it is still printing the second page. Only the Page Header and Page Footer are printing; there are no Details sections shown at all. And to make matters worse, if I preview more than one work order, it takes all the Details from the second work order (a one page work order) and displays them on Page 2 of the first work order with the Page Header and Footer of the first work order.
How can I suppress this Details section when the subreport is blank, stop the second page from printing, AND stop CR from skewing the formatting?