Solved

Show a value for a blank field

Posted on 2011-02-27
2
420 Views
Last Modified: 2012-05-11
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
Comment
Question by:srodgers45
2 Comments
 
LVL 16

Accepted Solution

by:
sjklein42 earned 500 total points
ID: 34992701
How about an "empty string"?

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

Open in new window

0
 

Author Closing Comment

by:srodgers45
ID: 34992718
Thanks, knew it had to be simple, new to SSRS
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question