Last post Jul 20, 2011 04:01 AM by You-Hu Fu
Jul 16, 2011 07:01 AM|jassu107|LINK
I have a stored proc which has two select statements which give me two results.
Now in my SSRS report I want to use the two results .
The first SELECT statement gives records from join of Tables.
The second SELECT statement in the stored procedure is the concatenation of the parameter of the stored proc (@Country--can contain multi values).
The first result is used in MATRIX while the second which is concetenation of all Countries selected is to be used in textbox( to show which countries were selected by the user).
Now my question is how to use these two SELECT statements in my report . Can I get all the Columns (from both the Select Statements in one DATASET of the report)
Jul 16, 2011 02:45 PM|princeG|LINK
Jul 20, 2011 04:01 AM|You-Hu Fu|LINK
It is true, 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. So here you have to join these tables together to return just one table or create
separate stored procedures, and separate datasets to solve your problem.