SQL query in REPORTS

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?

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.