求助：WPF项目中使用ReportViewer从数据库展示报表报错

Hey there, sorry to hear you're stuck with errors when using the ReportViewer control in your WPF project to display reports from a database. Let's work through some common troubleshooting steps and fixes that usually get things back on track:

• Double-check your database connection string
  First things first: make sure your connection string is accurate. Typos in server names, database names, or authentication details are super common culprits. You can quickly test if the connection works with a simple snippet:

  using (var conn = new SqlConnection("YourActualConnectionString"))
  {
      try
      {
          conn.Open();
          MessageBox.Show("Database connection successful!");
      }
      catch (Exception ex)
      {
          MessageBox.Show($"Connection failed: {ex.Message}");
      }
  }
  

  Also, verify permissions: if using Windows Auth, ensure the user running your app has access to the database. For SQL Auth, confirm the username and password are correct.

• Validate your report data source
  Make sure the data you're feeding into the ReportViewer is actually populated. Before binding, debug or log the number of rows in your DataSet/DataTable to confirm data is being pulled from the database:

  var dataSet = new DataSet();
  using (var adapter = new SqlDataAdapter("YourReportQuery", "YourConnectionString"))
  {
      adapter.Fill(dataSet);
      Debug.WriteLine($"Fetched {dataSet.Tables[0].Rows.Count} rows from database");
  }
  

  Also, ensure the data source name in your RDLC report matches exactly what you're using in code—it's case-sensitive!

• Check ReportViewer version compatibility
  Ensure the ReportViewer packages you're using match your project's .NET Framework version. You can install the correct packages via NuGet: look for Microsoft.ReportViewer.Runtime.Common and Microsoft.ReportViewer.WinForms (yes, WinForms packages work with WPF via hosting).
  Don't forget to verify your App.config has the right configuration section for ReportViewer:

  <configSections>
      <section name="Microsoft.Reporting" type="Microsoft.Reporting.WinForms.LocalReport, Microsoft.ReportViewer.WinForms, Version=15.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />
  </configSections>
  

• Verify report parameters (if used)
  If your report uses parameters, make sure you're setting them correctly in code, and that the data types match what's defined in the RDLC. For example:

  var reportViewer = new ReportViewer();
  reportViewer.LocalReport.ReportPath = "YourReportFile.rdlc";
  
  var parameters = new List<ReportParameter>();
  parameters.Add(new ReportParameter("OrderDate", DateTime.Now.ToString("yyyy-MM-dd")));
  reportViewer.LocalReport.SetParameters(parameters);
  

• Capture detailed error messages
  The most important step is getting the actual error details, not just knowing "it broke". Wrap your ReportViewer code in a try-catch block to grab the full error, including inner exceptions:

  try
  {
      // Your code to load the report and refresh
      reportViewer.RefreshReport();
  }
  catch (Exception ex)
  {
      var fullError = $"Report load failed: {ex.Message}\nInner Error: {ex.InnerException?.Message}\nStack Trace: {ex.StackTrace}";
      MessageBox.Show(fullError);
      Debug.WriteLine(fullError);
  }
  

  This will tell you exactly what's wrong—like a bad SQL query, missing report file, or permission issue.

• Confirm report file path
  If you're using a local RDLC report, make sure the file path is correct. Also, in your project settings for the RDLC file, set "Copy to Output Directory" to "Copy if newer" or "Copy always" so the file is available when your app runs.

内容的提问来源于stack exchange，提问作者Mahmmoud Kassem