Getting SSRS to display just the specified error message when the using raiserror function
Posted on 2014-08-06
I'm using the fuction raiserror in a stored procedure to produce an error in a reporting services report when certain criteria are met. My problem is that reporting services does not just display the error text that I specify. It adds in the following text before my error message
An error occurred during local processing. An error has occurred during report processing. Query exclution failed for the dataset 'Dataset1'.
When this report is run via the client application it's even worse and I get the following;
An error has occurred during report processing. -->
Microsoft. ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. -->
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for the dataset 'Dataset1'. -->
We think the end users won't even read the proper error message that we specify because there is so much other meaningless texp before it. How do I get RS to just display my error text?