Click on the desired tab when appears for information about that program tab.

Main Column Definition Query Sort Print

The Query tab of the Report Writer window and Forms Writer window is used to specify selection criteria that are used to determine whether or not the client or record will be included on the report. Up to 40 queries can be defined for each definition. For example, you can state that you only want clients with a primary timekeeper of 1 included on the report. Or, you can state that you only want to include clients with a balance due that is greater than $200.00. Or you can state that you only want clients included that have work-in-process less than $500.00. Or, you can stipulate that you only want clients included that meet all of the aforementioned criteria.

Note: This tab is optional. If you want all clients selected, then simply skip this tab.

Note: You also have the ability to change or add queries at the time you print the report. The changes made at that time are temporary and are not saved to the report definition file.

Field/Column

And/Or

Test Condition

Test Value

As each query is added, it is shown in the display of queries in the lower portion of the window. Each line in the display of queries represents a single query. To modify an existing query, simply highlight the desired query and the associated fields with that query will be displayed in the upper portion of the window.

The New Query button can be used to define a new query. You can also click on the (New Query) row in the query display to add a new query. To insert a query between existing queries, add a new query and then use the Move Up button to move the query to the desired position.

The Delete button can be used to delete the highlighted query. Any subsequent queries will be moved up one position.

The Move Up button or Ctrl+Up can be used to move the highlighted query up one row.

The Move Down button or Ctrl+Down can be used to move the highlighted column down one row.