# Issue with Named Query in a Report

**URL:** <https://forum.inductiveautomation.com/t/issue-with-named-query-in-a-report/24492>\
**Category:** Ignition\
**Created:** [April 30, 2019, 4:20am UTC](https://forum.inductiveautomation.com/t/issue-with-named-query-in-a-report/24492 "2019-04-30T04:20:29Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![camatt3](https://avatars.discourse-cdn.com/v4/letter/c/22d042/32.png) [@camatt3](https://forum.inductiveautomation.com/u/camatt3)\
**Post date:** [April 30, 2019, 4:20am UTC](https://forum.inductiveautomation.com/t/issue-with-named-query-in-a-report/24492/1 "2019-04-30T04:20:29Z")

</div>

If I add a named query data source to a report, it is called ‘named\_query’ by default and shows up in the report builder’s key browser. If I then rename the data source ‘named\_query’ (for example to ‘named\_query\_2’), the query does not show in the key browser, and a NullPointerException is shown in the report design/preview tabs. Reverting the name back to the default makes it work again.

Is this a bug, or am I missing something?

Ignition is 7.9.10

---

<div class="post-metadata">

**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\
**Post date:** [April 30, 2019, 1:30pm UTC](https://forum.inductiveautomation.com/t/issue-with-named-query-in-a-report/24492/2 "2019-04-30T13:30:26Z")

</div>

I can’t reproduce this in 7.9.10.

---

<div class="post-metadata">

**Author:** ![camatt3](https://avatars.discourse-cdn.com/v4/letter/c/22d042/32.png) [@camatt3](https://forum.inductiveautomation.com/u/camatt3)\
**Post date:** [May 1, 2019, 3:28am UTC](https://forum.inductiveautomation.com/t/issue-with-named-query-in-a-report/24492/3 "2019-05-01T03:28:38Z")

</div>

After publishing the named queries it appears to be working better.

---

<div class="post-metadata">

**Author:** ![Cas](https://avatars.discourse-cdn.com/v4/letter/c/77aa72/32.png) [@Cas](https://forum.inductiveautomation.com/u/Cas)\
**Post date:** [May 21, 2020, 9:39pm UTC](https://forum.inductiveautomation.com/t/issue-with-named-query-in-a-report/24492/4 "2020-05-21T21:39:48Z")

</div>

Thanks for your post, camatt3. I had the same issue and you saved me tons of time. Cheers!