Displaying thresholds on a report

Individual cell data can be automatically formatted differently than the data in the rest of the report, including a report displayed on a document. Data that is formatted differently calls attention to itself, and makes that data easier to locate for analysis.

To see a report displaying various types of thresholds, such as symbols, highlighted values, and so on, see the Formatting a Report chapter in the Basic Reporting Guide.

Conditional formatting is formatting that is applied to values when certain conditions are met.  For example, it is possible to have all profit margins below a certain percentage appear in red, while all other profit margins are displayed in black. The data that meets the condition is considered to be data that has passed the threshold of the condition; once data passes the threshold, the formatting is applied. So thresholds are cells of data that are formatted differently from the rest of the data on a report; the formatting is applied dynamically, whenever the report is re-executed.

Thresholds highlight particular data in a report by displaying special cell formats, symbols, images, or replacement text.

To display the thresholds on your report

1 Run a report.
2 From the Tools menu, select Report Options. The Report Options dialog box opens. On the General tab, select the Show thresholds check box.
3 Click OK at the bottom of the dialog box. Any thresholds in the report are displayed.

To display or hide thresholds on a report in a document

1 Edit the document that contains the report.
2 In Editable Mode, click the report to select it.
3 On the Data toolbar, click the Toggle Thresholds icon Toggle Thresholds icon to switch between showing and hiding thresholds.
To display the Data toolbar, click Data on the menu bar.

Related topic

Report Options dialog box: General