SQL Server Performance

Error Handling, how to catch before user sees them

Discussion in 'SQL Server Reporting Services' started by mikecou, Jul 19, 2006.

  1. mikecou New Member

    I would like to capture any error messages while generating a report and fail gracefully. Is there any way to do this? I am attempting to capture stored proc errors as well as invalid data passed to the report.

    An example would be if I was searching on a name of a project and that project was invalid. Instead of typing in the XXXXXX format they typed in XXX-XXX which would generate an error. How can I best catch this?

    I am working in RS 2000 right now with no plans at the moment to go to 2005.

    thanks

    mike
  2. bijesh New Member

    As far as I know, custom error handling is not possible. RS displays its own Error message as "#Error".

    Thanks,

    Bijesh

Share This Page