you would use wild characters in crystal like this:
{customer.name} like "M???????"
or
{customer.name} like "M******"
Im not a massive guru on crystal, but from what i can gather, you are making things difficult for yourself.
You will need to account for so many possible user entries.
There may be an easy way that someone might know, but the oly option I can see for it to work in crystal is:
Create a formula called PARAMETER
this formula will simply be: LEFT({?country},1)
this will give you the first letter of the user input..
then try some combination of:
{country.name} like {@parameter}&"??????"
but again, this wont account for the length or amount of chracters the user has inputted...
Its really messy.
Do YOU HAVE to do it this way?
I stil lthink the better option would be for YOU to define a list of countrys that the user can select from, but there may be good valid reasons why this is not a viable option for you.
im trying for ya though!
IP Logged
