Blank pages print in some cases at the end of a report.

[Former Member]

Hello All,

We are having a problem with some of our reports. The problem is that a blank page will print with no data on it.

The page is not completely blank. A contract number and a page n of n prints in a page header section. I thought that crystal will page only if there is more data to print.

One detail. We are required to leave 3/4" white space on the bottom of each page because some of our

customers have preprinted paper with headers and footers. So, the very last section of the report

is a page footer 3/4" deep that prints unconditionally.

This seems to be causing the page break. When I suppress this

section there is no extra blank page.

We have tried to suppress this 3/4" section on the basis of a boolean parameter telling the report that it is being printed

for a pre printed form customer. The thought was we'll print the 3/4" page footer only for pre-printed form customers

and suppress it for regular customers. However the sectionsd above don't know anything about whther the 3/4"

sections is supposed going to be suppressed or not, so it will print as far as it thins it can go, running into and over-writing

pre-printed verbiage.

There is not always a blank page. It occurs only when the detail sections and various

footer sections print just far enough down toward the bottom of the page.

Does anyone have any ideas?

Thank you,

Joe

[Former Member · Accepted solution]

If you have New Page After condition enabled for any one of the section then try this

Set up the 'New Page After' formatting to apply conditionally, so Crystal Reports only inserts a new page after the section when it is not on the last record of the report.

To change a formatting option to apply conditionally:

1. On the 'Format' menu, click 'Section'. This opens the Section Expert.

2. In the 'Sections' list, click the section that has the 'New Page After' formatting.

3. Clear the 'New Page After' check box, and click 'X+2' beside it. This opens the Conditional Formatting Formula Editor.

4. Type this formula:

Not(OnLastRecord)

5. Save this formula, and close the Formula Editor, then click 'OK' to return to the report.

When you preview the report you will see that the last page is no longer blank.

Regards,

Raghavendra.G

[Former Member]

Your page footer is NOT the problem. Crystal reserves the space for an unconditional footer as it's formatting the page. Removing the footer is just shifting the data on the page so that the end-of-page conditions are different.

In the format that prints just before the page footer (what format is that?), are there any fields that have Can Grow set? Is there constant text or field boarders so that you know if and where it is printing (for diagnostic purposes)? Are you sure the format just doesn't have blank data? Is there blank space underneath the fields that may be rolling over to the next page? Does the format have Page After set?

HTH,

Carl