Skip to Content
author's profile photo
Former Member

Problem exporting a crystal report to a PDF

Hi,

I have the following setup - I've created a flash file from Xcelsius and then imported it into a Crystal Report. I've connected the flash variables, that feed the data into the Xcelsius report, to data from the Crystal report and then I let it run in "Preview". Everything seems fine and I'm happy with the report. The next step was to export this report into a PDF file - Here I've encountered a problem and got a message that says "Failed to Export the report" and another one - "Not supported". When trying again with about half the data (by shortening the stored procedure that fetches the data) the export succeeds. Another weird thing is that when exporting the rpt to rptr, then opening it in the CR viewer and exporting it to PDF from there succeeds with any amount of data. Any idea how to enable a proper pdf export?

Thanks,

Heli.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Dec 18, 2012 at 02:07 PM

    That's interesting. I've done this sort of thing before with large sets of data, Xcelsius, and Crystal with no problems.

    Since it works when you export to rptr and then to pdf, I do have a thought.... Are you using "Page N of M" or "TotalPages" in your report? If so, take them out. When you have either of those, Crystal has to generate and render the whole report memory prior to export to PDF. When exporting to rptr Crystal is able to render a page at a time during the export and then has everything it needs to export to PDF.

    -Dell

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Dell,

      Thanks for your reply. The report is only 1 page long (it contains only the flash component and 3 formulas). I do not use any other components....

      Any other suggestions?

  • Dec 18, 2012 at 05:34 PM

    when exporting the rpt to rptr, then opening it in the CR viewer and exporting it to PDF from there succeeds with any amount of data.

    I suspect that this is because when you export a report, it brings in all the data so it essentially becomes a "saved data" report. E.g.; no database connection. The fact that the export proceeds fine with saved data indicates that the export engine and all that is ok.

    So it appears that the issue is when you are actually connecting to the database fetching fresh data. Which brings up a question; what database are yo connecting to?

    As you are exporting to rptr, you are either using CR 2011 or CR for VS 2010, please indicate which. Irrespective, make sure you have the latest updates.

    CR 2011:

    http://scn.sap.com/docs/DOC-28273

    CRVS2010:

    http://scn.sap.com/docs/DOC-7824

    - Ludek

    Follow us on Twitter

    Got Enhancement ideas? Try the SAP Idea Place

    Share Your Knowledge in SCN Topic Spaces

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Heli

      I'll see if I can get a bit of time to look at the files tomorrow. Just as an FYI, testing, even looking at files from here is way down on the priorities list. But I promise to try and get to these.

      - Ludek