October 10, 2018 at 10:10 am
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/VISUAL/e.i.e.i.o.
October 22, 2018 at 9:16 am
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 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply