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!
A:
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!
Even Mien
2009-02-25 21:12:43
A:
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.)
=Fields!Parent.Value.FirstName
Vitalik
2009-05-09 04:53:11