VB6.0 and Crystal Report9

[Paul.johnab]

Hi Guys,



Can any one tell me how to call a report build in crystal Report9 from VB6.0


thnxs in Advacned,

Regards,

Paul.

[si_the_geek]

Thread moved from the FAQ forum.

[Pasvorto]

I have this in the General section

Dim crxApplication As New CRAXDRT.Application
Public Report As CRAXDRT.Report
Dim crxDatabaseTable As CRAXDRT.DatabaseTable

I use this to call the report

Set Report = crxApplication.OpenReport("Z:\DAD\JobsUnder4K.rpt", 1)
For Each crxDatabaseTable In Report.Database.Tables
    crxDatabaseTable.ConnectionProperties("user id") = "sa"
    crxDatabaseTable.ConnectionProperties("Password") = myPasswordTechniSQL
Next crxDatabaseTable
Report.PaperOrientation = crDefaultPaperOrientation
Report.PrintOut False

as an example.

[Paul.johnab]

thnxs Pasvorto for giving ur inputs..

I found the solution and the one is similar to what u have mentioned...