SQL Server Performance

Using a Business Logic Object as Data Source

Discussion in 'SQL Server Reporting Services' started by JanneH, Jan 29, 2004.

  1. JanneH New Member

    Hi,
    I want to connect the datasource of my reports to a business logic object that
    returns a dataset instead of using a direct connection to a SQL Server.

    Anyone that knows if and how this be done?

    Regards
    -Janne
  2. jasper_smith New Member

    In order to do this you need to implement a Data Processing extension.With Reporting Services data processing extensions, you can integrate into Reporting Services data processing any custom DataSet objects that are created by external applications. To accomplish this, you create a custom data processing extension in Reporting Services that acts as a bridge between your DataSet object and the report server. Most of the code for processing this DataSet object is contained in the DataReader class that you create.

    See "Using an External Dataset with Reporting Services" in BOL.

    HTH

    Jasper Smith
  3. jasper_smith New Member

    Also, you might want to check out http://www.sqlrs.com/DesktopDefault.aspx?tabid=73
    A Data Extension for Microsoft SQL Server Reporting Services that allows DataSets returned from methods within Assemblies to be used as Data Sources

    HTH

    Jasper Smith
  4. JanneH New Member

    Thanks for all help Jasper,
    now I'm on the right track!

    Another useful example is provided by Microsoft under
    Program FilesMicrosoft SQL ServerMSSQLReporting ServicesSamples

    Look in documentation
    "Sample File Share Data Processing Extension"

    Thanks again!
    -Janne

Share This Page