Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Extra Blank Page in Report
- Thread starter 9757
- Start date
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
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
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:
----------------------
NOT OnLastRecord
----------------------
hth,
- Ido CUT (Crystal UTilities): e-mailing, exporting, electronic bursting & distribution of Crystal Reports:
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
Kent
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
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
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
tek@kenhamady.com
Public classes and individual training.
Guide to using Crystal in VB
tek@kenhamady.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question