Additional Formatting Options for Crystal Reports

When you schedule a Crystal report to some formats, you may be required to set additional options. This topic details the additional options for each format to which they apply:

·            Table 4-3: Microsoft Excel (97-2003)

·            Table 4-4: Microsoft Excel (97-2003) (Data Only)

·            Table 4-5: Microsoft Word (97-2003)

·            Table 4-6: PDF

·            Table 4-7: Rich Text Format (RTF)

·            Table 4-8: Microsoft Word - Editable (RTF)

·            Table 4-9: Plain Text

·            Table 4-10: Paginated Text

·            Table 4-11: Separated Values (CSV)

·            Table 4-12: XML

Table 4-3: Microsoft Excel (97-2003)

Option Description
Use the export options defined in the report

To use the export options already defined in the report, select this option. You will not be able to set any of the other additional formatting options.
Set Column Width

·            To set the widths of Excel columns based on objects in the report, select Column with based on objects in the report and choose a report area from which to take the column widths.

·            To set a constant column width, select Constant column width (in points) and type the width.
Export page header and page footer

·            To include the page headers and footers in your instance, choose whether you would like to export them Once Per Report, or On Each Page.

·            To exclude the page headers and footers from your instance, choose None.
Create page breaks for each page Select this option to create page breaks.
Convert date values to strings

Select this option to export date values as text strings.
Show gridlines Select this option to see gridlines in your exported document.
Page range

·            To include all pages of the report, select All.

·            To include a page range, select from: and type the first page you want to include, and type the last page you want to include in the to: field.

Table 4-4: Microsoft Excel (97-2003) (Data Only)

Option Description
Use the export options defined in the report

To use the export options already defined in the report, select this option. You will not be able to set any of the other additional formatting options.
Set Column Width

·            To set the widths of Excel columns based on objects in the report, select Column with based on objects in the: and choose a report area from which to take the column widths.

·            To set a constant column width, select Constant column width (in points) and type the width.
Export object formatting

Select this option if you wish to preserve the object formatting.
Export images Select this option to use summaries in the report to create worksheet functions in Excel.
Use worksheet functions for summaries Select this option to use summaries in the report to create worksheet functions in Excel.
Maintain relative object position Select this option to maintain the positioning of objects relative to one another.
Maintain column alignment Select this option to preserve the alignment of text within columns of your report.
Export page header and page footer Select this option to include the header and footer in your instance.
Simplify page headers Select this option to simplify page headers.
Show group outlines Select this option to show group outlines.

Table 4-5: Microsoft Word (97-2003)

Option Description
Page Range

·            To include all pages in the report, select All.

·            To include a page range, select from: and type the first page you want to include, and type the last page you want to include in the to: field.

Table 4-6: PDF

Option Description
Use the export option defined in the report To use the export options already in the report, select this option. You will not be able to set any of the other additional formatting options.
Page Range

·            To include all pages of the report, select All.

·            To include a page range, select from: and type the first page you want to include, and type the last page you want to include in the to: field.

Create bookmarks from group tree Select this option to create bookmarks in your PDF file based on the tree structure of the report. This will make the report easier to navigate.

Table 4-7: Rich Text Format (RTF)

Option Description
Page Range

·            To include all pages of the report, select All.

·            To include a page range, select from: and type the first page you want to include, and type the last page you want to include in the to: field.

Table 4-8: Microsoft Word - Editable (RTF)

Option Description
Use the export option defined in the report To use the export options already define in the report select this option. You will not be able to set any of the other additional formatting options.
Page Range

·            To include all page of the report, select All.

·            To include a page range, select from: and type the first page you want to include, and type the last page you want to include in the to: field.

Insert page break after each report page Select this option to insert page breaks in your RTF file after each page of the report.

Table 4-9: Plain Text

Option Description
Number of characters per inch Type a value between 8 and 16 for the number of characters to include per inch. This setting controls how the text file is displayed and formatted.

Table 4-10: Paginated Text

Option Description
Use the export options define in the report To use the export options already defined in the report, select this option. You will not be able to set any of the other additional formatting options.
Number of lines per page Type the number of lines of text to include between page breaks.
Number of characters per inch Type a value between 8 and 16 for the number of characters to include per inch. This setting controls how the text file is displayed and formatted.

Table 4-11: Separated Values (CSV)

Option Description
Use the export options define in the report To use the export options already defined in the report, select this option. You will not be able to set any of the other additional formatting options.
Delimiter Type the character you want to use as the delimiter.
Seperator Type a character to use to separate values, or select Tab.
Mode Select either standard or legacy mode. In standard mode, you can choose report, page, and group sections to include in your instance. In legacy mode, you cannot set those options.
Report and page sections If you selected standard mode, indicate whether you want to export report and page sections, and if so, whether or not you want to isolate them.
Group sections If you selected standard mode, indicate whether you want to export group sections, and if so, whether or not you want to isolate them.

Table 4-12: XML

Option Description
XML Exporting formats Select the XML exporting format you wish to use.