I am looking for a solution of following problem: I use SQL Server Reporting Services 2005 and create DataSet with parameter. For this parameter I created a separate DataSet. I customize the report parameter and set "Available value" = from query and use this new (second) DataSet. If I run the report and open the parameter I can see the list of available values and can select one of this. Is it possible (if yes how can I do it) to create a multiselection list box by opening the parameter list so that I can select more than one entry from the list ?

If you designate your parameter as a multi-value, this will present a checkbox list. In your main dataset, use the SQL IN() function as 'ProductID IN(@ProductIDs)'

Paul Turley, MCSD, MCDBA, MCT, MSF Practitioner

This does not seem to work for me with my stored procedure.
This thread covers it:
http://www.microsoft.com/technet/com...927&sloc=en-us

Watch for wrap on that...

Paul,
Any other thoughts to work around this?

-Julius