generates reports using the db