# Chart in Report - Nested Query

**URL:** <https://forum.inductiveautomation.com/t/chart-in-report-nested-query/100395>\
**Category:** Ignition\
**Tags:** vision, reporting\
**Created:** [January 2, 2025, 7:04pm UTC](https://forum.inductiveautomation.com/t/chart-in-report-nested-query/100395 "2025-01-02T19:04:52Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Paulo\_Filho](https://avatars.discourse-cdn.com/v4/letter/p/5daacb/32.png) [@Paulo\_Filho](https://forum.inductiveautomation.com/u/Paulo_Filho)\
**Post date:** [January 2, 2025, 7:04pm UTC](https://forum.inductiveautomation.com/t/chart-in-report-nested-query/100395/1 "2025-01-02T19:04:52Z")

</div>

Hello,  
My first time posting here:

I have a Nested Query where the child query gets a parameter from the Root Query.

In the report, I am using a Table Group where I am able to return the data as I list with no issue. I also want to get this data to a chart dinamically

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

Point of Use info is coming from the Root, and the data with timestamp from the child query.

How do I create a chart dynamically based with the info from the list / child query?

I am using Vision and SQL for the data collection.

Please let me know if you need more data or I have not provided enough info.

I am using Ignition vs 8.1.44  
Thanks,  
Paulo

---

<div class="post-metadata">

**Author:** ![Paulo\_Filho](https://avatars.discourse-cdn.com/v4/letter/p/5daacb/32.png) [@Paulo\_Filho](https://forum.inductiveautomation.com/u/Paulo_Filho)\
**Post date:** [January 2, 2025, 9:53pm UTC](https://forum.inductiveautomation.com/t/chart-in-report-nested-query/100395/2 "2025-01-02T21:53:42Z")

</div>

I figured that out!

I was adding the chart into the Header but it required it to be in the Details row and its row to be unstructured.