Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
New Member

Customize reports error

Hi,

We use IPCC express 4.0

we wrote customize reports for Historical reports

but we got problem like

i can report SQL Query Analyzer : http://img502.imageshack.us/img502/6040/queryanalyzerwk9.jpg

i can report crystal reports : http://img502.imageshack.us/img502/5899/crystalreportspx3.jpg

but when i declare .rpt & .xml in historical reports and when i declare datetime and necessary skill : http://img248.imageshack.us/img248/5716/historicalreportserrorht2.jpg

i get in LOG file this message :

2: 10.07.2007 16:26:18 %CHC-LOG_SUBFAC-3-UNK:The following SQL Command failed due to ([Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'CC_sp_Agent_Calls'.)SQL Command=[Exec CC_sp_Agent_Calls '07/03/2007 9:00:00 AM', '07/03/2007 11:00:00 AM', 0, 0, 'NULL', 'OR|AYLIN CAN', 'NULL']

3: 10.07.2007 16:26:18 %CHC-LOG_SUBFAC-3-UNK:TraceDBError #1:(ADO Error# -2147217900|Description [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'CC_sp_Agent_Calls'.|Source Microsoft OLE DB Provider for ODBC Drivers|SQLState 37000|NativeError 2812)

4: 10.07.2007 16:26:18 %CHC-LOG_SUBFAC-3-UNK:SQL Command Failed | Could not obtain information from database: The syntax of SQL command contains errors. Check the log file for error 5048.

5: 10.07.2007 16:26:34 %CHC-LOG_SUBFAC-3-UNK:Failed to run Interpreted SQL Command(Exec CC_sp_Agent_Calls '07/03/2007 9:00:00 AM', '07/03/2007 11:00:00 AM', 0, 0, 'NULL', 'OR|AYLIN CAN', 'NULL')

Thank you

1 REPLY
New Member

Re: Customize reports error

i was just having the same problem about ten minutes ago.. i was getting the 5048 error.. then noticed in my xml definition where i placed $CSQList, it wasn't in single quotes.. added '$CSQList' and it worked.. i take it all string params need to be enclosed in the single quotes..

hope that helps

385
Views
0
Helpful
1
Replies
CreatePlease to create content