expand
expand

The expand statement reveals the next level of collapsed detail records associated with the currently active summary record.

Parameters

No parameters.

Description

This statement reveals any collapsed detail records associated with the currently active summary record. If there is more than one level of collapsed detail, only the next level will be revealed (see expandall if you want to reveal all detail records, right down to data records).

This example goes to the last record in the database and, if it is a summary record, expands it to the next level below that summary record’s level.

    lastrecord
    expand

This example uses the collapse, expand, and expandall statements in a procedure to calculate percentages of Balance values for each data record associated with a specific summary 1 record for that group.

    local BalTotal
    field GLCategory
    groupup
    field Balance
    total
    outlinelevel 1
    firstrecord
    field Percentage
    loop
        if info("summary") =1
            BalTotal = Balance
            expand
            formulafill (Balance/BalTotal)*100
            collapse
        endif
       downrecord
    until info("eof") or info("summary") >1
    lastrecord
    fill Percentage
    fill "100"
    Percentage = zeroblank(0)
    expandall

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.
- 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.
- removesummaries -- removes summary records from the current database.
- total -- calculates totals and subtotals for the current field.

History

Version | Status | Notes
10.0 | No Change | Carried over from Panorama 6.0.