making DB connection with Crystal Designer

[ts04]

Hi!

Using: CR 9
Visual Basic 6
Pervasive SQL 2000i SP3 database server

I have a visual Basic application that uses Crystal reports. Do I need to connect to Pervasice in VB manualy to refresh my report data or is there a way to have the reports connect to the database. This would probably be a lot easier because it is difined in the reports where they should connect to.
If I need to connect to it manually, what steps do I need to take in order to make everything work properly.

Any help is most welcome!!

Tanja

 

[vidru]

You need to supply the connection to the Report from VB. Once it is connected, the report can get the data. How you supply the connection information depends on the type of connectivity the report is set up for (ODBC, Native...).

This document should give you a nudge in the right direction:

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

-dave