Get list of grouping values. How?

[Andrew Leyba]

Hi,
I guess it is the pretty old problem, but I did not find solution so far.
I have a DW
Group header 1 --- field name, total amount
data
data
data
data
Group 1 summary total_amount
Group header 2 --- field name, total amount
data
data
Group 2 summary total_amount
...
Group header N --- field name, total amount
data
data
Group N summary total_amount

I would like to have an array some thing like this

1. total_amount from group 1
2. total_amount from group 2
3. total_amount from group 3
...
N. total_amount from group N

How to get value from group section, and how to get groups amount?

Thank you.
Andrew

[Jerry Siegel]

FindGroupChange() is your friend

"Andrew Leyba" <ale...@stellarfinancial.com> wrote in message
news:42cd66ca$1@forums-2-dub...

[Ricci Astudillo]

Hi

You need to use the function findgroupchange and then get the value of your
compute field using the return value of the findgroupchange. compute_1 is
the compute field that is in the trailer group band.

Try with a piece of code like this:

integer li_group = 1
dec ld_group_total_amount
integer li_group_number = 0

do
ld_group_total_amount = dw_1.object.compute_1[li_group]
li_group_number++
messagebox("Grupo " + string(li_group_number), ld_group_total_amount)
li_group = dw_1.findgroupchange(li_group + 1,1)
loop until li_group = 0

Ricci

"Andrew Leyba" <ale...@stellarfinancial.com> wrote in message
news:42cd66ca$1@forums-2-dub...