Forum Discussion
Post ProdigySSRS user forum?
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!
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
2 Replies
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
Dellis81Thank 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