With the way the database is normalized, this is how the data is returned to Crystal.
Kingdom|Type|Appendage|# of|
Animal|Dog|Leg|4
Animal|Dog|Arm|0
Animal|Cat|Leg|4
Animal|Cat|Arm|0
Animal|Human|Leg|2
Animal|Human|Arm|2
Animal|Caterpillar|Leg|100
Animal|Caterpillar|Arm|0
Plant|Carrot|Leg|0
Plant|Carrot|Arm|0
Plant|Lettuce|Leg|0
Plant|Lettuce|Arm|0
And I want it to end up looking like this:
===============================================
Animal
Dog
Graph of Average Legs
dog: 4
Animal: 27.5
Overall: 18.3
Graph of Average Arms
dog: 0
Animal: .66
Overall: .33
Cat
same
Human
Graph of Average Legs
Human: 2
Animal: 27.5
overall: 18.3
Graph of Average Arms
Human: 2
Animal: .66
Overall: .33
etc...
===============================================
I could easily do it if it was just a sum, but I need to use a running total to separate the arms from the legs. Is there any way to accomplish this without having to run a subreport to get the average animal/plant, and overall through each grouping?
Kingdom|Type|Appendage|# of|
Animal|Dog|Leg|4
Animal|Dog|Arm|0
Animal|Cat|Leg|4
Animal|Cat|Arm|0
Animal|Human|Leg|2
Animal|Human|Arm|2
Animal|Caterpillar|Leg|100
Animal|Caterpillar|Arm|0
Plant|Carrot|Leg|0
Plant|Carrot|Arm|0
Plant|Lettuce|Leg|0
Plant|Lettuce|Arm|0
And I want it to end up looking like this:
===============================================
Animal
Dog
Graph of Average Legs
dog: 4
Animal: 27.5
Overall: 18.3
Graph of Average Arms
dog: 0
Animal: .66
Overall: .33
Cat
same
Human
Graph of Average Legs
Human: 2
Animal: 27.5
overall: 18.3
Graph of Average Arms
Human: 2
Animal: .66
Overall: .33
etc...
===============================================
I could easily do it if it was just a sum, but I need to use a running total to separate the arms from the legs. Is there any way to accomplish this without having to run a subreport to get the average animal/plant, and overall through each grouping?