How to take reference ranges from my RDLC Report table and change the Font of the observed values for abnormal values.

See more:

ASP.NET

MVC

C#3.5

SSRS

RDLC

Hello everyone,

I Have a RDLC Report which basically is a Medical Laboratory report.

In this report i have three columns Investigation Name, Observed Values, and Reference Ranges.

If my Observed value is beyond the boundaries of reference ranges the font for observed values should change.

I am able to change the font statically but i want it to be dynamic.

Please find the Rdlc Table and code for more reference.

Thanks for helping.

| TEST | OBSERVED VALUE | REFERENCE RANGES |
Blood Test | 20 | 30 - 40


In observed value column i have written the below expression in fonts.

=Iif(Fields!ObservedValues.Value >= 30, "Normal", Iif(Fields!ObservedValues.Value <= 40, "Normal", "Bold"))

So in the above expression reference value is fixed to greater than 30 and less than 40.

This i want to come from my Reference Ranges column.

Thanks