Lucent Technologies CentreVu, User Manual

Page: 161 / 198

Advanced Report Design CentreVu CMS Custom Reports
Including Exceptions Data in a Custom Report
6-21
Including Exceptions Data in a Custom Report
6
For historical custom reports only, you can design reports that include
exceptions data. See the
CentreVu CMS R3V8 Database Items and
Calculations (585-210-939) document for a description of the exceptions
tables and the data they contain.
The steps for creating a custom report with exceptions data are almost
identical to the steps for creating any other custom report. As with any other
type of data, you must specify the database item(s), the table(s), the row
search conditions, and the report input fields. However, you cannot copy any
standard exceptions report on the Screen Painter. The exceptions reports do
not appear if you select
List all
in the Get Copy of Design window.
Also, in every exceptions table, the database item EXTYPE stores the types
of exceptions that occurred. However, exception types are stored as
numbers, not as character strings. If you want your report to list the types of
exceptions that occurred, then the types must be listed as numbers (see the
CentreVu CMS R3V8 Database Items and Calculations (585-210-939)
document for a description of these numbers). The VDN Exceptions Report
shown in
Figure 6-4 is an example of this.
Figure 6-4: VDN Exceptions Report — Sample 1
If you designed a custom exception report to replicate the standard VDN
Exceptions Report, then the design might appear as shown in
Figure 6-5 .
VDN Exceptions
ACD: burbank Printed 04/10/93 04:35 PM
Date: 04/09/93
Time
Time VDN Vector Exception Limit Threshold
------------------------------------------------------------------------------------------
09:16AM Catalog Sales Weekday Sales Number calls abandoned in vector 20
09:24AM Catalog Sales Weekday Sales Calls in ACD split queue 10
10:02PM Catalog Sales Off-hour Sales Calls disconnected 50