CODEWITHSUNDEEP
reporting-servicesreportbuilder3.0
user2684009
user2684009

Reputation: 167

Hide or Display column based on group visibilty expression

Currently working on an SSRS report in which there is a parameter "Display by Order" set to false as default. Within the body of the report, I would like to set the group expression to display the Column order if Parameter "Display by Order" is true otherwise do not display the column. I am unsure what the expression would be for this. Help would be greatly appreciated.

Thanks

Upvotes: 1

Views: 10320

Answers (2)

Ian Preston
Ian Preston

Reputation: 39566

The Hidden expression for the Column Visibility should be something like:

=Not Parameters!DisplayByOrder.Value

This just flips the parameter value, i.e. if the user selects True, the Hidden property should be False.

More details as requested

Add a Boolean parameter called DisplayByOrder.

enter image description here

I created a simple table with two columns.

enter image description here

Set the Column Visibility for the second column by right-clicking the top of the column to bring up its properties, then using the above expression:

enter image description here

enter image description here

enter image description here

Now the column is hidden/shown by the parameter selection as required:

enter image description here

enter image description here

Upvotes: 5

Ryuzaki
Ryuzaki

Reputation: 207

Hi try with something like this

IIf(Parameters!DisplayByOrder.Value = False, True, False)

Upvotes: 0

Related Questions