• Article

How to: 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.

SSRS Items in the SharePoint New Document menu

Watch a video about these procedures.

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

With SharePoint 2010 products, 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. You can enable the content types for each document library following the procedures in this topic enable for site collections per the following steps:

  • To enable the content types and content management in all document libraries in a new Business Intelligence Center site, go to the site settings and then to site collection features. Then disable and enable the Report Server Integration Feature.

  • If you want to enable the content types and content management for multiple Business Intelligence Center sites, go to General Applications settings and activate the Reporting Services feature for specific sites or all sites.

To enable content type management for a document library

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

  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. Change any other settings that you want, and then click OK.

To add report server content types

  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 Reporting Services.

  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 steps 5 and 6.

  8. When you finish selecting all of the content types that you want to add, click OK.

Change History

Updated content

Added a screen shot of what the context menu looks like when the content types are enabled. Added a link to a video that demonstrates the procedures.