Cisco Acs 5x User Guide

13-27
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Formatting Reports in Interactive Viewer
Step 2Navigate to the location where you want to save the file.
Step 3Type a file name and click Save. 
Step 4Click OK on the confirmation message that appears. 
Formatting Reports in Interactive Viewer
You can use the Interactive Viewer to format reports. 
This section contains the following topics:
Editing Labels, page 13-27
Formatting Labels, page 13-28...

13-28
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Formatting Reports in Interactive Viewer
Step 2Select Change Text. 
The Edit Text dialog box appears.
Step 3Modify the text as desired and click Apply.
Formatting Labels 
To modify the formatting of a label:
Step 1Click on the label and then select Style > Font. 
The Font dialog box appears. 
Step 2Select the formats you desire, then click Apply.
Formatting Data
There are several ways to modify how...

13-29
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Formatting Reports in Interactive Viewer
Changing Column Data Alignment 
To change the alignment of data in a column, right-click the column and select Alignment from the 
context menu. Then, choose one of the alignment options: Left, Center, or Right.
Formatting Data in Columns
The default formatting for column data comes from the data source. Typically, you modify the formatting 
of column data to...

13-30
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Formatting Reports in Interactive Viewer
Formatting Data Types
In an information object, as in the relational databases on which information objects are based, all the 
data in a column is of the same data type, excluding the column header. The column can display numeric 
data, date-and-time data, or string data.
Each data type has a range of unique formats. Numeric data, for example, can appear as...

13-31
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Formatting Reports in Interactive Viewer
Formatting Numeric Data
Numeric data can take several forms. A column of postal codes requires different formatting from a 
column of sales figures. Figure 13-16 shows the numeric formats you can use.
Figure 13-16 Formats for Numeric Data
The data type of a column is determined by the data source. Keep in mind that a text or string data type 
can contain...

13-32
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Formatting Reports in Interactive Viewer
Step 7In Negative Numbers, select an option for displaying negative numbers, by using either a minus sign 
before the number or parentheses around the number.
Step 8Click Apply.
Formatting Fixed or Scientific Numbers or Percentages
Step 1Select a column that contains numeric data, then click Format.
The Number column dialog box appears.
Step 2In Format Number...

13-33
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Formatting Reports in Interactive Viewer
Step 3In Format Code field, type a format pattern similar to those shown in Table 13-7. 
Step 4Click Apply.
Formatting String Data
Step 1To define the format for a column that contains string data, select the column, then click Format.
The String column format appears. 
Step 2Select an option from the drop-down list. See Table 13-6 for the standard string...

13-34
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Formatting Reports in Interactive Viewer
Step 1Select a string data column, then click Format.
The String column format window appears. 
Step 2In Format String as field, select Custom. 
A second field, Format Code, appears.
Step 3In the Format Code field, enter a format pattern such as those shown in Table 13-9. 
Step 4Click Apply.
Formatting Date and Time
The appearance of date and time data...

13-35
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Formatting Reports in Interactive Viewer
Table 13-6 shows the standard date-and-time data type formats.
Step 1Select a column that contains date or time data, then click Format.
The Date and Time Format window appears. 
Step 2In Format Date or Time As field, select the desired option. 
Step 3Click Apply.
Formatting Custom Date and Time
You can set custom date formats. Use custom date formatting,...

13-36
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Formatting Reports in Interactive Viewer
Formatting Boolean Data
A Boolean expression evaluates to True or False. For example, you create a calculated column with the 
following expression:
ActualShipDate  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...