Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 SSRS 2005 and custom error message

Author  Topic 

mtlmonk
Starting Member

6 Posts

Posted - 2009-02-11 : 13:45:17
Hello,
Is there a a way to catch general errors on ssrs and display a custom error page to the user?

The goal is that if a user try to access a report when the ssrs is down, He won't see the RS general error but a custom notice from me.

Thanks.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-02-12 : 11:11:10
yup. this can be done using a custom viewer in .NET. just implement SSRS webservice using soap api and get rdl from server. then based on rdl data you may display report data or error page.

or see this

http://www.devx.com/dotnet/Article/30424
Go to Top of Page

mtlmonk
Starting Member

6 Posts

Posted - 2009-02-17 : 09:31:05
quote:
Originally posted by visakh16

yup. this can be done using a custom viewer in .NET. just implement SSRS webservice using soap api and get rdl from server. then based on rdl data you may display report data or error page.

or see this

http://www.devx.com/dotnet/Article/30424




this implies that i build a webpage that will integrate this custom viewer?

in my case, i'm calling the report server through URL with report name and parameters and the standard report server website gives a response back to my 3rd party application.

if i understand your solution, i should build another website that will receive request from the 3rd party application and from that website, call the report server website with the appropriate report name and parameters.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-02-17 : 09:34:56
yup. if you want to show custom errors, you need to do it using another webpage by implementing webservice of reporting services.
Go to Top of Page

luzer
Starting Member

1 Post

Posted - 2011-07-19 : 17:14:03
quote:
Originally posted by mtlmonk

quote:
Originally posted by visakh16

yup. this can be done using a custom viewer in .NET. just implement SSRS webservice using soap api and get rdl from server. then based on rdl data you may display report data or error page.

or see this

http://www.devx.com/dotnet/Article/30424




this implies that i build a webpage that will integrate this custom viewer?

in my case, i'm calling the report server through URL with report name and parameters and the standard report server website gives a response back to my 3rd party application.

if i understand your solution, i should build another website that will receive request from the 3rd party application and from that website, call the report server website with the appropriate report name and parameters.



hi. did you ever find a solution? i am trying to do the same thing...
Go to Top of Page
   

- Advertisement -