views:

371

answers:

3

I have a business object that compiles into a DLL that handles all calculations for my system for concepts such as eligibility, etc. The object also handles the connectivity to the DB via some wrappers around it.

Is there anyway to take this .NET DLL and use it as a datasource for a reporting services report (SSRS)? We don't want to have the logic in multiple places.

EDIT
What about exposing the functionality in a webservice in the web app itself and having the report connect to the web service? Anyone done this before? We are using asp.net MVC for our web app if that helps.

+3  A: 
Jon Erickson
+1  A: 

Not overly familiar with SSRS but I would imagine it would be able to consume XML web services.

If this is the case you could use the underlying data and logic and expose it as HTML for the web site and XML for SSRS.

Garry Shutler
+1  A: 

There are two ways to get your data to the report: WebServices and Custom Data Processing. there is an excellent book to get you started: http://prologika.com/Books/0976635313/Book.aspx

After reading the related chapters I was able to easily use both techniques.

Shabbazz