You have to walk through the Crystal object model to the subreports and update the Database objects for them. I have some code at the office that does this for DBFs, but it will point you in the right direction. I'll post it later today.
>Hi craig,
>
>How then I to connect several views of a MainReport also containing a subreport containing several views ?
>( ADO connection )
>Thanks In advance craig
>
>bernhart
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer