Once you run a report, you may want to save it instead of printing or emailing it. The available export options are Adobe PDF, Microsoft Word and Microsoft Excel. There is also an option to export the file to Crystal Reports, which allows you to edit the base report file. The export options are available on the Report Viewer under the Tools menu.
These options are only available in the Report Viewer when you preview a report. If the report is emailed or run for multiple records, the Report Viewer does not display. Some formatting supported in Crystal Reports, such as lines, shapes and pictures, may not export well to Microsoft Excel or Microsoft Word.
It is possible to export the Crystal Report from the Report Master. See Export a Standard or Custom Report File for more information.
You can only export a report if it includes at least one row of data. Even though you can still see text on the report, it may not have returned results from the software so it is considered blank.
Report export security is controlled by the Override Allow Export Report Setting access privilege.
Comments
12 comments
How do we export a standard report that doesn't have the EXPORT TO option? For example, the Registrant Confirmation report has parameters to only send to the printer or email. I don't see an Export To in either of those options.
1 upvotes
Lori-
For reports like that, as long as you are printing only a single report, select To Printer. This will bring up the standard preview window before it is sent to the printer. You can choose Export To from there.
0 upvotes
When exporting a report to word, the formatting of the report all goes from how it is displayed on EBMS or if this report is exported to PDF.
How can I fix this for the report to be exported to word as it is to PDF.
0 upvotes
Kris-
Crystal Reports handles exports to Word and Excel differently depending on how the original report was designed. Usually, when we build a report, we have the final product in mind. If the report will be exported to Word, we test the report by exporting to Word, with the knowledge that it may not look good if it's displayed straight out of Ungerboeck or exported to PDF.
For Word exports, the important thing to remember is that each item on the page will be treated as a new block of text by Word. Try to keep your data in paragraph form by adding fields to text boxes instead of dropping the field straight onto the page. To get the formatting perfect requires a good deal of trial and error.
0 upvotes
Hi all,
When exporting a report in pdf (ie : an invoice) it's possible to configure/add to the filename the Invoice number ? Because for the moment, the default name given to the pdf si the name of the report.
Thanks,
Christophe
1 upvotes
Christophe -
There is no way to do this by default, other than adding it when naming the report. It is, however, a great idea. I'll pass it on to our product managers!
1 upvotes
How do I export the Proforma Service Order Invoice in the hosted environment? We are a V20 customer. I can export it and edit it locally in Crystal, but it then resides locally and I have no way to load it back into USI for use. I cannot edit it using your Citrix implementation of Crystal because Citrix does not see my local workstation.
0 upvotes
Hi Steven, why can't you load it back into USI from your local machine?
0 upvotes
Hi Steven-
Citrix should be able to see your local drives. If you are unable to access your local drives from Citrix, please enter a ticket with Client Care.
However, when importing the report into v20, you just need to select the file you are using. The files shown when you click browse in v20 are the files on your local machine. There is no need to get it into the Citrix environment unless you need to run it in v19.
0 upvotes
Thanks, I found that I can see the local drive, some folders are missing. When I place the crystal report in a folder that crystal can see, it cannot see the .rpt file in it. Very perplexing.
0 upvotes
If there is something wrong with these buttons, where should I start by troubleshooting?
Something wrong means, there is an issue when generating the report.
Thank you!
Kim
0 upvotes
Hi Kimberly,
I would start troubleshooting with a standard report first. This may be something you will need to contact Client Care to help resolve.
Regards,
Mike
0 upvotes
Please sign in to leave a comment.