# Why does a csv report recreate the header every ~10 rows?

**URL:** <https://forum.inductiveautomation.com/t/why-does-a-csv-report-recreate-the-header-every-10-rows/85407>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [February 7, 2024, 9:17pm UTC](https://forum.inductiveautomation.com/t/why-does-a-csv-report-recreate-the-header-every-10-rows/85407 "2024-02-07T21:17:05Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![JB77](https://avatars.discourse-cdn.com/v4/letter/j/f19dbf/32.png) [@JB77](https://forum.inductiveautomation.com/u/JB77)\
**Post date:** [February 7, 2024, 9:17pm UTC](https://forum.inductiveautomation.com/t/why-does-a-csv-report-recreate-the-header-every-10-rows/85407/1 "2024-02-07T21:17:06Z")

</div>

When I export my data table in csv format via email, the header is reproduced every 10 or so rows. I have went through all of the report table settings but have only managed to change it from every 4 to every ~10 somehow. I just want it just be a continuous list. Any ideas?

---

<div class="post-metadata">

**Author:** ![ryan.white](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryan.white/32/73193_2.png) [@ryan.white](https://forum.inductiveautomation.com/u/ryan.white)\
**Post date:** [February 7, 2024, 9:19pm UTC](https://forum.inductiveautomation.com/t/why-does-a-csv-report-recreate-the-header-every-10-rows/85407/2 "2024-02-07T21:19:48Z")

</div>

Are you exporting data from the reporting module to make the csv? In that case the headers are likely from each page of the report.

Instead, you should have a script that grabs all the same data that the report uses, convert it to excel using `system.dataset.toExcel()` and then use `system.net.sendEmail()` to distribute it

---

<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:** [February 7, 2024, 11:17pm UTC](https://forum.inductiveautomation.com/t/why-does-a-csv-report-recreate-the-header-every-10-rows/85407/3 "2024-02-07T23:17:42Z")

</div>

Ryan's correct, it's every page of the report. We do have a ticket [IGN-9172] to fix this, and I've linked this post to the ticket to get more visibility.
