Forum Discussion
SSRS user forum?
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
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
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