locked
How to use result of two select statements from single stored procedure in SSRS RRS feed

  • Question

  • User843229376 posted

    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)

    Saturday, July 16, 2011 7:01 AM

Answers

  • User1471008070 posted

    Hi,

    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.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, July 20, 2011 4:01 AM

All replies