The article on my website shows how to do this. Here's part of the code:
loCr = CREATEOBJECT("CrystalRuntime.Application")
loCrRpt = loCr.OpenReport("C:\CR\Cust.Rpt")
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....
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer