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:
..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: