sql server reporting services: Displaying multiple datasets in one report -- sql server reporting services

Displaying multiple datasets in one report

Mike S
12/22/2004 11:37:02 AM

sql server reporting services: I have a store procs that return more that one result set i.e. multiple
selects in the store proc. The report always picks out the first result set
it finds. How can I get a report to show the other result sets that the store
proc generates? Rewriting the store procs is not an option due to time

Re: Displaying multiple datasets in one report

Jeff A. Stucker
12/22/2004 2:10:03 PM

Bad news. Currently RS only works with the first recordset. If you can't
rewrite the sp's, you might be able to create separate wrapper sp's that
return the individual recordsets.

--
Cheers,

'(' Jeff A. Stucker
\

Business Intelligence
www.criadvantage.com
--------------------------------------
[quoted text, click to view]