earth_america
user_standard Log on
action_search_stroke
earth_america
Log on to rate and give feedback 1 2 3 4 5 Log on to rate
0
How to

How to


Products: WebReports
Functionalities: Reports
Product version: 1.2, 1.3, 1.4, 1.5, 1.6, 1.7, 1.8, 1.9
6/5/2013

Creating a Data Source

You create a data source to establish the Building Operation database as the source of data for your new report.

Show More
action_close

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 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 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.

Note:

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.

To create a data source

  1. In MS Report Builder, in the Design view, point to New and then select Data Source .

     
    action_zoom_plus_stroke

  2. In the Name box, type a name for the data source.

    Note:

    The data source name cannot contain spaces, and it must begin with a letter followed by letters, numbers, or the underscore character (_).

     
    action_zoom_plus_stroke

  3. Click Use a connection embedded in my report .

  4. In the Select connection type box, select Microsoft SQL Server .

  5. Click Build .

  6. In the Server name box, enter the name of your Reports Server, using the format xxxxxx\SQLEXPRESS (where xxxxxx is the server name).

     
    action_zoom_plus_stroke

  7. Click Use Windows Authentication .

  8. In the Select or enter a database name box, select StruxureWareReportsDB .

  9. Click Test Connection to ensure you have valid settings in the database.

  10. In the Test results dialog box, click OK

  11. In the Connection Properties dialog box, click OK .

  12. In the Data Source Properties dialog box, click OK .

Now, create a dataset for the report.

See Also

  • Reports in Report Builder
  • Creating a Dataset