SAP Knowledge Base Article - Public

1853934 - Using Crystal Reports in a Visual Studio .NET web application, database connection is left open


  • Viewing a Crystal report in a Visual Studio application, the database connection will not close
  • Thousands of connections on the database servers are left open even after the application is closed


  • SAP Crystal Reports, developer version for Microsoft Visual Studio
  • Microsoft Visual Studio 2010


Store the ReportDocument object in HttpSession as given below:


using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;
public partial class _Default : System.Web.UI.Page
private ReportDocument hierarchicalGroupingReport;
private void ConfigureCrystalReports()
if(Session["hierarchicalGroupingReport"] == null)
hierarchicalGroupingReport = new ReportDocument();
hierarchicalGroupingReport.Load(Server.MapPath("Hierarchical Grouping.rpt"));
Session["hierarchicalGroupingReport"] = hierarchicalGroupingReport;
hierarchicalGroupingReport = (ReportDocument)Session["hierarchicalGroupingReport"];
crystalReportViewer.ReportSource = hierarchicalGroupingReport;
private void Page_Init(object sender, EventArgs e)


db vs cr4vs crvs closed terminated , KBA , BI-DEV-NET-SDK , .NET SDK / COM SDK , Problem


SAP Crystal Reports, developer version for Microsoft Visual Studio