You can send or schedule objects to different formats for each type of instance.
The Crystal Reports option preserves more formatting than other file formats. When you select other file formats, the BI platform preserves as much formatting as the format allows. However, reports may lose some or all formatting. If you choose to print a report when it is scheduled, the report instance is automatically sent to the printer in Crystal Reports format. This file format does not conflict with the file format you select when scheduling the report.
|
Format |
Description |
|---|---|
|
Crystal Reports |
This .rpt format preserves the most formatting of all output format options. It produces a normal, editable report. |
|
Crystal Reports (RPTR) |
This .rptr format produces a read-only Crystal report. |
| Microsoft Excel (XLSX) | This .xlsx format is a page-based format that converts the report contents into Excel cells on a page-by-page basis. Content from multiple pages are exported to the same Excel worksheet. If a report element covers more than one cell, the export program merges cells to represent a report element. This export format retains most of the formatting, but does not export line and box elements from your report. This format is an enhancement to the existing Microsoft Excel (XLS) exporting type, and removes the 65536 rows and 256 columns restrictions. |
|
Microsoft Excel (XLS) |
This .xls format attempts to preserve the look and feel of the original report. It preserves data and does not merge cells. You must specify some formatting properties for the report. |
|
Microsoft Excel - Data Only (XLS) |
This .xls format saves only data, and each cell represents a field. |
|
Microsoft Excel - Data-only (XLSX) |
This .xlsx format is a record-based format that concentrates on data. However, this format does export most of the formatting as well. The data-only format does not merge cells; each object is added to only one cell. The data-only format can also export certain kinds of summaries in Crystal Reports as Excel functions. The summaries that are supported are SUM, AVERAGE, COUNT, MIN, and MAX |
|
Microsoft Word |
This .doc format preserves as much formatting as possible, including graphics. Each object appears in an individual text field. |
|
|
.pdf format |
|
Rich Text Format (RTF) |
This .rtf format preserves as much formatting as possible, including graphics. Each object appears in an individual text field. This option is available only from a web viewer. |
|
Microsoft Word - Editable (RTF) |
This .doc format preserves less formatting than the Microsoft Word (97-2003) option. Text appears in lines, and images are placed inline with text. |
|
Plain Text |
|
|
Paginated Text |
You must specify some formatting properties for the report. |
|
Tab Separated Text (TTX) |
This format places a tab character between values. You must specify some formatting properties for the report. |
| Separated Values (CSV) |
This .csv format places a specified character between values. You must specify some formatting properties for the report. For example, if you select this option, you must enter characters for the separator and delimiter. |
|
XML |
.xml format |
|
Format |
Notes |
|---|---|
|
Web Intelligence |
.wid format |
|
Microsoft Excel |
.xlsx format |
|
Adobe Acrobat |
.pdf format |
|
Comma Separated Values (CSV) |
.csv format |
|
Plain Text |
.txt format |