Report mixedup Contacts

Hello all,

I need to create a report which create a list of contacts with email by accounts.
Unfortunatelly the output mixed up the contacts.

Ex.
If an account has 3 contacts
Alex Lion alion@mail.com
Marti Zebra mzebra@mail.com
Gloria Hippo ghippo@mail.com

The Output is
Alex Lion alion@mail.com
Alex Zebra alion@mail.com
Alex Hippo alion@mail.com

Marti Zebra mzebra@mail.com
Marti Lion mzebra@mail.com
Marti Hippo mzebra@mail.com

Gloria Hippo ghippo@mail.com
Gloria Lion ghippo@mail.com
Gloria Zebra ghippo@mail.com

My report is configured as following


Did somebody has a tip how to fix that?
Running Version 8.8.0 on debian 12

Thanks in advance

Pay attention to the details! Checkboxes etc

This outputs the following:

It doesn’t handle multiple emails per contact, but at least it handles multiple contacts per account (with correct emails).

My first reaction is if you want a report of contacts, why are you running it from the Accounts module? It would be easier and run faster if you did from the contacts module then you don’t need all that accounts:contacts business. (you may have a valid reason for doing so, but I’d start the report from the contacts if it was me, unless you have a good reason you’re doing it from Accounts).

I’ve found the reports can sometimes be wonky the further you’re pulling data from the base module you start the report from. ie: Accounts:contacts:email_addresses is 3 hops away

1 Like