Making certain rows not to display in the report

[bpamarti]

My dataset that is being passed to the report template is as under:

Id         Name            Appt TIme                 Appt Location

11        SampleName     8:00AM               Location A

11        SampleName     10:00AM             Location B

12        SomeName         7:00AM               Location A

12         SomeName       11:00AM              Location B

 

For each "Id" there can be any number of rows with different appointment times. I just want to print "One" row for each Id with earliest appointment time. So the detail band in the jasperreports should print --

 

Id         Name            Appt TIme                 Appt Location

11        SampleName     8:00AM               Location A

12        SomeName         7:00AM               Location A

 

Is there any functionality to do this in jaserreports. Any help greatly appreciated!!

 

 

Post Edited by bpamarti at 09/29/2009 20:19

[svenn]

Is the data in a database?

Is it stored in one table or mutiple tables?

[linvicch]

u can do this via sql, get the id and appttime as a subquery and join to it where the id=id and apptTime=apptTime. google "select top from group by"