For connecting VB6 with Crystal Report 9.

I got some samples codes like below i copied

but when i declare the variable as crystalreport1 its not coming

this line not working
"Dim Report As New CrystalReport1"
please tell me which are the things we need to work this

and please read the below sample codings and and correct it if any mistake is there

thank you for your ongoing support and help

Nishab Kottaram


sample codes :
CrystalReport.rpt
CRViewer91 is the view you design


'VB 6 form
Dim Report As New CrystalReport1

Private Sub Form_Load()
Screen.MousePointer = vbHourglass
'Report.Database.LogOnServer "P2ssql.dll", "servername", "database", "sa", "password" <---not required
Report.Database.Tables.Item(1).ConnectionPropertie s.Item("password") = "password"

CRViewer91.ReportSource = Report
CRViewer91.ViewReport
Screen.MousePointer = vbDefault

End Sub

Private Sub Form_Resize()
CRViewer91.Top = 0
CRViewer91.Left = 0
CRViewer91.Height = ScaleHeight
CRViewer91.Width = ScaleWidth

End Sub

that line... works fine... with VB 7/8/9 .NET (where you add a physical Report file to the solution and declare an instance of it and make use of it) but not with VB 6. Here you have to create global CR application object and open that report by mentioning its physical path. I guess you are mixing VB6 code and VB.net version code (which are in deifferent for this approach).

Hope this gives you some idea.

With Regards,
Raghavendra Mudugal

I am using VB6 and created Report in Seagate Crystal Report9. How i can open a crystalreport when the vb project running mode. Thru which control we can connect the VB6 and Crystal report9 report. pls tell me. i am waiting for your replay

hmmm.... I posted the code in your own thread... here is your thread link link http://p2p.wrox.com/topic.asp?TOPIC_ID=61228

With Regards,
Raghavendra Mudugal