New Report in Historical Reports problem

[rhealy]

Does anyone know what the <ReportSQLCommand> Exec sp_ReportDisplayName refers to? I have created a new report format and have followed the directions of the Creating Custom Historical Reports for CRS Applications, but it does not explain what this command references and it fails with a SQL error.

[venkasub]

Hi,

Following is extracted from "Creating Custom Reports for Cisco CRA"

http://www.cisco.com/en/US/products/sw/custcosw/ps1846/products_programming_reference_guide09186a00801bbed0.html#1021938

ReportSQLCommand - SQL command (query or stored procedure) upon which the report is based. You can follow this name with any number of parameters. When this report is generated, the Cisco CRA Historical Report client will replace each parameter with its value.

Each parameter must follow these conventions:

A parameter must begin with a dollar sign ($)

A parameter may contain only alphabetic characters and underscores (_)

At a minimum, the SQL command requires the following parameters:

$StartDate—First date of the date range for which to generate information in the report, as specified by a user

$EndDate—Last date of the date range for which to generate information in the report, as specified by a user

$SortBy—Sort method that a user specifies for the report

If the command includes characters that the XML processor might interpret as markup characters, use the standard XML entity references for the characters or use hexadecimal character references. Refer to your XML documentation for more information.

You may find the following links useful for IPCC Express Historical Reporting(HR):

Understanding HR

http://www.cisco.com/univercd/cc/td/doc/product/voice/sw_ap_to/apps_3_1/english/admn_app/hist_rep/index.htm

Cisco CRA HR User Guide

http://www.cisco.com/univercd/cc/td/doc/product/voice/sw_ap_to/apps_3_1/english/agents/hr_user/index.htm

Cisco CRA Database Schema

http://www.cisco.com/univercd/cc/td/doc/product/voice/sw_ap_to/apps_3_1/english/admn_app/schema/index.htm

Hope it helps.

Regards

Venkat

[rhealy]

What I'm looking for is the name right after the Exec statement in the ReportSQLCommand. Is this just a variable name? If not, where do I define it?

[rhealy]

I understand why this is failing, but not sure how to fix the problem. I finally found the log file that displays my error. The file name after the EXEC statement in the ReportSQLCommand is a stored procedure. How can I create a stroed procedure in IPCC when it doesn't come with Enterprise Manager? Can someone help answer this problem?