Using (Select All) for report parameter

your problem is here...

AND (item.family_code IN (@Family) OR @Family = '<Select All>')

Please see following link for way to enable multi parameters in SSRS.

---

Regards,

Vishal Patel

Blog: http://vspatel.co.uk

Site: http://lehrity.com