SSRS How to hide empty / empty column through expression?

Question

I need to hide a column if all the rows in the column are empty (spaces).

In this case, it col3should be hidden because there are no values ​​in the column.

col1 col2 col3
 v1   v4
 v2
 v3   

I use the following expression in column properties Hidden:

=IIF(Fields!Test5.Value = "",TRUE,FALSE)

This expression works, but it discards every empty field (empty field), even the entire column is not empty. It should hide the column only when there are no values.

Answer 1

You can use:

=IIF(Max(Field, Dataset)= "",TRUE,FALSE)

If the maximum value is empty, it means that there is nothing, and make your expression in the form of a column.