Problem with Formula 1

[CrystalUser1]

Hi,

Can somebody explain what is the following record selection formula doing? This was written by somebody, I need to understand and change the logic.

I am using crysal reports 8.5.


Record Selection Formula:


(trim({%LastNameFirstMName}) = "," and trim({?EmployeeName}) <= " "
or Replace({%LastNameFirstMName}," ","") startswith replace({?Employee}," ",""))


%LasNameFirstMName is the following sql Expression:

{fn CONCAT({fn CONCAT({fn CONCAT({fn RTRIM(Employee."Employee_LNAME")},' ,' )},
{fn LTRIM({fn CONCAT({fn RTRIM(Employee."Employee_FNAME")},' ' )})})},Employee."Employee_MNAME" )}


?EmpployeeName is the parameter in the above record selection formula.

Please help me in understanding the above record selection formuala.

thanks in advance.

 

[synapsevampire]

It returns rows where the sql expression is just a comma and the parameter was empty, or it returns the sql expression where it starts with what was entered in the parameter.

-k

 

[CrystalUser1]

thank you K for your help, can you explain little bit on this what is doing actually?

or Replace({%LastNameFirstMName}," ","") startswith replace({?Employee}," ",""))

thanks

 

[synapsevampire]

This:

Replace({%LastNameFirstMName}," ","")

Replaces spaces with nothing

This:

startswith replace({?Employee}," ",""))

says if it begins in what's in the employee prompt, after it has replaced any spaces with nothing.

So it states that if what was entered in the parameter, after it's replaced the blanks with nothing, is at the beginning of what's in the %LastNameFirstMName SQL Expression then return it.

-k

 

[CrystalUser1]

Thank you so much Synapsevampire for your kind help.