CODEWITHSUNDEEP
reporting-servicesssrs-2008ssrs-2008-r2ssrs-tablixreportbuilder
Babyboss
Babyboss

Reputation: 1

How to make a column Hide in ssrs matrix

I have an ssrs matrix , the design of which looks like this : enter image description here When the report is run , My output looks like this : enter image description here

I am expecting output like this: If the column have no data i want to hide but i used all the visiblity hide expression but no luck enter image description here

I want to hide the matrix column group hide if the [productshortdesc] value is empty. In the [productshortdesc] column have two value close fund and ISO-CEF ADJ if any one of the data is not available i want to hide the column group and required the availbale value in the first column

Upvotes: 0

Views: 35

Answers (1)

Pooja
Pooja

Reputation: 26

Have you tried the below expression on column visibility:

=IIF(ISNOTHING(Fields!productshortdesc.Value) = 0, False, True)

Upvotes: 0

Related Questions