Exporting Crystal Reports

Instead of viewing reports in the browser using the interactive HTML-based viewer, ReCrystallize Server can export Crystal Reports directly to a file. To export a report, add the

exportfmt=

or equivalent

exttyp=

parameter to the URL or include it as a field when POSTing a form to ReCrystallize Server’s viewreport.aspx page.

The following export formats are available:

For example, to export a report to PDF format the URL would be similar to

ViewReport.aspx?reportName=library.rpt&author=Shakespeare&exportfmt=PDF

!All parameter values required by the report must be included in the report request, either as part of the URL or POSTed in form fields. Users will not be prompted for parameter values. The report will fail to export if all required parameter values are not set.

The exported file will open in the browser or be saved to disk, based on the client browser configuration. To request the exported file to be treated as a download and saved to disk, include the option download parameter with a value of YES or TRUE.

ViewReport.aspx?reportName=library.rpt&author=Shakespeare&exportfmt=PDF&download=y

As with parameter values, the export format may be posted from a form rather than included in the link.

To specify a filename for downloaded files, include exportname in the request. The filename may be a literal string or may use substitutions of parameter values enclosed with tildes. The following examples produce the same results:

ViewReport.aspx?reportName=library.rpt&author=Shakespeare&exportfmt=PDF&download=y&exportname=Shakespeare

ViewReport.aspx?reportName=library.rpt&author=Shakespeare&exportfmt=PDF&download=y&exportname=*author* 

To append the current date and time to a filename for downloaded files, include _DATE as part of exportname in the request.

ViewReport.aspx?reportName=library.rpt&author=Shakespeare&exportfmt=PDF&download=y&exportname=MyReport~DATE~

To redirect the browser to another web address, include redirect=.

ViewReport.aspx?reportName=library.rpt&author=Shakespeare&exportfmt=PDF&download=y&redirect=http://www.recrystallize.com