Top N Domain Report

Been looking around the community and in Google and don't seem to find a proper answer to this.

How can a Top N report be created in Jaspersoft using DomEL? The data source has to be a domain for various reasons I wont get into.

The values that need to be sorted are Group Counts, however, there does not seem to be a way to reference these group counts once the report has been processed. Crystal and other BI solutions come with built in Top N features but this does not seem to be the case in Jasper.

Any ideas? 

efrain_santiago's picture
Joined: Sep 12 2014 - 5:28am
Last seen: 4 years 6 months ago

1 Answer:

Sorting by group counts is possible in Crosstab.  Limiting the number of records retrieved can be done in a derived table where you specify the SQL Query and can add a Limits clause to it.

djohnson53's picture
Joined: May 25 2012 - 11:10am
Last seen: 1 year 4 months ago