Crystal reports path 
Author Message
 Crystal reports path

I have designed a report which uses a database in directory A.

When the software installs it gets placed in program files/progname and
the database is also installed there.

When I try and run the report I get a "Can't open database message" as
it thinks the db is still in directory A.

The database is aa.mdb and the table I use for reporting is bb

I have set the datafiles option using

crystalreport1.datafiles(0) = App Path & "\aa.mdb"

but it seems to take absolutely no notice whatsoever.

Any idea what I am missing or is this a known problem.

Email responses would be appreciated.

Thanks In Advance

Tony Brown

Tony Brown
Arete Software Limited
Tel : +44 (0) 1344 867706
Fax : +44 (0) 1344 867714



Mon, 06 Aug 2001 03:00:00 GMT  
 Crystal reports path
Hi !

I faced the same problem as you but most of them gave me the same solution
as you mentioned, which seem like doesn't work !!!
Some of them told me to set the database location 'same as report' at
database property but my 'same as report' button always disabled ! How about
yours ?
Please let me know if you manage to find the solution. Thanks in advance.

Quote:

>I have designed a report which uses a database in directory A.

>When the software installs it gets placed in program files/progname and
>the database is also installed there.

>When I try and run the report I get a "Can't open database message" as
>it thinks the db is still in directory A.

>The database is aa.mdb and the table I use for reporting is bb

>I have set the datafiles option using

>crystalreport1.datafiles(0) = App Path & "\aa.mdb"

>but it seems to take absolutely no notice whatsoever.

>Any idea what I am missing or is this a known problem.

>Email responses would be appreciated.

>Thanks In Advance

>Tony Brown

>Tony Brown
>Arete Software Limited
>Tel : +44 (0) 1344 867706
>Fax : +44 (0) 1344 867714




Thu, 09 Aug 2001 03:00:00 GMT  
 Crystal reports path
Yes I've tried same as report but that ignores anything else set also.

Any other ideas anyone ??



Quote:
>Hi !

>I faced the same problem as you but most of them gave me the same solution
>as you mentioned, which seem like doesn't work !!!
>Some of them told me to set the database location 'same as report' at
>database property but my 'same as report' button always disabled ! How about
>yours ?
>Please let me know if you manage to find the solution. Thanks in advance.


>>I have designed a report which uses a database in directory A.

>>When the software installs it gets placed in program files/progname and
>>the database is also installed there.

>>When I try and run the report I get a "Can't open database message" as
>>it thinks the db is still in directory A.

>>The database is aa.mdb and the table I use for reporting is bb

>>I have set the datafiles option using

>>crystalreport1.datafiles(0) = App Path & "\aa.mdb"

>>but it seems to take absolutely no notice whatsoever.

>>Any idea what I am missing or is this a known problem.

>>Email responses would be appreciated.

>>Thanks In Advance

>>Tony Brown

>>Tony Brown
>>Arete Software Limited
>>Tel : +44 (0) 1344 867706
>>Fax : +44 (0) 1344 867714


Tony Brown
Arete Software Limited
Tel : +44 (0) 1344 867706
Fax : +44 (0) 1344 867714



Sat, 11 Aug 2001 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Crystal Report Path

2. Crystal report path

3. Crystal Reports - relative path in report file name

4. Can you define report path for crystal reports?

5. Printing Crystal Reports without Crystal Control ActiveX or Crystal Reports API call

6. Crystal Reports and Path to DB

7. Crystal Report: DB Path manipulation in VB code

8. changing .mdb path in crystal report using vb 4.0

9. Image Path's & Crystal Reports

10. Set the Data Link File path in crystal report by Visual Basic coding

11. .mdb file path in crystal report

12. changing .mdb path in crystal report using vb 4.0

 

 
Powered by phpBB® Forum Software