SQL query in REPORTS

Ignition
1

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?

2

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.