# Cross-tab report issue

**URL:** <https://forum.inductiveautomation.com/t/cross-tab-report-issue/12203>\
**Category:** Ignition\
**Created:** [October 5, 2016, 5:22pm UTC](https://forum.inductiveautomation.com/t/cross-tab-report-issue/12203 "2016-10-05T17:22:21Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![dkeith](https://avatars.discourse-cdn.com/v4/letter/d/91b2a8/32.png) [@dkeith](https://forum.inductiveautomation.com/u/dkeith)\
**Post date:** [October 5, 2016, 5:22pm UTC](https://forum.inductiveautomation.com/t/cross-tab-report-issue/12203/1 "2016-10-05T17:22:21Z")

</div>

I am creating a cross-tab report that will be emailed as .csv file (+1 for .xlsx format 🙂 )

The rows will show plant and material data and total product quality. The columns show date. The report will be month-to-date so each day will have 1 more column added - then back to 1 column on first day of the month.

The problem I have is the .csv file has duplicate rows that I can’t figure out where they are coming from. As I was trying to simplify the report to find the smallest case that shows the issue I found it is related to the “reprint header rows” checkbox. When the option is true, the date headings repeat every 46 rows (46, 91, 136 etc.) When the option is false (un-checked) the data that is in row 46 gets repeated at rows 91, 136 etc.

Any ideas on what may be causing this.

Thanks,  
-David

Ignition: 7.8.2 Data for report coming from MySql 5.2

---

<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:** [October 5, 2016, 6:44pm UTC](https://forum.inductiveautomation.com/t/cross-tab-report-issue/12203/2 "2016-10-05T18:44:23Z")

</div>

We had some strange issues with repeating / missing rows in the reports that seem to be solved in 7.8.4. Can you upgrade and see if it still happens? If it does, please let support know so they can make a ticket to get it resolved. Thanks! 😃

---

<div class="post-metadata">

**Author:** ![dkeith](https://avatars.discourse-cdn.com/v4/letter/d/91b2a8/32.png) [@dkeith](https://forum.inductiveautomation.com/u/dkeith)\
**Post date:** [April 10, 2017, 5:15pm UTC](https://forum.inductiveautomation.com/t/cross-tab-report-issue/12203/3 "2017-04-10T17:15:49Z")

</div>

Kathy:  
Sorry it took so long to reply - I thought I had tried again and reported back, but apparently I didn’t.

We have version 7.9.0 installed and I still see the same cross-tab issue.  
Let me know if I can do anything else to help solve this.  
Thanks.

---

<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:** [April 10, 2017, 6:38pm UTC](https://forum.inductiveautomation.com/t/cross-tab-report-issue/12203/4 "2017-04-10T18:38:11Z")

</div>

Can you email / call the details in to support? Thanks!