# Report Export copies the columns for every page **URL:** \ **Category:** Ignition\ **Tags:** ignition79\ **Created:** [December 11, 2017, 6:43pm UTC](https://forum.inductiveautomation.com/t/report-export-copies-the-columns-for-every-page/16288 "2017-12-11T18:43:41Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![danewilbanks1](https://avatars.discourse-cdn.com/v4/letter/d/e274bd/32.png) [@danewilbanks1](https://forum.inductiveautomation.com/u/danewilbanks1)\ **Post date:** [December 11, 2017, 6:43pm UTC](https://forum.inductiveautomation.com/t/report-export-copies-the-columns-for-every-page/16288/1 "2017-12-11T18:43:41Z")
When making a report that gets saved as a csv, I’m getting this issue where it reads the headers more than once, how would I go about getting around that? EDIT: I want it to show up at the top of every PDF, but not in the CSV. Is that possible? ---
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [February 6, 2018, 11:29pm UTC](https://forum.inductiveautomation.com/t/report-export-copies-the-columns-for-every-page/16288/2 "2018-02-06T23:29:35Z")
Bump. I have this issue as well ---
**Author:** ![bfuson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bfuson/32/4597_2.png) [@bfuson](https://forum.inductiveautomation.com/u/bfuson)\ **Post date:** [February 6, 2018, 11:43pm UTC](https://forum.inductiveautomation.com/t/report-export-copies-the-columns-for-every-page/16288/3 "2018-02-06T23:43:37Z")
You could try running your report in a script using [system.report.executeReport](https://docs.inductiveautomation.com/display/DOC79/system.report.executeReport) with a filetype of CSV. Then use regexes or string operations to delete all but the first header. I haven’t experienced this issue though. To my knowledge the CSV should contain only that data you see in the report XML on the Preview tab. ---
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [February 6, 2018, 11:51pm UTC](https://forum.inductiveautomation.com/t/report-export-copies-the-columns-for-every-page/16288/4 "2018-02-06T23:51:29Z")
If the report spans a number of pages though in the preview, the column headers are repeated on each page. There doesn’t appear to be an option to remove this. I think the simpler option, unfortunately, might be to just use scripting to convert the dataset to CSV format and write this to a file using a gateway script or a transaction group trigger. ---
**Author:** ![bfuson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bfuson/32/4597_2.png) [@bfuson](https://forum.inductiveautomation.com/u/bfuson)\ **Post date:** [February 6, 2018, 11:54pm UTC](https://forum.inductiveautomation.com/t/report-export-copies-the-columns-for-every-page/16288/5 "2018-02-06T23:54:27Z")
And you can accomplish that conversion with executeReport. Which still accepts parameters and fires any preprocessing scripting events. ---
**Author:** ![kugan.puspanathan](https://avatars.discourse-cdn.com/v4/letter/k/a9a28c/32.png) [@kugan.puspanathan](https://forum.inductiveautomation.com/u/kugan.puspanathan)\ **Post date:** [April 21, 2022, 3:52pm UTC](https://forum.inductiveautomation.com/t/report-export-copies-the-columns-for-every-page/16288/6 "2022-04-21T15:52:19Z")
If you are just looking to export a CSV without the headers being repeated, you can increase the height of the page. Then expand the table so it covers the full page. In your preview screen, you should only see one large page. and your CSV will not have any repeating headers. Hope it helps