Family Member Last Name is Different
Moderators: Moderators, Tech Support
Family Member Last Name is Different
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.
-
- Tech Support
- Posts: 3045
- Joined: Thu May 13, 2004 9:59 am
- Location: PowerChurch Software
- Contact:
Re: Family Member Last Name is Different
You can accomplish this by adding a variable to display the profile's name. The expression in the variable would be something like:
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.
Code: Select all
alltrim(firstname) + iif(lastname_a <> lastname_b, " " + alltrim(lastname_b), "")
Let me know if you need more detailed instructions about adding a variable or anything like that.
Re: Family Member Last Name is Different
Thank you. I was able to to do this successfully.