Stored Proc with Multiple Selects and SRS 2005 Report

[dldev]

Hello,

I have a stored proc which uses several select statements for multiple resultsets, but I've come up against a brick wall because it seems that SQL Server Reporting Services 2005 doesn't support multiple select statements and will only return results from the first select statement. If anyone could suggest a strategy or workaround I would really appreciate it.

Thanks,
Dennis

 

[CuteGeek]

Can you send me the statement? If I am understanding you correctly it seems that you would be able to take those individual statements and put them in Temp tables(#) then pull in your fields through a main select statement.

cutegeek

 

[PWise]

I have never worked with Server Reporting Services 2005, but I have run into this same problem with Access. What the issue is that ADO dose not return all the recordsets till you loop thur recordset collection.

See

http://www.tek-tips.com/viewthread.cfm?qid=1429182