removesummaries
removesummaries
LEVEL

The removesummaries statement removes summary records from the current database.

Parameters

This statement has one parameter:

level – specifies the minimum summary level that will not be removed. In other words, if you want to remove only the first level of summary this value should be 1. This value may be between 1 (lowest summary) and 7 (highest level summary). To make sure that all summary records are removed, use 7.

Description

This example calculates summaries, prints a report, then restores the database to its original condition.

    field Date
    group by year
    group by month
    openform "Annual Report"
    print dialog
    closewindow
    removesummaries 7

See Also

- analyzedialog -- opens the standard Analyze dialog.
- average -- calculates averages and sub-averages for the selected records in the current field.
- collapse -- hides the detail records associated with the currently active summary record.
- collapsetosummary -- collapses to the next higher summary level.
- count -- counts all non-empty data cells for the current field.
- expand -- reveals the next level of collapsed detail records associated with the currently active summary record.
- expandall -- reveals all collapsed detail records associated with the currently active summary record.
- groupdown -- 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 -- 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") -- checks to see if the current record is collapsible.
- info("expandable") -- checks to see if the current record is expandable.
- maximum -- calculates the maximum and sub-maximums for the current field.
- minimum -- calculates the minimum and sub-minimums for the current field.
- removeallsummaries -- removes all summary records.
- removedetail -- removes data records from the current database, leaving only summary records. It can also delete low level summary records, leaving only higher levels.
- total -- calculates totals and subtotals for the current field.

History

Version | Status | Notes
10.0 | Updated | Carried over from Panorama 6.0, but no longer supports the dialog option.