wildcard parameter 1

[wiplash]

Using CR11

I need to create a parameter so the user can select only certain records beginning with a letter or letters AND is also able to just select all records in the db. Currently I'm using "starts with" in the selection criteria, but an * returns no data. If I change it to "like", then * works, but if they enter A, only A is returned, and they want to see AA or AAAA, etc.

Would appreciate any advice.

Thanks

 

[pmax9999]

You could use a record selection formula as follows:

[Code RecordSelection]
{YourTable.YourField} Like ({?YourParameter} + '*')
[/Code]

If nothing was entered it would return all records, otherwise it would return records starting with the character string entered in the parameter.

Cheers
Pete.

 

[wiplash]

Thanks!