I need connection code for crystal report 11, Below code is connecting with Crystal report 9 without problem.but For CR X1 GIVING ERROR
Dim Appl As New CRAXDRT.Application
Dim Report As New CRAXDRT.Report
Dim crxTable As CRAXDRT.DatabaseTable
Dim CPProperty As CRAXDRT.ConnectionProperty
Set Report = Appl.OpenReport(App.Path & "\Report12.rpt")
Report.DiscardSavedData CRViewer91.Refresh
For Each crxTable In Report.Database.Tables
crxTable.SetLogOnInfo "SAGE", "SAGE", "sapest", "sapest"
Next
CRViewer91.Refresh
Report.RecordSelectionFormula = "{RETAILQUATATION.QUATATIONNO} >= '" & Form4.cmbno.Text & "'" CRViewer91.DisplayGroupTree = False
CRViewer91.ReportSource = Report CRViewer91.ViewReport