How to Change the Header Name in a CSV Export
When exporting reports in CSV format, there is a common behavior that automatically uses the text box name of the details row as the header for the CSV header. However, it is important to note that this behavior can lead to inaccurate values displayed in the CSV header. You can modify the CSV header behavior by following the steps below:
- Select the cell in the Tablix detailed row that corresponds to the header.
- Update the value of the cell to match the desired header row value.
- Alternatively, you can set the value for the Data Element associated with the details row to achieve the desired behavior.
- Export the report to CSV and verify that the changes have been applied correctly.
By following these steps, the CSV export will use the details row’s text box name value as the header, ensuring the correct values are displayed in the CSV header.