This page is currently incomplete, but you can find information about this topic at the links below:

• average -- The average statement calculates averages and sub-averages for the selected records in the current field.
• collapse -- The collapse statement hides the detail records associated with the currently active summary record.
• collapsetosummary -- The collapsetosummary statement collapses to the next higher summary level.
• count -- The count statement counts all non-empty data cells for the current field.
• countsummaries -- The countsummaries statement counts summary records.
• expand -- The expand statement reveals the next level of collapsed detail records associated with the currently active summary record.
• groupdown -- The groupdown statement divides the database into groups, with a summary record at the end of each group. The groups are arranged in descending order (high to low).
• groupup -- The groupup statement divides the database into groups, with a summary record at the end of each group. The groups are arranged in ascending order (low to high).
• info("collapsible") -- The info("collapsible") function checks to see if the current record is collapsible.
• info("expandable") -- The info("expandable") function checks to see if the current record is expandable.
• maximum -- The maximum statement calculates the maximum and sub-maximums for the current field.
• minimum -- The minimum statement calculates the minimum and sub-minimums for the current field.
• removeallsummaries -- The removeallsummaries statement removes all summary records.
• removedetail -- The removedetail statement removes data records from the current database, leaving only summary records. It can also delete low level summary records, leaving only higher levels.
• removesummaries -- The removesummaries statement removes summary records from the current database.
• total -- The total statement calculates totals and subtotals for the current field.

History