CODEWITHSUNDEEP
reporting-servicesssrs-2008
nowYouSeeMe
nowYouSeeMe

Reputation: 999

How to make a column visible based on parameter

I have a table column that is set to Visiblity: Hidden = True.

Now I want to make the column visible if the parameter equals 'Maths'.

I've currently selected the column and gone to Column Visivlity, 'Show or Hide based on an expression'

My expression is:

=IIf(Parameters!subjectParam.Value="Maths",False,True)

But for some reason it does not work?

Upvotes: 1

Views: 1422

Answers (1)

Sewder
Sewder

Reputation: 754

A good work around is sometimes to use field values from the actual database or dataset rather than the parameter.

So if the subject is math and certain columns are filtered then you could use that as visibility.

Something like:

 =IIF(Fields!MathColumnFieldValue.Value > 0, True, False)

Upvotes: 1

Related Questions