How can I customise error messages in SSRS?

Question

I have SSRS Report being accessed from a Report Server. Is there any way I can give an error message of my own, if my report fails to open there?

Answer 1

To configure a custom error page for SSRS:

1-Browse to Report Manager folder. For SSRS 2005, its typical location is DRIVE:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting Services\ReportManager, where x is the instance; for SSRS 2008 and SSRS 2008 R2, DRIVE:\Program Files\Microsoft SQL Server\MSRS10.SSRS\Reporting Services\ReportManager. 

2-Make a copy of the existing Web.config as backup 

3-Open Web.config in a text editor, or in Visual Studio to get Intellisense support 

4-Under the <system.web>section, locate the <customerrors> section 

5-Modify the existing <customerrors>section, or insert a new one, with the appropriate settings 

6-Restart the Report Server



Below Link will help you. Let us know this help you or not.

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/87989623-068f-4c45-84e9-d151635ac1b3/

http://www.simple-talk.com/sql/t-sql-programming/sql-server-error-handling-workbench/