# Dynamic Report chart

**URL:** <https://forum.inductiveautomation.com/t/dynamic-report-chart/80373>\
**Category:** Ignition\
**Tags:** database, scripting, reporting\
**Created:** [October 12, 2023, 3:56am UTC](https://forum.inductiveautomation.com/t/dynamic-report-chart/80373 "2023-10-12T03:56:19Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Vatsal\_Shah](https://avatars.discourse-cdn.com/v4/letter/v/0ea827/32.png) [@Vatsal\_Shah](https://forum.inductiveautomation.com/u/Vatsal_Shah)\
**Post date:** [October 12, 2023, 3:56am UTC](https://forum.inductiveautomation.com/t/dynamic-report-chart/80373/1 "2023-10-12T03:56:19Z")

</div>

Is there any way to change to chart according to the report page which is currently visible?  
For e.g. I have a generated report of 10 pages, and it has a chart as well. The Timeseries chart displays the plotted chart from the start to the end of all the pages, but I want to display the chart of the data which is visible on the current page.  
when I switch to page 2 the chart should be plotted for the data available on page 2 only and so on?

---

<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:** [October 12, 2023, 12:05pm UTC](https://forum.inductiveautomation.com/t/dynamic-report-chart/80373/2 "2023-10-12T12:05:50Z")

</div>

You need table grouping, and subqueries for each page of data.

{ I've removed the perspective and vision tags on this topic--this has nothing to do with them. }

---

<div class="post-metadata">

**Author:** ![Vatsal\_Shah](https://avatars.discourse-cdn.com/v4/letter/v/0ea827/32.png) [@Vatsal\_Shah](https://forum.inductiveautomation.com/u/Vatsal_Shah)\
**Post date:** [October 13, 2023, 11:23am UTC](https://forum.inductiveautomation.com/t/dynamic-report-chart/80373/3 "2023-10-13T11:23:43Z")

</div>

Can you explain a bit more ?  
Because No of pages of report is not predefined sometimes it may be 5 or may be 8.

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [October 13, 2023, 11:29am UTC](https://forum.inductiveautomation.com/t/dynamic-report-chart/80373/4 "2023-10-13T11:29:03Z")

</div>

Phil is saying that if you want a chart and table section per page then you need to generate a dataset per page and create a table and a chart for each. This might not be possible without unreasonable effort.

---

<div class="post-metadata">

**Author:** ![Vatsal\_Shah](https://avatars.discourse-cdn.com/v4/letter/v/0ea827/32.png) [@Vatsal\_Shah](https://forum.inductiveautomation.com/u/Vatsal_Shah)\
**Post date:** [October 13, 2023, 11:33am UTC](https://forum.inductiveautomation.com/t/dynamic-report-chart/80373/5 "2023-10-13T11:33:10Z")

</div>

making different dataset for each page would not sound good as the number of pages are not fixed.

---

<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:** [October 13, 2023, 12:07pm UTC](https://forum.inductiveautomation.com/t/dynamic-report-chart/80373/6 "2023-10-13T12:07:25Z")

</div>

> [@Vatsal\_Shah](#):
>
> number of pages are not fixed.

Why is this a problem? Make an outer query for your report's table group that yields one row per page. Make a nested query that takes the information from the outer row to produce the display data for that page.