handle missing data from c.r. report