Filter
Top Products
13-37
User Guide for Cisco Secure Access Control System 5.4
OL-26225-01
Chapter 13 Managing Reports
Formatting Reports in Interactive Viewer
Figure 13-17 Specifying Display Values for True and False
Applying Conditional Formats
Conditional formatting changes the formatting of data when a certain condition is true. For example, in
a report that shows customers’ past-due invoices, you can highlight in red any customer name that has
an invoice 90 days or more past due. Then, you can highlight in blue any customer name that has an
invoice 60 days or more past due.
To set conditional formats, open the Conditional Formatting dialog box by right-clicking a column and
selecting Style > Conditional Formatting. You can set up to three conditional formatting rules for a
single column. You also can remove or modify conditional formatting.
On Conditional Formatting, you create a rule, or condition, for displaying the data in the column you
selected. The rule includes both the condition that must be true and the formatting to apply. Figure 13-18
shows Conditional Formatting.
Figure 13-18 Conditional Formatting in Interactive Viewer
You can affect the formatting of one column based on the value in another column. For example, if you
select the CustomerName column, you can base the condition on the creditRank column so that
conditional formatting applies to the customer name if the customer’s creditRank is a particular value.
You set various types of comparisons, such as whether the data in the comparison column is null or False.
You can also compare the column value to one or two other values. For example, you can specify that
data that is less than or equal to a value triggers the conditional formatting.
You also can check whether a value is between or not between two values. For example, you can specify
conditional formatting to apply if the order total is between $10,000 and $100,000. With this setting, the
names of all customers whose orders total between $10,000 and $100,000 take the conditional
formatting.