Can I use 2 different stored procedure in a single report?

Can I use 2 different stored procedures in a single report with the same
dataset? How so?I am not sure why would you want do do this but if you are after getting two
resultsets by executing the two stored procedures, RS doesn't support
multiple resultsets.If you just need to do some pre-processing with the
first stored procedure, consider wrapping the two stored procedures with a
third stored procedure.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"MissQti" <MissQti@.discussions.microsoft.com> wrote in message
news:FDACE96D-69B7-41B7-A93B-4504C9332BBF@.microsoft.com...
> Can I use 2 different stored procedures in a single report with the same
> dataset? How so?