Jump to content
Changes to the Jaspersoft community edition download ×

Sort group data in custom sort order


Recommended Posts

By: priyas - priyas

Sort group data in custom sort order

2006-07-31 05:48

Hello,

 

Is it possible to sort a group's data according to an application specific order?

 

Say I have a table column called "Priority" in the database and it stores text like "P1", "P2", "P3", etc. When I display report in table form, I want to sort these values in a preferred order like "P5", "P1", "P2" etc. This preferred order can be changed at runtime.

 

I know that this can be easily done using "field" function in "Order by" clause. I am looking out for a java solution as the number of records to process in database are more.

 

Thanks in advance for any help.

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...