# Reporting Module (dynamic filter expressions)?

**URL:** <https://forum.inductiveautomation.com/t/reporting-module-dynamic-filter-expressions/9892>\
**Category:** Ignition\
**Created:** [April 8, 2015, 9:59pm UTC](https://forum.inductiveautomation.com/t/reporting-module-dynamic-filter-expressions/9892 "2015-04-08T21:59:47Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gratliff](https://avatars.discourse-cdn.com/v4/letter/g/a5b964/32.png) [@Gratliff](https://forum.inductiveautomation.com/u/Gratliff)\
**Post date:** [April 8, 2015, 9:59pm UTC](https://forum.inductiveautomation.com/t/reporting-module-dynamic-filter-expressions/9892/1 "2015-04-08T21:59:47Z")

</div>

Is there a way to dynamically change the filter expression for an item in the reporting module? I would like the user to be able to select various filter criteria via components on the window such as drop down boxes or check boxes and then change the output of the report, based on this criteria.

---

<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:** [April 10, 2015, 11:45am UTC](https://forum.inductiveautomation.com/t/reporting-module-dynamic-filter-expressions/9892/2 "2015-04-10T11:45:03Z")

</div>

What you can do is bind the dataset you’re using to pass data to the report viewer (by default called ‘Data’) to another dynamic property e.g. you could create a new string dynamic property called ‘query’ on the report viewer and bind the dataset SQL Query to this property. When you then change the SQL query held in ‘query’ the data being sent to the report viewer will change and the report viewer will update with the new data.

You can create the string in ‘query’ using on screen controls as required, either through binding or with a script on an ‘Update report’ button.

---

<div class="post-metadata">

**Author:** ![Gratliff](https://avatars.discourse-cdn.com/v4/letter/g/a5b964/32.png) [@Gratliff](https://forum.inductiveautomation.com/u/Gratliff)\
**Post date:** [April 10, 2015, 12:06pm UTC](https://forum.inductiveautomation.com/t/reporting-module-dynamic-filter-expressions/9892/3 "2015-04-10T12:06:37Z")

</div>

Thanks AlthePal (love the name),

That’s what I ended up doing. Work’s great. Thanks for the suggestion.

---

<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:** [April 10, 2015, 1:16pm UTC](https://forum.inductiveautomation.com/t/reporting-module-dynamic-filter-expressions/9892/4 "2015-04-10T13:16:58Z")

</div>

Welcome!