For example, you may want to use report data to project trends in a spreadsheet package, or you may want to enhance the presentation of data in a desktop publishing package.
NOTE: When you export a report to a different file format other than Seagate Crystal Reports format, you may lose some or all of the formatting that appears in your report. The program attempts to preserve as much formatting as the export format allows.
1. With the report you want exported active, click the Export button on the Standard toolbar. The Export dialog box appears.
Export dialog box
This dialog box appears when you choose the Export command from the File | Print menu. Use the Export dialog box to export your report to an electronic file in a format that can be read by another software application. For example, you could export your report in Microsoft Excel format and then open it in Excel as a normal spreadsheet file.
The Export facility supports several popular word processing, database, and spreadsheet formats, as well as a number of standard data interchange formats.
2. Use the Format drop-down list to select the format in which you want to export the report. If you select "Character-separated values, you will be presented with the following dialog:
Enter the character which you want to use to separate data fields in the "Separator" field. Enter the delimiter which you want to use to identify text fields in the "Delimiter" field. (Consult your documentation for the application into which you are going to import the resulting data for these values.)
3. The exporter next needs to know how to handle any numbers and dates that may be contained within the report that you are exporting. The following dialog is used to designate this information:
4. From the Destination drop-down list, select a destination for your file.
To save the report to a disk file, select Disk file.
To attach the report to an e-mail document, select the appropriate Mail application. Seagate Crystal Reports supports Microsoft Mail (MAPI), Microsoft Exchange Mail (MAPI), and Lotus cc:Mail (VIM).
To store the report in a Microsoft Exchange folder, select Exchange Folder.
To send the report to a Lotus Notes database, select Lotus Notes Database.
To send the report to an application (such as MS Excel or Word), select Application.
NOTE: While the program assigns the native extension to all files you export in a specific word processor, database, or spreadsheet format, it automatically assigns the extension *.TXT for all files you export in one of the common data interchange formats. The program you want to use the data in, however, may look for specific extensions other than *.TXT. Consult the manual for that program to determine the correct file extension, and change the extension accordingly in the File Name edit box.
5. Click Save. The program exports the report to a disk file in the format specified.
EXPORTING TO HTML
Providing support for the Internet and corporate intranets becomes more important with every passing day. Seagate Crystal Reports recognizes this importance and provides World Wide Web support. Although incorporated as an export format, HTML represents a whole new export destination for reports as well.
By exporting reports in HTML format, Seagate Crystal Reports provides you with a new option for rapid, convenient distribution of important company data. Once exported, your reports become accessible with many of the most popular web browsers, including Netscape and Microsoft Internet Explorer.
1. With the report you want exported active, click the Export button on the Standard toolbar. The Export dialog box appears.
2. From the Format drop-down list, select one of the HTML formats listed.
If Netscape is your browser, select HTML 3.2 (Standard) format.
If using Microsoft Internet Explorer as your browser, select HTML 4.0 (DHTML) format.
3. Select a destination from the Destination drop-down list. The rest of this section assumes you select Disk file to store the HTML document in a directory on a web server.
4. Click OK. The Export dialog box appears. When exported to HTML format, a report may create more than one HTML file. For this reason, the program asks you for the name of a directory for an export destination, and uses default names for the HTML files.
5. Select an existing directory, or create a new directory for your report.
6. Click OK. The program exports the report to HTML format.