RRW80 Changing database paths

[Chareos]

Is there a simple way to replace/change database paths in RRW80?____In RR60 I used a simple C routine to read the RP1 library files searching for string A and replacing it with string B. By this method it was simple to alter the paths of all reports in a library from (for example) ^c:cresc^ to ^f: est^.____I have attempted this technique using a binary text editor on the .RRW files generate and it only works if the path name lengths are equal, otherwise the report fails to load.____I assume that a fixed number of characters have been allocated for the file name, but it is not clear from the file how much.____Does anybody have any information on how the .RRW files are defined?____Thanks. __

[kfleming]

The file structure is reasonably complex.____Why not just open and save the reports or run them through runtime and use its master/alias properties to change the data path?____Kathleen__R&R Support

[Chareos]

Assuming that RRW80 uses relative paths to all linked databases, then overriding the Master database directory in the runtime using the RI_MASTER field will work okay if all paths are to be changed in the same way.____However, if I have the following master and related databases____ f:crescdatadbmaster.dbf____ f:crescdata elativ1.dbf__ c:crescin elativ2.dbf____which I want to change to ____ g:demov4datadbmaster.dbf____ g:demov4data elativ1.dbf__ c: estin elativ2.dbf____then simply overriding the master directory isn^t going to work.____This means that I would have to use the RI_ALIAS# field for each database not affected by the master directory change. Due to the nature of my system this would mean at least 2 values for each report and sometimes more than 10. This would require an individual control file for each report.____I am shipping 40 reports to 20 sites each running at least two systems (live and training - so different paths). Each of these sites has their own set of additional reports (generally numbering between 10 and 50). The users do not all have R&R skills so I cannot ask them to modify the reports themselves. I hesitate to contemplate the workload required to convert these 1,000s of reports manually.____The system we used for RR60 requires a one-time running of an executable to convert all reports for use on each site which is infinitely preferable to the above option. I would therefore prefer a breakdown of the Report file format.____Thanks for the help so far.______

[Michael_Hoffmann_(Guest)]

Hi Chareos,____You should consider using the SUBST command. Use HELP SUBST on the command line to get some more information.____HTH____Michael.