Click to rate and give feedback    1 2 3 4 5
How to How to 5/18/2018
Products: WebReports
Functionalities: Reports
Product version: 2.0, 2.1

Creating a Data Source

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

Show More

To create a data source
  1. In MS Report Builder, in the Design view, point to New and then select Data Source .

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


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

  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 Connection Properties dialog box, in the Server name box, enter the name of your Reports Server, using the format xxxxxx\SQLEXPRESS (where xxxxxx is the server name).

  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.

Community Content

Product version