UNION ALL type query

[jconnelly]

Is there any way to reproduce something similar to a UNION query with RR11? ____We have a table with two date fields. The users want to see the record on the report twice if the dates don^t match. For example, if record one has an Order date of 4/28/06 and a ship date of 05/01/06 they would like the report to show the record under the April activity section AND the May activity section. Only one table but using two different fields and want the record twice in the result set.____In SQL, I can get the records I want with something like this: __SELECT ordernbr, orderdate FROM orders UNION ALL SELECT ordernbr,shipdate FROM orders____Can this be done in RR11?____Thanks,__Jill

[kfleming]

You need to create a New User SQL report where you write the SELECT statement for this type of query.____Kathleen__R&R Support

[jconnelly]

What is a New User SQL report and how do I do that? We are using RR11 Xbase against FoxPro tables.____Thanks,__Jill____

[kfleming]

A user SQL is only for the SQL version. In Xbase you would build two scan relations to the related table and manually change the alias name for the second scan.____Kathleen__R&R Support