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