I have what is (hopefully) and quick and simple question. I have a report that has two subreports in it. The second of the two subreports, when there is data, needs to be on a new page which is what's causing my problem. When I add conditions in the formula for New Page Before or New Page After such as: 'Not onlastrecord', conditional formulas in the suppress fields of the main report sections containing the subreports and it just wont work the way I need it. The subreports are checked "Suppress Printing if No Records" and are as small as they can be to prevent a field spillover problem. The problem that I have is that I can either get the report to suppress the blank section but when the report has data it is not on a new page, or I can get it on a new page but I get a blank page at the end of the report with only a page header and footer on it (no blank or unsuppressed sections either). I have combed through several forums and tried several different solutions and combinations of solutions and nothing works. Anyone that can help me solve this would be my hero!
3 Answers
Don't try to split the pages in the main report.
Instead, conditionally set the New Page Before option in the Report Header section of the second subreport, so that it is only true if at least one record is returned - for example, using a condition like Count ({Table.Field})>0 .
You may need to split the subreport's Report Header section into two subsections, in order to be able to set the New Page Before option - if so, suppress the first subsection and conditionally set the New Page Before option in the second subsection.
I had a similar problem and found it was a graphic too far to the right that was falling onto another page. I found it by printing the report to a PDF using the Acrobat print driver and then opening it up in Acrobat or Reader or Adobe Illustrator. I then did a select-all on the blank page it showed me a small white box on the page where the graphic from the first page was falling over. I moved the box back a few millimeters and the blank page disappeared.
