# Report DataSet Table

**URL:** <https://forum.inductiveautomation.com/t/report-dataset-table/18408>\
**Category:** Ignition\
**Created:** [June 11, 2018, 7:31pm UTC](https://forum.inductiveautomation.com/t/report-dataset-table/18408 "2018-06-11T19:31:16Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![emanuel\_serrano](https://avatars.discourse-cdn.com/v4/letter/e/22d042/32.png) [@emanuel\_serrano](https://forum.inductiveautomation.com/u/emanuel_serrano)\
**Post date:** [June 11, 2018, 7:31pm UTC](https://forum.inductiveautomation.com/t/report-dataset-table/18408/1 "2018-06-11T19:31:16Z")

</div>

Hi Team,  
Hope you can help me out

I have a dataset in a client tag that I would like to display it on the report section… so the user can print out with a button and with a really nice format

The dataset is something that I’m building and is not coming from a query

**I cant find the option to do the binding from my dataset to the table**

Any help is really appreciated it

Thank

![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/1/16d8938c79aa8a1990f5b7b790eda81c15f8a23b.png)

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/8/85853dea153f00877b61983e9c9411a87d099806.png)00"\>

---

<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:** [June 11, 2018, 7:36pm UTC](https://forum.inductiveautomation.com/t/report-dataset-table/18408/2 "2018-06-11T19:36:42Z")

</div>

Look at the script data source option of the report and build the dataset there, not in a Client Tag. Reports are actually generated in the gateway and cannot read a client tag. It is supposed to be possible to use a dataset parameter to pass one back from the client, but your mileage may vary. /-:

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [June 11, 2018, 7:37pm UTC](https://forum.inductiveautomation.com/t/report-dataset-table/18408/3 "2018-06-11T19:37:26Z")

</div>

Reports are executed and built on the gateway, so you don’t have access to client tags’ values.

---

<div class="post-metadata">

**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\
**Post date:** [June 11, 2018, 7:38pm UTC](https://forum.inductiveautomation.com/t/report-dataset-table/18408/4 "2018-06-11T19:38:20Z")

</div>

You can’t use client tags directly in a report, because reports are generated in the gateway.

What you’ll need to do is use your client tag to [override an existing parameter](https://docs.inductiveautomation.com/display/DOC79/Report+Parameters#ReportParameters-WhatareParametersUsefulFor?) for your report in either the [report viewer](https://docs.inductiveautomation.com/display/DOC79/Report+Viewer?src=sidebar) or through [system.report.executeAndDistribute()](https://docs.inductiveautomation.com/display/DOC79/system.report.executeAndDistribute)

---

<div class="post-metadata">

**Author:** ![emanuel\_serrano](https://avatars.discourse-cdn.com/v4/letter/e/22d042/32.png) [@emanuel\_serrano](https://forum.inductiveautomation.com/u/emanuel_serrano)\
**Post date:** [June 11, 2018, 8:41pm UTC](https://forum.inductiveautomation.com/t/report-dataset-table/18408/5 "2018-06-11T20:41:47Z")

</div>

First,  
Thank you very much for the prompt answer. I was not aware of that

This is an example of the script that I have

```auto
myEndpoint = 'https://jsonplaceholder.typicode.com/posts'
results = system.net.httpGet(myEndpoint)
decodedDict = system.util.jsonDecode(results)
data = []
headers = ["userId", "id"]
for i in decodedDict:
	userIDVar = i['userId']
	IdVar = i['id']
	oneRow = [userIDVar, IdVar]
	data.append(oneRow)

```

> dataset= system.dataset.toDataSet(headers, data)

I don't have clear how to fill the table on the report designer

Could you explain to me or is there any documentation/guidance that I can read?

Thank you

---

<div class="post-metadata">

**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\
**Post date:** [June 11, 2018, 8:58pm UTC](https://forum.inductiveautomation.com/t/report-dataset-table/18408/6 "2018-06-11T20:58:51Z")

</div>

> [@emanuel\_serrano](#):
>
> I don't have clear how to fill the table on the report designer
> 
> Could you explain to me or is there any documentation/guidance that I can read?

[Docs](https://docs.inductiveautomation.com/display/DOC79/Report+Table)

You'll probably also find the free IU courses on reporting datasources and reporting tables helpful. Go to [Inductive University Course List - Learn Ignition Free](https://inductiveuniversity.com/library/), click on `reporting` and then watch the videos for the appropriate topics. They're all short and to the point, so definitely worth your while. 🙂

---

<div class="post-metadata">

**Author:** ![emanuel\_serrano](https://avatars.discourse-cdn.com/v4/letter/e/22d042/32.png) [@emanuel\_serrano](https://forum.inductiveautomation.com/u/emanuel_serrano)\
**Post date:** [June 11, 2018, 9:08pm UTC](https://forum.inductiveautomation.com/t/report-dataset-table/18408/7 "2018-06-11T21:08:57Z")

</div>

Thank you Kathy,  
Before created this post, I saw all of those videos and didn’t find an answer to this question : (

Again, thanks for the links

Regards