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

x
?
Solved

SSRS Filter on empty Field

Posted on 2014-10-26
4
Medium Priority
?
263 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 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:
=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

Introduction As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset.  This makes it troublesome when you need to display data from more than one dataset in the same data region.  SQL Serve…
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 …
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Suggested Courses

772 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