Accessing multiple result sets from a stored procedure
-
hi, I am creating a report in SQL Reporting Services 2005. The data is coming from a stored procedure which has multiple select statements (multiple result sets). When I bind the report with the dataset ,I am getting the data only from the first select statement (1st table), whereas I am getting the data from each select statement in the stored procedure. Is there any way to get the data while designing the reports? Thanks in advance.
-
hi, I am creating a report in SQL Reporting Services 2005. The data is coming from a stored procedure which has multiple select statements (multiple result sets). When I bind the report with the dataset ,I am getting the data only from the first select statement (1st table), whereas I am getting the data from each select statement in the stored procedure. Is there any way to get the data while designing the reports? Thanks in advance.
You can use the DataSet.Load[^] option and pass in a SqlDataReader and it will fill multiple DataTables with the multiple resultsets.