# Reports ignoring same values

**URL:** <https://forum.inductiveautomation.com/t/reports-ignoring-same-values/3195>\
**Category:** Ignition\
**Created:** [August 19, 2011, 12:24am UTC](https://forum.inductiveautomation.com/t/reports-ignoring-same-values/3195 "2011-08-19T00:24:26Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![techerdone](https://avatars.discourse-cdn.com/v4/letter/t/9fc348/32.png) [@techerdone](https://forum.inductiveautomation.com/u/techerdone)\
**Post date:** [August 19, 2011, 12:24am UTC](https://forum.inductiveautomation.com/t/reports-ignoring-same-values/3195/1 "2011-08-19T00:24:26Z")

</div>

I have a table in a Report Module that recieves its dataset from the Tag History binding. There is just too much data, I have the scan class set for every ten minutes but a lot the data is duplicated and often a whole year needs to be viewed in a report.

Is it possible to ignore data with the same value as the previous and/or next row in the dataset?

i.e.:  
Row/Time/Value  
0 / 1 / 6.00  
1 / 4 / 6.00  
2 / 6 / 6.00  
4 / 9 / 4.50  
5 / 12 / 4.50  
6 / 15 / 4.50  
7 / 20 / 19.00

in the example data from rows 1,2,5 & 6 would be ignored as duplicates. Leaving:

0 / 1 / 6.00  
4 / 9 / 4.50  
7 / 20 / 19.00

I could not find any other posts or was not able to search them out, if anyone can help or can direct me to another posting that would be great. Thanks

-Brian

---

<div class="post-metadata">

**Author:** ![techerdone](https://avatars.discourse-cdn.com/v4/letter/t/9fc348/32.png) [@techerdone](https://forum.inductiveautomation.com/u/techerdone)\
**Post date:** [August 19, 2011, 12:34am UTC](https://forum.inductiveautomation.com/t/reports-ignoring-same-values/3195/2 "2011-08-19T00:34:49Z")

</div>

OK, it actually looks like the data isn’t updating in my DB but still how can I eliminate unimportant values in the report table?  
It seems to fake the time values for these to fill in the report but i end up with tens of thousands of rows of data…?

Thanks.

---

<div class="post-metadata">

**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\
**Post date:** [August 19, 2011, 5:49pm UTC](https://forum.inductiveautomation.com/t/reports-ignoring-same-values/3195/3 "2011-08-19T17:49:28Z")

</div>

Yes, set your Sample Size to On Change in the tag history binding. It will only give you the rows when the value actually changed.

---

<div class="post-metadata">

**Author:** ![techerdone](https://avatars.discourse-cdn.com/v4/letter/t/9fc348/32.png) [@techerdone](https://forum.inductiveautomation.com/u/techerdone)\
**Post date:** [August 19, 2011, 9:18pm UTC](https://forum.inductiveautomation.com/t/reports-ignoring-same-values/3195/4 "2011-08-19T21:18:22Z")

</div>

Thanks Travis!  
You’re the man.
