SAP BusinessObjects Enterprise InfoView User's Guide

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 1: 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 2: 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 export the images in your report.
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 3: Microsoft Word (97-2003)

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.

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.
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 5: 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 6: Microsoft Word - Editable (RTF)

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.
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.
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 7: 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 8: Paginated Text

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.
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 9: Separated Values (CSV)

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.
Delimiter	Type the character you want to use as the delimiter.
Separator	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 your 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 your want to isolate them.

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

SAP BusinessObjects
http://www.sap.com/sapbusinessobjects/
Support services
http://service.sap.com/bosap-support/
Product Documentation on the Web
http://help.sap.com/