SQL Server Performance

Help with multi resultset

Discussion in 'SQL Server Reporting Services' started by bijesh, Jul 6, 2006.

  1. bijesh New Member

    Hi,

    I have a SP that returns more than one resultset and I want to use both the resultsets in my SQL Report.
    But, on calling that SP from SQL Report only the first resultset is fetched and displayed. Is there any way of including the second resultset in the Dataset so that I can display the data contained in the second resultset also?

    Thanks,

    Bijesh
  2. peterlemonjello New Member

    From BOL:

    Reporting Services supports stored procedures that return only one set of data. If a stored procedure returns multiple result sets, only the first one is used.

  3. bijesh New Member

    Thanks Pete!

    It seems I will have to change my SP to make it work.

    Thanks,

    Bijesh

Share This Page