Installing, Uninstalling, and Supporting Report Builder 3.0
Report Builder is a report authoring tool that you use to create, update, and share reports, report parts and shared datasets. Report Builder is available in two versions: stand-alone and ClickOnce. The stand-alone version is installed on your computer by you or an administrator. The ClickOnce version is installed automatically with SQL Server 2008 R2 Reporting Services and downloaded to your computer from Report Manager or a SharePoint site integrated with Reporting Services.
The stand-alone version of Report Builder is not installed with Reporting Services. You must download and install it separately from the Microsoft Download Center.
Report Builder cannot be installed on Itanium-based computers. This applies to the ClickOnce and stand-alone versions of Report Builder.
An administrator typically installs and configures Reporting Services, grants permission to use the ClickOnce version of Report Builder, and manages folders and permissions to reports, report parts, and shared datasets saved to the report server. For more information about Reporting Services administration, see Administration (Reporting Services) in SQL Server Books Online on msdn.microsoft.com.
Report Builder is available as a stand-alone and ClickOnce versions. You or your administrator download and install the stand-alone version on your computer, whereas the ClickOnce version is installed with SQL Server 2008 R2 Reporting Services. You can download Report Builder from the Microsoft Download Center.
Report Builder cannot be installed on Itanium 64-based computers. This applies to the ClickOnce and stand-alone versions of Report Builder.
Before you install either version of Report Builder, verify system requirements and install any prerequisites.
Report Builder requires that the Microsoft .NET Framework version 3.5 is installed on the local computer. If the .NET Framework is not installed on the local computer when you install Report Builder, you will be prompted to install it before you can continue and complete the installation.
The .NET Framework 3.5 is free. You can download the .NET Framework 3.5 from the Microsoft Download Center.
You can install Report Builder on any Microsoft Windows operating system that supports the .NET Framework 3.5. For example, you can install Report Builder on Windows XP, Vista, or Windows 7.
It is recommended that the computers that will run Report Builder have 512 MB of RAM. However, depending on the complexity of reports you run, you might want less or more RAM.
Installing the Stand-alone Version of Report Builder Directly on Your Computer
You install Report Builder from the download site, Microsoft Download Center, or an administrator makes the ReportBuilder3.msi file, the Windows Installer Package for Report Builder, available on a share from which you can install it.
You can also perform a command line installation and include options such as making the installation silent and writing log files for the installation. The documentation for Windows Installer that runs .msi files provides information about the available options.
For more information, see How to: Install the Stand-Alone Version of Report Builder (Report Builder3.0).
An administrator can also use software such as Microsoft Systems Manager Server (SMS) to push the program to your computer. To learn how to use specific software to install Report Builder 3.0, consult the documentation for the software. For more information about SMS, go to the SMS site on www.microsoft.com.
Installing the ClickOnce Version of Report Builder on Your Computer
The ClickOnce version of Report Builder is installed with SQL Server 2008 R2 Reporting Services. It is installed by both native and SharePoint integrated installations of SQL Server 2008 R2 Reporting Services.
ClickOnce is a Microsoft technology for deploying Windows applications. ClickOnce enables users to install and run a Windows application such as Report Builder by clicking a link on a web page. For more information about deploying ClickOnce applications, applying ClickOnce application security, or running ClickOnce applications in the Internet zone, see the "ClickOnce Deployment for Windows Forms Applications", "Security in Windows Forms Overview", or "Trusted Application Deployment Overview" articles on the Microsoft Developer Network Web site at www.microsoft.com/msdn.
The ClickOnce version of Report Builder is located on the report server, and installs on your computer when you click the Report Builder button in Report Manager or click the Report Builder Report option on the New Document menu in a SharePoint library.
If the New Document menu does not list the Report Builder Report, Report Builder Model, and Report Data Source options, their content types need to be added to the SharePoint library. For more information, see How to: Add Report Server Content Types to a Library (Reporting Services in SharePoint Integrated Mode) in SQL Server Books Online on msdn.microsoft.com..
You can open Report Builder from Report Manager or a SharePoint library. For more information about opening Report Builder, see How to: Start Report Builder (Report Builder 3.0).
Report Builder Languages
Report Builder is available in 21 languages in addition to English. When you download the stand-alone version of Report Builder, you select the language version that you want to install. You must repeat the download for each language version that you want to use.
For the ClickOnce version, all language versions are installed on the report server when you install SQL Server 2008 R2 Reporting Services. The culture of the user's computer determines which language version is installed on the computer. If the culture does not match an available Report Builder language, the English version is installed.
The following table has information about the available language versions.
You can uninstall the stand-alone version of Report Builder from the control panel or the command line. This applies only to the stand-alone version of Report Builder. The ClickOnce of Report Builder cannot be uninstalled separately. It is always installed and uninstalled with Reporting Services.
For more information, see How to: Uninstall the Stand-Alone Version of Report Builder (Report Builder 3.0).
To support report authors, an administrator is responsible for managing folders, reports, and report related items on the report server, grant permission to resources on the report server, and configure the report server for access.
Folders, Reports, and Report Related Items
The following folders, reports, and report related items are managed on the report server:
Folders in which you store reports, shared data sources, models and so forth.
My Reports, the private folder in which you store your reports and report related items.
Shared data sources that enable report authors to use data sources that are stored externally to reports.
Shared datasets that can provide ready-to-use queried data to multiple reports for multiple users.
Report parts such as tables and charts that enable users to enhance and reuse parts of reports, created by others, in a collaborative environment.
Report models that can make it simpler and easier to get data for reports from complex data sources.
Images such as background images and logos that might be used in multiple reports and are stored externally from reports for easy maintenance.
The administrator grants permission to the report server. As a Report Builder user, you need permissions to the report server before you can access the content and functionality of the report server. For example, you might want to use report parts stored on the report server, update reports and resave them to the report server, and run reports in Report Manager. Depending on your needs and the tasks you perform, lower or higher permissions might be granted. For example, permissions with lower privileges are granted to users who need only to open shared reports in comparison to users who need to modify a shared report.
When Reporting Services is installed in native mode, an administrator can:
Enable the My Reports feature to provide you a private folder to create and save your own reports.
Use the Report Builder role on public folders to allow you to open a copy of a shared report, and then save a modified version to a private folder.
Use the Publisher role to allow you to manage reports and shared data sources in public folders. This role is granted to more experienced users.
When Reporting Services is installed in SharePoint integrated mode, an administrator can:
Use the Read permission level, granted to the Visitors group by default, to allow you to open a copy of a report in a public folder, and then save the modified version of the report to a private folder or to your computer.
Use the Contribute permission level, granted to the Members groups by default, to allow you to manage reports and shared data sources in public folders. This level of permission is granted to more experienced users.
For general information about permissions and creating and using roles, see the Reporting Services SQL Server Database Engine documentation in SQL Server Books Online on msdn.microsoft.com.
Configuration of Report Server
When you author reports in Report Builder and connect to an instance of SQL Server that is installed on Windows Vista, Windows Server 2008, or Windows 7, you might encounter an access denied error when you attempt to access the report server to open or save a report. This occurs because the security feature, User Account Control (UAC), in Windows Vista, Windows Server 2008, and Windows 7 limit the overuse of elevated permissions by removing administrator permissions when accessing applications.
However, with additional configuration the report server is available to Report Builder users. You can add Reporting Services URLs to trusted sites. By default, Internet Explorer 7.0 or later runs in Protected Mode on Windows Vista, Windows Server 2008, and Windows 7. Protected Mode is a feature that blocks browser requests from reaching high-level processes that run on the same computer. You can disable protected mode for the report server applications by adding them as Trusted Sites. You must have administrator permission to make this change.
SQL Server 2008 R2 provides the Adventure Works family of sample databases that you can use to learn report authoring and write sample reports.
The databases are available in the following versions:
Adventure Works OLTP database supports standard online transaction processing scenarios for a fictitious bicycle manufacturer (Adventure Works Cycles). Scenarios include Manufacturing, Sales, Purchasing, Product Management, Contact Management, and Human Resources.
The Adventure Works DW database demonstrates how to build a data warehouse.
The Adventure Works AS project can be used to build an AS database for business intelligence scenarios.
The Adventure Works LT database is a highly simplified and smaller sample database which is helpful for those who are new to relational database technology.
The sample databases are not included with SQL Server 2008 R2 and not installed when you install SQL Server 2008 R2 Reporting Services or the stand-alone version of Report Builder. Instead, you download sample databases from the Microsoft SQL Server 2008 R2 2008 R2 Community Projects & Products Samples Web page on CodePlex. All versions of the sample databases are downloaded together. You can also download earlier database versions that were released with SQL Server 2005 and SQL Server 2008.
For prerequisites and instructions about downloading and installing the SQL Server 2008 R2 sample databases, see Installation Prerequisites for the SQL Server 2008 Sample Databases and Installing Sample Databases on CodePlex.
This section lists procedures that show you how to install and uninstall Report Builder.