Using SQL Server 2008 R2, BIDS (VS 2008). Using a SSRS Expression for a BackgroundColor of a Textbox (in a Tablix).
Unable to get a expression working that evaluates two conditions:
iif(Fields!CurrentStage.Value = "Project Close", "White", "Red"))))
Funding Authority - Date field "dd/mm/yyyy"
Current Stage - Text field
What I am trying to do is to get a Red color if the remaining funding authority is less than 8 weeks AND if the current stage of the project is not in "Project Close", otherwise it's Green.
Please can you help advise the best way to write the expression.
Many thanks in advance for your help!