# Report module - change component properties by script

**URL:** <https://forum.inductiveautomation.com/t/report-module-change-component-properties-by-script/31586>\
**Category:** Ignition\
**Created:** [January 24, 2020, 8:18am UTC](https://forum.inductiveautomation.com/t/report-module-change-component-properties-by-script/31586 "2020-01-24T08:18:53Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![flavien](https://avatars.discourse-cdn.com/v4/letter/f/f475e1/32.png) [@flavien](https://forum.inductiveautomation.com/u/flavien)\
**Post date:** [January 24, 2020, 8:18am UTC](https://forum.inductiveautomation.com/t/report-module-change-component-properties-by-script/31586/1 "2020-01-24T08:18:53Z")

</div>

Hi everybody,

I have questions about Report Module :  
I’ve made a dynamic report which use a script data source.  
In the last pages I would like to add/remove pages dynamically in my script. Is it possible ?

Thanks

---

<div class="post-metadata">

**Author:** ![User45199](https://avatars.discourse-cdn.com/v4/letter/u/41988e/32.png) [@User45199](https://forum.inductiveautomation.com/u/User45199)\
**Post date:** [June 15, 2021, 2:16pm UTC](https://forum.inductiveautomation.com/t/report-module-change-component-properties-by-script/31586/2 "2021-06-15T14:16:51Z")

</div>

Hi,

Did you ever find a way to do that ?

---

<div class="post-metadata">

**Author:** ![flavien](https://avatars.discourse-cdn.com/v4/letter/f/f475e1/32.png) [@flavien](https://forum.inductiveautomation.com/u/flavien)\
**Post date:** [June 16, 2021, 1:08pm UTC](https://forum.inductiveautomation.com/t/report-module-change-component-properties-by-script/31586/3 "2021-06-16T13:08:17Z")

</div>

Hi

I didn’t.  
I hope somebody help us.

---

<div class="post-metadata">

**Author:** ![flavien](https://avatars.discourse-cdn.com/v4/letter/f/f475e1/32.png) [@flavien](https://forum.inductiveautomation.com/u/flavien)\
**Post date:** [December 17, 2021, 11:40am UTC](https://forum.inductiveautomation.com/t/report-module-change-component-properties-by-script/31586/4 "2021-12-17T11:40:33Z")

</div>

Hi,

Do you have some news about this features ?

---

<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:** [December 17, 2021, 1:43pm UTC](https://forum.inductiveautomation.com/t/report-module-change-component-properties-by-script/31586/5 "2021-12-17T13:43:01Z")

</div>

I've created completely dynamic reports using nested tables to match a set of nested data keys. For the parts of the report that I wanted to omit, I ensured the corresponding nested query returned no rows. Creating a such a nested data key _ **via script** _ is rather complicated, though. See this topic:

> [@Report with Scripted Nested Data](https://forum.inductiveautomation.com/t/report-with-scripted-nested-data/11801):
>
> The report datasource scripting examples explain how to access the nested data in another key for use constructing a custom dataset. What I don’t see is how to construct nested data that would be suitable for use with a child table in a table group. I have a parent dataset that I’m constructing via script due to annoying limitations of an ancient SQL Server 2000 instance. I need a subquery for each row that could be done with a normal query, but there’s no way to add a regular subquery to a s…