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
||From the Tools
menu, select Report Options.
The Report Options dialog box opens. On the General
tab, select the Show thresholds
at the bottom of the dialog box. Any thresholds in the report are
To display or hide thresholds on a report in a document
||Edit the document that contains the report.
||In Editable Mode, click the report to select it.
||On the Data toolbar, click the Toggle Thresholds icon to switch between showing and hiding thresholds.
||To display the Data toolbar, click Data on the menu bar.