Is there any way to convert the SSRS report into excel automatically without manually export it to excel.

0
votes

i am not using SSIS, C#, web. only ssrs repoting project http://servername/ReportServer?/Folder/Report%20Name&rs:Format=EXCEL&rs:Command=Render

1
reporting-services
You provided answer yourself, check this: msdn.microsoft.com/en-us/library/ms154040.aspx – OctoCode
yes but i am actually not getting where to set this url option. – Shum
You need to explain what are you doing clearly. Did you just created a report in report builder and published it to the server, or you have a project inside some solution? How are you planning to consume this report? – OctoCode
i have created a ssrs project. and when i deploy my report it shows this. servername/ReportServer?/Folder/Report%20Name in url. how to embed this "&rs:Format=EXCEL&rs:Command=Render" in url. is there any code to add it. – Shum
Open web browser and navigate to: YOURSERVERNAMEHERE/reportserver Navigate to your report and just add parameters to the URL. – OctoCode

1 Answers

3
votes

To export reports automatically on a schedule you can set up a Subscription:

https://msdn.microsoft.com/en-us/library/ms159762.aspx

If you want to export many different versions of the report based on a dataset used to populate the parameters, with one row for each version required you can use a Data-Driven Subscription:

https://msdn.microsoft.com/en-us/library/ms169673.aspx

If either of those links stop working, google "SSRS report subscription" and you will find a vast number of resources, tutorials and examples you can look through.