add transaction for report generation