Export (0) Print
Expand All

Installing Report Builder 2.0

SQL Server 2008

Report Builder 2.0 is a report authoring tool that you can use to create, update, and share reports. SQL Server 2008 PCU1 introduces the ClickOnce version of Report Builder 2.0. Until PCU1, Report Builder 2.0 was available only as a standalone application that you or your administrator installed directly on your local computer.

ClickOnce is a Microsoft technology for deploying Windows applications. ClickOnce enables users to install and run a Windows application such as Report Builder 2.0 by clicking a link on a web page. Users can install and run Report Builder 2.0 from Report Manager or a SharePoint site.

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.

Report Builder 1.0, available only as a ClickOnce application, continues to be installed with SQL Server 2008 and is available to use after you install the Report Builder 2.0 ClickOnce application. Report Builder 1.0 remains the default ClickOnce application after you install SQL Server 2008 2008 PCU1. An administrator needs to change the default to Report Builder 2.0 to make it the default. For more information, see How to: Set Report Builder 2.0 as the Default ClickOnce Report Builder Version.

NoteNote

Neither Report Builder 1.0 or 2.0 can be installed on Itanium 64-based computers. For Report Builder 2.0, this also applies to the stand-alone version.

Report Builder 2.0 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 try to install Report Builder 2.0, the following message displays:

"The Microsoft .NET Framework 3.5 must be installed on your computer before you can install Report Builder 2.0. Please install .NET Framework 3.5 and then install Report Builder 2.0."

You can download the .NET Framework from Microsoft Download Center.

You can install Report Builder 2.0 on any Microsoft Windows operating system that supports the .NET Framework 3.5. For example, you can install Report Builder 2.0 on Windows XP or Vista.

It is recommended that the computers that will run Report Builder 2.0 have 512 MB of RAM. However, depending on the complexity of reports you run, you might want less or more RAM.

Report Builder 2.0 requires 150 MB of disk space. However, you should allow for additional space for storing reports.

To deploy the standalone version of Report Builder 2.0, an administrator can use software such as Microsoft Systems Manager Server (SMS) to push the program to users' computers or make available the Report Builder 2.0 .msi file on a share from which users 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 the .msi file provides information about the available options. You can also use the /? option to display the command prompt options for Windows Installer Help.

To learn how to use specific software to install the application, consult the documentation for the software. For more information about SMS, go to the SMS site on www.microsoft.com.

Install From a Share

Contact your administrator for the location of ReportBuilder.msi that you run to install Report Builder 2.0 on your local computer.

To install Report Builder 2.0

  1. Browse to locate the ReportBuilder.msi, the Windows Installer Package (MSI) for Report Builder 2.0, and click it. The Microsoft SQL Server Report Builder Wizard is launched.

  2. On the Welcome to the Installation Wizard page for Report Builder 2.0, click Next.

  3. On the License Agreement page, read the agreement and then select the I accept the terms in the license agreement option. Click Next.

  4. Provide your personal name and company name. Click Next.

  5. On the Feature Selection page, optionally click Browse or Disk Cost. Click Next.

    • Click Browse to see the default location of Report Builder 2.0 and update it.

      NoteNote

      The default installation folder for Report Builder 2.0 is <drive>Program Files\Microsoft SQL Server.

    • Click Disk Cost to learn how much disk space Report Builder 2.0 consumes.

      NoteNote

      If a volume does not have sufficient amount of free disk space, the volume is highlighted.

  6. On the Default Target Server page, optionally provide the URL to the target report server if it is different from the default. Click Next.

    NoteNote

    If you plan to work with Report Builder 2.0 when it is connected to a report server, it is convenient to provide the URL to the server at this time. However, you can also do this from the Options dialog box when you are working in Report Builder 2.0.

  7. Click Install to complete the installation of Report Builder 2.0.

Install Using the Command Line

When you perform a command line installation of Report Builder 2.0, you can provide arguments to customize the installation. In addition to the standard MSI intrinsic parameters, you can use the custom parameters that Report Builder 2.0 provides. The custom parameters are name/value pairs. Two custom parameters are available: RBINSTALLDIR and REPORTSERVERURL.

If you want a completely silent installation, with no user interface interaction at all, specify the /quiet option. By design, the quite option flag suppresses installation errors. It is therefore recommended that you include the /l option, which specifies logging, when you use the quiet option.

Important noteImportant

Vista security features require elevated permissions to run command line operations and Vista will prompt for permission to run the command line and the installation is not silent. To make the installation silent you need to run the command line as an administrator.

Syntax

msiexec/i ReportBuilder.msi /option [value] [/option [value]]

Parameters

Option

Description

/?

Displays the command prompt options for Windows installer help.

NoteNote
The Report Builder 2.0 customer parameters are not included.

RBINSTALLDIR

Specifies the root installation directory for Report Builder 2.0.

For example: using RBINSTALLDIR=C:\myRB20Folder installs MSReportBulder.exe (the executable for Report Builder 2.0) in the folder: C:\myRB20Folder\Report Builder 2.0.

REPORTSERVERURL

Specifies the default report server that Report Builder 2.0 uses to save reports on the server.

For example: using REPORTSERVERURL ="http://myServer/reportserver" makes myServer the default report server.

Examples

The following examples show command lines for installing Report Builder 2.0.

Basic command line installation.

msiexec /i ReportBuilder.msi /quiet

Command line with logging enabled.

msiexec /i ReportBuilder.msi /quiet /l*v c:\junk\install.log

Command line that includes logging and a custom installation directory. This installs Report Builder 2.0 in C:\myRB20\Report Builder 2.0.

msiexec /i ReportBuilder.msi /quiet /l*v c:\junk\install.log RBINSTALLDIR="C:\myRB20

Command line that includes logging and a custom installation directory. The name of the installation directory contains spaces. This installs Report Builder 2.0 to C:\myFolder toplevel folder\sub folder\Report Builder 2.0.

msiexec /i ReportBuilder.msi /quiet /l*v install.log RBINSTALLDIR=”C:\myFolder toplevel folder\sub folder”

Command line that invokes the user interface. The installation directory path is loaded into the wizard page, on which you can modify the path.

msiexec /i ReportBuilder.msi /l*v install.log RBINSTALLDIR=”C:\mydesired toplevel folder\and some sub folder”

The ClickOnce version of Report Builder 2.0 is located on the report server, and opens on your computer when you click the Report Builder button in Report Manager or from a SharePoint site where it is installed. An administrator needs to install the application on the report server before you can access it.

For more information about opening the ClickOnce version of Report Builder, see How to: Start Report Builder 2.0 ClickOnce.

The ClickOnce version is installed to the report server and can be used with Reporting Services in native mode or SharePoint integrated mode. After the ClickOnce version is installed, users can open it from Report Manager or a SharePoint site.

By default, the ClickOnce application opens Report Builder 1.0. After you install SQL Server 2008 PCU1 or Report Builder 2.0 for SharePoint, you can specify Report Builder 2.0 as the default version instead. For more information, see How to: Set Report Builder 2.0 as the Default ClickOnce Report Builder Version

Reporting Services in Native Mode

To install the ClickOnce version of Report Builder 2.0 to Report Services in native mode, install the SQL Server 2008 PCU1. You can download SQL Server 2008 PCU1 from the SQL Server 2008 Downloads page accessible from SQL Server Troubleshooting and Support.

Reporting Services in SharePoint Integrated Mode

To install the ClickOnce version of Report Builder 2.0 to Report Services installed in SharePoint integrated mode, you need to install the add-in, SQL Server 2008 Report Builder 2.0 for SharePoint. You download and install it separately from SQL Server 2008 PCU1. Although it is recommended that you install SQL Server 2008 PCU1 as well, it is not required. You can download the add-in from the SQL Server 2008 Downloads page accessible from SQL Server Troubleshooting and Support.

You must have the SQL Server Report Services Add-in for SharePoint Technologies add-in installed in your SharePoint environment before you can install the ClickOnce version of Report Builder 2.0.

To install Report Builder 2.0

  1. Browse to locate RBClickOnce.msi, the Windows Installer Package (MSI) for the Report Builder 2.0 ClickOnce application, and click it. By default the MSI is downloaded to the C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\ISAPI\ReportBuilder folder.

  2. On the Welcome to the Installation Wizard for SQL Server 2008 Report Builder 2.0 for SharePoint page, click Next.

  3. On the License Agreement page, read the agreement and then select the I accept the terms in the license agreement option. Click Next.

  4. Provide your personal name and company name. Click Next.

  5. Click Install to complete the installation of Report Builder 2.0. The ClickOnce version of Report Builder is now available for use.

Report Builder 2.0 is available in 21 languages in addition to English. When you download the standalone version of Report Builder 2.0, select the language version that you want to install. You must repeat the download for each language version that you want to install. For the ClickOnce version, all language versions are installed on the server. The culture of the user's computer determines which language version is installed. If the culture does not match an available language, the English version is installed.

The following table has information about the available language versions.

LCID

Language

Culture

1028

Chinese (Traditional)

zh-TW

1029

Czech

cs-CZ

1030

Danish

da-DK

1031

German

de-DE

1032

Greek

el-GR

1033

English

en-US

1035

Finnish

fi-FI

1036

French

fr-FR

1038

Hungarian

hu-HU

1040

Italian

it-IT

1041

Japanese

ja-JP

1042

Korean

ko-KR

1043

Dutch

nl-NL

1044

Norwegian (Bokmal)

nb-NO

1045

Polish

pl-PLl

1046

Portuguese (Brazil)

pt-BR

1049

Russian

ru-RU

1053

Swedish

sv-SE

1055

Turkish

tr-TR

2052

Chinese (Simplified)

zh-CN

2070

Portuguese (Portugal)

pt-PT

3082

Spanish (Spain)

es-ES

Community Additions

ADD
Show:
© 2014 Microsoft