Hi,

You can utilize SSRS subscription to run the report at a particular time and you will get your report in your required format too. To achieve this, you can redirect your report manager URL from your application for generating the report(Subscription). Follow the below link for more information:

http://www.sqlcircuit.com/2012/10/ssrs-implementation-of-file-share.html

Thanks,

Vishal