You mentioned data retrieval and render time, how about processing time?
I am curious to know if any optimizations have been made towards SSRS settings.
How does the data retrieval compare when run as a report as opposed to as a query from within sql server (run the proc or script that generates your report sets)?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events