Change Background Colour Of Record Depending On Proj_Status

Question

Hi,

I'm writing a report where I want to colour the background of a record blue if "Fields!Proj_Status = Tender" and red if "Fields!Proj_Status = "Won/Ordered"

I realise this requires some sort of IF statement in the BackgroundColor property but I'm not sure how to write it. Can anybody please advise how to do this?

CheersPaul

Answer 1

HI,

IN the backgroundColor property, you can enter the expression below:

=Switch(Fields!Proj_Status.Value="Tender","Blue",Fields!Proj_Status.Value="Won/Ordered","Red")

Alternatively, you can use this expression:

=IIF(Fields!Proj_Status.Value="Tender","Blue",IIF(Fields!Proj_Status.Value="Won/Ordered","Red","Black"))

---

Please mark as answered or vote helpful if this post help resolved your issue. Thanks!

k r o o t z