How to hide the table column or row when the field value is empty

To hide a table column or row when the field value is empty, set a visibility expression on the column or row in the Bold Reports® Report Designer properties panel.

How to hide the table column when the field value is empty

  1. Drag and drop the table, then select the dataset and assign the field values to the table.

table design 2. Select the column and click visibility in the properties panel. set visibility expression 3. You can hide the empty column in the table based on the column visibility expression as follows:

 =IIF(Sum(IIF(IsNothing(Fields!FirstName.Value), 1, 0)) = COUNT(Fields!FirstName.Value), FALSE, TRUE)
  1. Click Preview at the top-right corner of the Report Designer toolbar to see the output result.

output-column

How to hide the table row when the field value is empty

  1. Drag and drop the table, then select the dataset and assign the field values.

table design 2. Select the row and click visibility under the properties panel. set visibility expression 3. You can hide the empty row in the table based on the row visibility expression as follows:

 =IIF(IsNothing(Fields!FirstName.Value) ,TRUE, FALSE)
  1. Click Preview at the top-right corner of the Report Designer toolbar to see the output result.

output-row