Hi Bharat,

*NOTE* all below assumes that you would use the RDC automation controller.

Hmmm, I'm getting confused. Did you use the Crystal REports ActiveX control or the SmartViewer ActiveX control ?

The smartviewer activeX control is used along with the RDC am server. when instantiating it gives you an OLE error, which can be prevented with sys(2333,1).

>All I wanted to do at runtime was (1) change the selection criteria (2) change the RPT file.

1. Why do you need to change the selection criteria ? The most common practice is to have your queryresult filtered alread and send it to CR in FOX2.x format. In this way you seldom want to change the selection criteria at runtime.

Further you can use parameterfields to have a predefined recordselection on a variable which can be changed at runtime (see paramterfields in developer.hlp).

If for some reason you still want to change the recordfilter (Recordselection formula) you can change it (it is a property of the report object) before you actually preview the report.

2. in the RDC approach you would not need to 'change' the RPT file. You just open it with the openreport method. It returns a report object which you can attach to the smartviewer control (I just sent you the code in another message)


>If anyone has successfully run a crystal report from VFP, please post some basic code.

Just search the UT for RDC and you'll find a lot of messages regarding this subject.

Walter,