Summarized data with multiple rows

[agoldchleger]

Hi there,

I have data that looks like this:

Animal	Class	AnimalQty	ClassQty
Dog	Mammal	50	80
Cat	Mammal	30	80
Parrot	Bird	20	30
Hummingbird	Bird	10	30

So basically ClassQty is calculated in the database as a window function over the Class filed. I have the data above in the detail band of my report, and would like to have the animal class totals at the end of the report (I tried the summary band), such as:

Class	ClassQty
Mammal	80
Bird	30

However, the naive approach of just placing the fields in the Summary band does not work, as I get a single row for the animal class of the last row in the detail band:

Class	ClassQty
Bird	30

I tried to fiddle with evaluation time properties, but to no avail. I figure that I could just stick a subreport and be done with it, but I wonder if there is a cleaner solution that I might be overlooking.

[yama818]

I know this is not a smart solution, but it could be accomplished by using a wrist component for the summary band.

* Preview

* Design

 

* SQL
To use the list component, a sub-dataset is required.
The SQL for this sub-dataset should be written as follows

select class,sum(animalqty) as classqtyfrom test.t27group by class

 

[agoldchleger]

Thank you, it works and it is better than adding a subreport just for that.