locked
How to return multiple values from stored procedures RRS feed

  • Question

  • How to return multiple values from stored procedures to reports in sql server 2005
    Friday, June 22, 2007 7:17 AM

Answers

  • Hello,

     

    Do you mean multiple resultsets from a single stored procedure?  This is not supported, Reporting Services will only use the first one.  You could break up your stored procedure so that each resultset would populate it's own dataset in the report.

     

    Hope this helps.

     

    Jarret

    Friday, June 22, 2007 12:59 PM
  • Not possible, one resultset only.


    Jens K. Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---

    Friday, June 22, 2007 1:20 PM

All replies

  • Hello,

     

    Do you mean multiple resultsets from a single stored procedure?  This is not supported, Reporting Services will only use the first one.  You could break up your stored procedure so that each resultset would populate it's own dataset in the report.

     

    Hope this helps.

     

    Jarret

    Friday, June 22, 2007 12:59 PM
  • Not possible, one resultset only.


    Jens K. Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---

    Friday, June 22, 2007 1:20 PM
  • thanx
    Saturday, June 23, 2007 10:35 AM