# Selecting multiply values from a drop down list

**URL:** <https://forum.inductiveautomation.com/t/selecting-multiply-values-from-a-drop-down-list/14547>\
**Category:** General Discussion\
**Created:** [June 16, 2017, 4:31pm UTC](https://forum.inductiveautomation.com/t/selecting-multiply-values-from-a-drop-down-list/14547 "2017-06-16T16:31:16Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![drfisher](https://avatars.discourse-cdn.com/v4/letter/d/3e96dc/32.png) [@drfisher](https://forum.inductiveautomation.com/u/drfisher)\
**Post date:** [June 16, 2017, 4:31pm UTC](https://forum.inductiveautomation.com/t/selecting-multiply-values-from-a-drop-down-list/14547/1 "2017-06-16T16:31:16Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![AlThePal](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/althepal/32/3603_2.png) [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\
**Post date:** [June 20, 2017, 4:37pm UTC](https://forum.inductiveautomation.com/t/selecting-multiply-values-from-a-drop-down-list/14547/2 "2017-06-20T16:37:27Z")

</div>

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…

---

<div class="post-metadata">

**Author:** ![drfisher](https://avatars.discourse-cdn.com/v4/letter/d/3e96dc/32.png) [@drfisher](https://forum.inductiveautomation.com/u/drfisher)\
**Post date:** [June 22, 2017, 2:40pm UTC](https://forum.inductiveautomation.com/t/selecting-multiply-values-from-a-drop-down-list/14547/3 "2017-06-22T14:40:31Z")

</div>

Thanks, I will give that a try.