Hide or Display column based on group visibilty ex

问题:

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

回答1:

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.

I created a simple table with two columns.

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:

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

回答2:

Hi try with something like this

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