>>>Hi everyone,
>>> I am currently using R&R Report Writer for my reporting needs. However, my organization is switching to Crystal Reports 7.0. Unfortunately, I have two tables of Accounts Receivables, one for open and the other for historical records. When I needed information from both in the same report, I could use the SCANNING() function in R&R. How does Crystal Reports link two like tables together into one report? Does crystal have a similar function?
>>
>>
>>It will use SQL SELECTs
>
>Thanks for the response, Craig. But how do I do this?


My preference is to write a PRG to do this from within VFP, then save the data to a FOX2X table. Crystal will then use the Fox2X table for the report. The other option is to use ODBC and use Crystal's query tools.