Hello all,
I am trying to filter either my dataset or my tablix within Report Builder to only retrieve records for certain vendor numbers. I seem to be able to add one filter to my tablix (for one vendor number)…but I have 16 or 17 more I need to add. There doesn’t appear to be an “OR” when adding additional filters. I tried messing around with an expression but my syntax keeps failing. Any thoughts? I feel like this shouldn’t be that difficult to achieve…
You want to use the “IN” operator on your dataset.
You are so awesome. I should have asked sooner. Thank you.
I am using Epicor 11.1.200. I am running into the same problem Alice Elizabeth did. I am using the filter field Vendor_ID instead of vendor number. If I use the example above, Epicor places double quotes around my selection. I enter 123456,789456 into the value field and when i say OK, it changes the values to ““123456"”,”“789456"” and then when i save the report it gives an error about quote marks. i have tried enclosing in (), but no joy. Do you have any solutions? I am happy to appear the “duh” person in this exchange. I have this all in one BAQ for perpetual inventory and this is one style that needs the filter. Thank you in advance for any help 
