reporting services - SSRS Color Expression Lesser than X -
i have table handles stock, have data outputting in table in ssrs can see stock levels. so:
partnumber, partdescription, qty
i can use
=iif (fields!qty.value < 40, "red", "teal")
on quantity field set threshold within table applies every row.
is there way set unique thresholds per row (partnumber)?
if have threshold every partnumber
can store in reportdatasource
.
for example: partnumber
, threshold
, partdescription
, qty
then change expression in:
=iif(fields!qty.value < fields!threshold.value, "color1", "color2")
Comments
Post a Comment