Forum Discussion
Columns heading when exporting a Report Builder report to CSV
Hi krrose,
Thank you for the response. The textbox name property is only an internal identifier in the report and it cannot contain spaces, but it does not control the csv column header text.
- In Paginated Reports, when exporting to csv, the column headers come from the value of the textbox in the tablix header row. So, to have headers like ‘Customer Number’ in the csv, set the desired text as the value of the textbox in the header row.
So, if the tablix contains a proper static header row and the header cells are aligned directly above the data columns, the csv export should use the textbox value as the column header.
Thanks and regards,
Anjan Kumar Chippa
Thanks for the replies and solution. Unfortunately it wasnt quite the solution I wanted. I wanted my column headings to contain spaces e.g. "Customer Number" but renaming the header textboxes does not allow spaces in the name.
Community SupportHi krrose,
Thank you for the response. The textbox name property is only an internal identifier in the report and it cannot contain spaces, but it does not control the csv column header text.
- In Paginated Reports, when exporting to csv, the column headers come from the value of the textbox in the tablix header row. So, to have headers like ‘Customer Number’ in the csv, set the desired text as the value of the textbox in the header row.
So, if the tablix contains a proper static header row and the header cells are aligned directly above the data columns, the csv export should use the textbox value as the column header.
Thanks and regards,
Anjan Kumar Chippa