I had developed all my reports using CRXI and stored procedures of MSSQL 2000. Now I am migrating from CRXI to SSRS. But i have a problem because of my report stored procedures. These stored procedures are complex and nested. When i try to use procedures in a report, it gives a error. When i comment out my EXEC line in my procedures, it goes OK.
Please help me to do this ?
It can only mean that the nested stored procedure has issues and needs to be fixed. The stored procedure that you use in SQL Reporting services can use a stored procedure which has nested another stored procedure.
Shyam
No comments:
Post a Comment