PDA

Click to See Complete Forum and Search --> : VB6.0 and Crystal Report9


Paul.johnab
Jun 2nd, 2008, 01:37 AM
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
Jun 2nd, 2008, 03:27 AM
Thread moved from the FAQ forum.

Pasvorto
Jun 2nd, 2008, 02:45 PM
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
Jun 3rd, 2008, 08:00 AM
thnxs Pasvorto for giving ur inputs..

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