Hello, I have to create a report for which i have an SP which gives 2 result set on execution , i have to bind both of this result set to a sindle dataset. Can anyone plz help me in getting the solution. I am new to sql reportd

This should be in the SSRS forum - but the answer is that you cannot do that. SSRS does not support multiple recordsets from a single stored procedure.Chuck

Hi Asrar, As Chuck has posted above, Reporting Services supports stored procedures that return only one set of data at this point. If a stored procedure returns multiple result sets, only the first one is used. This is by design. To work around the issue, there are two suggestions for your reference: Write a wrapper stored procedure that uses the original stored procedure but only returns the second result setRedesign the stored procedure such that the first procedure populates temp tables and then retrieve the results from the temp tables For more information, you can refer to Roberts answer in the following thread: http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/e0cf8f54-9895-472f-846c-c08a185e5530/ Hopes this helps. Regards, Mike Yin

Developers have been asking for this for years. Why are multiple result sets not supported by SSRS? It doesn't make sense for the reporting tool to have no support for such a basic capability of the database tool. SQL Server 2012 doesn't support this? The whole point of using multiple result sets is so that only one batch gets executed on the server.Best Regards, Chris Durkin