VB6.0 and Crystal Report9

Hi Guys,



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


thnxs in Advacned,

Regards,

Paul.

Thread moved from the FAQ forum.

I have this in the General section

Code:

---

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

---

I use this to call the report

Code:

---

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.

thnxs Pasvorto for giving ur inputs..

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