Display group total and report total 1

[yog2go]

I have order and orderdetail tables. one to many relationship.

On report, Orders are grouped by first State and city. Tax for each order is defined in tax field in orders table.

Suppose customer orders five items.

OrderNo. tax Orderdetail
100 $20 Pipes
100 $20 Bolts
100 $20 Screws

Same way there are many orders for one state.

How would i display tax totals for each state and total tax for all states?

Thanks for help.

 

[lbass]

Insert a group on {Order.OrderNo}. You can suppress the group header and footer if you wish. Then insert a running total that uses a sum of {Order.tax}, evaluate on change of group (OrderNo}, reset on change of group (state). Place the running total in the group footer (state).

For the grand total, insert another running total exactly like the first except change the reset to never, and place the result in the report footer.

-LB