# Hide Table in Report module dynamiclly

**URL:** <https://forum.inductiveautomation.com/t/hide-table-in-report-module-dynamiclly/83982>\
**Category:** Ignition\
**Created:** [January 9, 2024, 5:19pm UTC](https://forum.inductiveautomation.com/t/hide-table-in-report-module-dynamiclly/83982 "2024-01-09T17:19:33Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![nader.chinichian](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nader.chinichian/32/9261_2.png) [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\
**Post date:** [January 9, 2024, 5:19pm UTC](https://forum.inductiveautomation.com/t/hide-table-in-report-module-dynamiclly/83982/1 "2024-01-09T17:19:33Z")

</div>

Hi  
I created a report that the end client wants to see in Excel format and not PDF. It has two tables and one of them should be hidden based on key values. I use a dynamic data key on the "Visible" property of the table but when I generate the report as Excel the table always displays and Report Module doesn't care about the key value. Maybe it is a bug or I missed something here, any workaround is appreciated.

---

<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:** [January 9, 2024, 5:24pm UTC](https://forum.inductiveautomation.com/t/hide-table-in-report-module-dynamiclly/83982/2 "2024-01-09T17:24:15Z")

</div>

The report module's Excel generation isn't very flexible. You should simply generate your Excel file with the Apache POI libraries directly. No report at all.

---

<div class="post-metadata">

**Author:** ![nader.chinichian](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nader.chinichian/32/9261_2.png) [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\
**Post date:** [January 9, 2024, 6:16pm UTC](https://forum.inductiveautomation.com/t/hide-table-in-report-module-dynamiclly/83982/3 "2024-01-09T18:16:40Z")

</div>

Yes, It is also cheaper, and easily saves report module costs.