# Generate report for trends data

**URL:** <https://forum.inductiveautomation.com/t/generate-report-for-trends-data/17697>\
**Category:** Ignition\
**Tags:** ignition79\
**Created:** [April 13, 2018, 6:25am UTC](https://forum.inductiveautomation.com/t/generate-report-for-trends-data/17697 "2018-04-13T06:25:28Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![patneshubham123](https://avatars.discourse-cdn.com/v4/letter/p/cab0a1/32.png) [@patneshubham123](https://forum.inductiveautomation.com/u/patneshubham123)\
**Post date:** [April 13, 2018, 6:25am UTC](https://forum.inductiveautomation.com/t/generate-report-for-trends-data/17697/1 "2018-04-13T06:25:28Z")

</div>

Hi Everyone,  
i wanted to generate the report of trends of tag data which is logged into the mysql database and stored in “final1” table .when i select particular column from final table in reporting module using basic sql query and sql query.the report which is generated is blank.  
can anyone help me with this ?

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/0/0101ba2777249c3c7aefc2b16fe92dcbbe69e417.png) ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/0/043edeac6701f5be8eb829e5f2e0407022f61281.png)

---

<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:** [April 13, 2018, 2:15pm UTC](https://forum.inductiveautomation.com/t/generate-report-for-trends-data/17697/2 "2018-04-13T14:15:05Z")

</div>

You can easily tell if the problem is your report data or your report design by heading to the Preview tab and looking at the data in the right hand column. The XML there is what the report sees coming back from the data sources – if the XML is empty, the problem is your data.

---

<div class="post-metadata">

**Author:** ![qliu](https://avatars.discourse-cdn.com/v4/letter/q/bc8723/32.png) [@qliu](https://forum.inductiveautomation.com/u/qliu)\
**Post date:** [January 24, 2019, 4:44am UTC](https://forum.inductiveautomation.com/t/generate-report-for-trends-data/17697/3 "2019-01-24T04:44:25Z")

</div>

Hey Kathy,

I have the same issue for mine, and the XML is not empty, but my preview is blank.

---

<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:** [January 24, 2019, 2:44pm UTC](https://forum.inductiveautomation.com/t/generate-report-for-trends-data/17697/4 "2019-01-24T14:44:42Z")

</div>

Then the problem is in your report design.

---

<div class="post-metadata">

**Author:** ![qliu](https://avatars.discourse-cdn.com/v4/letter/q/bc8723/32.png) [@qliu](https://forum.inductiveautomation.com/u/qliu)\
**Post date:** [January 27, 2019, 4:15pm UTC](https://forum.inductiveautomation.com/t/generate-report-for-trends-data/17697/5 "2019-01-27T16:15:25Z")

</div>

I have a transaction group to generate the data, but in the XML there are only the names for each columns, and no numbers.😥

---

<div class="post-metadata">

**Author:** ![qliu](https://avatars.discourse-cdn.com/v4/letter/q/bc8723/32.png) [@qliu](https://forum.inductiveautomation.com/u/qliu)\
**Post date:** [January 27, 2019, 4:19pm UTC](https://forum.inductiveautomation.com/t/generate-report-for-trends-data/17697/6 "2019-01-27T16:19:33Z")

</div>

You still have this problem?