Hello everyone,
   I have an application that utilizes the Crystal Reports viewer and have everything working fine, but I have run into a very strange problem, simply my Try Catch statement when I load a report does not seem to be working??

try
{
     loadReport();
}
catch(Exception ex)
{
     //send email alerting me an error
}

The crystal report is generating an internal error: "Failed to open a record set" and it is not occuring at any line in code but in the crystal report (I assume inside the report viewer control). Is there anyway that I can capture this error so that my users aren't presented with the Compiler Error screen??

"The one language all programmers understand is profanity."

__________________
===============================================
Doug Parsons
Wrox online library: Wrox Books 24 x 7
Did someone here help you? Click on their post!
"Easy is the path to wisdom for those not blinded by themselves."
===============================================

Handling Exceptions in Code

Depending on whether you are using the Report Document object, the Windows Forms Viewer, or the Web Forms Viewer, the way you handle the exceptions will be slightly different. The two viewer controls have a predefined HandleException event that you can add code to. The Report Document object needs to have exceptions handled through a try-catch statement. If the report is passed to the viewer, and then the error occurs, then the viewer will catch the exception.
Handling Exceptions with the Viewer Controls

When handling the exception with the viewer controls, you use the viewer's HandleException event. In this event, you can typecast the event's ExceptionEventArgs.Exception parameter to an EngineException class. Once you have the EngineException class, you can check the ErrorID property to determine the type of error that occurred.

The following example demonstrates how to override the error message that is displayed if there was a problem with logging on to a database or accessing the data source. All other error messages will be left to the Crystal Report Engine to display.

private void crystalReportViewer1_HandleException(object source, CrystalDecisions.Windows.Forms.ExceptionEventArgs e)
{
   if (e.Exception is EngineException)
   {
      EngineException engEx = (EngineException)e.Exception;
      if (engEx.ErrorID == EngineExceptionErrorID.DataSourceError)
      {
         e.Handled = true;
         MessageBox.Show _
         ("An error has occurred while connecting to the database.");
      }
      else if (engEx.ErrorID == EngineExceptionErrorID.LogOnFailed)
      {
         e.Handled = true;
         MessageBox.Show _
    ("Incorrect Logon Parameters. Check your user name and password.");
      }
   }
}

Above copied from: http://msdn.microsoft.com/library/de...ortsengine.asp

- Adam Kahtava [http://adam.kahtava.com]

Adam,
   Thanks alot I searched and searched but could not find that reference, much appreciated!

--Stole this from a moderator

I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

Sometimes all it takes is a fresh set of eyes, glad I could help.

- Adam Kahtava [http://adam.kahtava.com]