agoldchleger
-
Posts
2 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Downloads
Posts posted by 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.
Summarized data with multiple rows
in Products
Posted
Thank you, it works and it is better than adding a subreport just for that.