Jump to content
Changes to the Jaspersoft community edition download ×

BUG: Sort order in Sub-Report Report Query


Recommended Posts

First, let me say that I first checked the Tracker and Forum, and did not see any references to the bug I found. I also tried to enter the bug into Tracker, but could not figure how to do that - so here I am.


I have a report, that contains a sub-report, which lists records returned by a Database / Report Query in the sub-report. The report should sort by: SERVICE_NAME_SEQ_NUM ascending, SERVICE_START_DT ascending.


However, to get it to sort in that order I have to set up the Report Query as follows in the sub-report:


Database/Report Query

  "Sort Options" button on bottom

    Sorting Options

      Sort by... the below two fields:

        (Down Arrow) SERVICE_NAME_SEQ_NUM

            Click on "Modify Field" button

              Sort Type


        (Up Arrow) SERVICE_START_DT

          Click on "Modify Field" button

            Sort Type




Two things I find wrong/counter-intuitive about this:


1) SERVICE_NAME_SEQ_NUM shows a 'Down Arrow' icon next to it when it is set up to sort in Ascending order.


2) SERVICE_START_DT shows a 'Up Arrow' icon next to it and it has to be set up to sort in Descending order for it to actually be sorted in Ascending order.



iReport 1.3.2 on XP Pro SP2.


Post edited by: thosp8246, at: 2007/05/01 06:14

Post edited by: thosp8246, at: 2007/05/04 04:29

Link to comment
Share on other sites

  • Replies 1
  • 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...