This section explains how to hide a table column or row when the field value is empty using an expression.
visibility
under the properties panel.
You can hide the empty column in the table based on the column visibility expression as follows.
=IIF(Sum(IIF(Nothing(Fields!FirstName.Value),1,0)) = COUNT(Fields!FirstName.Value) ,FALSE,TRUE)
Preview
at the top-right corner of the Report Designer toolbar to see the output result.
visibility
under the properties panel.
You can hide the empty column in the table based on the column visibility expression as follows.
=IIF(Nothing(Fields!FirstName.Value) ,FALSE,TRUE)
Preview
at the top-right corner of the Report Designer toolbar to see the output result.