# Dynamic dataset in Report view

**URL:** <https://forum.inductiveautomation.com/t/dynamic-dataset-in-report-view/115398>\
**Category:** General Discussion\
**Tags:** perspective\
**Created:** [May 6, 2026, 9:22am UTC](https://forum.inductiveautomation.com/t/dynamic-dataset-in-report-view/115398 "2026-05-06T09:22:30Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![kavya\_shree](https://avatars.discourse-cdn.com/v4/letter/k/b4bc9f/32.png) [@kavya\_shree](https://forum.inductiveautomation.com/u/kavya_shree)\
**Post date:** [May 6, 2026, 9:22am UTC](https://forum.inductiveautomation.com/t/dynamic-dataset-in-report-view/115398/1 "2026-05-06T09:22:30Z")

</div>

Hi Team,

I am fetching the Piweb data in the UI screen on button click and showing in the data in the perspective table and the same table need to be downloaded in pdf format.

I am trying in the report view to fetch the same dataset to get the pdf format.

Note: Every time the table data will be dynamic data which is coming from piweb.

Please suggest how I can achieve this

Thanks

---

<div class="post-metadata">

**Author:** ![Cose\_Peter1](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cose_peter1/32/79174_2.png) [@Cose\_Peter1](https://forum.inductiveautomation.com/u/Cose_Peter1)\
**Post date:** [May 6, 2026, 9:48am UTC](https://forum.inductiveautomation.com/t/dynamic-dataset-in-report-view/115398/2 "2026-05-06T09:48:24Z")

</div>

> [@kavya\_shree](#):
>
> I am trying in the report view to fetch the same dataset to get the pdf format.

What problems are you facing while trying to use reports for this purpose?

---

<div class="post-metadata">

**Author:** ![kavya\_shree](https://avatars.discourse-cdn.com/v4/letter/k/b4bc9f/32.png) [@kavya\_shree](https://forum.inductiveautomation.com/u/kavya_shree)\
**Post date:** [May 6, 2026, 10:02am UTC](https://forum.inductiveautomation.com/t/dynamic-dataset-in-report-view/115398/3 "2026-05-06T10:02:54Z")

</div>

Report Module:  
Parameters: dataset

Data Source: Name: PiData  
script: return data['dataset']

select Table : Data Key : PiData  
UI screen: Report view: source: report path

params: dataset , binded to custom.table data

on button click the table data is binded to custom.tabledata

---

<div class="post-metadata">

**Author:** ![liam1](https://avatars.discourse-cdn.com/v4/letter/l/e68b1a/32.png) [@liam1](https://forum.inductiveautomation.com/u/liam1)\
**Post date:** [May 6, 2026, 1:34pm UTC](https://forum.inductiveautomation.com/t/dynamic-dataset-in-report-view/115398/4 "2026-05-06T13:34:07Z")

</div>

When passing data into the report from outside the report itself, you should provide it as a report parameter.

For example, if you are using the Report Viewer component, you can bind the report parameter directly on the component. If you are generating the report through scripting, pass the dataset in as an argument to the `system.report.executeReport` function.

Make sure the parameter name you pass in exactly matches the parameter defined in the report. That parameter will then be the data object you use when configuring the table in the report.

---

<div class="post-metadata">

**Author:** ![kavya\_shree](https://avatars.discourse-cdn.com/v4/letter/k/b4bc9f/32.png) [@kavya\_shree](https://forum.inductiveautomation.com/u/kavya_shree)\
**Post date:** [May 7, 2026, 8:21am UTC](https://forum.inductiveautomation.com/t/dynamic-dataset-in-report-view/115398/5 "2026-05-07T08:21:04Z")

</div>

yes its binded as you suggested, but in report view table dataset is not populating. since the table is dynamic how to bind the columns in report view.

---

<div class="post-metadata">

**Author:** ![liam1](https://avatars.discourse-cdn.com/v4/letter/l/e68b1a/32.png) [@liam1](https://forum.inductiveautomation.com/u/liam1)\
**Post date:** [May 7, 2026, 8:38am UTC](https://forum.inductiveautomation.com/t/dynamic-dataset-in-report-view/115398/6 "2026-05-07T08:38:51Z")

</div>

I don’t believe the Reporting Module in Ignition is dynamic enough to reconfigure report table columns at runtime. Someone else may have found a method for doing this, but I personally haven’t seen one yet.

One possible workaround is to create placeholder columns and use generic headers, then update the values through parameters. That can give the report somewhat of a dynamic feel.

For example, you could define parameters like:

```python
columnHeader1 = x
columnHeader2 = x
columnHeader3 = x

```

Then bind those parameters to the table headers and populate the matching columns accordingly. It’s not truly dynamic column generation, but it may work depending on how flexible the report needs to be.

---

<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:** [May 7, 2026, 11:19am UTC](https://forum.inductiveautomation.com/t/dynamic-dataset-in-report-view/115398/7 "2026-05-07T11:19:18Z")

</div>

> [@liam1](#):
>
> reconfigure report table columns at runtime

Correct. You can hide them conditionally, though, and supply custom column headers.

Design the table to take many columns with simple names, and use a scripted data source to generate a dataset with those fixed names, and generate a supplemental dataset with the original column names converted for use as column headers.
