Re: Reports 2.5 select multiple items from parameter

Michael Cooke wrote:
>
> I have a number of reports that require the user to select either a single
> item or multiple items from a single list in a parameter form e.g
>
> the parameter displays a list of product categories from which the user
> selects the category or categories and this in turns populates the report
> with product information related to them. I cannot find a way to enable
> multiple items to be selected.
>
> I would be grateful for any assistance
>
> Thanks in advance
> Mick

AFAIAA, the only way to do this directly in Reports is to have several parameters all with the same list of values and place them in your query e.g

WHERE product_category = :p1

OR     product_category = :p2
OR     ......................
OR     product_category = :p10

This of course means that your parameter form gets quite big

HTH,
MF

-- 
matt_foster_uk_at_yahoo.co.uk