efrain_santiago Posted February 2, 2015 Share Posted February 2, 2015 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? Link to comment Share on other sites More sharing options...
djohnson53 Posted February 13, 2015 Share Posted February 13, 2015 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now