# Report Options

The following options are available in the General Options window:

# General Options

- Allow Execution in Viewer: Allow or prevent the report from being run in the Report Viewer.

- Include Setup Info: Select Top or Bottom to display the data categories, sorts, and filters at either the beginning or end of the report.

- Allowed Export Types: Enable or disable output types for the report.

- Default Export Type: Specify the default output type for the report.

- Report Tree Shortcut: Specify whether the Run icon for the report in the report tree runs the report in the Report Viewer or exports it in the default output type.

- Filter Execution Window: Select which type of Filter menu displays when running the report with prompting filters:

  - Default – Display the default type of filter execution window.

  - Standard – Display the standard filter execution window.

  - Simple with Operator – Display a simplified filter execution window that only allows the operator and value to be changed.

  - Simple without Operator – Display a simplified filter window that only allows the filter value to be changed.

- Always Show Filters in Report Viewer: Show the filter menu and allow changes to be made every time the report is run.

- No Data Qualify Display Mode: Select what to display if no data qualifies for the report.

  - Show Message – Display the standard no data qualified message.

  - Show Report – Display the Page Header, Page Footer, Report Header, and Report Footer sections of the report. Any cells containing Data Fields will not be displayed.

## Excel Options

- Suppress Formatting: Export only the report data to Excel, without the formatting.

- Freeze Rows: Freeze the top number of rows when exporting to Excel, so that the rows stay anchored to the screen when scrolling through the report.

- Freeze Columns: Freeze the left number of columns when exporting to Excel, so that the columns stay anchored to the screen when scrolling through the report.

## Page Options

- Page Size: Select the page size of the report output.

- Page Orientation: Specify whether the report runs in Portrait or Landscape orientation.

- Fit to Page Width: Fit the width of the report to the width of the page.

# Report Viewer Options

The following options are available in the Report Viewer Options window:

## General

- Show Grid: Show or hide grid lines.

- Simulate PDF: Have the report appear as if it was on a page.

- Allow Hide/Show Columns in Report Viewer: Enable or disable the ability to hide columns.

- Show Toolbar in Report Viewer: Select whether to show or hide the interactive toolbar in the Report Viewer.

## Filters

To allow users to select interactive filters in the Report Viewer, add data fields as filters. For each filter you can select the following options:

- Title: Enter text to appear in place of the data field name.

- Type: Specify the type of ability the user has to choose filter values:

  - Single Choice - A drop down menu with all possible filter values. Users can choose one value.

  - Multiple Choice - A check list with all possible filter values. Users can choose multiple values.

  - Single Slider - Users can choose one value by sliding a point along a scale.

  - Range Slider - Users can choose multiple values between two points on a scale.

- Value Sort Direction: Whether the filter values should display in ascending or descending order.

- Filter Value Format: Select how the filter values should display.

- Initially Display Filter on Panel: Display the filter choice automatically when the report is run.

## Sorts

Display Sorts in Report Viewer: Select whether the user can see and modify sorts in the Report Viewer.

In the Title column, you can enter text to appear in place of the data field names.