# SQL query in REPORTS

**URL:** <https://forum.inductiveautomation.com/t/sql-query-in-reports/12806>\
**Category:** Ignition\
**Created:** [March 17, 2017, 7:07pm UTC](https://forum.inductiveautomation.com/t/sql-query-in-reports/12806 "2017-03-17T19:07:46Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![roshanbhosale](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/roshanbhosale/32/4899_2.png) [@roshanbhosale](https://forum.inductiveautomation.com/u/roshanbhosale)\
**Post date:** [March 17, 2017, 7:07pm UTC](https://forum.inductiveautomation.com/t/sql-query-in-reports/12806/1 "2017-03-17T19:07:46Z")

</div>

Hi everone,

```
 I have installed Mysql 5.7 database in my system. i created a table (7 data columns) with alomst 10 rows of data in it.

 I am trying to create the report from ignition 7.8.4 version for this data base records but every time i can see only first row of the database in the report and every other rows are not visible ( i am seeing it in the report preview), but in report preview page in xml detail window i can see all rows data.

```

do anyone faced same issue? or am i missing out something?

---

<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:** [March 17, 2017, 7:54pm UTC](https://forum.inductiveautomation.com/t/sql-query-in-reports/12806/2 "2017-03-17T19:54:02Z")

</div>

If you see it in the XML of the preview tab, your query was successful and it’s an issue with something in the design tab. Design issues can be a bit hard to diagnose here in the forum – you might try giving support a call and have them screen share with you.