Click here to Skip to main content
14,878,761 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
would you please give me the sample code for connection and calling the CRX1 report Iam using vb6, backend oracle , I want to call CRX1 report,PLEASE ADVISE
Posted

1 solution

   
Comments
naveen788 6-Dec-11 3:28am
   
Thanks for the Reply,
But 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
CRViewer91.Top = 0
CRViewer91.Left = 0
CRViewer91.Height = 12336
CRViewer91.Width = 15408
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

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900