crystal report footer blank space at end

[babub]

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

[babub]

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

[DonWilliams]

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]

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]

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

[DonWilliams]

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:

[babub]

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]

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.

[DonWilliams]

Download SP 36 from here:

https://help.sap.com/docs/SUPPORT_CONTENT/crystalreports/3354091173.html

Here's a Blog I wrote to upgrade your project:

Upgrading a Visual Studio 2008->2022 .NET project with the latest CR .NET SDK packages

[babub]

Hi Don,

Following is my Visual Studio version do I need to upgrade visual studio also along with upgrading CR.

[DonWilliams]

No, CR for VS will install in VS 2010-> 2022. Note, don't install the MSI packages separately, the installer will do this for you and it confuses VS if both are installed.

[DonWilliams]

Is the app a Web page or Desktop viewer?

CR formats the report based on the printer, so when designing the report use a real printer, when the viewer prints it uses a real printer driver and no the viewer dll's.

Change your default printer to use a real printer and try again.

[babub]

Hi Don,

[babub]

Hi Don, it desktop viewer and My page setup is A4 in crystal report following is the page setup of crystal report and printer preference.

[babub]

Hi Don, forgot to mention if I remove the report footer and print it, that will print only one page but whenever I add the report footer this is happening.

[babub]

Hi Don,

Sorry still no luck.  I have done the following Supress Blank Section on Report Header, Page Header, Details a, Details b, Page Footer, Report Footer a and Report 

Footer a and Report Footer b

[DonWilliams]

That's for the Report Header, what happens if you set it on the report Footer only?

What SP are you using? You can find the Version in Programs and Features.

[babub]

Hi Don,

I have report footer a and report footer b.  The report footer A prints along with page header and details as page 1 and report footer B is where I added the terms.  If I supress report footer b the first page print without any 2nd blank page but when I dont supress Report Footer b where I have terms this 3rd page starts printing.

[babub]

Hi Don,

following is the report footer a and b and SP versions

[babub]

Sorry Don,

Just wanted to tell you that I generate the crystal report dll in developer server then copy the dll file into Dynamics GP Addins folder and run the report.  My GP version is GP 2016 R2 so not sure whether the CR SP 36 will supported by GP 2016 R2 version framework.  Just wanted to confirm before I do them.

[DonWilliams]

Great Plain was an OEM partner years ago if that's what Dynamics GP is, but hasn't been for years also.

It would have been good to know this info at the beginning because I have no idea if they support updated CR software or if it's even used.

You'll have to ask them if they support newer versions of CR for .NET