Solved

SSRS Filter on empty Field

Posted on 2014-10-26
4
245 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Suggested Solutions

Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Chart-Optimization-Tips.html).  This article explained how …
This code started out as a fix for a customer that had incoming data that was hunderds of numbers and words long that was to fit in one column. The problem was that the customer did not want to split words or numbers when wrapping in the column. …
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…
Suggested Courses

751 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