question

Andrew-0873 avatar image
0 Votes"
Andrew-0873 asked ZoeHui-MSFT commented

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

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered ZoeHui-MSFT commented

Hi @Andrew-0873,

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


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

No, that is using a dataset filter. I am looking for how to do it using a Relational Query Designer, as shown in this link:
https://docs.microsoft.com/en-us/sql/reporting-services/report-data/relational-query-designer-user-interface-report-builder?view=sql-server-ver15

0 Votes 0 ·

Hi @Andrew-0873, I did find a good way to realize your requirement in this situation, I'd like suggest using SQL code to achieve your need.

0 Votes 0 ·