When you schedule something to run in the Reporting Services and when the report gets emailed to the requestors, by default, in the email, you'll see http://servername/reportserver/report....
So what happens that if you are on the network (which is most likely if the reporting services is used for a corporate), you may get some DNS error that "servername" machine not found.
You can change the "servername" to full qualified domain name i.e. servername.domain.com
Go to your Reporting Server machine and do the following:
- Open RSWebApplication.config (C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportManager) and change the value for key "ReportServerUrl" to "server.domain.com". Save changes.
- Open RSReportServer.config (C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer) and change the value for key "Services/UrlRoot" to "server.domain.com/reportserver". Save changes.
That's it. I personally would restart the IIS server and the SQL Server Reporting Services under Administrator Tools/Services. YMMV.
Hope this helps somebody.