13-36
User Guide for Cisco Secure Access Control System 5.4
OL-26225-01
Chapter13 M anaging Reports
Formatting Reports in Interactive Viewer
To create a custom date or time format,
Step1 Select a date-and-time column, then click Fo rmat.
The Date or Time column format window appears.
Step2 In Format Date or Time As field, select Custom.
A second field, Format Code, appears.
Step3 In the Format Code field, type a format pattern such as those shown in Table13-10.
Step4 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 di splays 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 Figure13 -17.
Table13-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)