Select Expert

[savok]

Does anyone know of any tutorials or examples on the web on how to use select expert? I am totally new to CR and I am forced to use it

I am trying to get the table.name field to show up where table.hospital = the parameter hospital

plz help

 

[dcm]

Savok: A suggestion - take each of the separate parts of Malcolm's last posting and make them a new formula field e.g.
formula1 = If Isnull({HOSPITAL.HOSPITAL_NAME}) then "No Hospital Name"
formula 2 = If Isnull({STUDENT.LASTNAME}} then "No Student Name"
formula3 = If {HOSPITAL.HOSPITAL_NAME)={?Hospital} then {STUDENT.LASTNAME}

Place each one on your report and look at the results. This may help you to understand which part is going wrong.

Also I notice the last test is equality (=). This is very precise and if your database is case sensitive or your parameter entry is spelt incorrectly or is incomplete, this part will fail David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Seagate Enterprise Partner

 

[MalcolmW]

Are you trying to use this formula as a record selection formula? If so, then it won't work - you should be using something like
//This formula always returns a TRUE/FALSE result
{HOSPITAL.HOSPITAL_NAME} = {?Hospital} Malcolm

 

[kenhamady]

I don't think anyone answered the original question.

If your parameter field is a Character field, and the database field is also a Character field then you should be able to add a new rule in the Select Expert itself.

Start the rule by clicking "New" and selecting the field from the database, then select "Equal To" and in the third box, the drop down, you should see your parameter field either at the top or bottom of the list of literal values. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal