Liveware Publishing Support Forum

We use R&R^s royalty free runtime as the primary reporting engine for several commercial software products we publish. Our products enhance products written by other companies, so there are times when data may be coming from two different data directories. Prior to distributing to customers there is no way of knowing where these directories are (i.e. f:datasource1 and g:programdatasource2)____Question: Is there a way that we can specify two data directories at runtime? Our products are written in Visual Foxpro, and upon launch we always replace all RI_MASTER fields in our report control file with the primary data directory. It works fine unless the data is distributed in two directories. I^m fairly familiar with the runtime options, so if you can give me some ideas I^ll be happy to work them through.____Thanks!____Jeff Barefoot________

You can use the RI_ALIASn fields to specify the location of any related files/indexes.____So if your report has two related tables with aliases of TABLEA and TABLEB you could set:____RI_ALIAS1__TABLEA=D:pathAsubdirA____RI_ALIAS2__TABLEB=E:pathBsubdirB______Kathleen__R&R Support

Kathleen,____I^ve experimented with that, but we don^t know ahead of time where the data will be. For example, when I distribute our application I know that the user will have files hrPersnl.dbf and pcPosit.dbf, but I have no way of knowing where they will be. ____BUT, I can resolve the data paths at runtime. Is there a way to programatically determine the tables that are used for a given report (sometimes users add their own R&R Reports into our product, so we wouldn^t know what they^re using until they actually do it)? If we can determine the tables that are in use, I can resolve their locations and populate the ri_aliasxx fields accordingly.____I saw similar functions for a .dll implementation, but we^ve already incorporated the .exe method into our apps and would hate to have to rehash all of that.____Thanks!____Jeff