SSRS using Xml datasource [WCF], its possible, but is it advisable?

Batman

New Member
We have a requirement to use WCF as a data source in our reports. [Server Mode]Dot Net 4.0/ SSRS 2008 R2/ ASP.Net 4.0The idea behind this is to apply common business rules throughout the application from Reports to standard application grids.Essentially it would work along the lines ofNormally its as follows[RDL - SQL Sever Data Provider - DB]but what we require is[RDL - XML/Custom Dataprovider - WCF Method - Business Layer - - DB]Our main app would use the WCF layer also.Actually for practical purposes its an interface layer so if we had to use Web Services for SSRS instead, it would be considered if there were advantages to this approach.I have found some articles on our approachhttp://weblogs.asp.net/jezell/archi...cf-endpoints-with-sql-reporting-services.aspxhttp://www.codeproject.com/Articles/37270/Consuming-a-WCF-Service-from-an-SSRS-RDL-Server-Rehttp://social.msdn.microsoft.com/Fo.../thread/aa0c8c5e-28a7-440f-a1c1-62e8bb184b8d/http://msdn.microsoft.com/en-us/library/ms154655(v=sql.105).aspxhttp://devblog.bardoloi.com/2011/09/using-wcf-web-services-as-data-source.htmlhttp://msdn.microsoft.com/en-us/library/aa964129(SQL.90).aspxEither way given the limitations herehttp://msdn.microsoft.com/en-us/library/aa964129(SQL.90).aspx#repservxmlds_topic5its all getting a little scary.What I do not want to do of course is go down a certain path and this then impacts report design capability, performance and possibly limits the types of reports that can be created.If anyone has any opinions or experience on the above layout I would appreciate greatly your views and input.I'm also very much open to possible alternatives in how we could create reports containing data which has been though a business layer that does the appropriate massaging of data etcApologies for the long post.Liam
 
Back
Top