CODEWITHSUNDEEP
reporting-servicesssrs-2008ssrs-2008-r2
Eray Balkanli
Eray Balkanli

Reputation: 7960

Conditional visibility for a row that toggled with another textbox in SSRS 2008

I have a matrix in ssrs like:

Name      Age
[Name]    [Age]
[Total]   sum([Total])

The [Name] row is toggled with Total, so When I click '+' sign near Total I can see each Name and Age, otherwise they are hidden. For some of my cases I have Age = 0 and I do not want to show them. I have to do this modification in SSRS, not in SQL. But since the row visibility settings are arranged for toggling (default:hidden) I cannot write expression there I guess. SO I could not find out what to do to provide this. I need something like:

For Hidden: IIF(Fields!Age.Value > 0, false, true)

Any help would be appreciated! Thanks.

Upvotes: 2

Views: 804

Answers (1)

alejandro zuleta
alejandro zuleta

Reputation: 14108

Go to tablix properties, in the Filters tab add a filter:

enter image description here

Where I set Point use your field Age, select > operator and use =0 expression in Value.

Now you can see use toogle functionality without zeroes values.

With the filter and without filter

enter image description here enter image description here

Let me know if this helps.

Upvotes: 3

Related Questions