Using (Select All) for report parameter









Hi there,

I am Looking for assistance in making the the (Select All) option work for a particular report. The parameter is for product families (which there are about 47 unique results for). The report is also influenced by two other parameters, one being a date type i.e 'MTD' 'YTD' 'MAT'. When a long date type such as MAT is selected, selecting all families causes the report to get stuck in an endless loop.

I've tried creating my own <Select All'> item in the parameter dataset, then I have the opposite issue, the <Select All> selection works perfectly but when I try and tick two or more product families I recieve the following error:

"An expressions of non-boolean type specified in a context where a condition is expected, near ',' "

Parameter Dataset:

SELECT        '<Select All>' AS family_description, '<Select All>' AS family_code
UNION ALL
SELECT DISTINCT family_description,  family_code
FROM            dim_item AS item
ORDER BY family_description

Snippet From Main Report Dataset:

Where 

sales.oe_branch_code IN (@Branch)
And 
sales.order_status <> 'X' and sales.line_status <> 'X'

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

Any help is appreciated

Thanks Kindly

SQL Novice