Search code examples
asp.netssasssrs-2008-r2

How to Change Column Group Header Color in SSRS on every new value


i have a column group in matrix report i want to change the background color of column on every value Changeenter image description here

Please Suggest very Helpfull


Solution

  • You have to use expression like this it show alternative color in columns

    =IIF((ColNumber(nothing) MOD 2)=1,"Gainsboro","Transparent")
    

    Please also see the below link as well it will help you

    http://www.mssqltips.com/sqlservertip/2612/data-driven-colored-text-for-reporting-services-reports/