March 22, 2011 at 4:14 am
Im having a report in which im geting data from the store proc but in store procedure the result is having multiple select statements. Now the problem is in the report it is geting the first select result only can any one help me how can i access all the select statements in the Report.
Thanks
Vasu
March 22, 2011 at 6:37 am
run multiple procs rather than just one.
March 23, 2011 at 7:53 am
"Reporting Services supports stored procedures that return only one set of data. If a stored procedure returns multiple result sets, only the first one is used. "
From: http://technet.microsoft.com/en-us/library/ms159260%28SQL.90%29.aspx
As pointed out by others, you'll need multiple SPs.
Rich
March 23, 2011 at 8:35 am
Depending on the situation, you may want to use a subreport (or more).
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking
March 28, 2011 at 11:26 pm
Create report datasets for each select, then your problem will be simple solved just like that:-D
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply