Adding Queries

Prev Next

Follow the steps below to add queries:

1.      Select the data source

2.      Click Add Query. The Data Source Wizard appears.

Data Source Wizard interface for creating queries or stored procedures in a database.

3.      Select the Desired Query Option radio button.

NOTE: The Query option allows the query to be built using database tables and views. The Stored Procedure option allows the query to be built only using stored procedures.

4.      Click Run Query Builder to open the Query Builder window and directly create the query using the drag and drop feature. Once you have finished building your query, click Finish.

5.      If the query still requires parameters, click Next to define the parameters.

6.      If the query does not contain parameters or you have finished adding the parameters, click Finish.