# Duplicated Data - Reports Table

**URL:** <https://forum.inductiveautomation.com/t/duplicated-data-reports-table/30604>\
**Category:** Ignition\
**Tags:** ignition80\
**Created:** [December 11, 2019, 1:45pm UTC](https://forum.inductiveautomation.com/t/duplicated-data-reports-table/30604 "2019-12-11T13:45:09Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![conan.a](https://avatars.discourse-cdn.com/v4/letter/c/22d042/32.png) [@conan.a](https://forum.inductiveautomation.com/u/conan.a)\
**Post date:** [December 11, 2019, 1:45pm UTC](https://forum.inductiveautomation.com/t/duplicated-data-reports-table/30604/1 "2019-12-11T13:45:09Z")

</div>

Hi Guys,

Have an Issue with the reporting feature on Ignition 8.

I am trying to display data in a 24 hour time from starting from midnight to 23:00PM.  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/0/064dbaa47928db4af064c2e3aa2a3b109c2e632f.png)  
This column is reading in a Text Value of @t\_stamp@,

I have the Rows sorted by TopN, showing 24 rows for my 24 hour datatable. My datatable is pulling in duplicated records and I cannot find where the issue is, would someone be able to steer me in the right direction? Not all times are duplicated as shown below;  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/9/9f96124dfa85e11e6981a43e5dcf532fe9d74b13.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:** [December 11, 2019, 1:50pm UTC](https://forum.inductiveautomation.com/t/duplicated-data-reports-table/30604/2 "2019-12-11T13:50:18Z")

</div>

If you run the same query in your database’s management console, are the rows duplicated there too?

---

<div class="post-metadata">

**Author:** ![conan.a](https://avatars.discourse-cdn.com/v4/letter/c/22d042/32.png) [@conan.a](https://forum.inductiveautomation.com/u/conan.a)\
**Post date:** [December 11, 2019, 5:52pm UTC](https://forum.inductiveautomation.com/t/duplicated-data-reports-table/30604/3 "2019-12-11T17:52:39Z")

</div>

Ran the query and there was no duplication in the records, ran it in a table via vision.