• Have you tried using Profiler to see if the query is really taking that long as opposed to the SSRS web service? If the problem is actually with the rendering (SSRS), you may want to see what is going on with the memory on the machine.