kvwarun
March 17th, 2008, 04:41 AM
hai
Is there any option to speed up the opening process of crystal report XI from VB and Oracle Stored procedure as datasource. It seems that every time report is trying to connect oracle server and this take a small time lapse in execution. Can we avoid this by defining a common connection object and use it wherever/whenever we want to open the report.
At present, i'm using the code given below
Private crApp As New CRAXDRT.Application
Private Rpt As New CRAXDRT.Report
Set Rpt = crApp.OpenReport(mvarReportName, 1)
Set ConnectionInfo = Rpt.Database.Tables(1).ConnectionProperties
ConnectionInfo.Item("Provider") = "MSDAORA.1"
ConnectionInfo.Item("Data source") = "Comapny"
ConnectionInfo.Item("User ID") = "UserID"
ConnectionInfo.Item("Password") = "Psd"
CRViewer1.ReportSource = Rpt
CRViewer1.ViewReport
dorges
Is there any option to speed up the opening process of crystal report XI from VB and Oracle Stored procedure as datasource. It seems that every time report is trying to connect oracle server and this take a small time lapse in execution. Can we avoid this by defining a common connection object and use it wherever/whenever we want to open the report.
At present, i'm using the code given below
Private crApp As New CRAXDRT.Application
Private Rpt As New CRAXDRT.Report
Set Rpt = crApp.OpenReport(mvarReportName, 1)
Set ConnectionInfo = Rpt.Database.Tables(1).ConnectionProperties
ConnectionInfo.Item("Provider") = "MSDAORA.1"
ConnectionInfo.Item("Data source") = "Comapny"
ConnectionInfo.Item("User ID") = "UserID"
ConnectionInfo.Item("Password") = "Psd"
CRViewer1.ReportSource = Rpt
CRViewer1.ViewReport
dorges