# Named Query shows no data for Report Works on Power Table **URL:** \ **Category:** Ignition\ **Created:** [July 15, 2025, 6:35pm UTC](https://forum.inductiveautomation.com/t/named-query-shows-no-data-for-report-works-on-power-table/108514 "2025-07-15T18:35:36Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Kyle\_Latzke](https://avatars.discourse-cdn.com/v4/letter/k/c68b51/32.png) [@Kyle\_Latzke](https://forum.inductiveautomation.com/u/Kyle_Latzke)\ **Post date:** [July 15, 2025, 6:35pm UTC](https://forum.inductiveautomation.com/t/named-query-shows-no-data-for-report-works-on-power-table/108514/1 "2025-07-15T18:35:36Z")
I have a Named Query that I use to populate a Power Table, and I’d like to reuse it in an Ignition report. To do that, I open a report window via a button click and pass the selected date from a Calendar component into the Report Viewer. The date parameter shows correctly in the report header, but it’s the only data that appears. None of the query results show up. In my report, I’ve added the Named Query as a Data Source and bound its `dayStart` parameter to `{reportDate}`, which is also displayed in the report header. I then dragged each field from the query under “Objects Details,” but the table remains empty except for the date. (See the attached screenshot for my current setup.) ![report](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/7/173afde4d6932f0359677f451c76da9e52812837.png) I'm assuming I went astray somewhere. ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [July 15, 2025, 6:39pm UTC](https://forum.inductiveautomation.com/t/named-query-shows-no-data-for-report-works-on-power-table/108514/2 "2025-07-15T18:39:14Z")
Don't use fully-qualified data keys in the table rows. Just the column names between `@` symbols. Sadly, dragging from the data key browser does the wrong thing. (Has for a long time.) ---
**Author:** ![Kyle\_Latzke](https://avatars.discourse-cdn.com/v4/letter/k/c68b51/32.png) [@Kyle\_Latzke](https://forum.inductiveautomation.com/u/Kyle_Latzke)\ **Post date:** [July 15, 2025, 6:50pm UTC](https://forum.inductiveautomation.com/t/named-query-shows-no-data-for-report-works-on-power-table/108514/3 "2025-07-15T18:50:52Z")
Thanks, I'll try it out. ---
**Author:** ![Kyle\_Latzke](https://avatars.discourse-cdn.com/v4/letter/k/c68b51/32.png) [@Kyle\_Latzke](https://forum.inductiveautomation.com/u/Kyle_Latzke)\ **Post date:** [July 15, 2025, 6:59pm UTC](https://forum.inductiveautomation.com/t/named-query-shows-no-data-for-report-works-on-power-table/108514/4 "2025-07-15T18:59:15Z")
I removed all the "named\_query." from my keys and just have @Hour@ for example. I'm still not seeing any data for any date. ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [July 15, 2025, 7:01pm UTC](https://forum.inductiveautomation.com/t/named-query-shows-no-data-for-report-works-on-power-table/108514/5 "2025-07-15T19:01:45Z")
Did you connect the table's own data key to your query? ---
**Author:** ![Kyle\_Latzke](https://avatars.discourse-cdn.com/v4/letter/k/c68b51/32.png) [@Kyle\_Latzke](https://forum.inductiveautomation.com/u/Kyle_Latzke)\ **Post date:** [July 15, 2025, 7:29pm UTC](https://forum.inductiveautomation.com/t/named-query-shows-no-data-for-report-works-on-power-table/108514/6 "2025-07-15T19:29:05Z")
Yeah, I have {reportDate} as the value for my dayStart Parameter if that's what you mean. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/9/a92c03cba6d867e668a130fca6ce0a11ee7560b4.png) ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [July 15, 2025, 7:30pm UTC](https://forum.inductiveautomation.com/t/named-query-shows-no-data-for-report-works-on-power-table/108514/7 "2025-07-15T19:30:30Z")
No, I meant in the Design tab, in the table component's properties. ---
**Author:** ![Kyle\_Latzke](https://avatars.discourse-cdn.com/v4/letter/k/c68b51/32.png) [@Kyle\_Latzke](https://forum.inductiveautomation.com/u/Kyle_Latzke)\ **Post date:** [July 15, 2025, 7:35pm UTC](https://forum.inductiveautomation.com/t/named-query-shows-no-data-for-report-works-on-power-table/108514/8 "2025-07-15T19:35:05Z")
No, that would probably be my issue then. Where exactly in the properties would I do that. Sorry I didn't see that mentioned in the Named Queries video. Edit: I just added named\_query to my Data Key list in my Configure Table tab if that's right. ---
**Author:** ![Kyle\_Latzke](https://avatars.discourse-cdn.com/v4/letter/k/c68b51/32.png) [@Kyle\_Latzke](https://forum.inductiveautomation.com/u/Kyle_Latzke)\ **Post date:** [July 15, 2025, 7:38pm UTC](https://forum.inductiveautomation.com/t/named-query-shows-no-data-for-report-works-on-power-table/108514/9 "2025-07-15T19:38:54Z")
Thank so much. I got it. I had named\_query in Grouping and NOT set at the Data Key. I set it as the data key and it deleted everything I had entered and I have to completely reformat my Report but I tested with @Hour@ and I see the data. Thanks again.