Liveware Publishing Support Forum

Thanks for the tip.____I have R&R Xbase 8.1 and don^t have the User SQL menu option. Is my version capable of using SQL statements as data source?

I^m a database person, new to R&R ReportWriter. I have a SQL that brings back the rows that I need the report to show. Note that this SQL has a subquery.____SELECT A.OPNDATE, B.BANKREF, B.CLNTREF, B.AMOUNT, B.QAMOUNT, B.TYPE __FROM MASTER A, TRANSACT B __WHERE A.BANKREF = B.BANKREF __AND A.APACR...