Totaling Subtotals

[hjmoffitt]

I am working with CR7. I am creating a Cost of Goods Sold report that has sections and a subtotal after each section except for Direct Labor which does not have a subtotal. I need to total the subtotals plus the direct labor detail line at the end of the report but before another detail line is printed and then that detail line added to the 'grand' subtotal to create the grand total for the report. It looks something like this:

Materials Consumed 
  Lumber                          23.00
  Glue                            45.00
  Cartons                         25.00
                                  -----
     Total Materials Consumed     93.00
                                  -----

Direct Labor                      25.00
                                  -----
 
Indirect Costs
  Labor                           45.00
  Travel                          25.00
                                  ----- 
     Total Indirect Costs         70.00
                                  -----

Total Manufacturing Costs        188.00

  Net Change, WIP                (25.00)
                                  -----

Total Cost of Goods Sold         163.00
                                 ------
                                 ------

The Net Change, WIP line is a detail line with no subtotals. Any suggestions on how to calculate the Total Costs from the subtotal?

 

[kenhamady]

Financial statement layouts can be a real pain.

You can use the running total feature of Crystal (Insert Running Total) which allows you to tell any total to accumulate only records that meet certain criteria. Use the formula button on the "Evaluate" setting to tell each total which categories of records that particular total should include. Create one running total for any total that doesn't simply sum the group above it.

Then divide your Group footer into several subsection and put each of these special totals into it's own sub section. The subsections can have conditions telling them when to appear. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal