Hello everyone,
i am trying to hide rdlc report columns whose values are zeros all through, that is, if some cells have values within the column, it shouldn't hide using the column visibility property. this is my code:
=iif(Fields!HousingAllowance.Value > 0,false,true)
this seems to work, but there is an issue with the above formula, it hides column if the first cell value for the column is zero, even when the column contains others values, i also tried this:
=SUM(iif(Fields!HousingAllowance.Value > 0,false,true))
but no success, i want to be able to sum the column values, if the result is zero, it should hide, else it show.
What I have tried:
=SUM(iif(Fields!HousingAllowance.Value > 0,false,true))
also tried this:
=iif(Fields!HousingAllowance.Value > 0,false,true)