Sample Header Ad - 728x90

SSRS Rectangle visibility based on Parameter Value

0 votes
1 answer
2854 views
I am creating a Report in SSRS. Its a Dynamic 2011 CRM Report. I have created some Tables. And some Rectangles. Each Rectangle contains some Tables. Also there is a Parameter that contains value from 1 to 4. It is a multiple values parameter. The goal is that the user select parameters( one or more ) and then tables based on the rec visibility condition appear.( Maybe two rec appear, or maybe all of them) We all know that there is IN operator in SQL Syntax. But I do not know how to make it here. I googled a lot but no success. Here is what I tried in rec visibility. =Parameters!type.Value.Equals("1") And in the second table : =Parameters!type.Value.Equals("2") till the last rectangle. Even changed to : =Parameters!type.IsMultiValue.Equals("1") I Also Put both of them in =iif, but no success. How can I perform this? Visibility of rectangle based on the multiple values parameter. Any help will appreciated.
Asked by alireza azadi (25 rep)
Feb 19, 2019, 05:47 AM
Last activity: Feb 19, 2019, 06:03 AM