Crystal Reports : How to close database connection? Plz Hlp!

[vishesh_marwah]

Hi !

I am using CrystalReportViewer to display the report using VB.NET inbuilt crystal report. The problem is every time a report is displaying, it is opening its own connection. How to close this connection once the user is through with the report.

Here is the Code:
=========================================================
Public Sub ShowReport(ByVal ReportFileName As String)
Try
Me._ReportName = ReportFileName
path = Application.StartupPath
oRpt.Load(path & ReportFileName) ' oRpt is report document
CrystalReportViewer1.ReportSource = oRpt
Catch ex As Exception
MsgBox(ex.Message)
End Try
End Sub
=========================================================

Thanks,