Hi experts,

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





Regards
Sapna Shekhawat

Hi,

For that you need to do the rendering on the fly using a URL.

Check this Link (http://www.ehow.com/how_6364430_change-default-rendering-ssrs.html)

Thanks Bhushan for your prompt reply.

Actually what I really wanted is that I want to run the report in SSRS and at the same time I want to save that report of the SSRS format in Excel format on the server so that I can use it for the mail purpose.

So I am finding an option of rendering in the SSRS itself that at the time of its execution it saves the copy in excel format on server.

As per your link I can not do this.
So could you please help me in this context.

Sapna, refer to MS SSRS for LN administrator guide, there are some options to store the report at a directory on LN server and in a specific format. I think you can make use of -path and -format argument in LN device data to achieve what you are looking for. Hope you are using LN to print reports to SSRS

I did that what you said Bhawesh.
In the Argument Field I put Format = Excel -server Bramha
and in the Path field I define My path of server.

But still its not creating my file.

Hi,

Make sure you are using the path like "path_name"

-path "f:\reports\$user\$report_$datetime"

Export SSRS Report (http://www.barcodelib.com/net_reporting_services/main.html) Into Excel
Refer to this:
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/53b92b38-b411-43bd-86d4-a2d050c919b6/export-ssrs-report-into-excel?forum=sqlreportingservices