sql - SSRS Report Builder: Creating text color expression based on textbox value? -
is possible have ssrs @ value of text box after calculating it, , apply expression determine color of text?
more specifically, have lot of different text boxes contain custom formulas calculate percentages. normally, create iif statement in text color expression builder this:
iif([complex formula]<0,"red","green").
this works fine, when have ton of these textboxes, each different formulas, more efficient copy 1 standard color expression them this:
iif(this.value>0,"red","green")
are expressions possible in ssrs?
the answer yes, if using recent version of ssrs:
=iif(me.value < 0,"red","green")
link original article here
hope helps.
Comments
Post a Comment