Cisco Cisco Customer Voice Portal Downloads

The report discussed here is designed to only return data from one call at a time. The user is
prompted to enter the RouterCallKey and the RouterCallKeyDay when launching the report.
All of the Unified ICME data originates from the Termination_Call_Detail table. This is a very
large table and the report must do a sequential scan to retrieve the data as the RouterCallKey
and the RouterCallKeyDay are not indexed columns. To minimize the effect on the HDS you
should run the report during off-hours, or run against an HDS that does not support concurrent
reporting users.

0

8305558931

9789360000

312

159120

7/5/2006
2:30:23PM

7/5/2006
2:28:23PM

N

None

None

5001

7/5/2006
2:39:23PM

1

N

5002

5001

5001

7/5/2006
2:30:23PM

2

Running Crystal Reports Templates

In order to run Crystal Reports templates you must replace the ODBC connection with a local
one. Do not install a reporting package on the Reporting Server. Select a machine that is not
used by Unified CVP to develop and launch reports.

To change a template's ODBC connection, complete the following steps:

Note: These steps are only intended for advanced users. More complete documentation is
installed with the Crystal reporting product. If you are unfamiliar with setting up and configuring
ODBC connections, please see the Crystal Reports documentation.

1. Install Crystal Reports or a Crystal Viewer.

2. Install the Informix ODBC driver which is included in the CSDK installer. This is available

on the IBM web site.

3. Configure an ODBC connection that points to the Unified CVP Informix Server. Configure

a SQL Server connection to an HDS if required.

4. Open the template in Crystal Reports.

5. Choose 'Set Data Source Location' from the 'Database' menu.

6. Open your connection in the 'Replace with' windows by doing as follows:

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