Share via


Add Report Server Content Types to a Library (Reporting Services in SharePoint Integrated Mode)

Reporting Services provides predefined content types that are used to manage shared data source (.rsds) files, report models (.smdl), and Report Builder report definition (.rdl) files. Adding a Report Builder Report, Report Model, and Report Data Source content type to a library enables the New command so that you can create new documents of that type.

To add content types to a library, you must be a site administrator or have Full Control level of permission.

The Reporting Services content types and content type management will automatically be enabled in all document libraries for existing site collections created from the following site template types:

  • Business Intelligence Center

Sites created after the Reporting Services integration will not have the Reporting Services content types enabled.

Tip

If you have not previously configured content types for a library, first enable management of content types, then enable the Reporting Services content types. See the procedures on enabling content type management in a single document library.

Short video: (SSRS) Enabling Content Types in SharePoint2010.wmv (http://www.youtube.com/watch?v=yqhm3DrtT1w).

Enable Content Types in all document libraries in an Existing Business Intelligence Center

  1. To enable the content types and content management in all document libraries in an existing Business Intelligence Center site, you can toggle the Reporting Services integration feature.

  2. Go to Site settings.

    • In SharePoint 2013, click the Settings icon. SharePoint Settings

    • In SharePoint 2010, click Site Actions, then click Site Settings.

  3. Click Site collection features.

  4. Find the Report Server Integration Feature and click Deactivate.

    report server integration feature is active

  5. Refresh the browser then click Activate for the Report Server Integration Feature.

    reporting services feature not active

    Important

    If the Reporting Services integration feature does not appear under Site Collection Features, on the SharePoint site, confirm that the Reporting Services Central Administration Site Collection feature is active. For more information, see Activate the Report Server and Power View Integration Features in SharePoint

To enable content type management for a document library (SharePoint 2013)

  1. Open the library for which you want to enable multiple content types.

  2. Click Library in the ribbon.

    sharepoint 2013 document library ribbon

  3. On the Library ribbon, click Library Settings. If you do not see Library Settings or the button is disabled, you do not have permission to configure library settings, including content types.

    sharepoint 2013 library settings icon

  4. In the General Settings section, click Advanced settings.

    sharepoint library advanced settings

  5. In the Content Types section, select Yes to allow management of content types.

  6. Click OK.

To Add Reporting Services content types (SharePoint 2013)

  1. Open the library for which you want to add Reporting Services content types.

  2. On the ribbon, click Library.

  3. Click Library Settings.

  4. Under Content Types, click Add from existing site content types.

  5. In Select site content types from, select SQL Server Reporting Services Content Types.

  6. In the Available Site Content Types list, click Report Builder, and then click Add to move the selected content type to the Content types to add list.

  7. To add Report Model and Report Data Source content types, repeat the previous step.

  8. When you finish adding content types, click OK.

  9. Note, if the content type group SQL Server Reporting Services Content Types is not visible on the Add Content Types page, one of the following conditions is true:

    • The Reporting Services add-in for SharePoint products has not been installed. For more information, see Install or Uninstall the Reporting Services Add-in for SharePoint.

    • All of the Reporting Services content types have already been added to the library. If all the content types are part of a library, then the group is removed from the Add Content Types page. If you delete one or more of the Reporting Services content types, then the group SQL Server Reporting Services Content Types will be visible on the Add Content Types page.

To enable content type management for a document library (SharePoint 2010)

  1. Open the library for which you want to enable multiple content types. On the library menu bar, you should see the following menus: New, Upload, Actions, and Settings. If you do not see Settings, you do not have permission to add a content type.

  2. On the Library Tools ribbon, click Library.

    sharepoint 2010 library ribbon

  3. On the Settings ribbon group, click Library Settings.

  4. Under General Settings, click Advanced settings.

  5. In the Content Types section, select Yes to allow management of content types.

  6. Click OK.

To add report server content types (SharePoint 2010)

  1. Open the library for which you want to add Reporting Services content types.

  2. On the Library Tools ribbon tabs, click the Library tab.

  3. On the Settings ribbon group, click Library Settings.

  4. Under Content Types, click Add from existing site content types.

  5. In the Select Content Types section, in Select site content types from, click the arrow to select SQL Server Reporting Services Content Types.

  6. In the Available Site Content Types list, click Report Builder, and then click Add to move the selected content type to the Content types to add list.

  7. To add Report Model and Report Data Source content types, repeat the previous step.

  8. When you finish adding content types, click OK.

To Enable Content Types and Content Management for Multiple BI sites

  1. For SQL Server Reporting Services 2008 and 2008 R2 report servers, you can enable content types and content management for multiple Business Intelligence Center sites:

  2. In SharePoint Central Administration, click General Applications settings. In the SQL Server Reporting Services (2008 and 2008 R2) section, click Reporting Services Integration.

    reporting services general application settings

  3. Click Activate feature in all exciting site collections.

    reporting services integration 2008 and 2008 R2

  4. Click Ok.

See Also

Tasks

Start Report Builder (Report Builder)

Concepts

Site and List Permission Reference for Report Server Items

Other Resources

Quiz: Configuring SSRS 2012 for SharePoint Integration