Possible to do a lookup on a db table within a SSRS Expression ?

Question

I would like to make a lookup within a SSRS expression, is that possible ?

The idea behind that: for a check report I have to decide if a value on the report is ok, if not it should be shown with a red background color. However instead of keeping the values that are ok in the expression I would like to use lookup in a sql table where these values are centrally stored.

Answer 1

You could do this through custom code or assemblies, but I'd look for a way to do it in the data source query instead. Is your data source the same SQL database?