Share via

ssrs export to csv issue

suresh durisala 1 Reputation point
2021-10-14T17:38:03.08+00:00

Hi ,
my report having region ,country , number at the end of number field there is total, while exporting this report into csv format my report is showing like below.
region country number textbox13
A Cn1 100 550
B Cn2 150 550
C Cn3 300 550
i want to show that 550 in at the end of number column ,please help me here and excel and pdf are working fine.

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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Joyzhao-MSFT 15,566 Reputation points
    2021-10-15T01:53:01+00:00

    Hi @suresh durisala ,
    After the SSRS report is exported to CSV format, Automatic subtotals will be ignored when rendered.
    For more information, see Export a paginated report to a CSV file (Report Builder).
    Best Regards,
    Joy

    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.