Removing groups of records...
Rostislav Lyudmirsky
Can anyone help?
After grouping data, I have a DataWindow containing several
hundred of group_2 sections. Each of these group_2 section
countains several hundred of group_1 sections. Each of these
group_1 section has hundred detailed records.
What I need is to get top 20 group_2 totals.
Simple way is to sort DataWindow by group_2 subtotals
and manually delete detail rows that are not in
"top 20" group_2 sets.
The problem with this idea is that we're talking about
deleting a few thousand records. It takes a huge amount of time.
Another way is to get this set in temp DataObect and transfer
only needed rows to my DataWindow... but that also involves
a large number of records and very slow.
group_2 subtot_for_group_2
group_1
detail_1
detail_N
group_1
detail_1
detail_N
group_2 subtot_for_group_2
group_1
detail_1
detail_N
...
Anyone knows a quicker way to get this "top 20" subset?
Could you please CC your reply to my email: rlyud...@abac.com
Thank you.
--
--------------------------------------------------------------------------
Rostislav "Steve" Lyudmirsky - rlyud...@abac.com - rvl.netfirms.com
--------------------------------------------------------------------------
"The Universe... is a pretty big place. It's bigger than anything, anyone
has ever dreamed of before. So, if it's just us... it seems like an awful
waste of space." -- Ellie Arroway (Contact)