ssrs : chnage the text as well as text background color in ssrs

Posted by hareeshkumarkr-16190 under Sql Server on 7/24/2014 | Points: 10 | Views : 333 | Status : [Member] | Replies : 1
Hi All,

In single iif condition i want display data as well as change the color of text in expression.

e. g :

=iif(Parameters!cond.Value= 1,

"text1" , "Gray" ,

"text2" " , "Nothing"

)
any suggestion ?

Regards,
Harish




Responses

Posted by: nayeemdotnetfunda-27597 on: 7/24/2014 [Member] Starter | Points: 25

Up
0
Down
go to properties then background click on expression and write
=switch(Fields!cond.value=1,"gray",Fields!cond.value=0,"black")

hareeshkumarkr-16190, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response