# How to Reference Parameters in SQL query in Reporting Module

**URL:** <https://forum.inductiveautomation.com/t/how-to-reference-parameters-in-sql-query-in-reporting-module/79682>\
**Category:** Ignition\
**Created:** [September 27, 2023, 3:36am UTC](https://forum.inductiveautomation.com/t/how-to-reference-parameters-in-sql-query-in-reporting-module/79682 "2023-09-27T03:36:28Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Wendy\_Minai1](https://avatars.discourse-cdn.com/v4/letter/w/cdc98d/32.png) [@Wendy\_Minai1](https://forum.inductiveautomation.com/u/Wendy_Minai1)\
**Post date:** [September 27, 2023, 3:36am UTC](https://forum.inductiveautomation.com/t/how-to-reference-parameters-in-sql-query-in-reporting-module/79682/1 "2023-09-27T03:36:28Z")

</div>

I am having trouble passing my parameters in this stored procedure in the reporting module. Can anyone help me

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/c/9cc6febd261a8f1eb8facfa68082bd5539ac4c25.png)

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/6/9601b341b397d5d82049b231e3ba9757a2779a9a.png)

---

<div class="post-metadata">

**Author:** ![andrews](https://avatars.discourse-cdn.com/v4/letter/a/898d66/32.png) [@andrews](https://forum.inductiveautomation.com/u/andrews)\
**Post date:** [September 27, 2023, 3:51am UTC](https://forum.inductiveautomation.com/t/how-to-reference-parameters-in-sql-query-in-reporting-module/79682/2 "2023-09-27T03:51:54Z")

</div>

What flavor db are you using?

---

<div class="post-metadata">

**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\
**Post date:** [September 27, 2023, 6:58am UTC](https://forum.inductiveautomation.com/t/how-to-reference-parameters-in-sql-query-in-reporting-module/79682/3 "2023-09-27T06:58:19Z")

</div>

put question marks where you want your parameters to be, and boxes will appear at the bottom of the screen to pass them their values.

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/7/6721f1db6898aa1c35d0c5b7db33fb9e6ce1e63e.png)

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/f/1ff56ccae88f86bcec63823248117067d6b7206b.png)