cancel
Showing results for 
Search instead for 
Did you mean: 

crystal report footer blank space at end

babub
Explorer
0 Kudos
506

Hi All,

I have added a report footer into an existing crystal report with terms.  when I print the report its prints 1st page with all header and details and 2nd page just report footer but its giving totally 1/3 in display but when i print its prints only 1 & 2nd page and the third one is just blank no page.  As anyone faced this issue please help me.  following is the screenshot of the report footer and output.  I have added following formula at page header section PageNumber >= TotalPageCount -1 otherwise the terms will print along with header from 2nd page and extend to 3rd page

crystal report.png

babub
Explorer
0 Kudos
I have added following formula at page header section PageNumber >= TotalPageCount -1 otherwise the terms will print along with header from 2nd page and extend to 3rd page
View Entire Topic
DonWilliams
Active Contributor

Ah so you are using the Microsoft's Easy Print, Redirected print drivers.

CR doesn't like that driver because it's a InProc (Memory) load of the printer dll's, it transfers an XML file down to the local PC and uses that to do the printing.

CR is old technology and looks up the printer info saved in Windows DEVMODE structure to format the pages. Since it doesn't exist using the Redirected printer info CR defaults to your Default printer properties, which is different than what you designed it with.

TO fix this I suggest changing the No Printer to a real printer like an HP Printer or what ever that Redirected printer is and save the report.

Or install the printer driver on the PC where you are printing the report from.

Crystal Reports has always required a real printer when designing reports.

No printer uses the USP10 and some Default Printer properties when No Printer is enabled

So even if you don't have access to a real printer install it locally anyways and set it to the Default Printer.

That should fix your issue.

babub
Explorer
0 Kudos
Hi Don, I changed my default printer to Microsoft print to PDF and still same result. On my report footer I have Report Footer A which prints on the first page itself as expected and Report Footer B is my terms which prints in 2nd page
babub
Explorer
0 Kudos

Hi Don, I added the network printer as local printer in the terminal server where I am testing this. Following is the Printer preferences.

printer.png

DonWilliams
Active Contributor
0 Kudos

The extra page is due to the formatting of the report. Try removing extra space from each section and shrinking the report as much as possible.

See if this has any change for you:

DonWilliams_0-1726627953338.png

 

 

babub
Explorer
0 Kudos

Apologies  Don for not mentioning in the beginning itself.  Yes Great Plains is Dynamics GP and the crystal report itself works fine without any problem until I added the new section on report footer b where I added the terms if I supress the report footer b the report prints just one page.

DonWilliams
Active Contributor
It's possible GP has control over the output, I know a lot of OEM's used a database field to control each reports output, set parameters etc. so best to contact them for support.