CODEWITHSUNDEEP
c#.netreporting-servicesrss
Alex Gordon
Alex Gordon

Reputation: 60871

connecting to data feed from SSRS

I need to do regular snapshots of a few reports that are being generated by SSRS. I've pleaded for backend access to the data, but I am not allowed to connect to the database.

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

There's an icon export to data feed:

enter image description here

How can I grab this data programmatically? Is there a way to utilize this export to data feed option?

Upvotes: 4

Views: 2494

Answers (1)

Simon Halsey
Simon Halsey

Reputation: 5479

You can access the Reporting server using the web services.

This article shows how to render a report:

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

This'll get you started on accessing the web service

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

The links above are for 2008 R2, but should work equally well for 2005 - 2012

Upvotes: 4

Related Questions