Specifying Summary Levels

When you specify the parameters for a report, you may also be required to specify Summary Levels by object.

When you select a Summary Level, the data retrieved for a report can be grouped and sub-totalled based on the values of one Object Attribute (for example, Year ) or based on a combination of Object Attributes such as those shown above.

How summary levels are applied

In the underlying SQL query that is used to retrieve data for a report, a GROUP BY keyword, followed by a comma-separated list of fields is used to determine grouping.

GROUP BY <field_name> [, <field_name> ...]

For example, in the SELECT statement below, the values in the AREA field are totalled based on distinct values in the COMPANY_NAME field. This produces a total area for each company.

SELECT company_name, SUM(area) AS TOTALAREA

FROM tenements

GROUP BY company_name