SQL Server 2000 Reporting Services with LLBL GEN Pro

Posts   
 
    
vbo
User
Posts: 1
Joined: 30-Sep-2005
# Posted on: 04-Oct-2005 16:45:35   

Has anyone had a chance to test or look at getting sql server reporting services to work with llblgen. Would be nice if anyone had some insight on this or how it can be done. Appreciate any replies Vbo

Paul.Lewis
User
Posts: 147
Joined: 22-Aug-2005
# Posted on: 05-Oct-2005 04:37:57   

vbo wrote:

Has anyone had a chance to test or look at getting sql server reporting services to work with llblgen. Would be nice if anyone had some insight on this or how it can be done. Appreciate any replies Vbo

I haven't actually done what your asking, but you can reference custom assemblies within your reports. It stands to reason that your custom assembly could be a LLBLGen generated data layer.

I found this article through Google: http://www.c-sharpcorner.com/Code/2005/June/CustomAssemblyinRS.asp It shows how to create a custom assembly (you probably have that one covered already) and how to use it within your report.

On the down side, it appears you can only use your custom assemblies for expressions; for instance to calculate a monetary conversion rate based on a value stored in your database. I don't believe your reports source data can be derived from a custom assembly.

Anyone else have any thoughts?

Paul