Re: Break Logic ????

[Shivakumar Rajagopal <SRajago774@AOL.COM>]

Try the following:-

Begin-select

product                      () on-break level=1 print=never save=$product
                                    before=prod_before
product_name            () on-break level=2 print=never save=$product_name
                                    before=prod_name_before
product_plan
sum(amount)

       do print_detail

from product_table
where .........
group by product,product_name,product_plan
end-select

Please note:

In the two before procedures, make sure that you print the &product and
&product_names respectively. Print the product_plan and sum(amount) in the
print_detail procedure.

Hope it works for you.....keep me posted

shiv