How to Make a Column Invisible in an Ssrs Matrix

How to hide a column in SSRS Matrix report in SQL Server

Select the column to hide, right-click --> Column Visibility --> Show or hide based on an expression --> Click f(x) to provide expression as provided below

=IIF(Count(Fields!.Value) = Cint(0), True, False)

What is the expression to hide a column in an SSRS report if the current month number an integer?

Have in mind hiding some columns could result in duplicate values into your report, especially if those columns are the ones making unique your rows.

Now for your specific case you can use:

=IIf(
(Month(Today()) >= 2 AND Day(Today()) >=5)
AND
(Month(Today()) <= 3 AND Day(Today()) <=4)
,true,false)

Make hidden table column take no space in SSRS 2008 R2

I think you are looking at the Hidden property of the column. Something that is hidden will still take up space. What you want to change is the Visibility of the column. Right click on the column header and click Column Visibility and set it there.

How do I hide the left-most column in an SSRS 2008 matrix?

I was able to find a work-around with a little experimentation. Here's what I did:

• Added an adjacent column group to the FieldName column. This column was grouped on Time (the same as the row group).

• Set the header of the new column group to always display the text "Time."

• Right-clicked on the selection button for this new column and selected "Column Visibility..." from the list. Entered the hidden expression I wanted.

• Deleted the original Time column, choosing to retain the associated group.

---

Related Topics