Hey thanks Mauricio.... yea i got all my SP tuned and indexes in line... its just reporting services is so sloww in executing and delivering and then to render the report...

Hey Mauricio ... thats a cool name, its mine as well but everyone calls me Moe... man there is no way to speed up RS... what troubles have you ran...

yup i have found that out too... where are the pro's when we need them..

I tried the solution above and sorry it does not come up with it correctly... so in my SP i have 2 dates i do a datediff on ... i...

thanks... i will use this and see what happens...

how many people do you have running reports at one time... i did have these report running on the same server and it was bringing the server down to its...

We are looking into the bottlenecks... I have written my queries and index the db to the T... we are still looking into why it is slowwwwww... i got a post...

thats what i am saying... i got people from all across the US hitting these reports and i mean big business and reports are timing out and such ... is...

what is your set up like in production?? are you having performance issues as well..??? im trying to pick as many brains as possible about how incredibly slow reporting services...

are you saying that say for instance Norton anti virus would somehow grab a hold of it and cause the server to slow down??? has anyone else ran into this???

SQL Reporting Services 2005 only supports Multi Parameter querys ....

and when you log into the report manager are you still seeing those TEST reports in there as well???

The SMTP service can be modified on the RSReportServer.config file under the ReportServer folder.... if they are using an external SMTP it should be still find... as long the IP...

A.) Go to the folder where the reports are stored and delete those reports manually

B.) In the project make sure those test RDL file are COMPLETLY REMOVED from the project...