Hi there,
I am looking for asssistance in making the (Select All) option work for a particular report. The parameter is for product families (which there are about 47 of). 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 expression 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
- Edited by KCBA 19 minutes ago