Setting Report Options

Report options specify the report location and format.

  To set report options:

  1. Click the lower half of the Create Report icon and select Report Preferences to set a location and format for the report before you select a report.

  2. In the Location group, select whether to create the report in a new Microsoft Excel workbook or the current workbook.

    If you select 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 text box.

  3. 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 selected.

    If you choose to include cell comments, only non-Crystal Ball comments are included; Crystal Ball cell comments are redundant and are filtered out.

  4. In the Chart Format group, select Image to create a Crystal Ball chart or select Microsoft Excel to create a Microsoft Excel chart.

    If you select Image, you can format charts using the Crystal Ball Chart Preference settings. Image is the default chart format.

  5. When all settings are complete, click OK.