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 Dataset

You create a dataset to select a data and connection string from one of the EcoStruxure Building Operation database tables, or a stored procedure. You can also create a dataset by entering text into the Query box.

Show More

To create a dataset
  1. In MS Report Builder, in the Design view, point to New and then click Dataset .

  2. In the Name box, type a name for the dataset.

    Notice

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

  3. Click Use a dataset embedded in my report .

  4. In the Data source box, select a previously created data source.

  5. Select a Query type option.

  6. Click Query Designer .

  7. In Query Designer, in the Database view pane, expand the Tables folder or the Stored Procedures folder, then select the table containing the fields you want to use in the report.

  8. Click OK.

  9. In the Query box, check that the SQL query displays for the table that you selected.

  10. Click OK .

  11. In the Report Data pane, expand the dataset and check that the dataset fields display.

Now, set up the report using the data source and dataset.

Community Content

Product version

Language