I ran into a problem in SSRS. In fact, I have 3 Tablix in the same report and you want to hide 2 tablix based on the selected parameter value. I created a parameter called Report, and it has 3 values of All, Emp with Service Hrs, Emp without hrs services. Now what I'm looking for, if I select "Everything", then the "2" that belong to the "Service hours" and "Without service" should be hiding. Similarly, for the remaining parameters 2.
I knew this was possible if you have 2 Tablix using IIf () but no idea on 3. If anyone knows please give me feedback with ur. Thanks in advance.
Pooja source
share