How to consume a WCF service with SSRS 2008 R2

Question

Are there any good tutorials available for querying for WCF services from within SSRS?

My WCF service is running fine, but when I try to query it from SSRS, I get contract mismatch exceptions. Some Googling suggests that querying WCF services in SSRS 2008 R2 is possible, but there doesn't seem to be any good documentation available. Help!

Take a look at this as well. http://bhushan.extreme-advice.com/wcf-service-as-datasource-in-ssrs/. Also this. http://www.codeproject.com/Articles/37270/Consuming-a-WCF-Service-from-an-SSRS-RDL-Server-Re — VivekDev, Jan 28 '16 at 03:28

score 14 · Accepted Answer · answered Oct 20 '11 at 00:04

14

It took a while but I got it done! A lot of blog posts were helpful but not end-to-end, so in the spirit of paying it forward, here's my blog post to walk through the process.

answered Oct 20 '11 at 00:04

Vishal Bardoloi

652
5
18

Awesome. Still relevant and helped me today! – tinonetic Mar 25 '14 at 07:08
Link is no longer valid – BeanFlicker Sep 06 '18 at 11:44

score 2 · Answer 2 · answered Sep 12 '11 at 20:41

2

You can go through this links

http://www.codeproject.com/KB/aspnet/WcfSSRSEx1.aspx http://weblogs.asp.net/jezell/archive/2008/02/21/using-wcf-endpoints-with-sql-reporting-services.aspx

answered Sep 12 '11 at 20:41

How to consume a WCF service with SSRS 2008 R2

2 Answers2

Linked