Parameter 2

[fhurmuzlu]

I have to create Parameter with (Firstname%Lastname),Do I have create two parameters First name and Last name? but I need to put % between First and last Name?

 

[lbass]

Can you explain the rationale for this? Is the % supposed to act as a wildcard in case there is a middle initial? Where are you creating this parameter--in a command or in the Crystal GUI?

-LB

 

[fhurmuzlu]

% act as any record belong to First and Last name of person , I am creating this parameter in a command.

 

[Turkbear]

Hi,
What database?
Are First and Last names in separate fields in 1 record?





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

 

[fhurmuzlu]

Oracle database - First Name and Last name seprate Fields in same table

 

[fhurmuzlu]

Actually I am creating a parameter in the parameter fields section of the field explorer.

 

[lbass]

If you want the user to enter both first and last name at the parameter prompt {?FullName} (which you are creating inside the command on the right), then you could set up a where clause like this:

where "table"."firstname"||' '||"table"."lastname" = '{?FullName}'

This would assume that the user was prompted to enter the first name plus one space plus the last name.

-LB

 

[fhurmuzlu]

PLease I need more explanation!!I am using Crystal reports 2008

 

[lbass]

So do I. Of what?

-LB

 

[fhurmuzlu]

When i enter full name(first and last name) and run the report ,I do not get any record? Please help.
also I create formula
{People.Fstn}+""+{People.Lstn} (@Fullname)
then in selection expert
{@Fullname}={?Fullname}

 

[lbass]

I didn't see your post that you were creating the parameter in the main report--if you are using a command, you really should be creating the parameter and referencing it within the command--otherwise the selection occurs locally.

How will people enter the name at the prompt? I'm guessing it will be like this:

John Doe

...which means your selection formula should be:

{People.Fstn}+" "+{People.Lstn}={?Fullname}

... with a space between the double quotes.

-LB

 

[Turkbear]

Hi,
Another issue may arise depending on how those fields are defined in Oracle - There may be blank padding is CHAR is used.

Try LB's formula witrh this mod:

TRIM({People.Fstn})+" "+TRIM({People.Lstn})={?Fullname}

Better yet, have users enter each name separately.



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

 

[fhurmuzlu]

Please I need help , I did everything you told me to do still I am not getting any record!!!!!!!!!!

 

[Turkbear]

Hi,
Place your parameter in the Report header but do not use them in your record selection formula - return some records with the First and Last name fields and your {@Fullname} formula and compare them to the parameter values displayed - you may see why they do not match up.





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

 

[lbass]

Also, you should check to make sure the case matches.

You could try:

ucase(trim({table.fstn}))+" "+ucase(trim({table.lstn}))= ucase({?FullName})

-LB