Customer List Prompt by Last Name

[nickayle]

Good Day, I have created a report in crystal 8.5 that displays my customers information. I have tried to prompt on the customers last name by using the parameter prompt. It returns no results. How can i set up the report to prompt for a customer by last name. ie the users can put in the last name and the results would return the same.

Many Thanks!
nic

 

[IdoMillet]

Show the record selection formula in your report.

- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[nickayle]

Thank you for the quick response. what i have done is this: i have a parameter prompt call lastname, i have place this in my group footer which is suppress. in my select expert i have profile.lastname = {?.lastname). not sure if this is what you mean. If its not, can you break it down further plaese.

many thanks!
nic

 

[nickayle]

Ido, it seems like if you don't have the exact name/spelling of the last name exactly how it is in heat, it would not return a result.(i think that was the problem) tell me something, is there a way to just put the beginning letters of the last name and it brings up those customers?

Again I Say Thank You!
nic

 

[IdoMillet]

Ucase(Left({profile.lastname}, Length({?lastname})))= Ucase({?lastname})

should let the user enter any number of characters andmatch against them.

You may want to look up the online help on Soundex()...

- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[nickayle]

Good morning Ido, I tried the code that you send, I even tried using the soundex cmd, neither of those worked. the results are still the same(seems like i have to key the last name as is in heat)

Thanks again for your assistance!
nic

 

[IdoMillet]

Show your record selection formula (copy & paste).

Are you sure you are refreshing the data (not showing saved data in the report)?

- Ido


Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[nickayle]

save data with report was checked. that works like a charm.
Thank You, Thank You, Thank You.

nic

 

[nickayle]

Hi Ido, I have 3 prompts in my report start date, end date and lastname. Is there a way i can just put in the dates and it returns a result OR i can just put a last name and it return that. The way my report is working now is that I have to put in the start date, end date and lastname in order to get a result.

Much Thanks!
nic

 

[synapsevampire]

Set up defaults for each parameter, and if they aren;t changed, it will ignore them.

I often set the default date to 1/1/1970, and any string parameters to All.

Then in the report->selection formulas->record use:

(
if {?Startdate} <> cdate(1970,1,1,) then
(
{table.date} >= {?Startdate}
and
{table.date} <= {?Enddate}
)
else
if {?Startdate} = cdate(1970,1,1,) then
true
)
and
(
if {?name} <> "All" then
{table.name} = {?name}
else
if {?name} = "All" then
true
)

-k

 

[IdoMillet]

Glad the mystery was solved... )

- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[nickayle]

Hi, synapservampire, I have set up the defaults for the date and last name: when the report prompts, it automatically brings up the default date "1/1/1970" and name "All" - should it work this way. ALSO after inserting the code to the record selection formula it says that a string is needed before cdate. I tried using the datevalue(#,string) field, then it gives a message, not enough arguments have been given to this function. further assistance would be appreciated.

Thank you again for all your help!
nic