Reporting Services report output to CSV

Question

Reporting Services report output to CSV

John Kelly 166

Hi

I have a number of Reporting Services reports and i want one of these to be in CSV file format when it runs. I know that i can export this to Word, Excel, CSV etc when it has ran but is there a way to create this one report in CSV format at runtime.

This report has been written with Microsoft Visual Studio 2015 Shell (Integrated) software

Thanks

John

Accepted answer

1 additional answer

Your answer

Answer 1

Joyzhao-MSFT 15,631

Hi @John Kelly ，
When you preview a report in Report Builder or Report Designer or run a report on a Reporting Services report server, the report is always first rendered in HTML. After you run the report, you can export it to different file formats. see Renderers.
Best Regards,
Joy

If the answer is helpful, please click "Accept Answer" and upvote it.
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.

John Kelly 166 Reputation points

2021-08-04T08:16:59.133+00:00

Hi Joy

Thanks for the reply

I know you can do that as mentioned in my question but i wanted to know if there is any way that rather the report be rendered first in HTML that it could be output direct to CSV instead

Regards

John
Joyzhao-MSFT 15,631 Reputation points

2021-08-04T09:53:30.897+00:00

@John Kelly ，
I think it is impossible to render in CSV format in report designer or report builder . If you really need to view the report in CSV format, I suggest you download the report.
But in the report manager, it should be directly rendered in CSV format, and we can access the report directly in CSV format through URL Access.
For more information,please refer to:
Specify Device Information Settings in a URL.
Change default rendering method for reports.
Joyzhao-MSFT 15,631 Reputation points

2021-08-05T06:12:22.11+00:00

Hi @John Kelly ，
Has your issue been resolved? Have you tried to access the report directly in CSV format via URL Access？
If you have any questions, please feel free to let me know.
If the answer is helpful, please click "Accept Answer" and upvote it.
Best Regards,
Joy

Answer 2

John Kelly 166

Hi Joy

I had a look at the links you provided. This report is being sent to people so i will try this.
.
"If you can change the URL which the link is pointing to though (like you send the link in email or you have a custom portal/application), then you can change the URL to look like this:"

http://<servername>/reportserver/?MyReportPath&rs:Command=Render&rs:Format=CSV

Thanks for your help

Share via

Reporting Services report output to CSV

1 additional answer

Your answer