# Report with Multi-Select

**URL:** <https://forum.inductiveautomation.com/t/report-with-multi-select/15511>\
**Category:** Ignition\
**Tags:** ignition79\
**Created:** [September 29, 2017, 12:54pm UTC](https://forum.inductiveautomation.com/t/report-with-multi-select/15511 "2017-09-29T12:54:03Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ryanjmclaughlin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryanjmclaughlin/32/4318_2.png) [@ryanjmclaughlin](https://forum.inductiveautomation.com/u/ryanjmclaughlin)\
**Post date:** [September 29, 2017, 12:54pm UTC](https://forum.inductiveautomation.com/t/report-with-multi-select/15511/1 "2017-09-29T12:54:03Z")

</div>

I am trying to create a report against MSSQL with a basic in clause.

I can create a row selector in the UI to create the dataset of values to pass to the report parameters, but then getting a dataset into the IN clause of the SQL Query seems impossible. Does anyone have any examples of this?

```auto
SELECT 
  *
FROM 
  table t
WHERE
  t.name IN (?)

```

I want to be able to pass the Dataset parameter directly to the Query. Ex: {NameValues}

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [September 29, 2017, 12:57pm UTC](https://forum.inductiveautomation.com/t/report-with-multi-select/15511/2 "2017-09-29T12:57:49Z")

</div>

You cannot. You’ll have to generate this dataset in a script, creating the SQL on the fly with the correct number of ‘?’ placeholders.

---

<div class="post-metadata">

**Author:** ![ryanjmclaughlin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryanjmclaughlin/32/4318_2.png) [@ryanjmclaughlin](https://forum.inductiveautomation.com/u/ryanjmclaughlin)\
**Post date:** [September 29, 2017, 1:59pm UTC](https://forum.inductiveautomation.com/t/report-with-multi-select/15511/3 "2017-09-29T13:59:13Z")

</div>

☹

I can understand how to do that from scripting, but any ideas on how to prepare that for the reporting module?

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [September 29, 2017, 2:23pm UTC](https://forum.inductiveautomation.com/t/report-with-multi-select/15511/4 "2017-09-29T14:23:55Z")

</div>

Use a [Script Data Source](https://docs.inductiveautomation.com/display/DOC79/Scripting+Data+Source). If you need to do nesting from there, see [this topic](http://forum.inductiveautomation.com/t/report-with-scripted-nested-data/11801).