Koen,

No, I'm not positive in what takes the report so long. I'm not sorting or filtering in SSRS -- that's all taken care of in the query; it's a pretty basic rows and columns report. My only clue seems to be when I watch SQL Server with profiler running SSRS seems to wrap the SELECT in an executesql. I can then copy this executesql into SSMS and that takes minutes compared to executing the statements outside the executesql which takes under 10 seconds.

Rob