cancel
Showing results for 
Search instead for 
Did you mean: 

Data truncation with export to pdf

AMPrasad
Explorer
0 Kudos
283

Hi There,

With our previous request on this PDF formatting issues and the resolution given by SAP team like service pack upgrade, we still could see formatting issues even with this upgrade. And as we mentioned earlier it's working in developer machine and failing (data truncation issues) in server machine, and now we figured out this problem is server machine is due to a font size increase in the generated PDF.

And also found a similar ticket with data truncation issues but we are unclear to make the suggested changes at our side since there some differences in Windows System Registry.

AMPrasad_0-1736523525723.png

Can someone assist us to achieve a solution to our current problem (data truncation) in PDF.

Thanks and best regards.

Accepted Solutions (0)

Answers (3)

Answers (3)

DonWilliams
Active Contributor
0 Kudos

Firstly, don't mix SP's. Update your DEV PC with SP 37 so it matches what you installed on the Server. Rebuild your project and redeploy the app to the server.

See my blog on updating your Project:

https://community.sap.com/t5/technology-blogs-by-sap/upgrading-a-visual-studio-2008-gt-2022-net-proj...

Second, Font truncation has nothing to do with the font itself (Mostly). It's handled by registry keys CR uses to deal with fonts. Note: CR uses default values within it's code, to alter those default values CR uses the registry keys.

Did you export and copy the DEV PC's CR's Export Registry keys to the Server as I suggested in your other post?

For more info on export registry keys have a look at this KBA:

https://userapps.support.sap.com/sap/support/knowledge/en/2165260

Also, please don't generate multiple post for the same issue. It's a pain having to refer back to what was suggested and results...

DonWilliams
Active Contributor
0 Kudos

What SP are you using? It makes a difference as to which OS is supported?

Also, you MUST distribute the SAME MSI package as what you are using on your DEV PC onto the Server, you can't mix them. For the latest SP go here:

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

SP 37 is the latest, see my blog on upgrading your Project also:

https://community.sap.com/t5/technology-blogs-by-sap/upgrading-a-visual-studio-2008-gt-2022-net-proj...

On your user PC where it is working export the Export tree and install it on the Server PC, that should resolve the issue.

The other ones likely don't need to be installed on the Server.

You Cannot manually distribute the runtime, you must use the MSI package and be a local Admin to install it, lot's of registry keys and COM dll's need to be registered.

 

AMPrasad
Explorer
0 Kudos

Thanks for the response, DonWilliams.

For your comment on SP, it's SP30 on Dev PC and SP37(latest) on Server PC.

AMPrasad_0-1736927577298.png

Still, we are not sure what causes this PDF level data truncation problem in server.

Please review our comments and guide us on what made this problem.

Thanks & Regards.

 

 

DonWilliams
Active Contributor
0 Kudos
As I said, update you Developer PC with SP 37
umasaral
Active Participant
0 Kudos

Hi 

To resolve the PDF formatting and data truncation issues, ensure that the font size discrepancy between the developer and server machines is addressed. Verify and align the font settings, including any custom fonts, across both environments. Check the Windows System Registry for any differences related to font rendering or scaling, and standardize these settings. Additionally, confirm that the SAP service pack upgrade applied all relevant patches and configurations correctly. If uncertainties persist regarding registry changes, consult SAP's documentation or support for precise guidance.

AMPrasad
Explorer
0 Kudos

Thanks for the response, umasaral.

We verified the font settings in Windows registry for both Dev and Server. See below screenshot.

AMPrasad_0-1736930350451.png

And for the SAP's SP point of view, the server has latest SP37 compared to dev which has SP30.

AMPrasad_1-1736930611024.png

In server, having latest SAP SP, it should not give these kind of issues.

It looks the problem is with fonts as above first screenshot but no idea how to get over this data truncation issue.

Any other thoughts, kindly let us know.

Thanks and Regards.