Displaying more than one result from Stored Procedures

Hi,

I am executing my Stored Procedure in (SQL Server 2008) it return 5 table results. Am able to display the first table result values in (.dplx) file. Where as am not able to display the 2 or 3 or 4 or 5 tables resultset in report designer (.dplx) file by using (Record Area & Record Box) controls.

SP OUTPUT:

Table1:

Impl    Q3-2014    Q4-2014
0       10.23       32.12

Table2:

Q0      Q1         Q2
10.12   12.76      13.23


When i add in record controls i.e. column name "Q0" (from 2 table resultset column name)getting error

Error Message:

Exception Details: System.IndexOutOfRangeException: Q0

how to get this?

ManyThanks

Hello,

In the case where a single stored procedure is returning multiple tables, the ReportWriter can only display the first table. As a workaround, split your stored procedure into multiple stored procedures each returning a table then you can use sub-reports to display each of those tables. For this workaround, you have to make sure that you are using a valid query (that returns a null value or a single record) as the main report’s query.

Thanks,
ceTe Software Support Team.