CODEWITHSUNDEEP
reporting-servicesssrs-2008ssrs-grouping
scapegoat17
scapegoat17

Reputation: 5841

Replace Null value with string in ssrs expression

I have a row group of STATUS fields. There is a group that returns null that I would like to change to chat. I have tried:

=Iif(IsNothing(Fields!STATUS.Value), "Chat", Fields!STATUS.Value)

but the group still returns blank. Would anyone have any ideas on how to help me resolve this?

Upvotes: 0

Views: 2136

Answers (1)

Dan Scally
Dan Scally

Reputation: 2042

Your code is right. Are you sure it's returning nothing, and not something like a space or carriage return?

Upvotes: 1

Related Questions