Define a Query

To create a new query, right-click on the query list and select Add from the menu that is then displayed:

Note: A number of pre-defined queries are supplied with the product (refer to Create Reports with Predefined Queries). These are also listed here.

In the Name field, enter the name of the new query. In the large field beneath the Name field, enter the SQL query.

Note: Queries and parts of queries can be copied and pasted from other queries using the Ctrl+C and Ctrl+V key combinations.

Click Save to save the query. The new query is then added to the list of queries.

To view the results of a query, right-click on it in the list and select Execute from the menu that is then displayed. The results of the query are then listed in the grid beneath the list.