I still can't get it work. I run the code as mentioned:

loCrTables.Item[1].Location = "C:\Projects\Test2.DBF"

All subsequent calls, like ReadRecords or Export() create the following error message:
"File could not be found. "Test" at file location "H:\Projects\Test2.DBF"

What do I wrong?

>The article on my website shows how to do this. Here's part of the code:
>
>

>* Create the CR Object
>loCr = CREATEOBJECT("CrystalRuntime.Application")
>
>* Open the report
>loCrRpt = loCr.OpenReport("C:\CR\Cust.Rpt")
>
>* Set the data location
>loCrData = loCrRpt.Database
>loCrTables = loCrData.Tables
>loCrTables.Item(1).Location = "C:\CR\Customer.DBF"
>

>
>
>>Craig,
>>
>>Did you read my question in Thread#679970?
>>Maybe you know the answer?
>>
>>I try to do the following:
>>Select SQL into a VFP free table with a random name.
>>Run a Crystal Report, that uses this table as source: So when the CR has been created using table "MyRep.DBF", I want to change the table source into "TempRep.DBF".
>>The name of the table can change so multiple users can run the report at the same time.
>>
>>
>>>www.craigberntson.com
>>>
>>>Crystal Reports can handle more than one subreport. I've used as many as six at a time.
>>>
>>>>I've try to browse your page at www.craig........ forgot...
>>>>
>>>>but always failed....
>>>>
>>>>Could you let me know where's your homepage containing white paper (Crystal Reports)
>>>>
>>>>And Do crystal reports.... Can handle sub report more than 1... like in access...
>>>>
>>>>Cause in VFP or VB.net can't...
>>>>
>>>>thanks....