I am designing a basic report. I would like to try to figure out how to do the following:
I have a priority column for each row. To keep it simple I would like to fill this particular column
If row priority =
High = red fill
Med = Yellow fill
Low = Green fill
Thanks
Well, you can do the following:
-
Un-structure the data details row. Select the data details row (you will get a red outline around the row) and uncheck the Structured - number of columns checkbox. All columns will get converted to labels.
-
Add three rectangles to the details row with different fill colors: red, yellow and green.
-
Select one rectangle at a time. With the rectangle selected choose the Roll, Scale & Skew button to the right. It is the 4th button in, two over from the fill or paint bucket button.
-
Set the IsVisible property of the rectangle to something like:Value == 1
Change the condition for each rectangle. The value is the column you want to switch off of.
Hope this helps.