How to Use Business Logic DLL

In my company, we have an extensive Business Logic Layer class library that
is used for several development projects. This works great for re-use and
streamlining project development. We would also like to extend this
capability to reporting services activities within the corporation. How can
we define a report in reporting services to use our class library vs an SQL
Datasource?I think your best bet would be to wrap some web services around your DLL and
then in RS 2005, you can create an XML data source. Connect to your web
services to pull in the data.
Otherwise, you would need to go into the Macro section of RS and add a
reference to your DLL, and then create functions to expose data elements. I
think that would less maintainable...
"Guy Thornton" wrote:
> In my company, we have an extensive Business Logic Layer class library that
> is used for several development projects. This works great for re-use and
> streamlining project development. We would also like to extend this
> capability to reporting services activities within the corporation. How can
> we define a report in reporting services to use our class library vs an SQL
> Datasource?

How to use ADO.NET DataSets in Sql Server Reporting Services ?

Hi All,
Anybody know how to use already developed Business Layer / ADO,NET
DataSets in Sql Server Reporting Services ?
How to attach XSD containing information about Report fields same as
in ADO.NET DataSet to Report at Design time ?
Regards
AmitUsing existing datasets/bo layer requires non-trivial implementation of a
data processing extension. However, with RS 2005 and VS 2005 there will be
another option. VS 2005 delivers a winform and webform control that can work
in local mode. In local mode you are responsible for the dataset and handing
it the report (i.e. no server is involved at all).
There is no support for XSD in 2000 or 2005.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"AmitK" <amitkarnik78@.gmail.com> wrote in message
news:1126779473.203596.246570@.g49g2000cwa.googlegroups.com...
> Hi All,
> Anybody know how to use already developed Business Layer / ADO,NET
> DataSets in Sql Server Reporting Services ?
> How to attach XSD containing information about Report fields same as
> in ADO.NET DataSet to Report at Design time ?
> Regards
> Amit
>|||Hi Bruce L-C...
I have created my own DPE & get success to attach xsd to the
report. When I execute the DataSet using Generic Query Designer.. It
executes the xml file. Shows Records in Result Pane but... It does not
show Fields in Fields Pane.. Thats why I can not Design the Report...
Could you please help me ?
Regards
Amit