Crystal Report: setting database path vb.net

[jwbaker]

I am creating a program in VB.net that uses crystal reports. If i install it on another machine I want it to be able to locate the database automatically.

How do I programmatically set the database path of a Crystal Report?

Thanks

John

 

[AndrewBaines]

Easiest way is to use an OLE DB connection, then set the connection string at run time.
If you're using file based databases you'll have lots of trouble!

Andrew Baines
Chase International

http://www.chase-international.com

 

[jwbaker]

Thanks for the reply. I am using an OLE DB connection. I want to know how to programmatically make the connection.

I know I can go into the report and through vb.net and "Set Location.." of the database, how do I do this in code.

report.setlocation(databasepath)

doesn't exist.

I am fairly new to vb.net and crystal reports.

Thanks,

John