Search code examples
reporting-servicesssrs-2012ssrs-2008-r2ssrs-tablixreportingservices-2005

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


I am trying to hide a column on my ssrs report based on a condition that the current month aka month(today()) is a specific integer.

For example, I have to hide "column11" until November 1st and "column12" until December 1st.

Thank you.


Solution

  • 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)