Crystal 11 PDF Export File TextBox Margins Different in Production

I have a Crystal 11 report that contains a textbox that is populated by a field from a stored procedure.  When we run this report in our development and QA environments, the data shows properly and wraps properly.  When the report is run in our production environment, the data on the right margin of the textbox is sometimes truncated.
1. The field has the "Can Grow" option turned on
2. The field is purposely much shorter than the page width, and does not extend beyond the page
3. There is no other element around the field, so I don't think there is any overlapping.

I wondered if it was possible to have some kind of configuration or .dll file that was different in the production environment that would cause this issue?
TextChipping.bmp
TextNotClipped.bmp
CLo121Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
Are you using the same printer driver on all machines?
Crystal uses the printer driver to render the report.  Changing drivers can cause issues like this.

mlmcc
0
CLo121Author Commented:
That is an excellent question.  Where do I look in order to find that answer?  What is the file, and where is it normally located?
0
mlmccCommented:
Check the default printer on each machine or server.

START --> SETTINGS --> PRINTERS

mlmcc
0
Become a Microsoft Certified Solutions Expert

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

CLo121Author Commented:
I'm having the print drivers checked, but I am getting a clarification question from our application developers.  The way that our reports are called is from within a custom application.  The application utilzes the CR11 API and references code such as:
report.OutputToFile(filePath, type)
- or -
report.OutputToFile("MyFile.pdf,ExportType.PDF)
report.OutputToFile("MyFile.doc, ExportType.Word)

App guys are telling me that the print driver should have nothing to do with this issue.
0
CLo121Author Commented:
Export call is: report.ExportToDisk(ExportFormatType.PortableDocFormat, mOutputFile);
0
mlmccCommented:
Crystal uses the printer driver in rendering the report regardless of how you generate the final product.  It is their way of trying to ensure the displayed report is the same in all exports.

mlmcc
0
CLo121Author Commented:
The suggestion does not seem to be the issue.  There are no printers installed on the machines where the application resides.
0
mlmccCommented:
Do you ever need to print the report?
If not then try setting the NO PRINTER option on the page setup.

mlmcc
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mlmccCommented:
Can you install a printer on the server?
It doesn't need to really exist.

mlmcc
0
CLo121Author Commented:
Interesting.  How would installing a printer fix the issue of data truncation?
0
mlmccCommented:
Crystal uses the printer driver to render the report.  Changing it can cause some fonts to become slightly larger than others and Crystal cannot grow a field horizontally thus there can be some truncation.

mlmcc
0
CLo121Author Commented:
ok, that makes sense, and I know that you have added that comment before.  However, that would also indicate to me that perhaps we checked the wrong servers since, how would we be generating reports in PDF format unless we have a printer installed in the proper location, given your information.

Let me try this a different way.  I need to identify the right location to examin.  If my application is invoking the PDF export using this statement:
report.ExportToDisk(ExportFormatType.PortableDocFormat, mOutputFile);
then it must be invoking some .dll files.  I want to identify some key .dll files that must be present in order for that statement to work.  That should, in theory, identify the server to which my target crystal components have been installed, and by extention, the servier that should have the print drivers installed.  Does that sound right?

Can you tell me some key files to look for and ther usual locations?

Sorry about this.  It is an old application and none of the original architechs are still with the company.
0
mlmccCommented:
Look for CRXF_PDF.DLL

mlmcc
0
CLo121Author Commented:
Found those files.  Still no printer installed.  Unable to install printers without further proof.  However, I'm grateful for the help.
0
CLo121Author Commented:
Although I could not use the full solution because of limitations on my end, the comments were still very helpful.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB Reporting Tools

From novice to tech pro — start learning today.