Cisco Cisco Unified Customer Voice Portal 11.0(1)

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

To run Crystal Reports templates, you must replace the ODBC connection with a local
connection. 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, perform the following steps:

1. Install Crystal Reports or a Crystal Viewer.

2. Install the Informix ODBC driver, which is included in the CSDK installer. The driver is

also available on the IBM web site.

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

a SQL Server connection to an HDS if required.

4. Open the template in Crystal Reports.

5. From the Database menu, choose Set Data Source Location.

6. In the Replace with window, perform the following steps to open a connection:

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