Add Reporting Services content types to a SharePoint library

Applies to: SQL Server Reporting Services (2016) SharePoint Not supported Power BI Report Server

For content related to previous versions of SQL Server Reporting Services (SSRS), see SQL Server 2014 Reporting Services.

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

Note

Reporting Services integration with SharePoint is no longer available after SQL Server 2016.

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 are automatically 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 don't 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 (https://www.youtube.com/watch?v=yqhm3DrtT1w).

In this topic:

Enable content types in all document libraries in an existing BI 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, select the Settings icon.

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

  3. Select Site collection features.

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

    Screenshot of the Report Server Integration Feature showing the Deactivate and Activate options.

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

    Screenshot of the Report Server Integration Feature showing the Activate option.

Enable content type management for a single document library (SharePoint 2013)

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

  2. Select Library in the ribbon.

    Screenshot that is showing the Library ribbon.

  3. On the Library ribbon, select Library Settings. If you don't see Library Settings or the button is disabled, you don't have permission to configure library settings, including content types.

    Screenshot of the Library Settings button.

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

    Screenshot of the General Settings menu, highlighting Advanced settings.

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

  6. Select OK.

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, select Library.

  3. Select Library Settings.

  4. Under Content Types, select 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, select Report Builder, and then choose 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, select OK.

    Note

    If the Reporting Services 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 isn't installed. For more information, see Install or Uninstall the Reporting Services Add-in for SharePoint. The article includes information on installing the add-in and stepping through a files only installation of the add-in to work around issues.

    • The add-in is installed but the site collection feature Report Server Integration Feature isn't active. Verify the site collection feature in Site Settings.

    • All of the Reporting Services content types are in 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 are visible on the Add Content Types page.

Enable content type management for a single 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 don't see Settings, you don't have permission to add a content type.

  2. On the Library Tools ribbon, select Library.

    Screenshot that shows the Library Tools ribbon.

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

  4. Under General Settings, select Advanced settings.

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

  6. Select OK.

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, select the Library tab.

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

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

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

  6. In the Available Site Content Types list, select Report Builder, and then choose 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, select OK.

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, select General Applications settings. In the SQL Server Reporting Services (2008 and 2008 R2) section, select Reporting Services Integration.

    Screenshot of SQL Server Reporting Services.

  3. Select Activate feature in all existing site collections.

    Screenshot of the Activate the Reporting Services feature selection.

  4. Select Ok.

SharePoint site and list permission reference for report server items
Start Report Builder