Follow-On Topics

Related Topics

# About the Having Pane

The Having section has exactly the same features as the Criteria section. Columns are added in the same way and criteria selected for filtering is identical.

The difference between them is the order in which they are processed when the query is run. The Having filter is always applied after the Grouping filter.

A simple example would be where a company has offices in different locations.

1. Columns are added in the Columns area to provide order and invoice information for all offices.
2. A Criteria filter is applied to only include orders received for the current month.
3. A Grouping filter is then applied to group all rows by office location.
4. Finally the Having filter is applied to only include orders for which an invoice has been raised.

Copyright © 2018 Quadrant Software B.V. All rights reserved.