I've got a SSRS matrix report in VS2017. I need to hide a column based on no.of days in a month.
Eg: Need to hide 29,30 & 30th Column in case of Feb Month in pic provided below.
My report's Dataset consists of 38 columns, I found this article with settings as =IIF(CountRows()>12,true,false)
but this still fails. My report still shows the 29,30 & 32 columns.
Any help would be much appreciated.
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)