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