Averages by groups? VB.Net 2005 & Crystal

I fixed my previous problem, but have since ran across this.

My report looks something like this:

Location #1
ID1 ItemsSold TotalPay
ID2 ItemsSold TotalPay
ID3 ItemsSold TotalPay
*** SummedItemsSold SummedPayForGroup
Location #2
ID1 ItemsSold TotalPay
ID2 ItemsSold TotalPay
ID3 ItemsSold TotalPay
*** SummedItemsSold SummedPayForGroup

GrandTotal *** GrandItemsSold GrandTotalPay

I am figuring the GrandTotal fine...it's the lines with the sums of ONLY the group items that I am having problems with. They reside in the Group Footer Section 1 area of the report. Any help on how to total them correctly?Is it giving a grand total for the group totals

how is the groups totals incorrect.|||The grand total is giving the sum of all items and a sum of all pay. Those are the correct numbers I am wanting to show. The footer sums are only showing the pay total for one record(the maximum pay record). I tried using a running total, but I am not sure which to use.|||I was able to set up a CR that displays

Group Header (Location)
Details (value)
Group Footer Total of (value) per location
GrandTotal

I did this for the footers the same as I did for the GrandTotal.

when I selected the sum tool button I then changed the Summary location to group #1
this created a field for the group footer to total the value per group.|||I am able to get to where you are up until the point where I pick the field to summarize. The calculations to summarize by are:

Max
Min
Count
Distinct Count
Mode
Nth Largest
Nth Smallest
Nth Most Frequent

I am wanting it to add the totals for the group, and i am not seeing that as available. What am I doing wrong?|||This is something with the type of field you are trying to sum.
I went in to my example and changed my value field to a date field or a string field and it only gave me the options that you show.

Autoresize fields

Hello,
I want to know if is possible to make a field in crystal that is autoresizing.
thank youNot sure how to do that, but here's a way to get the same effect:

Example, Displaying an address:

Put a Textbox onto your Report. Drag and drop the Name field into the textbox, click Enter to add a carriage return. Drag and drop the Address field into the textbox, click Enter to add a carriage return. Drag and drop the City field into the textbox, type a comma, Drag and drop the State field into the textbox, type a space or 2, Drag and drop the ZipCode field into the textbox. This "autosizes" the City, state, and zip code to look like it was typed normally. The result should look like the attached image.