SSRS how to do a NOT IN parameter filter on a dataset

SSRS 2008 R2 doesn't have an inbuilt "not in" operator when working with filters. Stacia Misner has a great trick to work around this over here . In Dataset properties Expression: =True Operation: "=" Value: = Iif(InStr(Join(Parameters!FilterList.Value,”,”), Fields!Category.Value)=0,True,False) Parameters!FilterList.Value is a multi-value parameter. It's basically a big array of values…

Fixed column headers

The fixed column headers property of a tablix is a confusing option that I think is probably not appropriately named. I would rather call them "floating" column headers because that's what they appear to do. The property is only useful for on-screen reports, those that are exported to PDF or…