In SSRS, when a report is exported to csv it seems to output in the following format:
and repeats like this for every row, repeating the header and footer on every line.
However I want it to output the header at the top of the csv, then all the detail rows, then the footer at the bottom, like this:
Does anyone know how to accomplish this?
- <HEADER> <FOOTER> <DETAIL1>
- <HEADER> <FOOTER> <DETAIL2>
- <HEADER> <FOOTER> <DETAIL3>
- <HEADER> <FOOTER> <DETAIL4>
and repeats like this for every row, repeating the header and footer on every line.
However I want it to output the header at the top of the csv, then all the detail rows, then the footer at the bottom, like this:
- <HEADER>
- <DETAIL1>
- <DETAIL2>
- <DETAIL3>
- <DETAIL4>
- <FOOTER>
Does anyone know how to accomplish this?