I thought this was a simple problem [and it probably is] but I can't seem to figure it out. Here's the situation. I have a view in my database that lists some locations. I let the user select from this list of locations. But I want to get data that can either be in this list, or slightly different.

For instance, let's say my list has 3 entries: 'first', 'second', and 'third'. And the user selects 'first'. I want Crystal Reports to return all records that have their {table.location} == 'first' or 'firstXX'.

I tried doing that in this way having the selection formula like so: {table.location} = {?selectedLocation} or {table.location} = {@locationFormula}. Where location Formula was '{?selectedLocation} & "XX"'. CR complained about {?selectedLocation} having to be an array. I guess because you can select more then one location.

Is there a (simple) way to do this?

For some reason when I do this, it gives me all the locations now. So if I select 'first', it will show me 'first', 'second' and 'third' on the report.

Any ideas?

EDIT: I tried using {table.location} = ({?selectedLocation} + "*"). But now if I select 'first', 'second' and 'third' and the database contains 'firstXX', 'second' and 'third'. CR will only display 'second' and 'third'. I think I'm getting closer?

I'm not sure if this behaviour is normal or not but if it is, can someone explain it to me?

Edited by lw00 - 02 May 2009 at 10:43am

I was not looking at your multiple selection critieria.

Can you post your solution for others to see?