I don't use command often, but what I would try is to 1) run the select from the command by itself in the DB and see how long it takes...if it is taking close to 10 minutes...even 8 minutes to run, well, there you have it. I suspect that it won't. Next I would copy the command out of the existing command object, delete it, create a new command object and paste the code in. Save it and see the report performs any better.
I can't think of any other things to do.
Perhaps someone else will have a suggestion.
Good luck