Home Forums Reporting Services Reporting Services 2008 Development Matrix Table - Each Column Different Color RE: Matrix Table - Each Column Different Color

  • October 9, 2014 at 8:41 am

    #1751323

    I finally figured it out and it was such a simple solution. Here's the expression I used.

    In the detail cell:

    =IIF(ISNOTHING(SUM(Count(Fields!RevCategory.Value))), 0, SUM(Count(Fields!RevCategory.Value)))

    In the Fill section of the detail cell:

    =IIF(ReportItems!RevCategory.Value = "ERP(Sys)" and ReportItems!RevCategory1.Value >= 0, "LightBlue"

    , IIF(ReportItems!RevCategory.Value = "Add-On Count" and ReportItems!RevCategory1.Value >= 0, "YellowGreen"

    , "PeachPuff"))