Crystal Report - Last Page is blank

问题:

I have a crystal report which when generated has a last page that is blank except for the page footer (which indicates the current page, as well as the report title).

This only occurs when the data displayed on the second last page completely fills the page.

Would anyone have any ideas as to why this might be?

回答1:

You have some (almost) empty group footer, which doesn't fit onto last (non-empty) page.

You have to set "New page after" option to some inner group footer section.

回答2:

When you check the checkbox New Page After, you will see an icon just right to it. This icon represents Formula Workshop. Click this icon and type NOT OnLastRecord.

Save and close the window, you are good to test this and praise me for the rest of your lives :)

回答3:

Instead of using the checkbox on the group footer, use a formula.

The one that I use is

not(OnLastRecord)

回答4:

+1 to Arvo because what he said is probably the case. I'll expand on it a little.

More than likely you have a section that will not totally fit on the second to last page so it spills over to a new page.

Some options you may be able to use are in the section expert are "Keep Together" which keeps all the lines of the section together, either on the current page (if there is room) or on the next (if not), or the "Suppress Blank Section". You could also try to shrink the height of the section, but this will probably not work in all cases.

As Arvo also said, make sure that you do not have the "New Page After" flag set for any of the sections as this could cause it as well.

回答5:

I was in the same situation and a good solution is to control the "New Page After" (in my case in the group footer) by a simple sentence, only doing it, when the current page is not the last.

With the option "New Page After" unchecked put a formula on it, clicking it's right formula button.

Code:

if(PageNumber = TotalPageCount) Then
    True
else
    False;

Saves a lot of troubles.

Greetings.

P.D. It's Crystal Syntax.

回答6:

I know that this is an old question, but I just had a similar problem.

In my case the last page was printing the Page header and nothing else.

It turns out that the fix for me was to Right Click on the Report Footer (Which had no contents) and choose Hide.

So it was basically putting in a blank report footer and including the page header with it...

Hope this helps...

回答7:

Evaluate if you need a report footer. If don't, be sure supress this section on report.

回答8:

In addition, to checking what other have mentioned above, after creating a new Blank Report, under Page Setup, the paper size for me was A4 by default. When I changed it to Letter, I would get a second blank page in the Print Preview as well as when physically printing to letter paper. Presumably this is due to going over the page boundaries. I was able to reduce the magins, and make the report content fit on the page.

回答9:

Or being on “Design” tab, under “Report Header” right click and select “Fit Section”

回答10:

In my case, it was an image outside the paper design, i just align it and scaled it to fit my paper.

回答11:

For some this might happen when there is an unused section like report footer. Suppress the section, it will be resolved.