none
Create report with complex and nested stored procedures

    Question

  • Hi all,

    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 ?
    Monday, April 16, 2007 5:55 AM

All replies

  • 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

    Monday, April 16, 2007 8:22 AM