cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
464
Views
0
Helpful
1
Replies

CUIC custom report using a custom stored procedure

HaiKLe8577
Level 1
Level 1

I am having problem of creating an CUIC report using a custom stored procedure in the Report-Definition building process.  I kept getting this error:  Stored procedure doesn't exist or syntax is invalid.  The credential that I used allowed me to execute the procedure in SQL Server without any issue.  I also verified the permission of the stored procedure and it seemed to be in order.

The stored procedure takes 3 input parameters sp_GetXRecords (startDate date, endDate date, agentList varchar(MAX))

I had CUIC report definition's builder to recognized the stored procedure once but I thought it was related to the stored procedure's name length.  I might have enabled other permissions that I cannot seem to remember.

Any suggestions or advises.  Many thanks in advance

1 Reply 1

HaiKLe8577
Level 1
Level 1

I have resolved the issue.  Thank you.