Share via

ssrs export csv format column headers issue

suresh durisala 1 Reputation point
2021-10-14T17:43:17.793+00:00

Hi , while exporting ssrs report into csv format it is showing detail field names instead of column names,
actually i wanted to show column header names in csv file.
please help me

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,938 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Isabellaz-1451 3,616 Reputation points
    2021-10-15T02:04:28.17+00:00

    Hi @suresh durisala ,
    By design, SQL Server Reporting Services render a report to CSV format with text boxes' name as columns' name.

    The workaround to fix the issue is exporting the report to Excel , and then rename the exported Excel file to .csv.

    Best Regards,
    Isabella

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.