If {SO_OpenOrdersWrk.UDF_USER} = "0000000034"

then "Jessica"

else ""

Hi Kevin, now if I have more than one user would I still use this formula?

I am sorry, I do not understand this formula you provided. In total I have 6 users in which I need to identify in the Open Sales Order Report. 

0000000027, 0000000058, 0000000046, 0000000034, 0000000011, and 0000000064

That is from the CR help files.

select {SO_OpenOrdersWrk.UDF_USER}

case "0000000034" : "Jessica"

case "0000000027" : "name2"

...

default : "";

It worked Kevin. Thank you so much!

What I did is create two UDFs one for First name and one for Last Name and added to the sales order header and added the script to the order number field.  Here is the script. It goes and gets the first and last name and writes it out to the UDFs which I can the flow to other work tables. 

sFirst="":sLast="":sKey="":sCKey=""

retVal=oBusObj.GetValue("UserCreatedKey",sCKey)

SetoUser=oBusObj.AsObject(oBusObj.GetChildHandle("UserCreatedKey"))

retVal=oUser.getvalue("UserKey$",sKey)
retVal=oUser.getvalue("FirstName$",sFirst)
retVal=oUser.getvalue("LastName$",sLast)

If sKey=sCKey then
retVal=oBusObj.SetValue("UDF_FIRST$",sFirst)
retVal=oBusObj.SetValue("UDF_LAST$",sLast)

end if