db1 report - preprocessing