Does anyone know how to connect to Crystal XI using VB 6?

[mpodlesny]

I want to run a report created in Crystal XI developer edition through VB 6 code. Does anyone know how or can you point me in the right direction?

 

[vidru]

Add a reference to the Crystal Reports ActiveX Designer Run Time Library 11.0 (craxdrt.dll). From Project > Components, add the Crystal ActiveX Report Viewer Library 11.0 (crviewer.dll).

The minimum code to open a report, and send it to a CR ActiveX Viewer:

'General Declarations
Dim crxApp As New CRAXDRT.Application
Dim crxRpt As CRAXDRT.Report

Private Sub Form_Load()

'Open the report
Set crxRpt = crxApp.OpenReport(App.Path & "\Reports\Profile.rpt")

'Clear any saved data to force to report to read from the db
crxRpt.DiscardSavedData

'Set login information for the report here, if necessary

'View the report
CRViewer.ReportSource = crxRpt
CRViewer.ViewReport

You can download the sample RDC apps for CR 10 (which will work with CR XI) here.

-dave

 

[mpodlesny]

how do I log in?

 

[vidru]

Depends on your type of db/connectivity. This whitepaper covers most scenarios:

http://support.businessobjects.com/communityCS/TechnicalPapers/cr_rdc9_connectionproperties.pdf.asp

-dave