Having Clause Builder

  To create a Having clause:

1. Enter the Having clause in the Clause field.

   For example, MAX(Product.UnitPrice)>1000 limits the products that appear in the report to products greater than $1,000.

   To add a Having clause::

   • Drag a function to the desired column in the left pane.

   • Drag a function or column into the Clause field.

   • Double-click a function or column to enter it into the Clause field.

   • Type in the Having clause.

     To delete an expression from the Clause field, click Clear.

     Available functions (see Function Examples) and operators (see Operator Examples) are displayed under Operations on the right side of the dialog box (for example, aggregate functions, string functions, arithmetic operators, and comparison operators). To view the available options for each type of operation, click the plus sign (+) next to the operation, or double-click the operation.

2. Click Validate to validate the Having clause before you insert it into the query.

   If the Having clause is valid, the question mark on the Validate button changes to a check mark. If the Having clause is not valid, the question mark changes to an "X."

   Clicking Validate is optional. SQR Production Reporting Studio automatically validates the Having clause when you click Insert. Click Validate if you wish to ensure that you entered a valid Having clause before you insert it into your query.

3. Click Insert to add the Having clause to your query.

   The Having Clause Builder remains open for additional entries. If you add an additional Having clause, click Clear to clear the input fields. If you are modifying a Having clause, Insert changes to Update.

   Note:

   SQR Production Reporting Studio enables Show Values when you click a text or numeric column in the left pane. Click Show Values to display the values contained in the selected column. You can use these values in your Having clause if desired.