CODEWITHSUNDEEP
visual-studio-2012reporting-servicesexpressionssrs-2012
smul86
smul86

Reputation: 411

SSRS Expression To Rename NULL Values

I am using Visual Studio 2012 for my SSRS Report.

I have a field called Root Cause in my Column Groups section (with 3 column groups underneath that column group umbrella), and it pulls in 4 fields Offense, Defense, Both, and NULL values. So the headers for those sections when I preview the report show up as Offense, Defense, Both and then where NULL should be...it's just a blank section.

My goal is to replace the blank section with text that says No Value or something along those lines, just not be blank.

How do I format the SSRS Expression for that box to do so?

Upvotes: 0

Views: 419

Answers (1)

Wesley Marshall
Wesley Marshall

Reputation: 444

Try using =IIF(IsNothing(Fields!RootCause.Value),"No Value",Fields!RootCause.Value) as your expression.

Upvotes: 1

Related Questions