I have a small problem with a report I am making. I wrote the following code for a Formula Field:

if {TLORDER.BILL_TO_CODE} like "D%" then

    {TLORDER.DESTNAME}

else if {TLORDER.BILL_TO_CODE} like "P%" then

    {TLORDER.ORIGNAME}

   

My goal is if the Bill To starts with a D, then it will display the DESTNAME field; if it starts with P, then it will display the ORIGNAME field. However, the field always comes up empty.

Any help in getting the field to display would be most appreciated.

note that you can also use the startswith option in crystal syntax