Page 2 of 2

Re: crystal formula used to group

Posted: Tue Mar 24, 2020 2:30 pm
by jgoswalt
Just one more shot - this is what I have as a text field on the report and I get the print out below.


Mid({AttendSummRpt1.EmplName}, InStrRev({AttendSummRpt1.EmplName}, " ") + 1) + ", " + Mid({AttendSummRpt1.EmplName}, 1, InStrRev({AttendSummRpt1.EmplName}, " "))


Report Generated: 03/24/2020 10:22:14 AM Page 1 of 1

Mid(James E. Johnson, InStrRev(James E. Johnson, " ") + 1) + ", " + Mid(James E. Johnson, 1, InStrRev(James E. Johnson," "))
Mid(Rick E. Woxman, InStrRev(Rick E. Woxman, " ") + 1) + ", " + Mid(Rick E. Woxman, 1, InStrRev(Rick E. Woxman, " "))
Mid(John Isaacs, InStrRev(John Isaacs, " ")

Re: crystal formula used to group

Posted: Wed Mar 25, 2020 1:40 pm
by Lech Kulikowski
Hello,

Please check the following expression:
{Mid(AttendSummRpt1.EmplName, InStrRev(AttendSummRpt1.EmplName, " ") + 1) + ", " + Mid(AttendSummRpt1.EmplName, 1, InStrRev(AttendSummRpt1.EmplName, " "))}

Thank you.