final adjustments for auto report generation