Liveware Publishing Support Forum

Hi!__I am using R&R 8.1027 XBase edition. I create a file, like this:____RI_REPORT=c:oscarlrretail.rrw__RI_WTITLE=Location Recap - Retail Only__RI_MASTER=c:oscar10.ACC11.STOMainFile.dbf__RI_MINDEX=c:oscar10.ACC11.STOMainFile.CDX,,MainFil1__RI_PRINTER=D__RI_QUERY=O__RI_COPIES=1__Arb=c:oscar10.ACC11.STOARB.DBF,c:oscar10.ACC11.STOARB.CDX,ARB1__Lob=c:oscar10.ACC11.STOLOB.DBF,c:oscar10.ACC11.STOLOB.CDX,LOB1__InvDate=07/09/2001__Client=10-11 ____Originally used DBFs don^t exist. I always get this error:__[RRW Runtime output]__RO_ECODE=R__RO_EMSG=Cannot open database table (table may be in use): Lob.dbf__RO_REPORTS=0__RO_PAGES=0__RO_RIRECNO=1____I checked (many times), files are on that positions. If I design report with databases, everything is OK. __In resume, if files are there where was on design time, everything is OK. If not, report not work. Please, what is wrong?__Regards,__Sandi__

Change the lines:__Arb=c:oscar10.ACC11.STOARB.DBF,c:oscar10.ACC11.STOARB.CDX,ARB1__Lob=c:oscar10.ACC11.STOLOB.DBF,c:oscar10.ACC11.STOLOB.CDX,LOB1____to read____RI_ALIAS1=Arb=c:oscar10.ACC11.STOARB.DBF,c:oscar10.ACC11.STOARB.CDX,ARB1__RI_ALIAS2=Lob=c:oscar10.ACC11.STOLOB.DBF,c:oscar10.ACC11.STOLOB.CDX,LOB1______You need to use these RI_ALIASn fields to specify the namelocation of the related tables. Right now it is erroring because it is trying to use the related files as saved in the report.____Kathleen__R&R Support

Thanks, Kathleen. It is solved!____Regards,__Sandi