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