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

Popular posts from this blog

javascript - oscilloscope of speaker input stops rendering after a few seconds -

javascript - gulp-nodemon - nodejs restart after file change - Error: listen EADDRINUSE events.js:85 -

Fatal Python error: Py_Initialize: unable to load the file system codec. ImportError: No module named 'encodings' -