I'm using Crystal Reports Basic for Visual Studio 2008.
I have each item in a group printing on a separate page. There is a footer section which is set to Print at the Bottom of the Page. I am suppressing the page when its data is 0 by suppressing all sections with a formula.
The problem I have is that when the footer is set to bottom of the page, the suppressed page is printed as a blank page. When I turn off bottom of the page, and use NewPageBefore with the formula instead, the page is suppressed correctly, but when I turn on "bottom of the page", I get a blank page.
I have checked for unsuppressed sections, but they are all either suppressed with the checkbox or the formula.
Best Answer
I had this issue before, which took me quite a lot of time to find a workaround. Hopefully putting the answer here will save some time for others.
Whenever you enable "Print at Bottom of Page" for a section, make sure other sections that come after that (including Report Footer and Page Footer) are all suppressed, otherwise there will be an empty page printed at the end. Note that keeping them empty or ultimately narrow is not enough, they must be suppressed explicitly.
I had an empty report footer with a 0 height, and I thought it would take no space and will not cause an issue; but I was wrong. I had to explicitly suppress that footer to solve the issue.
If the sections coming after that are suppressed via a formula, make sure the formula is satisfied on the last record.