Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Scripts          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

Installing Report Builder 3.0



By:

Overview

Report Builder 3.0 is a click-once application which allows you to run it without actually installing it.  When you install SQL Server Reporting Services (SSRS) 2008 R2, you must configure Reporting Services to run in native mode or SharePoint Integrated mode.  You can launch Report Builder from the Report Manager web application (when SSRS is running in native mode) or a SharePoint document library(when SSRS is running in SharePoint Integrated mode).

In order to eliminate the dependency on Report Manager or SharePoint, this topic reviews the Report Builder 3.0 installation steps.  The tutorial assumes that you have Report Builder 3.0 installed on your computer.

Explanation

Report Builder 3.0 is available for download on the Microsoft SQL Server 2008 R2 Feature Pack site.  Report Builder 3.0 requires the Microsoft .NET Framework 3.5 SP1, which is also available for download at the same location.  To install  Report Builder 3.0 download the ReportBuilder3.msi file and run it.  When you start the Report Builder 3.0 installation, you will see the following message if you do not have the .NET Framework 3.5 SP1 installed:

If the above message appears, download the .NET Framework 3.5 SP1, install it, then run the Report Builder 3.0 installation again.

The Report Builder 3.0 installation follows the familiar wizard approach where you step through a number of dialogs in order to perform the installation.  You will go through the following steps:

The Welcome page is displayed:

Accept the License Agreement:

Enter your name and your company name:

Select the features to install; Report Builder 3.0 only has a single feature: 

If you click the Disk cost button you will see that Report Builder 3.0 requires 142MB of space.

Enter the target server URL:

The target server URL is used to deploy the reports you design with Report Builder 3.0.  Normally you will need to get the target server URL from your information systems department.  If you do not know the target server URL at this point, you can leave it blank and enter it later in Report Builder 3.0 after the installation is complete.

The final dialog is displayed; click Install to perform the installation:

Additional Information


Last Update: 6/23/2011




More SQL Server Solutions











Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 


Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



    



Monday, May 21, 2018 - 2:01:11 PM - Raymond Barley Back To Top

The error message saying that you need the .NET Framework 3.5 SP1 installed in order to install Report Builder 3.0 is because this tip was written in the SQL Server 2008 time frame.


Wednesday, May 09, 2018 - 12:35:46 PM - James Back To Top

 Is this documentation old? The microsoft docs say it needs .NET 4.0 but this says 3.5 SP1

 


Learn more about SQL Server tools