Question about if condition in ReportBuilder

I have a question about table layout report. I want to do that:

I have a table report and on that report i have a Total field of money. And i want to do that if condition on that field, so if the prize is less then 150, the color of the text it should be red otherwise it should be other color. So how can i achieve that. I know that this is possible in Reporting services in Report Designer is like =IIF(field.?.Value<150;"red";"gree")

But if i make that same in report builder, the what it does, it displays not the value in color, but it displays the text "red" od "green".

I will be very happy and gratefull if somebody can help me.

thank you in advance.

Hello,

You need to place your expression in the color property, not the textbox.

=Iif(Fields!?.Value < 150, "Red", "Green")

Jarret

|||

Hello,

yes this works in Report designer, when you work on reports RDL, but what if you want to do that in Report Builder?

I know that this work in Color property in report designer. But when you want to make that in Report Builder (the client app od RS), then it just get the word out, it doesn't set the color.

Andrej

|||=IIF(FEILD.TEXTBOX.VALUE < 150,"RED","BLUE"

I AM YOGESH FROM HYD IF THIS DOES'NT WORKS JUST CALL ME AT 09391323274 I AM FROM HYDERABAD INDIA