Restrict available values from one parameter per othr parameters selected values

• catbeasy

  SSC Veteran

  Points: 271

  More actions

  February 2, 2023 at 10:50 pm

  #4144897

  Hello

  Have created a simple 9 column report where there are 7 (multi valued) parameters all reference the same table. I want all these parameters to reference one another.

  So, for example, once a user selects values from parameter 1, restricting say departments to 3 departments, then the rest of the parameters, once selected should display only values remaining from the table per the restriction of the first parameter.

  So, if 3 departments are selected for param 1, then if that restricts the dataset in the table to have values 'Blue and Green' for the field param 2 references (when no restriction from param 1 would have left a full colour load of Blue, Greem Red, Gray, Orange etc.), then clicking on param 2 will only show values Blue  and Green.

  Hope this is clear enough and thanks in advance for any help!

• pietlinden

  SSC Guru

  Points: 63572

  More actions

  February 3, 2023 at 4:37 am

  #4144952

  Cascading parameters...?

• Gerckens.3

  SSC Rookie

  Points: 42

  More actions

  February 3, 2023 at 5:19 am

  #4144961

  As mentioned by SSC Guru, the term you want to search for is:  ssrs cascading parameters

  There are any number of tutorials and examples out there.  Here's one:  https://www.mssqltips.com/sqlservertip/3466/cascaded-parameters-in-sql-server-reporting-services/

  If you're having any challenges getting that to work, then I'm happy to try to help.

  "When it comes to report design and development, I have a list of pet peeves a mile wide. You might think the list would be a mile long, but I like to turn it on its side, sharpen the end, and poke people with it." - Me