• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 431
  • Last Modified:

Show a value for a blank field

I would like to show a value for a blank/empty field, it's not a null field just blank. is this possible?

I tried the "nothing" did not work, nor "Blank"

=IIF(Fields!RUN_NUMBER.Value Is (?Blank??),"Not Entered",Fields!RUN_NUMBER.Value)
0
srodgers45
Asked:
srodgers45
1 Solution
 
sjklein42Commented:
How about an "empty string"?

=IIF(Fields!RUN_NUMBER.Value Is "","Not Entered",Fields!RUN_NUMBER.Value) 

Open in new window

0
 
srodgers45Author Commented:
Thanks, knew it had to be simple, new to SSRS
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now