# Empty fields in Reports

**URL:** <https://forum.inductiveautomation.com/t/empty-fields-in-reports/86508>\
**Category:** Ignition\
**Tags:** vision\
**Created:** [February 28, 2024, 1:16pm UTC](https://forum.inductiveautomation.com/t/empty-fields-in-reports/86508 "2024-02-28T13:16:07Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![user43](https://avatars.discourse-cdn.com/v4/letter/u/8dc957/32.png) [@user43](https://forum.inductiveautomation.com/u/user43)\
**Post date:** [February 28, 2024, 1:16pm UTC](https://forum.inductiveautomation.com/t/empty-fields-in-reports/86508/1 "2024-02-28T13:16:07Z")

</div>

I have a report that leaves the date off of the empty rows if the equipment does not run that day.  
Example: equipment didn't run on the weekend and the report left out the date for the 24th and 25th. I need the date to be on the report:

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/1/c1403e367967bda1948c884d150513a3aaab377c.png)

---

<div class="post-metadata">

**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:** [February 28, 2024, 1:17pm UTC](https://forum.inductiveautomation.com/t/empty-fields-in-reports/86508/2 "2024-02-28T13:17:14Z")

</div>

You will have to modify the query to do so. Show your query.

If the tag historian, ensure that data gets recorded even when the machine is down.

---

<div class="post-metadata">

**Author:** ![user43](https://avatars.discourse-cdn.com/v4/letter/u/8dc957/32.png) [@user43](https://forum.inductiveautomation.com/u/user43)\
**Post date:** [February 28, 2024, 1:42pm UTC](https://forum.inductiveautomation.com/t/empty-fields-in-reports/86508/3 "2024-02-28T13:42:23Z")

</div>

The tags are set to log "On Change". So I gather that no new records were created after the equipment was shut down on Friday evening, If I change the sample mode to Periodic, then I'm filling the dB with zeros but that would let the report generate the row with the date displayed. Is there a different method to accomplish this so I don't have to log unnecessary data?

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/1/11d87fd5469c74bd118b420dbebffc2f92e30ce7.png)

---

<div class="post-metadata">

**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:** [February 28, 2024, 1:55pm UTC](https://forum.inductiveautomation.com/t/empty-fields-in-reports/86508/4 "2024-02-28T13:55:42Z")

</div>

You could use a script data source to reprocess the historian result to inject the missing rows during report generation.

---

<div class="post-metadata">

**Author:** ![user43](https://avatars.discourse-cdn.com/v4/letter/u/8dc957/32.png) [@user43](https://forum.inductiveautomation.com/u/user43)\
**Post date:** [February 28, 2024, 2:17pm UTC](https://forum.inductiveautomation.com/t/empty-fields-in-reports/86508/5 "2024-02-28T14:17:11Z")

</div>

Sounds good, I will give it a try!