Add a Dataset

The next step is adding a data set, which will contain a SQL query that will retrieve the report data from the database.

To create a dataset:

1. In the Report Builder, right-click the Datasets folder in the left pane and then click Add Dataset.

2. In the Dataset Properties dialog, type a data set name and then select the Use a dataset embedded in my report option.

3. In the Data source field, select the data source that you created earlier.

4. In the Query type section, select Text to use an embedded SQL as your query and enter the sample query as shown on the screenshot above.

5. To test the query, click the Query Designer button. In the dialog that opens, click the exclamation sign icon (at the top) to run it. If the query is valid, you will see the result set.

6. Close the Query Designer dialog and then click OK to save the dataset.

Note: When you are ready to create queries for your own custom reports, please refer to RAS Reporting Database Schema.