Hi there,
I think no need to have a temporary table......... Just take a look on this logic......... Take a temp variable say Prt end date = previous rec. end date // temp variable date While select data If prt end date + 1 == this rec. start date Prt end date == this rec. enddate Else { Print your data . (here print end date stored in variable . ) } It is just a hint .. You have to update t temp variable as required......... PRASANNA <[EMAIL PROTECTED]> wrote: > > 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 development-axapta@yahoogroups.com, "uriskh" <uriskh@> > 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.. > > >