Parameter with wild card

[fhurmuzlu]

I have to create Parameter with First and last name , but some of names comes with middle intial.How to create the parameter without the user enter the middle initial. I mean we want just to enter First and last name.
I have table named People with two fields First name and last name(separate Fields).

 

[fhurmuzlu]

The parameter with wild card (Firstname%lastName)

 

[briangriffin]

Your select formula would be:

split({?Name Parameter}," ")[1] = split{yourtable.firstname}," ")[1]
and
split({?Name Parameter}," ")[2] = {yourtable.lastname}


So if the user typed in "Brian Griffin" this would return records for both Brian Griffin and Brian T. Griffin, assuming the middle initial always appears in the first name field.

 

[fhurmuzlu]

Thanks braingriffin , I have one more problem The last name field contains company name and crew member's names for same person.I suppose get two or three set of names , but I am getting just first and last name of person.Please any idea to solve this problem?Thanks in advance

 

[briangriffin]

Please post some sample data.

 

[fhurmuzlu]

LastName (Field)
-------------

James I. Brown

Jim Pusak

Lone Star Company

G/S Advanture Inc.



-----------------------------



Name:Brown James I.

DOB: 05/17/1985 SSN: 123456789

Name:Lone Star Company

DOB: Blank SSN: UNKNOWN

Nameusak Jim

DOB:9/15/1974 SSN:654893524

 

[briangriffin]

Not really sure what I'm looking at. In the first section, are those four values that could appear in the last name field? I thought the "James I." and "Jim" appeared in the first name field.

As for the second section, are DOB and SSN separate fields? Why do we need them? Why is there a second section?

I was expecting something like this:

First Name Field Last Name Field
Brian Griffin
Joe T. Smith
Jerry Griffin
Coca-Cola
Joe Crewmember

 

[fhurmuzlu]

Yes , James I." and "Jim" appears in the first name field , the second section are DOB ,SSN fields already in the People table
and what you are expected is correct
First Name Field Last Name FieldBrian GriffinJoe T. SmithJerry Griffin Coca-Cola Joe Crewmember

 

[Turkbear]

Hi,
If First Name and Last Name are in separate fields why use only 1 parameter? Using 2 would greatly simplify the task and should not be a problem for the users.



To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[briangriffin]

While I agree that two parameters would be a good approach, especially if using CR2008+ and could make first name optional, the data is in such disarray I'm not sure it matters at this point.

fhurmuzlu - based on what you've provided, I would probably first consider creating a database view that somehow excludes company names and crew members. Then integrate that view into your reports; it would be too much work doing it within CR every time.