Crystal Reort Formaula Writing Help

Hi,

i m using crsytal report with vb6. i have designed a report in Crystal report8.5. Now i want to give some selection formula to it but i m ubale to do so please help me. i m posting the code here please review it.

1. cr1.SelectionFormula = “{cfcdata1.DMIDNO} = ‘ adviceNo ‘”
2. cr1.SelectionFormula = “{cfcdata1.DMIDNO} = ‘” & adviceNo &”‘”

cr1 is the crystalReport control
cfcfdata1 is the table name
dmidno is the field name and adviceNo is a string type variable.

i have tried both ombinations above but it gives me error remaining test doest not seem to be part of formula or some thing like that.

please help me in this regard.