cleanup and reformat reports.