Report options specify the report location and format.
To set report options:
In the Create Report dialog, click the Options tab.
(In Microsoft Excel 2007 or later, if you clicked the lower half of the Create Report icon, choose Report Preferences to set a location and format for the report before you choose a report.)
In the Location group, choose whether to create the report in a new Microsoft Excel workbook or the current workbook.
If you choose Current Workbook, a new sheet is created after the current sheet. You can enter a descriptive name for the new sheet in the Sheet Name field.
In the Formatting group, indicate whether to include the cell location (workbook, worksheet, and cell address) in report headers and whether to include cell comments.
By default, these settings are checked.
If you choose to include cell comments, only non-Crystal Ball comments are included; Crystal Ball cell comments are redundant and are filtered out.
In the Chart Format group, choose Image to create a Crystal Ball chart or choose Microsoft Excel to create a Microsoft Excel chart.
If you choose Image, you can format charts using the Crystal Ball Chart Preference settings. Image is the default chart format.