Crystal report instance formatting options

When you schedule a Crystal report instance to some output formats, you may need to set additional options.

Microsoft Excel (XLS) and (XLSX) formats
Option Description

Page Range

  • To include all pages in a report, select All.
  • To include a page range, select Pages from, enter the first page number to include, and enter the last page number to include in the to box.

Use the export options defined in the report

Select this check box to use the export options defined in a report. You cannot set any other formatting options.

Set Column Width

  • To set the width of Excel columns based on objects in a report, select Column width based on objects in the, and choose a report area from which to take the column width in the list.
  • To set a constant column width, select Constant column width (in points), and enter the width in the box.

Export page header and page footer

  • To choose when to export page headers and footers in an instance, select Once Per Report or On Each Page.
  • To exclude page headers and footers from an instance, select None.

Create page breaks for each page

Select this check box to create a page break after each page in a report

Convert date values to strings

Select this check box to export date values in a report as text strings

Show gridlines

Select this check box to view grid lines in exported documents

Microsoft Excel - Data Only (XLS) and Microsoft Excel - Data Only (XLSX) formats
Option Description

Use the export options defined in the report

Select this check box to use the export options defined in a report. You cannot set any other formatting options.

Set Column Width

  • To set the width of Excel columns based on objects in a report, select Column width based on objects in the, and choose a report area from which to take the column width in the list.
  • To set a constant column width, select Constant column width (in points), and enter the width in the box.

Export object formatting

Select this check box to preserve the object formatting.

Export images

Select this check box to export the images in a report.

Use worksheet functions for summaries

Select this check box to use summaries in a report to create worksheet functions in Excel.

Maintain relative object position

Select this check box to maintain the position of objects, relative to one another.

Maintain column alignment

Select this check box to preserve the alignment of text in columns in a report.

Export page header and page footer

Select this check box to include the header and footer in an instance.

Simplify page headers

Select this check box to use simple page headers.

Show group outlines

Select this check box to show group outlines.

Microsoft Word format
Option Description

Page Range

  • To include all pages in a report, select All.
  • To include a page range, select Pages from, enter the first page number to include, and enter the last page number to include in the to box.
PDF format
Option Description

Page Range

  • To include all pages in a report, select All.
  • To include a page range, select Pages from, enter the first page number to include, and enter the last page number to include in the to box.

Use the export options defined in the report

Select this check box to use the export options defined in a report. You cannot set any other formatting options.

Create bookmarks from group tree

Select this check box to create bookmarks in a PDF file based on the tree structure of a report. This makes reports easier to navigate.

Rich Text Format (RTF) format
Option Description

Page Range

  • To include all pages in a report, select All.
  • To include a page range, select Pages from, enter the first page number to include, and enter the last page number to include in the to box.
Microsoft Word—Editable (RTF) format
Option Description

Page Range

  • To include all pages in a report, select All.
  • To include a page range, select from, enter the first page you want to include, and enter the last page you want to include in the to box.

Use the export options defined in the report

Select this check box to use the export options defined in a report. You cannot set any other formatting options.

Insert page break after each report page

Select this check box to insert page breaks after each page in a report.

Plain Text format - Crystal Reports 2020 only
Option Description

Use the export options defined in the report

Select this check box to use the export options defined in a report. You cannot set any other formatting options.

Number of Characters per Inch

Enter a value between 8 and 16 to indicate the number of characters to include per inch. This setting determines how text files appear and are formatted.

Paginated Text format - Crystal Reports 2020 only
Option Description

Use the export options defined in the report

Select this check box to use the export options defined in a report. You cannot set any other formatting options.

Number of Lines per Page

Enter the number of lines of text to include between page breaks.

Number of Characters per Inch

Enter a value between 8 and 16 to indicate the number of characters to include per inch. This setting determines how text files appear and are formatted.

New Paginated Text format – Crystal Reports for Enterprise only
Option Description
Page Range Use the options in this area to limit the number of report pages that you want to export.
Use the export options defined in the report

Select this check box to use the export options defined in a report. You cannot set any other formatting options.

Export page header and page footer

Select Once Per Report or On Each Page to choose when to export page headers and footers in an instance.

Select None to exclude page headers and footers from an instance.
Character Encoding

Select the character encoding system to use in the exported text file: UTF-8, UTF-16 Little Endian, or UTF-16 Big-Endian.

Minimum Lines per Page

Enter the number of lines of text to include between page breaks.

Insert Form Feed character

Select this check box to insert a form feed character after each page, as specified in the Minimum Lines Per Page field. The form feed character creates a page break.

Number of Characters per Inch

Enter a value between 8 and 20 to indicate the number of characters to include per inch. This setting determines how text files appear and are formatted.

New Tab Separated Text format – Crystal Reports for Enterprise only
Option Description
Page Range Use the options in this area to limit the number of report pages that you want to export.
Use the export options defined in the report

Select this check box to use the export options defined in a report. You cannot set any other formatting options.

Double quote string fields

Select this checkbox to surround string fields with double quotes(“”). To keep the quoted strings meaningful, multi-line text objects are exported in a single line.
Export page header and page footer

Select Once Per Report or On Each Page to choose when to export page headers and footers in an instance.

Select None to exclude page headers and footers from an instance.
Character Encoding

Select the character encoding system to use in the exported text file: UTF-8, UTF-16 Little Endian, or UTF-16 Big-Endian.

Minimum Lines per Page

Enter the number of lines of text to include between page breaks.

Insert Form Feed character

Select this check box to insert a form feed character after each page, as specified in the Minimum Lines Per Page field. The form feed character creates a page break.

Number of Characters per Inch

Enter a value between 8 and 20 to indicate the number of characters to include per inch. This setting determines how text files appear and are formatted.

Separated Values (CSV) format
Option Description

Use the export options defined in the report

Select this check box to use the export options defined in a report. You cannot set any other formatting options.

Delimiter

Enter the character to use as the delimiter.

Separator

Enter the character to use to separate values, or select the Tab check box.

Mode

Select Standard Mode or Legacy Mode. When you select Standard Mode, you can choose report, page, and group sections to include in an instance. When you select Legacy Mode mode, you cannot choose report, page, or group section options.

Report and page sections

If you chose Standard Mode, select Export or Do not export to indicate whether to export report and page sections.

If you selected Export, select the Isolate report/page sections check box if you want to isolate the report and page sections.

Group sections

If you chose Standard Mode, select Export or Do not export to indicate whether to export group sections. If you selected Export, select the Isolate group sections check box if you want to isolate the group sections.

XML
Option Description

Use the export options defined in the report

Select this check box to use the export options defined in a report. You cannot set any other formatting options.

XML Exporting Formats

Choose an XML export format, such as Crystal Reports XML.