Group Totals

[staceyn]

Hello,
I am using Crystal Pro version 10 with an informix database.
I can created a selling report that is grouped by vendor, season, department and then class.
In the detail we have price, cost, received units, on hand units on order units and unit margin.
There are selection parameters for season, department and vendor.
All values with the exception of the received units is working properly. However, when I try to create summaries for this field, the totals are not correct.
Following is a sample:
Vendor: C0LE
Season S05
Depart: Handbags
Class: Purse
item retail cost rec units oo units

123 50 25 10 10
456 70 35 24 15
789 80 40 48 35
Total for class 200 100 **2248 60

Vendor: Jacob
Season S05
Depart: Handbags
Class: Purse
item retail cost rec units oo units

123 50 25 30 15
456 70 35 24 24
789 80 40 48 48
Total for class 200 100 **7416 87

I have tried creating a summary through the insert summary option, I have also tried creating running totals.
Any ideas on how to get the proper totaling?

Thanks,
Stacey

 

[lbass]

How were the summaries created that gave you the above results?

If you were showing us a detail level rows, then an inserted summary would work, so your display for class must still be at the group level. Did you drag some of the detail fields into the group header?

We need to see what your data looks like at the detail level to see how the values are repeating. Then you will probably need to use running totals.

-LB

 

[staceyn]

There is a field from the table called rec units. That field is inserted into the details section. I then did the right click and inserted a summary based on the class group. ( I am having the same issues with department, vendor and season subtotals.)

If I show the detail, the item is replicated multiple times. This is why I went with hiding the detail and only showing group totals.
This is a sample of the detail data:

item price cost rec units
104183 150 66 2
104183 150 66 3
104183 150 66 3
104183 150 66 3
104183 150 66 2
104183 150 66 1
104183 150 66 0
104183 150 66 0
104183 150 66 3

 

[lbass]

There has to be another field that allows you to identify what is a legitimate new value and what is only repeated. This might be an invoice number or a date field or something like that.

In your example, there is no way of knowing whether the threes should all be counted or only one of them. Once you have identified that field, you can group or sort by it and then use a running total that counts only when that field changes.

-LB