How to not exclude null values in a not equal to filter in Report Builder

Andrew 1 Reputation point
2021-04-08T16:25:15.227+00:00

I'm using Report Builder 3.0 for SQL Server 2014 on a Relational Query Designer. Issue I'm having is when I set a filter where I want to exclude rows where a field equals a specific values, it also excludes all rows where the field is null. I need to include these rows. I am aware I can edit as text and use SQL code to achieve this but I am looking for a solution inside the interface. Can anyone assist?

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,787 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 32,411 Reputation points
    2021-04-09T05:56:09.423+00:00

    Hi @Andrew ,

    I did some simple test locally, once I set the filter like below, the null value will also show.

    86132-screenshot-2021-04-09-135023.jpg
    86141-screenshot-2021-04-09-135008.jpg

    Not sure if you want like this, if I misunderstand your meaning, please incorrect me.

    Regards，
    Zoe

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    What can I do if my transaction log is full?--- Hot issues November

    How to convert Profiler trace into a SQL Server table -- Hot issues November