Cisco Acs 5x User Guide

13-67
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Hiding and Filtering Report Data
Figure 13-43 Suppressed Values
You can suppress duplicate values to make your report easier to read. You can suppress only consecutive 
occurrences of duplicate values. In the Location column in Figure 13-43, the Boston value is suppressed 
in the second, third, fourth, and fifth rows. If Boston occurs again after the listing for NYC, that 
occurrence of Boston is...

13-68
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Hiding and Filtering Report Data
Figure 13-44 Group Detail Rows Displayed
Figure 13-45 shows the results of hiding the detail rows for the creditrank grouping.
Figure 13-45 Group Detail Rows Hidden

To collapse a group or section, select and right-click a member of the group or section that you want 
to collapse.
The context menu appears. 
To display the group members without their detail rows,...

13-69
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Hiding and Filtering Report Data
Types of Filter Conditions
Table 13-15 describes the types of filter conditions and provides examples of how filter conditions are 
translated into instructions to the data source.Bottom N Returns the lowest n values in the column.
Bottom Percent Returns the lowest n percent of values in the column.
Equal to Returns values that are equal to a specified value.
Greater...

13-70
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Hiding and Filtering Report Data
Setting Filter Values
After you choose a condition, you set a filter value.
Step 1To view all the values for the selected column, select Select Values. 
Additional fields appear in the Filter dialog box as shown in Figure 13-46. These fields allow you to find 
and select a filter value.
Table 13-15 Examples of Filter Conditions
Type of filter 
condition Description...

13-71
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Hiding and Filtering Report Data
Figure 13-46 Selecting a Filter Value in Interactive Viewer
Step 2
To search for a value, type the value in the Find Value field, then click Find. 
All values that match your filter text are returned. For example, if you type:
40
the text box displays any values in the column that begin with 40, such as:
40
400
4014
40021
When you see the value you want in the large...

13-72
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Hiding and Filtering Report Data
Step 3From the Condition pulldown menu, select a condition. Table 13-14 describes the conditions you can 
select. 
If you select Between or Not Between, Va l u e  F r o m and Va l u e  To, additional fields appear to 
display a range of values. 
If you select Is False, Is True, Is Null, or Is Not Null, no value fields appear. For all other 
selections, a single value...

13-73
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Hiding and Filtering Report Data
Figure 13-47 The Advanced Filter Dialog Box in Interactive Viewer
Advanced Filter provides a great deal of flexibility in setting the filter value. For conditions that test 
equality and for the Between condition, you can either set a literal value or you can base the value on 
another data column. 
For example, you can request actual shipping dates that are greater...

13-74
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Hiding and Filtering Report Data
Step 7Validate the filter syntax by clicking Va l i d a t e.
You have now created a filter with one condition. The next step is to add conditions.
Step 8Follow steps Step 3 to Step 7 to create each additional desired filter condition. 
Step 9In Filters, adjust the filter conditions to achieve the desired filtering. You can combine the conditions in 
the following...

13-75
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Understanding Charts
Step 2From the Filter pulldown menu, select a particular number of rows or a percentage of rows, as shown in 
Figure 13-48. 
Step 3Enter a value in the field next to the Filter pulldown menu to specify the number or percentage of rows 
to display. 
For example, to select the top 10 sales representatives by sales volume, after you have selected the 
column that contains sales...

13-76
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Understanding Charts
Figure 13-49 Parts of a Basic Bar Chart
There are a variety of chart types. Some types of data are best depicted with a specific type of chart. 
Charts can be used as reports in themselves and they can be used together with tabular data report styles.
Modifying Charts
The basic characteristics of a chart are determined in the report design editor. Such things as the chart 
type...