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,

[shakti5385]

I do not know what method you are using, Just Read CR In VB.NET at My signature

[vishesh_marwah]

hi,

I have changed my original post and provided the code also. please see and reply.

Thanks,

[shakti5385]

Put This Line at the above your code.

Dim oRpt As CrystalDecisions.CrystalReports.Engine.ReportDocument = New CrystalDecisions.CrystalReports.Engine.ReportDocument

[vishesh_marwah]

but i want to close the connection. After user has seen the report. How do i close the database connection.

[shakti5385]

Can you tell me in your code where you are opening the connection,