SSRS 2008 R2 Deployment Mode

Question

Hi,

Currently,I am having Native deplyment mode for my SSRS reports,wherein I deploy my SSRS reports on report manager,

If the reports are approved by users,Then I generate these reports from report manager on my local drive and then host these reports to end users sharepoint site manually.

All I want to automate these process and give suggestion to users to have sharepoint mode deployment.

Please let me know if there is an option that I can create subscriptions for reports in report manager to deploy them to sharepoint site.

If Yes,what are the installations that I need to do in order to have sharepoint deployment.

Answer 1

http://stackoverflow.com/questions/3056799/automating-ssrs-report-deployment

You can also create an ssis package and schedule for deploying report to share point.

Regards,Eshwar.

---

Please don't forget to Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful. It will helpful to other users.

Answer 2

Thanks for reply..

But I want to know that can I keep report manager for testing purpose and at the same time sharepoint site for final deploying of reports.

Also,are there any limit for creation of subscriptions at report manager end.

As I have more than 200 reports.....

Answer 3

Hi Neha,

Reporting Services supports two modes of deployment for report server instances: Native mode and SharePoint integrated mode. We should run reports on Native mode and SharePoint mode at the same time. So in your scenario, after you test the report on Report Manager, you switch to SharePoint integrated mode before you can run report on SharePoint site. For more information about it, please see:
http://msdn.microsoft.com/en-us/library/bb326345(v=sql.105).aspx

For the limitations of subscriptions, you can refer to the link below to see the details information.
http://msdn.microsoft.com/en-us/library/ms159762(v=sql.105).aspx

Hope this helps.

Regards,

---

Charlie Liao
TechNet Community Support