It has been years since I have had to use Crystal.  We are trying to put together a report that uses a large database? (in Access) that will count specific occurances of a specific item within a group so that we can create a manufacturing pull list.
I have set up a group on the cabinet number and a secondary group on the item name.  The report currently looks like this:

Group (Cabinet Number)
  Group (Item Name)           (count of item within cabinet group)

This seems to work except that the count is not correct.  I have tried resetting all of the options for the subtotal but nothing appears to work properly.  I have also tried to use a different method by inserting a summary of the item name group.  This would appear to work except that the summary just keeps repeating the last item in the cabinet.  Unfortunately the online documentation is similar to MS in that it is useless.  I want the report to look like this:

Cabinet 1
  Brown offset hinge                                                 4
  silver door pull 1/4"                                                2

Cabinet 2
  Brown offset hinge                                                  2
  silver door pull 1/4"                                                 1

Totals
  Brown offset hinge                                                  6
  silver door pull  1/4"                                                3


Any ideas on the right way to get subtotals and totals to count properly?

Are you doing a count or a distinct count and which field are you using to get your summary?

Thank you for the assistance.  After spending the weekend playing around I got the subtotals to work properly.  I had another report, provided by the software vendor, which shows totals.  I have been trying to use a modified version of that as a subreport to get the totals in place but it appears to use a different SQL query or something that causes its output to be completely incorrect.  I have some books on the way so I am hoping to get it worked out quickly.  I guess my other alternative is just to use two different reports, one for the "pull list" and one for the manufacturing report.
Thanks again