I think you actually need to generate an additional find for each subset report. This can be done quickly though with a quick jump to a new window or layout to print.
Maybe someone does know a way though.
SO is there any way to work within the subsets defined by sub summary parts iteratively or will I have to do some version of a specific find for each subset of Color that could exist from the original full found set as defined by the users selections.
There's the Fast Summary method.
• create a summary field that counts a non-empty field (e.g. the primary key)
• use GetSummary ( thatSummaryField; sortField ) to read the size of a sub-group
In your case, try this variant:
• create a summary field that counts the primary key (sCountAll)
• create a summary field that lists the primary key (sListID)
• create a global text field (gIDs) and …
• a self-join relationship by globalField = primaryKey
Use a script like
Sort Records [ by Color ]
Go to Record [ first ]
Set Field [ Table::gIDs ; GetSummary ( Table::sListID ; Table::Color ) ]
Go to Related Record [ Table_selfjoin ; matching only ; new window ]
# [ act on the isolated sub-group ]
Set Variable [ $size ; GetSummary ( Table::sCountAll ; Table::Color ) ]
Set Variable [ $nextStopAt ; Get ( RecordNumber ) + $size ]
If [ $nextStopAt > Get ( FoundCount ) ]
Go to Record [ $nextStopAt ]
Ok that looks awesome.
I can't wait to try it out.
Thanks a heap,