I want to set background color of a textbox based on three conditions. I have optional parameters in my report, when no parameters are selected, all the available data would be selected. And all the parameters are passed as a string.
1. when a Parameters!Book ID.value matchs Field!Book ID.value, Background color should be yellow.(Book ID is a single value parameter)
2. When Field!Book Type.value matches Parameters!Book Type.value, Background should be Yellow.(Book type is a multi value parameter, which is passed as a string value)
3. When no parameters are selected, highlight when when Book Level.value =1.
But another condition is
when 3 is true, 2 and 1 should be false
when 2 is selected, 3 should be false
When 1 is selected, 3 should be false.
I tried this way, but this is doesn't solve my need:
IIF(Fields!LEVEL.Value=1,"Yellow",IIF(RowNumber(Nothing) MOD 2, "White", "#e6e6e6") )))
View Complete Post