Report View help - Color coding a column in a row

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


Well, you can do the following:

  1. 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.

  2. Add three rectangles to the details row with different fill colors: red, yellow and green.

  3. 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.

  4. Set the IsVisible property of the rectangle to something like:Value == 1Change the condition for each rectangle. The value is the column you want to switch off of.

Hope this helps.