# SQL report help

**URL:** <https://forum.inductiveautomation.com/t/sql-report-help/108170>\
**Category:** Ignition\
**Tags:** reporting\
**Created:** [July 7, 2025, 8:35am UTC](https://forum.inductiveautomation.com/t/sql-report-help/108170 "2025-07-07T08:35:17Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Samueldale](https://avatars.discourse-cdn.com/v4/letter/s/57b2e6/32.png) [@Samueldale](https://forum.inductiveautomation.com/u/Samueldale)\
**Post date:** [July 7, 2025, 8:35am UTC](https://forum.inductiveautomation.com/t/sql-report-help/108170/1 "2025-07-07T08:35:17Z")

</div>

Hello,  
I'm a newbie with SQL queries. Trying to report from a transaction group I have setup on a trigger. The report generates in Database Query Browser OK however it doesn't show anything in preview in the report viewer.

Any assistance would be much appreciated.

 ![Report](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/1/91373ff2fd3e4c3c4c484cef7599a55413f12f8a.png)

---

<div class="post-metadata">

**Author:** ![Samueldale](https://avatars.discourse-cdn.com/v4/letter/s/57b2e6/32.png) [@Samueldale](https://forum.inductiveautomation.com/u/Samueldale)\
**Post date:** [July 7, 2025, 10:14am UTC](https://forum.inductiveautomation.com/t/sql-report-help/108170/2 "2025-07-07T10:14:01Z")

</div>

All sorted, had my report grouping configured incorrectly. Thanks