Selecting multiply values from a drop down list

General Discussion
1

I am attempting to pass multiply values into a SQL report in the reporting module. This report needs to select multiply equipment numbers so a comparison of total work order hours can be returned. I would like to use a dropdown list but it appears only a single selection can be used. Also when setting up my Default Value parameter in the report data will not except my syntax (‘eq123’,‘eq234’) If anyone can point me in the proper direction it would be appreciated.
Thanks
Dennis

2

If you want to select multiple values to pass as parameters you’d be better using a list, then pass the selected values as a Dataset.

It’s possible to define a report parameter as a Dataset, but I don’t know how to set a Default Value for a Dataset…

3

Thanks, I will give that a try.