How to fix report Builder Output header

Avyayah 1,211 Reputation points
2023-03-21T21:14:27.7833333+00:00

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.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,675 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,796 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. AniyaTang-MSFT 12,311 Reputation points Microsoft Vendor
    2023-03-22T02:00:24.48+00:00

    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

    0 comments
  2. AniyaTang-MSFT 12,311 Reputation points Microsoft Vendor
    2023-03-28T01:23:01.2466667+00:00

    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?

    1

    Best regards,

    Aniya

    0 comments