>>>>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.

Good idea. But the history file has 500,000 records in it and there are users in the app all throughout the day.