Multi-Color Formating in Matrix

  • TexasJohn

    Default port

    Points: 1476

    I have a report with at least 57 columns where I want to display a different background color for each of three departments and a different color font for each of two categories within the departments.  Additionally I only want to background color to display for months where the project is active, not the entire line.  I can pivot my data and put it in a report instead of a matrix, but the query is getting really ugly and I may have to use a dynamic query to achieve my goal unless I can get the matrix to format things the way I want.  That query is done.  Attached is a snip from an Excel spreadsheet example of what I am trying to accomplish.
    Thanks

    John
    SQL Rebel without a Where Clause
    SQL/Epicor/Prophet21/e.i.e.i.o.

  • meichmann

    SSCommitted

    Points: 1899

    If the data is grouped, you can try using IIF statements in the background color.

    Example:

         =Iif(Fields!YourValue.value) = "Detail", "Blue", Iif(Fields!YourValue.Value) = "Shop", "Green", Iif(Fields!Yourvalue.Value) = "Install", "Yellow", "White")))

    You can customize the cells as much as you want to, just include an additional Iif for each color.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply