SSRS returning a single Dataset from two storedprocedure RRS feed

  • Question

  • Hi,

    I'am trying to return a dataset from two different storedProcedure, that as same Column structure. This is the expression am using to load. 

    (= iif(Parameters!ViewLevel.Value = "Monthly", "DM.spReportMonthlyMarketPerformance", "DM.spReportMonthlyMarketPerformancebkp_05/02(2)")). 

     Is there any other better way to load or is there anything wrong with my syntax.

    Wednesday, May 15, 2019 2:27 PM