Cisco Acs 5x User Guide

13-47
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Organizing Report Data
Sorting Data
When you place data in a report design, the data source determines the default sort order for the data 
rows. If the data source sorts a column in ascending order, the column is sorted in ascending order in the 
design. Typically, however, data appears randomly in the data source. 
A column is likely to display customer names, for example, in the order in which...

13-48
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Organizing Report Data
Figure 13-31 Sorting Multiple Columns
If the report uses grouped data, the drop-down lists in Advanced Sort show only the detail columns in 
the report, not the columns you used to group the data.
Grouping Data
A report can contain a great deal of data. Consider the task of listing every item a corporation owns, 
along with information such as the purchase price, purchase...

13-49
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Organizing Report Data
Figure 13-32 Ungrouped Data
To organize all this information into a useful inventory report, you create data groups and data sections. 
Data groups contain related data rows. 
For example, you can create a report that lists all heavy equipment in one group, all office furniture in 
another group, all telephony equipment in a third group, and so on. For each group, you can show...

13-50
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Organizing Report Data
Adding Groups
To add groups:
Step 1Select and right-click the column you want to use to create a group. 
Step 2From the Context menu, select Group > Add Group. 
The new group appears in the viewer. As shown in Figure 13-34, the group expands to show all the detail 
rows. To collapse the group, click the minus sign ( - ) beside the group name.
Figure 13-34 Adding a Group...

13-51
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Organizing Report Data
Step 4To set a grouping interval, select Group every and enter a value and select the grouping interval. 
For example, to create a new group for every month, type 1 and select Month from the drop-down list. 
The report displays monthly data groups, as shown in Figure 13-36.
Figure 13-36 Data Grouped by Month
Removing an Inner Group
To remove an inner group:
Step 1Select and...

13-52
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Organizing Report Data
Figure 13-37 Calculated Column
To create a calculation, you
Provide a title for the calculated column. 
Write an expression that indicates which data to use and how to display the calculated data in the 
report. 
The expression contains a function and one or more arguments. Arguments indicate the data you 
want to use to create the calculation. 
As shown in Figure 13-38, when...

13-53
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Organizing Report Data
Understanding Supported Calculation Functions
Table 13-11 provides examples of the functions you can use to create calculations. 
NoteThe Calculation dialog box does not support the use of uppercase TRUE and FALSE functions in 
expressions.Calculation also does not support the use of initial capital letters for True and False. These 
functions must be expressed in lowercase...

13-54
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Organizing Report Data
COUNT( ) Counts the rows in a table.COUNT( )
COUNT(groupLevel) Counts the rows at the specified group level.COUNT(2)
COUNTDISTINCT(expr) Counts the rows that contain distinct values in a 
table.COUNTDISTINCT([CustomerID])
COUNTDISTINCT([Volume]*2)
COUNTDISTINCT
(expr, groupLevel)Counts the rows that contain distinct values at the 
specified group...

13-55
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Organizing Report Data
FIRST(expr, groupLevel) Displays the first value that appears in the specified 
column at the specified group level.FIRST([customerID], 3)
IF(condition, doIfTrue, 
doIfFalse)Displays the result of an If...Then...Else statement.IF([purchaseVolume] >5 , 7 , 0)
where
[purchaseVolume] is the column 
name and >5 is the test condition.
7 is the value to place in the new 
column if...

13-56
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Organizing Report Data
ISTOPNPERCENT(expr, 
percent, groupLevel)Displays True if the value is within the highest n 
percentage values for the expression at the specified 
group level, and False otherwise.ISTOPNPERCENT([SalesTotals], 
5, 3)
LAST(expr) Displays the last value in a specified column.LAST([FinishTime])
LAST(expr, groupLevel) Displays the last value for the expression at the 
specified...