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

__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!

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

__________________
BTW: this post has been made on my personal view. My employer might not share my point of view.

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"

__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!

Export SSRS Report Into Excel
Refer to this:
https://social.msdn.microsoft.com/Fo...ortingservices

__________________
Best regards.
Abby Lee