Report Options Dialog: General

If you arrived here from Workstation, see the Workstation Document Authoring Help.

The options on the General tab of the Report Options dialog box include the following.

For steps and background information on any options below that do not have links to help topics, see the Basic Reporting Help and the Advanced Reporting Help.

Headers:
- Rows: Determine whether to Merge and/or Lock the row headers on the grid report.
- Columns: Determine whether to Merge and/or Lock the column headers on the grid report.
View:
- Outline: Select whether to include an outline view of the grid report results. For steps, see How to Group Data by Indenting: Outline Mode on a Report.
- Show Banding: Select whether to include color banding on the grid report results. For steps, see How to Apply Color Banding to a Report.
- Show attribute form names: Determine how headers for attributes and attribute forms are displayed in a grid report. For example, you can choose to have a header containing the attribute form name automatically displayed above each attribute form shown in the grid, or have a single header automatically displayed for each attribute in the grid, with each header containing only the attribute name. For examples and detailed steps to format attribute and attribute form headers, see the Advanced Reporting Help. The following options are available:
  - Off (default): Select this option to have the attribute name automatically displayed in the header of each attribute in the grid. No attribute form names are included in the grid.
  - On: Select this option to have a header automatically displayed for each attribute form in the grid, with each header consisting of the attribute name followed by the attribute form name.
  - Form name only: Select this option to have a header automatically displayed for each attribute form in the grid, with each header consisting of only the attribute form name.
  - Show attribute name once: Select this option to have a header automatically displayed for each attribute form in the grid and have the attribute name included only in the header for the first attribute form for each attribute. The remaining attribute forms are displayed using the attribute form name only.
  - Automatic: Select this option to automatically display either headers for each attribute or each attribute form depending on the number of attribute forms visible in the grid for each attribute. If only one attribute form is shown in the grid for an attribute, the attribute is displayed with a header containing the attribute's name. If more than one of the attribute's forms are visible in the grid, each attribute form is displayed with a header containing the attribute name followed by the attribute form name.
- Show thresholds: If thresholds have been enabled for the report, you can select whether to include thresholds.
  You must have the appropriate privileges to enable the Show thresholds setting.
- Remove extra column: Select this option to hide the word "Metrics in the report. (Selected by default.)
- Hide Null/Zero toggle behavior: Select this option to determine how MicroStrategy hides null and zero metric values in the grid. For detailed steps, see How to Determine How Null and Zero Metric Values Are Displayed or Hidden in a Grid Report. From the drop-down list, select one of the following:
  - Hide Zeros Only: Select this option to hide rows and columns that consist only of zero metric values.
  - Hide Nulls or Zeros (default): Select this option to hide rows and columns that consist only of null or zero metric values.
  - Hide Zeros Only: Select this option to hide rows and columns that consist only of zero metric values.
Drilling:
- Drill options: Select the drilling options where users can drill:
  - No drilling: Disable drilling. Users cannot drill in any direction.
  - Drill down only: Users can only drill down from objects on the report. They cannot drill up or across to other objects.
  - Drill anywhere: Users can drill up, down, and across to any objects available in the drill menu. For steps, see How to Drill on a Grid Report.
Full Screen Mode:
- Always open this report in full screen mode: Determine whether the report opens in Full Screen Mode by default. For details, see How to Maximize Your View of a Report: Full Screen Mode.

Report Options Dialog: General

Related Topics