get latest report by sorting by id