Export to PDF line spacing changed

building reports crystal reports
1

We recently migrated a legacy ASP.NET Crystal application to new servers in a new data center. The application generates reports using CrystalDecisions.CrystalReports.Engine, Version=9.2.3300.0.

These are exported to PDF and stored for later retrieval. On the new servers, page breaks occur in different places than they used to. One thing we have noticed is that on the new servers, the line spacing is greater than on the old servers.

So far, we have been unable to determine what is different on the new servers. Here is what we have checked:

The only fonts used in the reports are Arial, and we have verified that the same version of the fonts are being used on the old and new servers.

The reports are set to use the default printer, rather than “No printer”.
However, all of the servers are set to use Microsoft XPS Document Writer as the default printer. (Setting them to “No printer” is not a good option, since that would actually introduce a new variable into the situation.)

We have verified that the Crystal Reports engine is the same on both the old and new servers.

No application code has changed leading up to the crEngine.Export() call, therefore the inputs to the report are the same on the old and new servers.

What else should we investigate to determine why the reports are not the same on the new servers as on the old?
Doc1.pdf (162.0 KB)

lorasloan :us: (BOB member since 2008-02-27)

2

If you can get to SAP Note 2165260, there is a master list of registry keys for Crystal. However, I’m going to assume you can’t get there.

The “base” registry keys for Crystal 9 (the runtime you’re using) are:

HKEY_LOCAL_MACHINE\Software\Crystal Decisions\9.0
HKEY_CURRENT_USER\Software\Crystal Decisions\9.0\

Under \Crystal Reports\Export\PDF you can try using the following keys:

UsePrecisePositioningForText = DWord(1): text fields are either truncated incorrectly, or the text is wrapped to the next line incorrectly.

ForceLargerFonts = DWord(1): Fonts shrink by approximately 10% when a report is exported to Adobe Acrobat Format.

TruncationAdjustment = DWord(from 1 to 10): To adjust truncation.

-Dell

hilfy :us: (BOB member since 2007-04-16)

3

Thank you Dell. Unfortunately, the registry change did not resolve issue. The odd thing is the PDF was generated correctly on one server and when it was moved to another it added height into the detail lines. None of the registry keys really addressed that problem.

We are going to try and shrink the detail line height to adjust PDF output.

I attached a screen shot of the before server and after server PDF exports.
Doc1.pdf (162.0 KB)

lorasloan :us: (BOB member since 2008-02-27)

4

Hello
I have exactly the same problem as you. We deployed a new version of our software on a dev and a rec server.
Now the function export to pdf has two differents results on the two servers. For one the line spacing has increased and all the presentation of the report has been modified.
The dlls of crystaldecisions etc … are the same, the code is the same, the rpt is the same.
We didn’t change the printer options or the registry keys on the servers.
I have no idea and I try to find someone who has the same problem and found a solution …
Did you find something since december ?
Thank you for your help
Ana

Arthemyz (BOB member since 2017-02-14)

5

Which version of Crystal are you using? Have you tried the registry keys that I suggested (they’ll go in a different location if you’re on a different version of Crystal).

-Dell

hilfy :us: (BOB member since 2007-04-16)

6

We tried the registry key recommendation but this did not correct the line spacing issue. My client has aborted this problem as another issue occurred with report.

Good luck. Please let us know if you have resolved.

Lora

lorasloan :us: (BOB member since 2008-02-27)