Printing empty page in the end of report????

[vshapiro]

I am using Crystal 9.0. When I print my report through Crystal viewer it is always prints one extra blank page in the end of the report. Can somebody help me to resolve this problem??

 

[GMcNamara]

In the design view, right click on the report footer and select Section Expert. Click the x-2 conditional button to the right of the Suppress (No Drill-Down) check box. In the formula editor enter: OnLastRecord;

 

[vshapiro]

Thank you very much. I'll try

 

[vshapiro]

No, it does not work. When I print report in Crystal Reports it's Ok. But through Crystal viewer I have the same problem - one more extra blank page...????????

 

[Ngolem]

describe your report....the "Crystal Ball" is weak on this side!

Jim Broadbent

The quality of the answer is directly proportional to the quality of the problem statement!

 

[vshapiro]

It is Monthly report, looks like:

Month/Year H/Received H/Complete R/Received.....

Jan,1998 5 3 8
Feb,1998 8 6 12.....

Report has a Date range parameter, so user can select any date range(report could be half page long or five pages long, depends to date ranges). And it is always prints one more blank page when I print it from web application..??
and in the print preview it says (for example for one page report)- Page 1 of 2...and so on

 

[checkai]

Do you have a "New Page After" selected option on in section expert?

If so, you would put in the x-2

Not OnLastRecord

DLC

 

[vshapiro]

no, I did not select 'New page after"..??

 

[MJRBIM]

A bunch of questions to point us in the right direction...

1.) Where does the data/report footer end on the last page of the report - is it near the bottom of the page, or much higher?

2.) Is it in the same location on both the Crystal Reports and Crystal Enterprise Viewer?

3.) Are you printining to the same printer from both the Crystal Reports and Crystal Enterprise Viewer?

4.) Which Crystal Enterprise Viewer are you using (HTML, ActiveX, Java, etc)?

5.) What are the print driver settings for the printer(s) in question - driver version, page settings, margins, form-feed, special characters, etc....?

 

[vshapiro]

Answers:
1. I have all the data in the details (every month) and totals in the report footer. Look ok on the first page.For example - I have 12 records(each month) and totals right under them. And then just empty end of the first page and empty second page...

2. and 3. Yes, everything in the same location and the same printer.

4. I am using HTML viewer (if I understand you correctly). How can I check it?

5.I do not understand this question. The only thing that I am always using this printer. all other reports are OK..??

 

[GMcNamara]

There was a similar problem a while back that never got resolved.

http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/100/pid/149/qid/716040

 

[vshapiro]

Thanks. At least I feel better that I am not missing anything easy..........
But, maybe somebody knows the answer??????????

 

[jkikuyu]

I had a similar problem which I was able to solve using not onlastrecord.
I have 4 groups and on the third group I had placed a 'new page after'. This resulted in a extra blank page.
What I did was uncheck the new page after(in section expert..) and place not(onlastrecord) on the third section, This is the section that I wanted to appear on new page, and the blank page vanished.
You would have to ensure that new page after is not checked in any of the other sections.