set up a denormalized report table so the web service can scale