Family Member Last Name is Different

Moderators: Moderators, Tech Support

Post Reply
ccarr
Posts: 12
Joined: Thu Sep 17, 2020 9:34 am

Family Member Last Name is Different

Post by ccarr »

Building my first custom report. Working on a church directory by visit area. I have been successful so far, except for how to print the last name of a family member that may differ from the main family name. I saw this somewhere in Power Church, but cannot find it at present. Any assistance would be great.

Zorak
Tech Support
Tech Support
Posts: 2719
Joined: Thu May 13, 2004 8:59 am
Location: PowerChurch Software
Contact:

Re: Family Member Last Name is Different

Post by Zorak »

You can accomplish this by adding a variable to display the profile's name. The expression in the variable would be something like:

Code: Select all

alltrim(firstname) + iif(lastname_a <> lastname_b, " " + alltrim(lastname_b), "")
That would print the first name and if the profile's last name is different than the family's last name, would add their last name as well.

Let me know if you need more detailed instructions about adding a variable or anything like that.

ccarr
Posts: 12
Joined: Thu Sep 17, 2020 9:34 am

Re: Family Member Last Name is Different

Post by ccarr »

Thank you. I was able to to do this successfully.

Post Reply