Monday, March 12, 2012

How to use multiple recordsets from a stored procedure?

I have one stored procedure which has 3 select statements inside it. So this
stored procedure returns 3 recordsets. I need to print all of these 3
recordsets onto the report.
Are there any way to print these 3 recordsets onto this report without
splitting this stored procedure into 3 stored procedures?
Thanks a lot.No, RS only supports one recordset being returned.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"BF" <BF@.discussions.microsoft.com> wrote in message
news:71BD33B4-2B04-4188-9814-8360BED57B87@.microsoft.com...
>I have one stored procedure which has 3 select statements inside it. So
>this
> stored procedure returns 3 recordsets. I need to print all of these 3
> recordsets onto the report.
> Are there any way to print these 3 recordsets onto this report without
> splitting this stored procedure into 3 stored procedures?
> Thanks a lot.
>

No comments:

Post a Comment