cancel
Showing results for 
Search instead for 
Did you mean: 

crystal report footer blank space at end

babub
Explorer
0 Kudos
509

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
0 Kudos

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
Explorer
0 Kudos
Hi Don,
babub
Explorer
0 Kudos

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.

pagesetup.png

babub
Explorer
0 Kudos
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
Explorer
0 Kudos

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

supressblank.png

DonWilliams
Active Contributor
0 Kudos

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
Explorer
0 Kudos

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
Explorer
0 Kudos

Hi Don,

following is the report footer a and b and SP versions

REPORTFOOTER.pngCRYSTALREPORTS.png

babub
Explorer
0 Kudos

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
Active Contributor
0 Kudos

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