Page 1 of 1

Family Member Last Name is Different

Posted: Mon Apr 26, 2021 11:12 am
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.

Re: Family Member Last Name is Different

Posted: Mon Apr 26, 2021 3:25 pm
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.

Re: Family Member Last Name is Different

Posted: Wed May 05, 2021 7:51 am
by ccarr
Thank you. I was able to to do this successfully.