SQL subquery and R&R

[Ramon_(Guest)]

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.APACRO = "44986" __AND (B.AMOUNT > 0 OR B.QAMOUNT > 0) __AND B.BANKREF NOT IN (SELECT BANKREF FROM TRANSACT WHERE TYPE = 9) ORDER BY B.BANKREF____I simply want to give this SQL to R&R and tell it where to place the fields listed in the SELECT clause on the report. Can somebody walk me through how I would do this? I know the part where I can place the fields on the report. I just don^t know how to give it an already built SQL.____Also, will R&R give problems due to the subquery?____Thanks in advance__Ramon

[kfleming]

You need to use the menu Choice File->New User SQL. After you select the data source, R&R will give you an entry box for you to enter the SELECT statement.____Kathleen__R&R Support

[Ramon_(Guest)]

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?

[kfleming]

No. The Xbase version does not use SQL.____Kathleen__R&R Support