February 2, 2023 at 10:50 pm
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!
February 3, 2023 at 4:37 am
February 3, 2023 at 5:19 am
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply