Creating a report using Report Builder

If you need a traditional tabular report in SharePoint, then build it using Reporting Services. This recipe demonstrates how to create a simple report using the Report Builder 3.0 application.

Getting ready

This recipe works for:

• SharePoint 2010 Foundation

• SharePoint 2010 Standard Edition

• SharePoint 2010 Enterprise Edition

You will need an instance of SQL Reporting Services that has been configured and integrated with your SharePoint environment.

This recipe uses a SharePoint site created from the Business Intelligence Centre template (only available with SharePoint 2010 Enterprise) for illustration as all the required business intelligence features are automatically enabled on this site. However, any type of SharePoint site can be used, but the required features will need to be enabled manually.

You will need a document library with the Report Builder Report and Report Builder Data Source Reporting Services content types enabled on it.

Report Builder allows...