Consolidated report preparation case analysis