Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 429
  • 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

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

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