You deploy a new report to the Reports Server so that the report can be accessed by WebReports. To complete this procedure, you need to use SQL Server Reporting Services Report Manager.
Report Builder is a separately downloadable part of Microsoft SQL Server 2008 and SQL Server 2012, and provides the facility for you to create, modify, and deploy your own reports to the Reports Server, based on selected parts of the EcoStruxure Building Operation database.
Using Report Builder, you can use wizards to create a table, map, chart, or matrix as the basis for your report. The data content of your report is based on the selection of datasets within the EcoStruxure Building Operation data source (StruxureWareReportsDB) in SQL Server 2008 or SQL Server 2012.
You can also modify existing factory supplied reports that are provided with the WebReports installation.
When you have built and formatted a report, you can deploy it to the Reports Server. You then synchronize the report with WebReports so that the report is displayed in the Reports Tree in a web browser.
After the reports is synchronized with WebReports, you cannot rename or delete the reports. Even if you delete reports from Report Manager, the reports will still be displayed in Reports Tree of WebReports.
The Report Builder section of this reference guide provides basic report customization procedures, and every effort is made to ensure that the information provided is accurate. For more detailed information about the Report Builder third-party software, please refer to the Microsoft Report Builder Online Help.
Open a Web browser on the Reports Server.
Type the URL to the Reports Server: http://localhost/Reports_SQLExpress to open Report Manager.
If you installed SQL Server 2008 Standard, the URL is http://localhost/Reports .
In SQL Server Report Manager, click New Folder to create a folder for the new report.
In the Name box, type a name for the folder. When you deploy the report to the Reports Server, the folder appears in the WebReports Reports Tree so consider the name carefully.
Click OK .
On the Home page, select the new folder.
On the menu bar, click Upload File .
In the File to upload box, enter the new report file that you want to deploy to the Reports Server.
Click OK .
Verify that the new report is in the folder.
Now, synchronize the new report with WebReports.