SSRS-not displaying correct result set

• pradnyasabnis_2006

  Valued Member

  Points: 63

  More actions

  February 17, 2011 at 2:36 pm

  #388890

  Hi,

  I am having reports that are using SPs for main result set and SP for cascading parameters.

  But for some reason the result generated after executing the main SP in SSMS is different from the one I am seeing when the report is generated in BIDS/SSRS.

  Does anyone has an idea what could have gone wrong?

  Thanks.

• Shanalise

  Hall of Fame

  Points: 3188

  More actions

  February 18, 2011 at 12:32 am

  #1288658

  Hi

  Adding cascading parameters in SSRS is a bit tricky, i would advice to check the cascading parameters cause they might be the problem.