SSRS 2008 and MOSS 2007 RRS feed

  • Question

  • Hi.

    I need to find any documentation about SSRS 2008-MOSS 2007 integration mode that tells also about the differences with SSRS 2005-MOSS 2007.

    Any suggests to me, please? Thanks

    Friday, May 21, 2010 3:24 PM

All replies

  • Hi,


    The following table compares newer and older levels of integration features. If you are planning a new deployment, or evaluating the new integration features for your organization, the table can help you weigh the advantages and disadvantages of each implementation.

    Comparison point SharePoint integrated mode SharePoint 2.0 Web Parts

    Key integration features

    Provides a user interface (UI) to administer, secure, manage, view, and deliver reports by using SharePoint products and technologies. Reports, data sources, and data models are stored, accessed, and managed in a SharePoint library.

    Integrates Reporting Services with SharePoint databases and security. This configuration enables SharePoint to be the front-end server that users access, and Reporting Services to be the back-end server that provides reporting capability.

    A single, all-new Report Viewer Web Part displays reports in either full-page view or within a SharePoint Dashboard. It supports the filter and row consumer interfaces, which connect to SharePoint filter Web Parts or other SharePoint Web Parts, such as the Reports Library Web Part or Shared Document Library Web Part. The viewer also provides properties to customize the Report Viewer Web Part.

    A free Web download of the Reporting Services Add-in provides a setup program that adds report server application pages to a SharePoint Web front-end.

    Support for data-driven subscriptions and the ability to manage jobs programmatically and by using SQL Server Management Studio in SQL Server 2008.

    Two Web Parts provide access and view capability, but no management features:

    Report Explorer Web Part shows a list of reports that are stored on a report server.

    Report Viewer Web Part displays a report.

    These Web Parts cannot be connected to other SharePoint Web Parts.

    Data storage

    Integrated storage:

    Users publish or upload reports, models, and data sources to a SharePoint library.

    Reports, data sources, and data models in a SharePoint document library are stored as files in the SharePoint content database for that SharePoint document library. Files are stored in the .rdl, .rsds, and .smdl extensions. When a user requests to view or manage a report, data source, or data model, Reporting Services synchronizes its contents with the SharePoint content database. For more information, see Storing and Synchronizing Report Server Content With SharePoint Databases.

    Report metadata, such as schedules, subscriptions, and the cache, are stored only in the report server database.

    No storage integration:

    Report server provides sole storage for items processed on and managed by the report server.

    Security and permissions

    Integrated security:

    Authentication providers and permissions defined in the SharePoint Web application are used to control access to report server operations and content. To align and secure Reporting Services items and operations, the report server performs security mapping of SharePoint permissions to Reporting Services permissions. For more information, see Security Overview for Reporting Services in SharePoint Integrated Mode.

    Separate security:

    Report server provides security for items and operations managed by the server. Report access and content management is performed through the report server tools.

    Content creation

    Publish reports, models, and data sources directly to a SharePoint library by uploading them in SharePoint or from Report Designer or Model Designer.

    Generate models, secure models, and link reports to entities in a model from a SharePoint Web application.

    Create and edit reports using Report Builder from a SharePoint Web application.

    Create data sources by using the Report Data Source content type in the SharePoint document library.

    All report server content is created in client tools and in Report Builder that launches from Report Manager.

    All content creation and management is handled exclusively through Reporting Services client tools.

    Product and version requirements

    SQL Server 2008 or SQL Server 2005 SP2.

    You must also have Windows SharePoint Services 3.0 or Office SharePoint Server 2007.

    SQL Server 2008, all versions of SQL Server 2005, and SQL Server 2000 SP2.

    You can use Windows SharePoint Services 2.0 and SharePoint Portal Server. The Web Parts are compatible on Windows SharePoint Services 3.0 and Office SharePoint Server 2007.

    Installation and configuration

    Download and install the Reporting Services Add-in on each Web front-end in a SharePoint farm.

    Configure integration in SharePoint Central Administration and Reporting Services Configuration tool.

    Add Reporting Services virtual directories to the Windows SharePoint Services list of exclusions.

    Run a .cab file to install the Web Parts.

    Modify the Web.config file and manually copy files.

    For Windows SharePoint Services 3.0 and SharePoint Portal Server 2007, you must add the assemblies to the GAC.

    Mode requirements

    Requires a report server that runs in SharePoint integrated mode.

    Requires a native mode report server, with Report Manager enabled.


    No support for linked reports or Report Manager.

    Programmatically, there is no support for batch operations.

    Requires that you configure and maintain separate security policies in the SharePoint Web application and the report server.

    Requires separate tools for managing content and operations on each server.

    Scheduled operations, data sources, report history, data processing and subscriptions must be managed report server tools.



    You may find more infomation about SharePoint Integrated mode at the link below:


    Hopefully this helps.





    Yao Jie Tang -Microsoft Online Community
    Monday, May 24, 2010 9:53 AM
  • I think It will be same on configuration point of view.
    Pritesh Gandhi P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)
    Monday, May 24, 2010 11:20 AM