Finding Drive letters

[Radha_(Guest)]

Kathleen,____I have two offices which has the same software installed. They are using Foxpro based database.____The database is residing in one site on H: drive and in trhe other site it is I: drive____I am in the process of writing couple of reports common to each of the sites. All I have to do is to change the heading, and couple of lines specifically for each of the property.____Now I have two ways of distributing these reports. One, write two reports one for each and distribute. Two,write a common report and have the specific titles being introduced on a conditional line. The second approach will greatly reduce the confusion I have in assigning drive letters and paths as well as heading and other info.____Is there any way, I could identify the drive letter on which a particular folder is located and based on that could activate the lines?____Example: If the main database is located in H: drive, can a condition or series of conditions be introduced into R&R report, which will locate the drive letter and if it is H:,then print "This is drive H" or if it locates drive I: then print "This is drive I:"?____Would appreciate if you could guide me on this.____

[kfleming]

When a report is saved R&R remembers the drivedirectory for the data files. When it is opened it will first try to find the files in the saved location. If the files cannot be found there, then it will look in the default data directory as specified in the RRW.INI.__But it will only use the INI setting when the files are not available in the saved location.____Kathleen__R&R Support