Articles in this section

How to Hide an Empty Matrix Column Without a Gap in Bold Reports

Published:
Updated:

Hiding a column in a matrix report keeps your report clean and focused by removing columns that have no data. In Bold Reports Web Designer, simply setting the visibility of a text box often leaves a physical gap in the layout. This method applies to static columns within a matrix (where each column represents a specific field). To hide individual empty instances of a dynamic column group, you should use a Group Filter instead. This guide walks you through using Advanced Mode to hide the underlying Tablix member, ensuring the report layout shifts to fill the empty space.

Steps to Hide a Column in a Matrix Report

1. Select the Matrix

  • Click the matrix report item in the design area to select it.
    Matrix report item selected in the design area

2. Enable Advanced Mode

  • In the Row Groups or Column Groups pane, located at the bottom of the designer, click the three-dot menu next to the Column Groups section. Select Advanced Mode from the dropdown menu to display the static members of the matrix.
    Advanced Mode option in the Column Groups three-dot menu

3. Select the Column to Hide

  • In the Column Groups pane, find the static member that matches the column you want to hide. It appears as Static.
  • Click the static member to select it.
    Static member selected in the Column Groups pane

4. Open the Hidden Expression Editor

  • In the Properties panel, locate the Visibility category. Find the Hidden property.
  • Click the square icon (property marker) to the right of the Hidden field and select Expression from the context menu.
    Expression option in the Visibility section of the Properties panel

5. Set the Expression

  • Enter the following expression and click OK to save it:
    = (Sum(IIF(IsNothing(Fields!Title.Value) OR Fields!Title.Value = "", 1, 0)) = CountRows())

Note: This expression counts the rows where the Title field is empty and compares that count with the total number of rows. When every row is empty, the result is true and the column is hidden. Replace Title with the field that fills the column you want to hide.

Visibility expression entered in the Expression editor

6. Preview the Report

  • Click Preview in the top-right corner of the Report Designer toolbar to check that the column is hidden when its data is empty.
  • Compare the report before and after hiding the column to confirm the change.

Before hiding the column

Matrix report preview with the empty column visible

After hiding the column

Matrix report preview with the empty column hidden

Conclusion

You can now hide an empty column in a matrix report using Advanced Mode and the Visibility setting. The column drops out of the layout when it has no data, which makes the report easier to read.

Limits

  • This method works specifically for static columns (where each column represents a different field).
  • To hide empty column group instances in a dynamic group, you should use a group filter instead.

Related Articles

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