Export To PDF Issue

I have an old server (Windows Server 2003 x86) that I used to export lots reports as PDFs and it has worked perfectly. The new server is now setup (running Windows Server 2008 R2 x64), and the export seems to have gone haywire. I am using Crystal Reports 2008 and an .NET 4.0 application using the CrystalDecisions version 12 libraries.

The report is 1 page long, 8.5 x 11, but when exported to a pdf it is spreading across 3 pages with lots of white space including an entire blank page at the end. This only happens when running it on the server through either a web application, or windows application. I am able to actually preview the report in Crystal, view and export and it looks good.

Any ideas what would be changing the report into a 3 page pdf? I have installed the correct merge modules, Crystal Reports 2008 and it hasn't help.

Who is Participating?
Ensure you are using the same printer and printer driver on all machines.

Crystal uses the printer driver to render the report and changing drivers even sometimes the version can cause issues lie that.

I suspect you have a field that is near the right margin and changing the driver could push the field over the default right margin

TimBusiness Systems AnalystCommented:
If you are using any functions for grouping and the regional settings on the server are different that on the system that the reports were developed on it can create issues.  For us, it eliminated a grouping based on a date field, I could see it affecting what is being hidden which could essentially give you 3 pages of empty records.
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

tgidirectAuthor Commented:
There is actually no data source attached it to.  It is more of a static report that has values from the application passed in as parameters.

I did verify that the print driver is the same on both machines.
I assume the driver changed and you are using the 64-bit version rather than using the 32-bit version from an old OS?
That change might be enough to cause the issue.

tgidirectAuthor Commented:
I will look into it again.  

Also, when I preview the report manually in Crystal and put in some random parameters it actually creates the report correctly with 1 page.  When the application creates it, it is 3 pages.  But it only happens on 64bit, not 32bit...
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.