Jump to content
Changes to the Jaspersoft community edition download ×

How To Get Row Header Value From Corresponding Colmn Value In Crosstab


nar.atul

Recommended Posts

I am using jasper report along with netbeans and itext plugin for creating some reports for my java web project.

My Crosstab looks like following diagram

 

        Param1  |    Param2   |   Param3  |---------------------------------------------1:06:15|   10    |     10      |     15    |------------------------------------------------2:03:29|   20    |     25      |     05    |-----------------------------------------------3:15:30|   50    |     17     |     18    |-------------------------------------------------4:45:1 |   10    |     25      |     65    |-------------------------------------------------MAX    |   50    |     25      |     65    |

So i am calculating max and min for every column using measure But i also have to get the time for the corresponding max and min value

for eg. i need to show param1 is max(50) at 3:15:30

Please advice me solution how can i get row value(3:15:30) from this corresponding max value(50) also note that in second column there are two same value(25) for max criteria so i want to fetch latest time(4:45:1) only with max value.

thanks in advance.

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