Solved

SSRS Filter on empty Field

Posted on 2014-10-26
4
226 Views
Last Modified: 2014-10-27
Hi

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 :

123.jpg
0
Comment
Question by:conceptdata
  • 2
4 Comments
 
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.
0
 

Author Comment

by:conceptdata
ID: 40406059
Hi

I am trying to set up a Group filter in a SSRS report
123.jpg
0
 
LVL 22

Accepted Solution

by:
Nico Bontenbal earned 500 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:
=IsNumeric(Fields!SALESREP.Value)
This should return true if the field has a number and false if it has anything else. (Like the strange character in your screenshot).
0
 

Author Comment

by:conceptdata
ID: 40406259
Hi

That was a special character : Chr(2)

So it is solved.

Thanks
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

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…
Time Corrections for Reports Working with a report, we made some interesting discoveries about the time corrections/updates We are using the following Parameters: Starting Entered Date (Date) formatted as Data type: "Date/Time" Ending Entered …
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
A short film showing how OnPage and Connectwise integration works.

930 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now