Click here to Skip to main content
15,880,364 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

1 solution

Share this answer
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")
For Each crxTable In Report.Database.Tables
crxTable.SetLogOnInfo "SAGE", "SAGE", "sapest", "sapest"
Report.RecordSelectionFormula = "{RETAILQUATATION.QUATATIONNO} >= '" & Form4.cmbno.Text & "'"
CRViewer91.DisplayGroupTree = False
CRViewer91.ReportSource = Report

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