Conditional Totals in Groups

[mike99]

I have a report where I have grouped on Invoice, order and Customer.

I have a conditional calculated field that awards point that is dependent on the order value and cannot find a way to total the points at the Customer level.
points
Inv 1 100
Inv 2 150
Order 1 250 10

Inv 3 150
Inv 4 175
Order 2 325 30
Total
Cust 1 575 ???

??? = How do I total the 10 + 30 here?

Points are 10 if order is 200 to 300 and 30 if 300 to 400
Subtotal and Running total does not seem to work nor the Conditional Sum function.

Thanks

Mike

 

[IdoMillet]

Set a variable to zero in the Group Header for CUSTOMER.

Increment the variable with the points calculated
in each Order group footer.

Display the value of the Variable in the CUSTOMER group footer.

Cheers,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[mike99]

Ido

Thanks, it worked like a charm

Mike