We help IT Professionals succeed at work.

Exporting Crystal Reports from within Sage X3

John Bosco
John Bosco asked
on
512 Views
Last Modified: 2017-07-08
Hi Experts,
Crystal Reports 2013 with SP7 and Sage X3 v.8.
Is there a way to export a report to pdf rather than print the report to the pdf print driver in Sage X3?
When printing to pdf, the report does not render exactly as it appears in preview. This has always been an issue with Crystal. It appears that in Sage, the only way to get a pdf is to print with a destination of pdf.  Is there a way to call the Crystal export function from within Sage?
Thanks in advance for your help.
John Bosco
Comment
Watch Question

Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
Crystal does have a PDF export capability but it is possible the developers of the Sage application hid it from the users.
If you don't see it as an option I suspect you can't do it.

The Crystal export to PDF has the same issue so you will not gain anything by using the direct export.

mlmcc
John BoscoCrystal Report Developer

Author

Commented:
When using CR to create a pdf, you want to use the export function and NOT print the report to a pdf printer driver. Results will be different as printing to a pdf driver will not render the report as designed. This has always been an issue with Crystal. Crystal export to pdf generally works well.
The issue is with Sage X3 and if it supports exporting reports rather than printing to a pdf driver.
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
Are you trying to export from a report preview screen?

mlmcc
John BoscoCrystal Report Developer

Author

Commented:
Correct.
The only workaround that I have been able to come up with, is to preview the report in Word and then save the Word doc as a pdf.
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
When previewing the report do you see the EXPORT icon?

Export icon in designer
Export ICON on viewer
If you don't see it then the Sage application has hidden it and it isn't available.

We did that in one viewing application I wrote because we couldn't hide the Excel export and didn't want users to be able to export to Excel so we provided it through other menus.

mlmcc
John BoscoCrystal Report Developer

Author

Commented:
I am previewing the report from within the Sage X3 application, not from within CR. My end users do not have access to CR.
Senior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.