update report & location tables