Schedule Objects › Set General Scheduling Options › Choose a Format › Additional Formatting Options for Crystal Reports › Microsoft Excel

Microsoft Excel

Use the export options defined in the report

To use the export options already defined in the report, select this option. You cannot 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 width 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.