Configure Report Builder 3.0 for use in SharePoint BI test environment

Applies to: SharePoint Server 2010 Enterprise

When you are using the BI Center template, the Microsoft SQL Server Reporting Services (SSRS) content types are already available. However, as we have switched to SQL Server Reporting Services integration after the initial installation, you must manually enable the SQL Server Reporting Services content types.

Enable content type management

To enable content type management

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

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

4. In the General Settings section, 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.

Add Report Server content types

To add Report Server content types to the document library on the BI Center

1. Go the BI Center, and from the Quick Launch pane, click Documents.

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

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

4. In the Content Types section, click Add from the 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. Click OK.

See Also

Concepts

Create a baseline environment for a BI test environment
Changing SQL Reporting Services from Native mode to Integrated mode in a BI test environment