User Support Forum

How do I get my custom report to display family members with different last names? I currently have the the following.

Mr. & Mrs John Doe
555 Oak St.
Columbus, OH 44995
John
Jane
Joe
Sue

Sue has a different last name from the rest of the family. How do I get that to show up in my custom report? How do I post a link to show what I have in my custom report?

Thanks,
Colleen

In order to do something like this, you need to use conditional formatting. Your expression for the name field would need to read something like:

ALLTRIM(FirstName) + " " + IIF(UPPER(LastName_A) <> UPPER(LastName_B), ALLTRIM(Lastname_b), "")