I’m new to Ignition and I’m trying to create a report using a SQL query. I verified that the query works using the Database Query Browser tool, but when I run the report, it will only ever display the first project returned from the database. Each project might have multiple rows. you can see in the image below that this particular project returned 3 rows in the “Details” Row.
There should, however, be more projects displayed.
I expect the report to continue with a new Detail row starting with a new “PSI Project #” followed by the respective details rows
You can see below my design configuration and a query I ran showing there are more rows not displayed on the report even though they are returned in SQL
And in the next image you can see how my report Data is configured.
Any help is appreciated. Thanks.
FYI version info
8.0.6 |**Symbol Factory Module**|6.0.6
|Alarm Notification Module|
5.0.6 |**SFC Module**|4.0.6
8.0.6 |**Enterprise Administration Module**|3.0.6
|SQL Bridge Module|
9.0.6 |**DNP3 Driver Module**|3.0.6
5.0.6 |**Vision Module**|10.0.6
1.0.6 |**Reporting Module**|5.0.6