If this is an internal tool, then 10 seconds wait is really not so bad for a report like this. I've run into the same issues before where calling external APIs

If this is an internal tool, then 10 seconds wait is really not so bad for a report like this. I've run into the same issues before where calling external APIs to get the most up to date data can take up to 30 seconds even. I would just keep it simple and allow the user to manually update the report themselves by clicking a button. I would also show the a timestamp of when it was last updated so they can see if the information is up to date or not.