SSRS Filter on empty Field

Posted on 2014-10-26
Medium Priority
Last Modified: 2014-10-27

I have a SSRS report, where i would like to put a filter that shows empty records with empty value in a specific field.

But I can't get it to work.

I have tried :
- iif(IsNothing(Fields!SALESREP.Value), True, False)
- Fields!SALESREP.Value = ""

I cant get it to work.
I sql management studio the field is showed like this :

Question by:conceptdata
  • 2
LVL 24

Expert Comment

by:Phillip Burton
ID: 40406049
Can you elaborate on your question please.

I don't know, for example, where you are trying your code, or what your SQL code is.

Author Comment

ID: 40406059

I am trying to set up a Group filter in a SSRS report
LVL 22

Accepted Solution

Nico Bontenbal earned 1000 total points
ID: 40406255
That field doesn't look empty. It would show up as 'NULL' in management studio if it was. If the 'empty' fields always contain something else then a number you might try:
This should return true if the field has a number and false if it has anything else. (Like the strange character in your screenshot).

Author Comment

ID: 40406259

That was a special character : Chr(2)

So it is solved.


Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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

Written by Valentino Vranken. Introduction: In a previous article (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Reporting-On-Data-From-Stored-Procedures-part-1.html) I announced that I would writ…
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…
Free Data Recovery software is an advanced solution from Kernel Tools to recover data and files such as documents, emails, database, media and pictures, etc. It supports recovery from physical & logical drive after a hard disk crash, accidental/inte…
Did you know PowerShell can save you time with SaaS platforms? Simply leverage RESTfulAPIs to build your own PowerShell modules. These will kill repetitive tickets and tabs, using the command Invoke-RestMethod. Tune into this webinar to learn how…

607 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