# How to add data from a query to my report

**URL:** <https://forum.inductiveautomation.com/t/how-to-add-data-from-a-query-to-my-report/90882>\
**Category:** Ignition\
**Tags:** ignition81, perspective\
**Created:** [May 24, 2024, 4:16pm UTC](https://forum.inductiveautomation.com/t/how-to-add-data-from-a-query-to-my-report/90882 "2024-05-24T16:16:05Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Esme\_Lopez](https://avatars.discourse-cdn.com/v4/letter/e/ecb155/32.png) [@Esme\_Lopez](https://forum.inductiveautomation.com/u/Esme_Lopez)\
**Post date:** [May 24, 2024, 4:16pm UTC](https://forum.inductiveautomation.com/t/how-to-add-data-from-a-query-to-my-report/90882/1 "2024-05-24T16:16:05Z")

</div>

Hello everyone  
I have a query in the section data sources of a report

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/3/2378eedce40aad6442a67ed0a529aa9e41ab86c6.png)

Do you know how can I add every column of the query to a table in the page of the report?

---

<div class="post-metadata">

**Author:** ![sebastien\_ng](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/sebastien_ng/32/55297_2.png) [@sebastien\_ng](https://forum.inductiveautomation.com/u/sebastien_ng)\
**Post date:** [May 24, 2024, 4:38pm UTC](https://forum.inductiveautomation.com/t/how-to-add-data-from-a-query-to-my-report/90882/2 "2024-05-24T16:38:41Z")

</div>

do something like:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/8/080781bf22a569872893c98df72d33b27015e287.png)

Table on repport.  
On this exemple, I only set 3column on the table, you must put all column taht you have on this Table

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/7/d7edf7a4713db4fad000fb69ff6a8bbe83e7dd81.png)

This doc will help you: [Report Tables | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.1/ignition-modules/reporting/report-design/report-table)  
UI video :[Simple Table Video at Inductive University](https://www.inductiveuniversity.com/videos/simple-table/7.9)

---

<div class="post-metadata">

**Author:** ![Esme\_Lopez](https://avatars.discourse-cdn.com/v4/letter/e/ecb155/32.png) [@Esme\_Lopez](https://forum.inductiveautomation.com/u/Esme_Lopez)\
**Post date:** [May 24, 2024, 9:13pm UTC](https://forum.inductiveautomation.com/t/how-to-add-data-from-a-query-to-my-report/90882/4 "2024-05-24T21:13:33Z")

</div>

Thank you so much
