Create group summary and Grand Total Summary for group records with formula field summary

See more:

CrystalReports

I created a report from a table named "Product_Order" with the following fields

secret_code
mem_name
mem_code
mem_chapter
trn_date
ar_no
or_no
pro_category
pro_sub_category
pro_code
pro_name
pro_qty
pro_cost
pro_price
total_cost
total_price
pay_mode
pay_terms
process_by
deliver_by

Now i needed to show report based on a group

NOTE: RC = REPORT COLUMN

Group 1 - Pro_Category: Has field "Pro_Category"
Group 2 - Pro_Name: Has the following fields below

RC 1 - Field: pro_sub_category
RC 2 - Field: pro_code
RC 3 - Field: pro_name
RC 4 - Formula Field: sum({product_order.pro_qty},{product_order.pro_name})
RC 5 - Field: pro_cost
RC 6 - Field: pro_price
RC 7 - Formula Field: {product_order.pro_price}-{product_order.pro_cost}
RC 8 - Formula Field: {product_order.pro_cost} * Sum ({product_order.pro_qty}, {product_order.pro_name})
RC 9 - Formula Field: {product_order.pro_price}*Sum ({product_order.pro_qty}, {product_order.pro_name})
RC 10 - Formula Field: RC9 - RC8

Task i can't do:
Summarize RC8, RC9 & RC10 based on Group 1 - Pro_Category.
Summarize ALL RC8, RC9 & RC10 - "Like a GRAND TOTAL SUMMARY"

In short i needed to summarize a summarized field.


You may see and download database file and screen shot at:
<ahref>https://dl.dropbox.com/u/65392916/SAMPLE.zip[^]

Hope this is clear enough to understand.