Report losing database path

[maxxam]

Hello,

I created a report and saved it to a network directory F:\ZZZ. Another user is using the report but they frequently have to reestablish where the databses references in the report are located. The path seems to want to change to where the reports are stored (i.e. F:\zzz rather then where the data resides (i.e. M:\data\rs.dbf). Why is this happening? What am I doing wrong? I have gone to the PC in question and used the ODBC Data Source Administrator and created a "System DSN" set to the path (M:\data\rs.dbf) however it always seems to change. Any suggestions on what I'm doing worng?

MAXXAM

 

[bgul]

It sounds like the mapping maybe different on the client's side than what you set up locally. I am guessing you're using a file based application (such as MS Access) as your data source.

In my experience, I have always tried to use absolute network references instead of mapping to a drive. So, for example, setting up the network location as \\data1\data2 instead of M:\data2 so the report is portable across desktops/servers.

I believe Crystal Reports has a wizard under the Database menu (Database --> Set Location --> Convert to UNC) which lets you change from a relative reference to an absolute network path (universal naming convention).

B.

 

[maxxam]

I did what you suggested but there is no change. What is suppossed to happen when you select Convert to UNC? I clicked on the button but there is no change .. at least not one I can see. The path in the description box doen not change to \\xxx\ it remains m:\XXX. Any ideas?