CASCADING FILTERS IN ssrs

• Smash125

  Hall of Fame

  Points: 3562

  More actions

  September 13, 2014 at 3:00 am

  #290073

  You cannot vote on your own post

  0

  I have three data sets and two parameters

  1. Main data set which is

  SELECT AccountId,AccountName,Region,Country FROM GlobalSales

  WHERE Region=@Region AND Country=@Country

  2.Region Data Set

  SELECT DISTINCT Region FROM GlobalSales

  3. Country Data Set

  SELECT DISTINCT Country FROM GlobalSales

  Two parameter I have I have configured correctly, region get it from region data set and country same. My Question is parameterization fine with me, I want to provide cascading filters suppose if I select EUROPE AS Region it should filter only European countries. How can I do that I tries using filter option in country, but could not succeed . Please let me know how to do this

  Smash126

• Michael_Garrison

  Hall of Fame

  Points: 3110

  More actions

  September 15, 2014 at 9:41 am

  #1745516

  Sounds simple enough: here are a few articles to read. Just include the parameters in your other dataset code.

  http://technet.microsoft.com/en-US/library/aa337498(v=SQL.105).aspx

  http://msdn.microsoft.com/en-us/library/dd255197.aspx

  http://www.resultdata.com/adding-cascading-parameters-to-a-ssrs-report/

  Google search on SSRS Cascading Parameters for more articles.