Thanks for reply. Select distinct records did not work. I tried to put in footer. It still repeat for each header but only last record of detail. Is there any other option. Unofrtunately this is a sub report, otherwise if it had been a main report, I would have used sub reports for one each for serial number and other for h/t information. crystal cannot support no more than 2 levels of sub reports