How to create free text parameter to search field 1

[javedi]

Hello

I'm in the process of creating a report to search by postcode. For this i can create a parameter, but how can i change it to free text to allow the user to type for example, AB1 and the report to show all entries with AB1 in the table.

Any idea's and help would be welcomed.

Thanks,
Javedi

 

[javedi]

I forgot to mention that I'm using crystal reports 10.

Javedi

 

[lbass]

{table.postcode} like "*"+{?parm}+"*"

If you only want those that start with the selected value, then use:

{table.postcode} like {?parm}+"*"

-LB

 

[javedi]

Thanks again LB,

It worked fine.

Javedi