CODEWITHSUNDEEP
reporting-servicescolorsnullexpressioniif
Aruna Raghunam
Aruna Raghunam

Reputation: 921

Unable to set Background Color for NULL values in SSRS report

I have a requirement to set Red colour for Outcome column = NULL values

Design below: Design

I am using below expression on the Count(StudentID) Text box: 

=IIF(IsNothing(Fields!Outcome.Value), "Red", "Transparent")

For Outcome textbox, I am using this expression:

=IIF(IsNothing(Fields!Outcome.Value), "NULL", Fields!Outcome.Value)

But I am unable to see any color change.

Preview: Preview

Can you please suggest how to resolve this?

Thanks,

AR

Upvotes: 0

Views: 4650

Answers (2)

madhura
madhura

Reputation: 41

=IIF(IsNothing(Fields!Apr.Value), "Aqua","Transparent")

Upvotes: 0

Amy Robinson
Amy Robinson

Reputation: 11

You can use the Me.Value function to refer to the actual value of the cell you are setting the color expression for, rather than referring to the value of a Field.

=IIf(Me.Value = "NULL","Red","Transparent")

Upvotes: 1

Related Questions