Extra Blank Page in Report

[9757]

Hi...
when i create a report with say 10 records(each record being displayed on
one page)..i get an extra page at the end with the page header only. How
can i REMOVE this page?????

Dennis Mathew
dennismat@yahoo.com

 

[scriv1]

Dennis, you might give this a try...

In Design View, right click on Page Header portion of design. Then click Format Section. In Section Expert, click the Supress checkmark box to check it, then click the X2 button. In the Format Formula Editor, type...

PageNumber = TotalPageCount

click the OK button.

Hopefully that will cause it to suppress the Page when the page number is equal to the total page count. It works for me sometimes.

Kent

 

[IdoMillet]

If you have a 'New Page After' option turned on in the Format of a group footer, change it to a conditional expression such as:
----------------------
NOT OnLastRecord
----------------------

hth,
- Ido CUT (Crystal UTilities): e-mailing, exporting, electronic bursting & distribution of Crystal Reports:

http://sobpc02.bd.psu.edu/CUT/CUT.htm

 

[Ngolem]

do you have a "new Page After" enabled in your report?

If so put the following into the conditional "New Page After"

WhilePrintingRecords;
not onLastRecord;

hope this helps Jim Broadbent

 

[scriv1]

Dennis. Sorry, I forgot to mention that you can save yourself some typing in the Format Formula Editor by clicking on the "Print State" portion of the "Functions" window. One of the Print State options is "PageNumber" and another one is "TotalPageCount". By clicking on PageNumber, typing an = sign, then clicking on "TotalPageCount", you don't have to type the whole thing in.

Kent

 

[Ngolem]

Scriv1 - I'm not really fussy about your approach...potentially you could be suppressing real data.

There is a cause for this extra page...camoflaguing the cause is not the answer.

9757 - another potential cause is a section that is been made too big to fit on one page and carries over to the next page.

This can happen if a field is made "Can Grow" but the report writer actually allocates more than sufficient space for the field to grow into....the solution to this is to make the field normal size but tighten the section borders to the bottom of the field...the section will increase as much as necessary to accomodate the increased size but not too much.

Jim Broadbent

 

[kenhamady]

My guess would be that there is an active report footer section, and it is empty. This is printing on the last page. Suppress your Report footer unless there is something in it to print. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com