I'm new to crystal reports and need help formatting a report.
My Data is shown below.

Rules are:
Records are sorted by Account
Type 1 Accounts are Headings and contain no Dollar Amounts
Type 2 Accounts are the only accounts that can have Dollar Amounts
Type 3 thru Type 9 Accounts are group totaling accounts - they will display a total of all preceding accounts of a lower type.

Is this possible to do with Crystal?  I need some guidance.

Hope someone can help.

Lee



My Data



Group A total is sum of preceding type 2 accounts
Group B total is sum of preceding type 2 accounts but not including Group A
Section Total (Account 300) is total of all preceding accounts of a lower type

Same applies to Group C and Grand Total.

Here's the Result Desired

I have no idea as to what the account numbers are.

All I know is that I need 7 total accumulators (3,4,5,6,7,8,9) all set to Zero at start of report.

As each type 2 account is reported, it's value is added to all 7 accumulators.

When a type 3 thru 9 account is detected, the account is printed along with it's corresponding accumulator and then that accumulator and all accumulators of a lower type are reset to Zero and running totals are maintained by all higher numbered accumulators till reported.

This is part of a user defined report with group totals controlled by the data itself.

Account numbers are in Database and report is sorted by account numbers.
I have no idea as to what account numbers will be except they are numeric.
The Type 1 accounts are optional and I can't rely on them being there.

I will work with your suggestions and see what I can come up with.

Thanks