I thought I answered this yesterday. Look at the Crystal Reports articles on my web site. One discusses parameter passing.

>Hi
>
>I am using VFP6 Free Tables to create crystal reports. I am using Crystal report 7.
>
>I want to pass parameters to Crystal report from fox.
>
>How I am calling crystal report from form.
>
>I have a form with one text box called txtempno
>I also have a command button.
>I have an crystal report active x control button dropped on my form and following properties are set
>
>1. Connect with ODBC connectivity
>2. Name = crpfxp1
>3. ReportFileName = c:\medical\akpmed1.rpt
>
>
>I have written following code on command button click
>
>thisform.crpfxp1.Formulas(0) = [co = "AKP123"]
>
>thisform.crpfxp1.action = 1
>
>
>I want to know how to pass Formulas with variable values instead on hardcoded value as shown in the above code as "AKP123"
>
>Suppose i want to pass a variable myempno which is same as value entered in textbox of the form, how can I achieve that ?
>
>In crystal report i have created a parameter field called myempno as string and in select expert i have given med_out.empno is equal to {?myempno}
>
>Is it ok. will i be able to filter the report from the parameter which i have passed from the form.
>
>Pl. help. Thanks in advance.
>
>Regards
>
>Ashish