SSRS user forum?

[Dellis81]

Hello

I am seeking help for PBI Report Builder - which forum is best to post questions?

thank you

Within the dataset filter - I am wanting to use a NOT contains filter.   I have attempted the custom expression option, but to no avail.

I would appreciate advice on converting this to a "NOT Contains"

thank you!

[Anonymous · Accepted solution]

Hi @Dellis81 ,

If I understand correctly, it seems that you want to filter the data which not contains some specific values. Am I right? If yes, you can refer the following links to get it:

Working with Reporting Services Filters – Part 4: Creating a NOT IN Filter – Data Inspirations

=Iif(InStr(Join(Parameters!FilterList.Value,”,”),Fields!Category.Value)=0,True,False)

sql - How to implement 'Not In' Filter in SSRS? - Stack Overflow

=IIF(Array.IndexOf(split("30,31,32,33,34,35,36,37,38,39",","),
CStr(Fields!YourField.Value))>-1,"Exclude","Include")

SSRS : Simulating NOT IN and NOT LIKE Functionality In SSRS Filter Expressions - TechNet Articles

In addition, you can apply the codes in the data source query as below:

WHERE  Production.ProductInventory.ProductID NOT IN (@ProductID)  

Best Regards

[Dellis81]

Thank you for your response and thoughts.   I will see if I can make one of your suggested links work.  I had previously searched, but seems the 1st option is a little more clear than what I had experienced before.

Will get back in touch - probably this weekend.

thanks