back to top

Unicode data from SalesLogix not exporting from the web Crystal Report viewer to PDF correctly.

The later version of SalesLogix allow the storage of Unicode data in the database.  This allows for the use and Japanese or Chinese characters.

I recently found if you try to use the PDF export of a Crystal Report that has a field containing Unicode
data in a SalesLogix field, the preview of the report works fine in the web Crystal viewer,
however if you export the file to PDF it strips out the Unicode
characters from the report.  They are replaced by squares instead.

Running the same report in the LAN client and using the LAN client’s Crystal Report preview and PDF export functionality did work properly.

I thought this to be a limitation with the underlying web architecture.  The web uses the ASP.Net
CrystalDecisions.CrystalReports.Engine assembly to generate the
PDF.  The LAN client uses an older ActiveX control.  I found  running something like
“Report.ExportToDisk(ExportFormatType.PortableDocFile, “report.pdf”);” from a custom C# solution caused the same problem. 

Stupid Crystal.

After further research, I have found the export problem is limited to Unicode characters in a Crystal Report using the MS Arial Unicode font.  All I had to do to make this work properly was switch to another Unicode friendly font.  In my case I used MS Gothic as the font in the report.

Whamo!  The export to PDF worked!

Still, stupid Crystal.

 

Contact Customer FX for your CRM project
We let our expertise speak for itself - let us know how our all-star team can help on your CRM project
About the Author
Kris Halsrud
Kris Halsrud
Kris Halsrud is a Senior Analyst / Developer for Customer FX Corporation.

1 COMMENT

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Infor CRM Sync for Exchange: Action Required by August 31, 2026

Using Infor CRM Sync for Exchange with Microsoft 365? Your Exchange administrator must update tenant settings by August 31, 2026 to prevent sync disruption.

[Webinar] What’s Coming Next for Infor CRM SLX and Why v10 Matters

See what’s coming next for Infor CRM SLX, including new marketing workflows, automation improvements, and reasons to consider upgrading to v10.

Disable Caching in Infor CRM SLX Web Client

In the rare case caching is causing issues in the Infor CRM SLX web client, it is possible to disable specific types of caching by making edits using Application Architect, and then deploying.

Exploring AI Options for Infor CRM v10

I've started taking a closer look at the AI capabilities built into Infor CRM v10. Over the next several posts, I'll share what I learn. From the built-in features and supported AI providers to implementation considerations, costs, and practical use cases.

Infor CRM SLX 10.0: Delegate Ownership Changes for “Everyone” Records

Learn how the new EveryoneOwnerAssignment secured action in Infor CRM SLX 10.0 allows designated users to change ownership of Everyone-owned records without requiring Administrator access.

Related Articles

Infor CRM Sync for Exchange: Action Required by August 31, 2026

Using Infor CRM Sync for Exchange with Microsoft 365? Your Exchange administrator must update tenant settings by August 31, 2026 to prevent sync disruption.

[Webinar] What’s Coming Next for Infor CRM SLX and Why v10 Matters

See what’s coming next for Infor CRM SLX, including new marketing workflows, automation improvements, and reasons to consider upgrading to v10.

Disable Caching in Infor CRM SLX Web Client

In the rare case caching is causing issues in the Infor CRM SLX web client, it is possible to disable specific types of caching by making edits using Application Architect, and then deploying.

Exploring AI Options for Infor CRM v10

I've started taking a closer look at the AI capabilities built into Infor CRM v10. Over the next several posts, I'll share what I learn. From the built-in features and supported AI providers to implementation considerations, costs, and practical use cases.

Related Videos