How can I add email addresses of Contacts to show up on their Household page? See below of full explanation of what I'm trying to do.
I want to modify a NPSP out-of-box report called Households with Donations - LYBUNT (Accounts report type). Development team wants to add email addresses (found in contacts object) and lead source (found in opportunities object) fields to this report. So I played around and created a separate joined report that used the Contacts & Accounts report type and the Opportunities report type. However, when there are two contacts (and subsequently two email address, each attached to their respective contact profile) in an account, their information goes on two separate lines. It throws off the rest of the fields, like showing the household's last gift twice and makes it slightly harder to read.
What we prefer is having all the information for one household on a single line, i.e. both email addresses showing up for a household but as separate fields in the same row. We decided we can add a field in the Account page that looks up the lead source in the most recent donation, but don't have any solutions on how to do that easily for the email addresses.
