Prerequisites for Tutorials (Report Builder 3.0)
The Report Builder tutorials require you to view and save reports on a report server or SharePoint site that is integrated with a report server. For data, all tutorials use literal queries that must be processed by an instance of SQL Server 2008 R2.
If you do not have access to a report server or site or to a data source, you can learn about Report Builder 3.0 by building an offline report. See Tutorial: Creating a Quick Chart Report Offline (Report Builder 3.0).
You must have the following prerequisites to complete Report Builder tutorials:
Access to Microsoft SQL Server 2008 R2 Report Builder 3.0. You can run Report Builder by using the stand-alone version of Report Builder or the ClickOnce version, available from Report Manager or a SharePoint site. Only the first step, opening Report Builder, is different for ClickOnce versions.
To use Report Manager, open Report Manager and click Report Builder. By default, the URL for Report Manager is http://<servername>/reports.
To use a SharePoint site, navigate to the site, for example, http://<servername>/sites/mySite/reports. Click the Documents tab, click New Document, and from the drop-down list, click Report Builder Report. The SharePoint administrator must enable the Report Builder report feature for each document library.
The URL to a Microsoft SQL Server 2008 R2 Reporting Services report server or a SharePoint site is integrated with a SQL Server 2008 R2 Reporting Services report server. You must have permission to save and view reports, shared data sources, shared datasets, report parts, and models. By default, the URL for a report server is http://<servername>/reportserver. By default, the URL for a SharePoint site is http://<sitename> or http://<server>/site.
The name of a Microsoft SQL Server 2008 R2 instance and credentials is sufficient for read-only access to any database. The dataset queries in the tutorials use literal data, but each query must be processed by a SQL Server 2008 R2 instance to return the metadata that is required for a report dataset. For example, the following connection string specifies only a server: data source=<servername>. You must have read-access to the default database that is assigned to you by the system administrator who grants you permission to access the server. You can also specify a database, as shown in the following connection string: data source=<servername>;initial catalog=<database>.
For the tutorial that includes a map, the report server must be configured to support Bing maps as a background. For more information, see Planning for Map Support in Reporting Services documentation in SQL Server Books Online on msdn.microsoft.com.
The tutorial Tutorial: Creating Drillthrough and Main Reports (Report Builder 3.0) uses the Microsoft Contoso BI Demo Dataset for Retail Industry. This dataset includes the ContosoDW data warehouse and the Contoso_Retail online analytical processing (OLAP) database. The reports you will create in this tutorial retrieve report data from the Contoso Sales cube. The Contoso_Retail OLAP database can be downloaded from Microsoft Download Center. You need only download the file ContosoBIdemoABF.exe. It contains the OLAP database.
The other file, ContosoBIdemoBAK.exe, is for the ContosoDW data warehouse, which is not used in this tutorial.
The Web site includes instructions for extracting and restoring the ContosoRetail.abf backup file to the Contoso_Retail OLAP database.
You must have access to an instance of Analysis Services on which to install the OLAP database.
The report server administrator must grant you the necessary permissions on the report server, configure SQL Server 2008 R2 Reporting Services folder locations, and configure Report Builder 3.0 default options. For more information, see Installing, Uninstalling, and Supporting Report Builder 3.0.
Added information about installing the Contoso OLAP database used in the tutorial about drillthrough reports.