Is the performance issue in the report or the query? I'm guessing if you just pull the query out and run it in SSMS you'll see the majority of the execution time going here. Then you can look at the query execution plan to tune the query.

HTH,

Rob