views:

1975

answers:

5

Hi All,

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?

Thanks in advance!

+2  A: 

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

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

Arvo
None of the inner group footer sections have the "New page after" option set.I will look into the group footers to determine if any of them do not fit on the last page properly.
Denis Sadowski
You may recolor them to make debugging easier :) Actually last page problems are sometimes really serious - we have even made line counters and split pages to avoid placing big group footer to last page and as few as 10 detail lines on previous.
Arvo
+2  A: 

+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.

Dusty
I am currently already making use of the "Keep Together" property and at the moment suppress blank section is not being utilized on all defined sections.At the moment simple decreasing the size of the group footer to half seems to have stopped the extra page from being generated. However, I will have to test more as you indicated this will probably not work in all cases.
Denis Sadowski
A: 

instead o using the checkerbox on the group footer use a formula the one that i use is not(lastrecord)

tydee
A: 

Hi dude,

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.

i know that property which one to be use. that is "New Page After" but i don't know which formula to use in that property.

Saravanan