Soundex function/Parameter Value 1

[lizzieb]

I'm trying to create a name search that uses the soundex function and it doesn't seem to like using the parameter value. I am using the selection expert where the soundex value of the field (last name) is equal to the soundex value of the parameter field (last name). If I substitute the parameter value for a static value, it returns a valid record. With the parameter field, it returns all records in the database. (Good thing I am running this against a small training db for testing!) Does anyone have any advice/ideas for me?

 

[kenhamady]

It works for me. What is your actual selection formula? Cut and paste it here. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[lizzieb]

Thank you so much for trying to help me out. I read in the standard Crystal "help" for syntax on the soundex function which mentioned that the value string must be in quotes. Just this morning I removed the quotes and it worked just fine. Thanks again.

 

[kenhamady]

That must be worded poorly, the quotes are only for a literal string. Not for a field or parameter. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/