# Create a dynamic report

**URL:** <https://forum.inductiveautomation.com/t/create-a-dynamic-report/87400>\
**Category:** Ignition\
**Tags:** reporting\
**Created:** [March 15, 2024, 1:08pm UTC](https://forum.inductiveautomation.com/t/create-a-dynamic-report/87400 "2024-03-15T13:08:04Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![sebastien\_ng](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/sebastien_ng/32/55297_2.png) [@sebastien\_ng](https://forum.inductiveautomation.com/u/sebastien_ng)\
**Post date:** [March 15, 2024, 1:08pm UTC](https://forum.inductiveautomation.com/t/create-a-dynamic-report/87400/1 "2024-03-15T13:08:04Z")

</div>

I have 4 Turbine , I would like create a table per Turbine

Repport Table  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/9/e9544e604feb01c2c5fc83991707ddae88195101.png)

I created a param Turbine but I do'nt kwow how set it dynamique.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/8/686bb5126b930fc768ce6d800e6fbd14a1fd8ef6.png)

The problem is My repport still Turbine 1

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/7/c7857fb8198fe876c29f6a29b0aa747c9ed4b221.png)  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/d/fd033a6f8d1d1b40b0271f50567ae0eaecc3a8a8.png)

What I want is a table per Turbine

Sommeone can tell me what is wrong ?

---

<div class="post-metadata">

**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\
**Post date:** [March 15, 2024, 2:09pm UTC](https://forum.inductiveautomation.com/t/create-a-dynamic-report/87400/2 "2024-03-15T14:09:41Z")

</div>

Sounds like what you want is [child tables](https://docs.inductiveautomation.com/docs/8.1/ignition-modules/reporting/report-design/report-table/table-groups#child-tables).

---

<div class="post-metadata">

**Author:** ![sebastien\_ng](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/sebastien_ng/32/55297_2.png) [@sebastien\_ng](https://forum.inductiveautomation.com/u/sebastien_ng)\
**Post date:** [March 15, 2024, 2:13pm UTC](https://forum.inductiveautomation.com/t/create-a-dynamic-report/87400/3 "2024-03-15T14:13:14Z")

</div>

Thank you for your answer.

I created child table but, all table have Turbie number = 1

Maybe because I set param = 1 ?  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/3/7347a0d29078dcd4346ca8205e7c303666365e03.png)

---

<div class="post-metadata">

**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\
**Post date:** [March 15, 2024, 2:27pm UTC](https://forum.inductiveautomation.com/t/create-a-dynamic-report/87400/4 "2024-03-15T14:27:14Z")

</div>

To figure out if it's you're table layout or if it's the data, look at the right sidebar in the Preview tab -- that's the data which is going in to the report.

You'll notice that your parameter for Turbine is a string -- this isn't something that can hold multiple values. You will likely need the turbine numbers to come from a query, with subqueries for the data for each turbine.

---

<div class="post-metadata">

**Author:** ![sebastien\_ng](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/sebastien_ng/32/55297_2.png) [@sebastien\_ng](https://forum.inductiveautomation.com/u/sebastien_ng)\
**Post date:** [March 15, 2024, 4:25pm UTC](https://forum.inductiveautomation.com/t/create-a-dynamic-report/87400/5 "2024-03-15T16:25:00Z")

</div>

> [@KathyApplebaum](#):
>
> come from a query, with subqueries for the data for each turbine.

@KathyApplebaum Thank you for you suggestions  
If I do a query,with subqueries for the data for each turbine like you recommeded me, how I will defined the paremeter below on \>\>\>\> **Historial Tags** because I'am using ` **Tag History** ` data

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/d/2d21aba84d1968f07935f116177e4c3ed74ca40b.png)

---

<div class="post-metadata">

**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\
**Post date:** [March 15, 2024, 5:07pm UTC](https://forum.inductiveautomation.com/t/create-a-dynamic-report/87400/6 "2024-03-15T17:07:39Z")

</div>

Check out the [docs on nested queries](https://docs.inductiveautomation.com/docs/8.1/ignition-modules/reporting/report-data/nested-queries) or the [IU video on nested queries](https://www.inductiveuniversity.com/videos/nested-queries/8.1). Both have examples of how to do exactly this.
