Filter
Top Products
13-36
User Guide for Cisco Secure Access Control System 5.4
OL-26225-01
Chapter 13 Managing Reports
Formatting Reports in Interactive Viewer
To create a custom date or time format,
Step 1 Select a date-and-time column, then click Format.
The Date or Time column format window appears.
Step 2 In Format Date or Time As field, select Custom.
A second field, Format Code, appears.
Step 3 In the Format Code field, type a format pattern such as those shown in Table 13-10.
Step 4 Click Apply.
Formatting Boolean Data
A Boolean expression evaluates to True or False. For example, you create a calculated column with the
following expression:
ActualShipDate <= TargetShipDate
If the actual ship date is before or on the target ship date, the expression evaluates to True. If the actual
ship date is after the target ship date, the expression evaluates to False.
If you do not format a column of Boolean data type, the column displays the values True and False. To
specify different labels, select the column and choose Format Data. Then type the labels in Boolean
Column Format, as shown in Figure 13-17.
Table 13-10 Results of Custom Date Formats
Format Result of formatting
MM-dd-yy 04-15-06
E, M/d/yyyy Fri, 4/15/2006
MMM d Apr 15
MMMM April
yyyy 2006
W 3 (the week in the month)
w 14 (the week in the year)
D 105 (the day in the year)