Thanks Walter,

I have implemented the automation server approach. I have another question for you . . when I execute the oReport.Preveiw
command the report just flashes on the screen. Do you know how I can make it stay on the screen and then allow the user to print
the report from the preview? I'm using Crystal 7.

Thanks Again for your help.

James Colson


>James,
>
>I have very briefly with the ActiveX control and moved to the automation approach soon after. The automation server provides you more control and flexibility and is certainly not more difficult than the activeX control. A few day's back i've given an example to pass paramters from VFP to Crystal Reports. See the thread #324615 "Crystal Reports" at 01/29/2000.
>
>As for get it to work with the automation control, be sure you pass the right value to the right parameter. The zero parameter in your example refers to the first parameterfield you've created within the report regardless of the name (you did create the parameterfields up there, didn't you ?). Further on you might chack if the parametertypes match (integer, logical, dat, string, etc).
>
>>ThisForm.olePrint1.ParameterFields(0) = "paramater1;&userid;TRUE"
>
>I've noticed that you use &userid. It looks like if you're trying to pass a numeric value by using marco substitution: CR might interpretate this as a string. You might want to try:
>
>>ThisForm.olePrint1.ParameterFields(0) = "paramater1;"+STR(userid)+";TRUE"
>
>another hint might be the typo of the word "paramater1" which probably should read "Parameter1".
>
>HTH
>
>Walter,
>
>
>
>>Has anyone used the ParameterFields Property in Crystal 7 ActiveX? I want to pass a parameter to the report from Visual Fox 6
>>and print the report based on a user id and not have the user prompted to enter it.
>>
>>My code is:
>>
>
>>
>>The error I'm getting is:
>>
>>Error Number 1429
>>OLE IDispatch exception code 0 from CrystalReport. Invalid parameter field name . . .
>>
>>
>>
>>I'm not sure if I'm missing something else I need, or what. Any information would be appreciated.
>>Crystal Report help isn't the best I've seen around!
>>
>>Thanks,
>>
>>James Colson