Follow

Problems printing, previewing, or exporting as PDF in Crystal Reports

Issue:  Problems printing, previewing, or exporting as PDF in Crystal Reports. Specific error messages you may encounter:

Database Login Failed:

mceclip0.png

Crystal Reports Error, “Failed to open the connection”:

mceclip1.png

 

 

Resolution

 

  1. Open the document having the issue
  2. Select ‘Layout Designer’ in the toolbar or Administration > Setup > General > Report and Layout Manager

mceclip2.png

  1. A: If you are fixing a Document Layout like for Sales Orders, select ‘Manage Layout’ and the select ‘Edit’ and continue to step 4

mceclip3.png

mceclip4.png


B:
If fixing a Report like "Plant Tags 3x2_OProductionGroup_v2" 
You can use the Menu Search bar at the top right (after selecting Menu from the drop down) and find it there
mceclip0.png
or go to Administration > Setup > General > Report and Layout Manager

From there you can go to Search​
Select Document Type to search for Sales Orders or Productions orders 
or
Select Report to search for specific reports and then search for the report you need to fix.

mceclip1.png

In this example you could search 3x2 click find, then select the report

mceclip2.png

Select ‘Edit’ and continue to step 4
mceclip3.png


  1. Wait for Crystal Reports to Open. **This step usually takes 30 seconds to 2 minutes but in rare instances can take up to 15 minutes. Please leave the window to load and do not close it out until then.
  2. Select ‘Add-Ins’, then ‘SAP Business One’ and click ‘Save’.

mceclip5.png

  1. Wait for this to complete.
  2. Close Crystal reports and try again.


Below is a video going through the steps above.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments