Jump to content

Ranking Results after Sum or Count Calculation


christoph.schubert

Recommended Posts

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#
A111
B112
B113
C114
A115
B116

 

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 Tickets
A2
B3
C1

 

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 Tickets
B3
A2
C1

 

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.

Thanks

Chris

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...