Report Builder is a stand-alone report authoring environment. With it, you can create paginated reports and publish them to Reporting Services installed in native or SharePoint integrated mode.
The first time you start Report Builder from the Reporting Services web portal or Reporting Services in SharePoint integrated mode, you're prompted to download it from the Microsoft Download Center.
You or an administrator can also install Report Builder on your computer from the Microsoft Download Center. See "Install Report Builder with Systems Manager Server" in Install Report Builder for more details.
Report Builder isn't installed when you install SQL Server Reporting Services; you need to download and install it separately.
When you start Report Builder from the web portal or SharePoint site, if an earlier version of Report Builder opens, contact your administrator, who can update the version on the web portal or SharePoint site.
To start Report Builder from the Reporting Services web portal
In your Web browser, type the URL for your report server in the address bar. By default, the URL is http://<servername>/reports.
In the top bar of the web portal, select New > Paginated Report.
The first time, you're prompted to install Report Builder.
After that first time, Report Builder opens, and you can create a paginated report or open a report from the report server.
To start Report Builder in SharePoint integrated mode
Navigate to the SharePoint site that contains the library you want.
Open the library.
On the New Document menu, click Report Builder Report.
The first time, this launches the SQL Server Report Builder Wizard. See Install Report Builder for more details.
Report Builder opens, and you can create a paginated report or open a report on the report server.
Note If the New Document menu does not list Report Builder Report, Report Builder Model, or Report Data Source, their content types need to be added to the SharePoint library. For more information, see Add Reporting Services Content Types to a SharePoint Library.
More questions? Try asking the Reporting Services forum