christoph.schubert Posted October 17, 2019 Share Posted October 17, 2019 Hi,we are using Jaspersoft Report with Domains as Source.So we don't have the possibility to solve following requiremend within SQL Code. (e.g. using RANK())Is there a way to rank the results for a calulated sum within Jaspersoft Studio?Source table in Domain:OwnerTicket#A111B112B113C114A115B116 So we built a report, which groups the Owners and count the number of Tickets for each Owner.(First you need to sort by Owner, otherwise the grouping is not working properly and would group the Owner B as 2 blocks.)Result as Report is now:OwnerAmount of TicketsA2B3C1 But for the Report we would like to rank the Owner with the most tickets to the top. How can this be done with standard features of JasperStudio and using Domains? I didn't find a way to get this result:OwnerAmount of TicketsB3A2C1 I just have seen older posts, which requested such a feature years ago. And it was meant, that it has been taken as enhancement request. But even in version 7.1 manual I cannot find anything about it.Any thoughts are appreciated.ThanksChris 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