Articles in this section
Category / Section

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

Published:
Updated:

This section explains how to hide a table column or row when the field value is empty using expression.

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 filed values.
    hide-row-column-table-design.d8bc14f.48d320334dc6f545241a2c7ed170e228.png
  2. Select the row and click visibility under the properties panel.
    hide-column-expression.cf61dc5.f3b8f62e154aa3676ef9ce8bbc218af7.png
  3. 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)
  4. Click Preview at the top-right corner of the Report Designer toolbar to see the output result.
    hide-column-output.d8bc14f.e84c15d60298e10f93c836e022e40bf8.png

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 filed values.
    hide-row-column-table-design.d8bc14f.48d320334dc6f545241a2c7ed170e228 (1).png
  2. Select the row and click visibility under the properties panel.
    hide-row-expression.cf61dc5.e72177978c8687773d21bb6bb78801e2.png
  3. You can hide the empty column in the table based on the column visibility expression as follows.

     =IIF(Nothing(Fields!FirstName.Value) ,FALSE,TRUE)
  4. Click Preview at the top-right corner of the Report Designer toolbar to see the output result.
    hide-row-output.d8bc14f.5f1287fa68455f6c731a7c9e5212d24e.png

Was this article useful?
Like
Dislike
Help us improve this page
Please provide feedback or comments
Comments (0)
Please  to leave a comment
Access denied
Access denied