# Alarm Journal Table in Report not showing correct values

**URL:** <https://forum.inductiveautomation.com/t/alarm-journal-table-in-report-not-showing-correct-values/29929>\
**Category:** Ignition\
**Created:** [November 13, 2019, 10:27pm UTC](https://forum.inductiveautomation.com/t/alarm-journal-table-in-report-not-showing-correct-values/29929 "2019-11-13T22:27:12Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![jlotzy](https://avatars.discourse-cdn.com/v4/letter/j/ce7236/32.png) [@jlotzy](https://forum.inductiveautomation.com/u/jlotzy)\
**Post date:** [November 13, 2019, 10:27pm UTC](https://forum.inductiveautomation.com/t/alarm-journal-table-in-report-not-showing-correct-values/29929/1 "2019-11-13T22:27:12Z")

</div>

I created a table in a report for alarm journal values - but the report does not display the time, only the date. Also the label, which is displayed correctly in an alarm journal table, does not display, only shows N/A.

Can anyone help?

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/9/936ed0508ee046e05d205b1a732ae210565e80d6.png)

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/b/bc4f612eb5deb608f31e19319b8c3fc6fa922c7f.png)

---

<div class="post-metadata">

**Author:** ![grietveld](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/grietveld/32/6984_2.png) [@grietveld](https://forum.inductiveautomation.com/u/grietveld)\
**Post date:** [November 14, 2019, 12:45pm UTC](https://forum.inductiveautomation.com/t/alarm-journal-table-in-report-not-showing-correct-values/29929/2 "2019-11-14T12:45:20Z")

</div>

In your table select the cell your date is in, and in the properties menu there should be an option to set the date format. Also make sure the column is wide enough since it might cut off data.

I’m not sure on the N/A though, might be a configuration with the datasource or the table. I’d look at the report in preview mode. The XML should help you see what data it is trying to use.

---

<div class="post-metadata">

**Author:** ![jlotzy](https://avatars.discourse-cdn.com/v4/letter/j/ce7236/32.png) [@jlotzy](https://forum.inductiveautomation.com/u/jlotzy)\
**Post date:** [November 15, 2019, 8:03pm UTC](https://forum.inductiveautomation.com/t/alarm-journal-table-in-report-not-showing-correct-values/29929/3 "2019-11-15T20:03:47Z")

</div>

Looking at the XML, the field “Label” shows null - however, when I look at the Alarm Journal table in the client, the labels are there - see below. Also, the eventTime in the XML shows the time and date, but the field on the report only shows the date, and is not in the same format

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/a/a9f40994c3365332867c0973d7f73b9093e293d1.png)

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/0/026aaa84b90a0aca85c35313569d21add82464be.png)

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/1/155b780581c1a83689de8696d84ed27cf5842b65.png)

---

<div class="post-metadata">

**Author:** ![jlotzy](https://avatars.discourse-cdn.com/v4/letter/j/ce7236/32.png) [@jlotzy](https://forum.inductiveautomation.com/u/jlotzy)\
**Post date:** [November 15, 2019, 8:17pm UTC](https://forum.inductiveautomation.com/t/alarm-journal-table-in-report-not-showing-correct-values/29929/4 "2019-11-15T20:17:26Z")

</div>

I reset the date properties, and it is displaying ok now. But, still showing null on the label, looking at the tag and alarms, the label is there for each alarm.

---

<div class="post-metadata">

**Author:** ![jlotzy](https://avatars.discourse-cdn.com/v4/letter/j/ce7236/32.png) [@jlotzy](https://forum.inductiveautomation.com/u/jlotzy)\
**Post date:** [November 15, 2019, 9:20pm UTC](https://forum.inductiveautomation.com/t/alarm-journal-table-in-report-not-showing-correct-values/29929/5 "2019-11-15T21:20:33Z")

</div>

I used the displayPath - that works, see below. Will apparently have to use this, is a little confusing showing the tag and label, but at least its there.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/f/fe3a349390f37cc7c3421c37567cf6d1f7681f09.png)