I've a Report which is developed using sql query, and is taking 2 min to process when i run it from reportserver.
But when i execute the same sql query in SSMS its taking 10 to 20 sec.
What could be the possible reason for the report server to take long time to execute the same query and why it is not taking that much time in management studio?
Please suggest me how to improve the performance of report server..!
No Dream Is Too Big....!