Crystal Report - Multiple database connections

[Sameer]

Hello

I have a simple crystal report. Report is displayed using CrystalReportViewer control in a web form. It works fine.
There is one problem with the database connection logic. Whenever I navigate thru' report pages, it creates a new (additional) database connection. Is there any solution to avoid this?

The code is -
************************************************** ***********
Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Ini
'CODEGEN: This method call is required by the Web Form Designe
'Do not modify it using the code editor
InitializeComponent(

'Create an instance of the strongly-typed report objec
crReportDocument = New Report1(

'Create a new instance of the connectioninfo object an
'set its propertie

crConnectionInfo = New ConnectionInfo(
With crConnectionInf
.ServerName = "myServer
.DatabaseName = "orcl
.UserID = "scottr
.Password = "tiger
End Wit

'Get the tables collection from the report objec
crDatabase = crReportDocument.Databas
crTables = crDatabase.Table

'Apply the logon information to each table in the collectio
For Each crTable In crTable
crTableLogOnInfo = crTable.LogOnInf
crTableLogOnInfo.ConnectionInfo = crConnectionInf
crTable.ApplyLogOnInfo(crTableLogOnInfo
Nex

CrystalReportViewer1.ReportSource = crReportDocumen

End Su
************************************************** *************

Please hel

Thank

Sameer