Using (Select All) for report parameter

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
March 31st, 2015 2:46am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics