Liveware Publishing Support Forum

I^m using R&R SQL v 12. I have created a report in this folder: g:myreports. The data is in g:it6it6.mdb. The report runs fine when I manually launch the viewer and run the report. I^m trying to use a batch file and control file to launch it. Here^s the batch file:__C:Progra~1RRinfi~1 swrun.exe /TTG:myreports swrunin.rss____Here^s the control file: (rswrunin.rss)__RI_REPORT=G:myreportsEMPLOYEE DETAIL.RSW__RI_PRINTER=D__RI_WTITLE=EMPLOYEE DETAIL__RI_WTOP=100__RI_WLEFT=100__RI_WHEIGHT=400__RI_WWIDTH=560__RI_WBORDER=2__RI_WMAX=T__RI_WMIN=T__RI_WCTRL=T__RI_WPARENT=__RI_DISPERR=T__RI_STATUS=T__RI_CHKTIME=__RI_MASTER=EMP__RI_MEMO=__RI_OUTFILE=__RI_NOESC=__RI_WPTR=__RI_WPORT=__RI_BEGPAGE=__RI_ENDPAGE=__RI_TEST=__RI_COPIES=__RI_INCLUDE=__RI_FILTER=__RI_REPLACE=__RI_WHERE=__RI_DSOURCE=__RI_DB=g:it6it6.mdb__RI_EXPDST=__RI_ALIAS1=__RI_ALIAS2=__RI_ALIAS3=__RI_ALIAS4=__RI_ALIAS5=__RI_ALIAS6=__RI_ALIAS7=__RI_ALIAS8=__RI_ALIAS9=__RI_SORT1=__RI_SORT2=__RI_SORT3=__RI_SORT4=__RI_SORT5=__RI_SORT6=__RI_SORT7=__RI_SORT8=__RI_GROUP1=__RI_GROUP2=__RI_GROUP3=__RI_GROUP4=__RI_GROUP5=__RI_GROUP6=__RI_GROUP7=__RI_GROUP8=__RI_REPPICK=____When I launch the bat file, the viewer appears in my task bar and I get this error: Library error(cannot open file) reading report G:myreportsEMPLOYEE DETAIL.RSW. The rswrun.out file is: [RSW Runtime output]__RO_ECODE=R__RO_EMSG=Library error (cannot open file) reading report G:myreportsEMPLOYEE DETAIL.RSW__RO_REPORTS=0__RO_PAGES=0__RO_RIRECNO=____Can somebody tell me what^s wrong here? I^m new to the SQL version, but have used other older R&R versions for years.

First make sure that the path/report name in RI_REPORT is really correct.__You should also pass the name the of the MDB as part of the RI_DSOURCE rather than using RI_DB.____You specify the name of the datasource followed by three vertical bars followed by DBQ= then the MDB name.____So if your data source was called TEST you would use:____RI_DSOURCE=TEST|||DBQ=g:it6it6.mdb ______Kathleen__R&R Support__