How to Hide an Empty Matrix Column Without a Gap in Bold Reports
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.
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.
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.
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.
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.
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
After hiding the column
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.