expandall

The expandall statement reveals all 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, all levels of detail will be revealed (see expand if you want to reveal only the next level detail 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
expandall

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


History

VersionStatusNotes
10.0No ChangeCarried over from Panorama 6.0.