Cisco Cisco Customer Voice Portal 8.0(1)

Reporting Against the Database

Unified CVP does not provide a native reporting engine. A third-party reporting engine, such
as Crystal Reports, can be used to generate various reports against the predefined Unified CVP
database schema. Unified CVP does provide, as examples, a few sample report templates. This
chapter discusses the various sample report templates.

Using the Cisco-Provided Sample Report Templates

Unified CVP provides a few sample Crystal Reports templates, as well as the SQL statements
used in the reports. This may make it easier for you to generate customized reports with your
own reporting tools.

Thus, these samples can be used in three ways:

•

As is, if you are using Crystal Reports and these templates meet your needs

•

As a foundation that you can alter to create Crystal Report templates that better suit your
needs

•

As examples of report templates that you can use to guide you in creating report templates
for whatever report engine you are using

The templates can be run using Crystal Reports or a Crystal Viewer. Either of these would
execute the sample templates to query against the reporting database. The sample reports are
based on data that was generated by sample VoiceXML scripts. These sample scripts are shipped
with the Reporting Server so that you can run the scripts to generate data and then run the sample
reports. The SQL statements used by Crystal Reports are also provided.

Note: Sample templates are available on the Cisco Unified CVP Release 4.1(1) Software CD,
in a top-level directory called Samples. The templates are installed on the Reporting Server.
The sample scripts, and the SQL statements, are also provided in the Samples directory.

Reporting Guide for Cisco Unified Customer Voice Portal Release 4.1(1)