I want to add the expression for the textbox [MTDD1].
if [MTDD1] is nothing, shows light grey;
if [MTDD1] <[MTDS1], shows Red (in the attachment "preview", number 19 should show in red), otherwise shows CornflowerBlue.
I wrote the query, the SSRS can pass the expression, but the fill color did not apply. Can anyone help me on it. Thanks.
=switch(Fields!Step.Value = "Total" and Fields!MTDD1.Value<Fields!
e, "Red", "CornflowerBlue",