Set Position Order after average (Get order from value)

[heavensinformaticagmail.c]

Hello friends, how can I automatically define a student's position based on their average?My list is organized in alphabetical order, but I would like to be able to automatically fill in the "Position" field according to the average of each student.

This is what I wish:

 

This is what I have:

[C-Box]

You could ORDER BY your Average Column already in your sql-query and use the ROW_NUMBER() or perhaps better the RANK() Function to number these results in a separate column e.g. "Position"

In your Report you can then use the built-in JasperOrdering (sort menue/button in iReport) by the field "$F{StudentName}" again, to alphabetical order by students name.

Not tried, but worth to give it a try.

hth + regards

C-Box

[heavensinformaticagmail.c]

Thanks so much @C-Box

But I want to do it only with Jasper. In a crosstab I can do it. I can rank by expression. I want to do the same with a regular report.

If You have any advice I'l appreciate it.