I have a problem here guys I cant seem to think of a way to get around.
I have a set of sample data I use for development, and it is accessed via odbc. I use an ODBC driver for a database format called Topspeed. It stores databases as files. The development data for example is placed in a folder called C:\DEVDATA.
However, when installed by a client my program (which uses the Crystal ActiveX control for CR interface), and hence data can be stored in any number of locations. The problem is that Crystal Reports is remembering the physical file system location of the database files.
In Crystal Reports designer I can get around this by using the Database -> Set Location facility to reselect my odbc table if the location the driver points to on the file system has changed. This then changes the CR properly and it uses the new data location. If i do not perform this operation, that change is not taken on board by CR automatically, and it tries to use data in the old location stored in the report file. It doesn't seem to query the ODBC driver for the location.
Is there any way using the ActiveX control, to automatically set the location of the databases (via odbc) that a report uses?
Regards,
Mark
Mark Allanson
Software Developer
PalmTEQ Limited
I have a set of sample data I use for development, and it is accessed via odbc. I use an ODBC driver for a database format called Topspeed. It stores databases as files. The development data for example is placed in a folder called C:\DEVDATA.
However, when installed by a client my program (which uses the Crystal ActiveX control for CR interface), and hence data can be stored in any number of locations. The problem is that Crystal Reports is remembering the physical file system location of the database files.
In Crystal Reports designer I can get around this by using the Database -> Set Location facility to reselect my odbc table if the location the driver points to on the file system has changed. This then changes the CR properly and it uses the new data location. If i do not perform this operation, that change is not taken on board by CR automatically, and it tries to use data in the old location stored in the report file. It doesn't seem to query the ODBC driver for the location.
Is there any way using the ActiveX control, to automatically set the location of the databases (via odbc) that a report uses?
Regards,
Mark
Mark Allanson
Software Developer
PalmTEQ Limited