Solved

SSRS Filter on empty Field

Posted on 2014-10-26
4
238 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

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

Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error With the introduction of SQL Server 2008 R2 and Vista (Windows 7 as well) came new enhanced security features. One of the features included was User Access Control (UAC) t…
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.   …

820 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