Hi I think you should create a temporary table to collect all the data from the main table and write the logic there in a method (which should be called from the fetch method in the report). The code u write should just create one line for all The "NOR" values. Then send the temporary table in the normal way as this.send(tempTable). Assuming tempTable is the buffer for the temporary table. This should work.. as i had done the same for another report. Please try the same and let me know if it works..
Thanks Gunjan --- In [email protected], "uriskh" <[EMAIL PROTECTED]> wrote: > > Hi, I got this history record from HR where i want to merge some > record to print in the report. please give an idea how to do this > task. thanks. > > record from history: > > Org Unit Start date End date > > BAR 8/14/2005 8/20/2005 > CAP 6/21/2003 7/5/2003 > MAS 7/6/2003 7/20/2003 > NOR 8/11/2003 8/20/2003 > NOR 8/21/2003 9/4/2003 > NOR 9/5/2003 9/19/2003 > NOR 9/20/2003 10/5/2003 > NOR 10/6/2003 10/20/2003 > NOR 11/6/2003 11/20/2003 > > this is what i want to show in the report. > > Org Unit start date end date > > BAR 8/14/2005 8/20/2005 > CAP 6/21/2003 7/5/2003 > MAS 7/6/2003 7/20/2003 > NOR 8/11/2003 10/20/2003 > NOR 11/6/2003 11/20/2003 > > i want to merge the record if the org unit is the same and the start > date of the second record is next to the end date of the previous > record, but if it has at least a day of gap it will become a new > line in the report. thanks you for your help.. >
