Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Show a value for a blank field

Posted on 2011-02-27
2
Medium Priority
?
428 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 2000 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

[Webinar] Cloud Security

In this webinar you will learn:

-Why existing firewall and DMZ architectures are not suited for securing cloud applications
-How to make your enterprise “Cloud Ready”, and fix your aging DMZ architecture
-How to transform your enterprise and become a Cloud Enabler

Question has a verified solution.

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

Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
Screencast - Getting to Know the Pipeline
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

916 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