Cisco Acs 5x User Guide

13-37
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Formatting Reports in Interactive Viewer
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...

13-38
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Formatting Reports in Interactive Viewer
b.In the next field, use the drop-down list to select the operator to apply to the column you selected. 
You can select Equal to, Less than, Less than or Equal to, and so on.
Depending on your selection, zero, one, or two fields appear to the right. If you selected Is Null, Is 
Not Null, Is True, or Is False, zero fields appear to the right. If you selected...

13-39
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Formatting Reports in Interactive Viewer
Step 4On Conditional Formatting, choose Format, and set the formatting for the conditional text. You can set 
the font, font size, font color, and background color. You also can specifying displaying the data in bold, 
italic, or underlined font style. 
Step 5You set the formatting by using the same Font dialog box used for formatting labels, as shown in...

13-40
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Formatting Reports in Interactive Viewer
Figure 13-23 Removing a Conditional Format in Interactive Viewer
Step 4
Click Apply.
Setting and Removing Page Breaks in Detail Columns
In Interactive Viewer, you can force page breaks after a preset number of rows. 
Step 1Select and right-click a detail column. 
Step 2From the context menu, select Group > Page Break. 
The Page Break window appears.
Step 3In...

13-41
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Organizing Report Data
Figure 13-24 Setting a Page Break
Step 3
Specify whether to set a page break before every group, or for every group except the first or last groups. 
To delete an existing page break, select None in Before group or After group.
Step 4Click Apply.
Organizing Report Data
You can use Interactive Viewer to organize report data. 
This section contains the following topics:...

13-42
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Organizing Report Data
Reordering Columns in Interactive Viewer
To reorder columns:
Step 1Select and right-click a column. 
Step 2From the context menu, select Column > Reorder Columns.
The Arrange Columns window appears
Step 3Select the column you want to move. 
NoteYou can select only detail rows, not groups or sections. 
Step 4Click the up or down arrows at the right until the column is in the...

13-43
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Organizing Report Data
Figure 13-26 Move to Group Header Dialog Box
Step 3
From the Move to Group field, select a value.
Step 4In the Header row field, select the row number in which to move the value you selected in Step 3.
Step 5Click Apply. 
The data value from the first detail row in each group appears in each group header, as shown in 
Figure 13-27. The Name column displays one customer name...

13-44
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Organizing Report Data
Hiding or Displaying Report Items
To hide or display report items:
Step 1Select and right-click a column. 
Step 2Select Hide or Show Items. 
The Hide or Show Items dialog box appears, similar to Figure 13-28.
Figure 13-28 Hiding or Displaying Report Items
Step 3
Select any items you want to hide or Deselect any hidden items you want to display.
To display all hidden items,...

13-45
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Organizing Report Data
Displaying Hidden Columns
TO display hidden columns:
Step 1Select and right-click a column. 
Step 2Select Column > Show Columns. 
The Show Columns dialog box appears.
Step 3Select any items you want to display. Use Ctrl to select several columns. 
Step 4Click Apply.
Merging Columns
You can merge the data from two or more columns into one column. For example, in Figure 13-29...

13-46
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Organizing Report Data
Figure 13-30 Merged Column
To merge data in multiple columns:
Step 1Select and right-click the columns
Step 2Select Column > Merge Columns.
Selecting a Column from a Merged Column
You can aggregate, filter, and group data in a column that contains data that is merged from multiple 
columns. You must first select one of the columns on which to aggregate, filter, or group data....