Skip to Content
0
Former Member
Jun 29, 2009 at 05:06 PM

Changing the Data Source on a report

70 Views

I have been trying to get some sort of technique for changing the data source (the path to the db) for my crystal reports, and have been unable to do this.

Now, I have an app, written in VB.NET using VS 2005 Pro. The database I am using is Access. This was my first time using crystal with access and I ended up using ODBC. Ok, ok, ODBC is old and I really want to use OLEDB. I have been using the code from Vol 2 of Brian Bishof's Crystal Reports Encyclopedia, pages 352 - 356. It does work on my pc, but it does not work at all on another pc. I still get that darned Database Login dialog box. I notice that in that dialog box, the path to the database is still set to the old path on my development pc! The only way to get rid of it is to set the report's datasource once again to ODBC - YECH!

Has anyone been through this problem and solved it. What I want is to move away from ODBC and go to OLEDB and be able to dynamically set the data source to where the access *.mdb file is located for the report to work. Thank you.

Ed Cohen

Edited by: Edgar Cohen on Jun 29, 2009 7:07 PM