SQL Server Reporting Services

Posts   
 
    
JimFoye avatar
JimFoye
User
Posts: 656
Joined: 22-Jun-2004
# Posted on: 06-Apr-2005 18:19:38   

Has anyone used this product talking to a middle tier that returns LLBLGenPro entities? Or do folks generally give up on LLBLGenPro and just use datasets when doing reports with it?

Devildog74
User
Posts: 719
Joined: 04-Feb-2004
# Posted on: 07-Apr-2005 18:53:58   

I have done some things with SRS. When it comes to consuming assemblies from RDL, I havent looked at returning data objects from assemblies, which is one approach that you could take.

I think that in most scenarios, the schema information is pumped into the RDL by the report designer, so it is feasable that you could probe LLBLGen generated assemblies and use the information in the assemblies to create the RDL Meta Data required by the SRS Engine to run the report.

Good luck though.

wayne avatar
wayne
User
Posts: 611
Joined: 07-Apr-2004
# Posted on: 08-Apr-2005 09:35:21   

JimFoye wrote:

Has anyone used this product talking to a middle tier that returns LLBLGenPro entities? Or do folks generally give up on LLBLGenPro and just use datasets when doing reports with it?

I create database views and then use LBLGen TypedViews for reporting purposes...Yeah i guess it comes down to a dataset/datatable. wink