# Reports displaying value other than Null

**URL:** <https://forum.inductiveautomation.com/t/reports-displaying-value-other-than-null/78779>\
**Category:** Ignition\
**Created:** [September 5, 2023, 6:28pm UTC](https://forum.inductiveautomation.com/t/reports-displaying-value-other-than-null/78779 "2023-09-05T18:28:51Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Zayne\_Luker](https://avatars.discourse-cdn.com/v4/letter/z/74df32/32.png) [@Zayne\_Luker](https://forum.inductiveautomation.com/u/Zayne_Luker)\
**Post date:** [September 5, 2023, 6:28pm UTC](https://forum.inductiveautomation.com/t/reports-displaying-value-other-than-null/78779/1 "2023-09-05T18:28:51Z")

</div>

Hello All,

I am currently trying to troubleshoot an error I am having with the reporting module in Ignition. I have a report querying from this SQL table:

 ![SQL_Table (2).PNG](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/f/ffffc374426e74e90b4fa78a4a4368a6e41b7758.jpeg)

Looking at the BACKWASH\_TOT column there are several null values. In my Ignition Report rather than displaying a blank indicating a null value it continues to display the first record of BACKWASH\_TOT.

 ![IGN_Report (2).PNG](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/4/746511e507c4347c719f2debf4cf1cd8af628d88.jpeg)  
 ![IGN_Report_pg2 (2).PNG](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/c/2cf18cc0073f522ba1062ab63159129e61a608fe.jpeg)

Everywhere in the Backwash Total column the value 35063 should be null (except for Aug 1st, 2023). At the end of the Report there is a row that takes the sum of each column. Looking at the sum of this column the sum is correct. It appears that the value is actually null for these days but Ignition continues to display the value in the first record.

Has anyone experienced this before?

---

<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:** [September 6, 2023, 2:46pm UTC](https://forum.inductiveautomation.com/t/reports-displaying-value-other-than-null/78779/2 "2023-09-06T14:46:59Z")

</div>

> [@Zayne\_Luker](#):
>
> It appears that the value is actually null for these days but Ignition continues to display the value in the first record.

Just to make sure, is the value showing as NULL in the XML data view in the preview tab?

---

<div class="post-metadata">

**Author:** ![Zayne\_Luker](https://avatars.discourse-cdn.com/v4/letter/z/74df32/32.png) [@Zayne\_Luker](https://forum.inductiveautomation.com/u/Zayne_Luker)\
**Post date:** [September 6, 2023, 5:50pm UTC](https://forum.inductiveautomation.com/t/reports-displaying-value-other-than-null/78779/3 "2023-09-06T17:50:19Z")

</div>

The values in the XML data were showing as NULL. However, I did find out the solution. My problem was the data key I used to make my table group was incorrect. After changing it to query it resolved the issue.