Exporting Crystal Report to PDF: Error Message

[entropy50]

Hi all,
I'm using Crystal Reports XI with an SQL database. I have a report that I've run several times with no issues until I added one extra supreport. It's a main report, with three associated sub-reports added. I can export the main report with the associated documents subreport and the 'associated reports' subreport, but each time I try to run the report with associated photos subreport and export it to PDF, I get an error message saying "Failed to export report" followed by "Not Supported." Everything seems to be the same with this third subreport other than it fails to export to pdf; there are no fancy links to the photo or anything just the photo id so essentially it's the same as the documents report. I can however, export a single report with all of the associated records, but not multiple reports with associated records. I've spent the whole morning building and re-building this report with no success. If anyone has had this issue before, I'd be most grateful for your advice.

Entropy50

 

[IdoMillet]

Save the subreport to a report file and open it alone. Can you export to pdf?

If not, can you export to other formats?

Are you using different fonts in the subreport?

Please clarify the sentence: "I can however, export a single report with all of the associated records, but not multiple reports with associated records".

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[entropy50]

Hello Ido,

Thanks for taking the time to respond. I'm a user of your Visual Cut program - I've been grateful for your help and advice in the past. About this report that I'm doing now: It runs fine in Crystal, but every time I try to add the third subreport and export it to PDF, I get an error message reading "not supported" and I can't figure out why. I'm going to try rebuilding the subreport again from scratch to see if it helps although I've already done this before. Would it help if I included the SQL statment??

Best,

Entropy50

 

[IdoMillet]

Hi ?,

Save the "bad" subreport (the one that causes an export failure) to a report file and open it alone. Can you export to pdf?

If not, can you export to other formats?

Are you using different fonts in the subreport?

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[entropy50]

Hello Ido,

I've rebuilt the subreport for the fourth time and now it works. I still don't know why it wouldn't export to PDF: it always seemed to run fine, but just wouldn't export. The joins and formulae were the same for each of the five subreports that I used in the report, so each of them should have worked in the same fashion. I only use two fonts (Arial and Times New Roman) and I don't add a lot of extra formatting so I can't see how the fonts were ever an issue. Sorry about wasting everyone's time. Thanks for your help and suggestions, however.