I'm creating an SSRS report with a multi-value parameter "FilterColours" set for the size of the product. The available sizes are SMALL, MEDIIUM and LARGE. I am expecting to create my query as follows:
SELECT * FROM PRODUCT
WHERE Size IN (@FilterColours)
For performance reasons I would like to ignore the parameters if all three available sizes are selected. Is there a way to do this?