We have a .NET web application (Ellucian Advance) using Crystal Reports Runtime for Crystal Reports display. We recently had an upgrade to the product that included upgrading the runtime/viewer from CR Runtime 2008 to CR Runtime 2013 (currently using 64-bit v13.0.019). At some point between the upgrade and now we started noticing a word wrapping issue with our existing Crystal Reports when viewing in the application (examples below). Specifically, words that contain punctuation characters like slashes, dashes, and apostrophes that bump up against the right hand margin or cases where a period hits that margin, part of that word or the period will wrap down to the next row (fields are set as Can Grow with a value of 0 for unlimited). We have not noticed a case yet were it does this with a word without non alpha-numeric/non-punctuation characters. The report itself wraps fine when viewing within Crystal Reports designer (Crystal Reports 2013 Support Pack 2 v. 14.1.2.1121), the issue only pops up once the syntax is uploaded and viewed in the application and carries over when printed to PDF from there. So we are thinking it might be something with the Viewer or with Adobe PDF. I haven’t been able to find much with this exact issue so wanted to check and see if anyone else has run into this problem.
Examples:
“Thank you for your generous donation to XYZ endowment at the College of ABC that was received 10/30/2
017” (this has broken both before the year and after the 1st digit of the year)
“To provide undergraduate scholarships in the College of ABC at XYZ University with preference to need-bas
ed, and merit based sophomore, junior and senior students.”
“Thank you for your commitment in support of XYZ endowment. Your generosity boosts the University’
s students and faculty and their broad impact on our world.”
“To provide undergraduate scholarships in the College of ABC at XYZ University
.”
Some of the fixes we have tried include:
- Setting the ‘No Printer’ checkbox in Crystal Reports designer to checked
- Setting the ‘No Printer’ checkbox in Crystal Reports designer to unchecked
- And also installing the PDF print drivers and the drivers for the printer the reports are most commonly printed on, onto the web server.And setting the printer under Page Setup to use those printers
- Ensuring a ‘common-use’ font was used for the report such as Arial
- Adding a ‘PDF’ key to the registry settings for SAP Crystal Reports under ‘Export’ and adding values for ‘TruncateAdjustment’, ‘EnforceLargerFonts’, and ‘UsePrecisePositioningforText’, both under HKEY Local Machine and Current User
- Changing the size of the text box object and margins (depending on how dynamic the sentence is – built up based on data or just a static sentence – this of course can fix it one place but cause it to happen elsewhere)
- Setting the ‘Adjust Automatically’ check box in Crystal Reports designer (Page Setup) to checked (this actually worked but caused one report to span two pages for each actual page of data, when printed, the 2nd was blank.The display within the app was in Portrait still but had the width of two pages)
- Setting a fixed value for the Can Grow setting number of max rows
- Placing the field directly on the report (and changing the Text Interpretation to ‘RTF’ from ‘None’)
- Placing the field within an inserted Text Object onto the report
- Using the field within a formula and inserting that formula into the report
Thanks for any help you might be able to provide or if you need any further details.
Mike
Crystal Reports Designer - Crystal Reports 2013 Support Pack 2 v. 14.1.2.1121
Crystal Reports Viewer/Runtime- 2013 64-bit v13.0.019
.NET - 4.0.3019
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
Windows Server 2012 R2
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.