How to fix report Builder Output header

Question

We have created a report using SSRS, query output looks correct. But when the report is exported in CSV only one of the column is giving wrong output. The report when exported in PDF has no issues.

Answer 1

Hi @Avyayah

When you export a report to a CSV file, it ignores formatting and layout, as well as the following items during rendering: headers, footers, custom report items, automatic subtotals, and so on. For more details, you can refer to this link: https://learn.microsoft.com/en-us/sql/reporting-services/report-builder/exporting-to-a-csv-file-report-builder-and-ssrs?view=sql-server-ver16.

You can choose a suitable output format or change the report design to better suit the CSV format.

If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

Best regards,

Aniya

Answer 2

Hi @Avyayah

Do you mean the header line is not shown? I did the test and the header line can be output. Can you provide some screenshots for me to analyze in detail?

Best regards,

Aniya