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, " ")
crystal formula used to group
-
- Posts: 6266
- Joined: Tue Mar 20, 2018 5:34 am
Re: crystal formula used to group
Hello,
Please check the following expression:
{Mid(AttendSummRpt1.EmplName, InStrRev(AttendSummRpt1.EmplName, " ") + 1) + ", " + Mid(AttendSummRpt1.EmplName, 1, InStrRev(AttendSummRpt1.EmplName, " "))}
Thank you.
Please check the following expression:
{Mid(AttendSummRpt1.EmplName, InStrRev(AttendSummRpt1.EmplName, " ") + 1) + ", " + Mid(AttendSummRpt1.EmplName, 1, InStrRev(AttendSummRpt1.EmplName, " "))}
Thank you.