Click to See Complete Forum and Search --> : How to make the connection/db location to report dynamic - CR9


CrystalBabysteps
August 2nd, 2007, 09:05 AM
Hi folks,
..Project\application\Database\mydb.mdb
..Project\application\Reports\myreport.rpt
the above is the structure how my db and rpt is organised in relation to the application developed in VB.
In the evening I copy the whole proj on to a CD.
Everyday when I sit to design/modify a report, I do it on a system whichever is available, so I simply copy the whole proj in to the available system. The problem is everytime I change the system, and open the report in CR9 I need to again set the connection/db settings (the one which asks for location of db etc) for every report created/modified earlier in another system. I was wondering, since the relative structure between the db and report is remaining same, is it possible to make the connection/db location dynamic. This would save me a lot of trouble.
Does anyone know how this can be done.
db: Access 2003
Report: CR9

Thankyou.
:thumb:

jggtz
August 2nd, 2007, 12:46 PM
Sure you can do it, but it depends on how you manage crystal reports from vb
OCX, RDC, API ?

CrystalBabysteps
August 3rd, 2007, 03:05 AM
Thank you for the response jggtz,

my problem is not in accessing the report from VB, but opening my report from cr9 itself The problem is everytime I change the system, and open the report in CR9 I need to again set the connection/db settings (the one which asks for location of db etc) for every report created/modified earlier in another system :thumb: