Connect to data channel from SSRS

Question

I need to take regular snapshots from several reports generated by SSRS. I requested a backend for data access, but I am not allowed to connect to the database.

I have never done anything with data feeds / RSS, and I was wondering how can I get started with C # to capture the report generated in SSRS?

There icon to export to the data feed:

How can I get this data programmatically? Is there a way to use this export for the feed parameter?

Answer 1

You can access the report server using web services.

This article shows how to make a report:

http://msdn.microsoft.com/en-us/library/reportexecution2005.reportexecutionservice.render%28SQL.105%29.aspx

This will allow you to start accessing the web service.

http://msdn.microsoft.com/en-us/library/ms152787%28SQL.105%29.aspx

The links above relate to 2008 R2, but should work equally well between 2005 and 2012.