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