Tutorial :Building a SSRS 2008 off an EDM


Can someone please outline the process of building a SQL Server Reporting Services 2008 report based on a ADO.Net Entity Framework Entity Data Model? If you know of any example, please point me to it. Thank you!


Create ADO.NET Data Services based on your EDM:

http://geekswithblogs.net/frankw/archive/2008/03/08/ado.net-entity-framework-and-data-services-in-action-part-1.aspx http://geekswithblogs.net/frankw/archive/2008/03/08/ado.net-entity-framework-and-data-services-in-action-part-2.aspx

Consume web service as data source in SSRS 2008:


Hope this helps!


There is no reason to go through a web service. Just map your objects to your database, when creating a report choose "Object Data Source".

The only trick with Object Data Source, is if you need to access members of a related object you do it like this (for example if you want to print a first name of a person's parent.)


Note:If u also have question or solution just comment us below or mail us on toontricks1994@gmail.com
Next Post »