CiviCRM Community Forums (archive)

hi natascha
i would probably try pulling this together in views first where you should be able to 'aggregate' and get the 'count' of those - IF contact reference field has been woven in to the Views code.

The other option on civi side would be to see if Relationships can do what you want instead of the contact reference field - and then aggregate those in Views.

If you don't know Views it can be a bit of a struggle even knowing whether to start with a View based on 'civi contacts' or 'civi relationships' - and then adding in the Views Relationships to join all the bits together

But if you do know views, you might get what you need without actually coding anything ;-)

otherwise some brighter spark will come along with a suggestion on how to do a Custom civi Report I expect

never used that - have you looked at whether it can work for you alongside https://www.drupal.org/project/civicrm_entity

I started in the relationships area, but had other issues there...
when a contact fills in the registration form, I want them to create a drupal user on the fly... with civicrm-webform, I can make a relationship, but I can not create a drupal user...

I'm not a coder, so, unless someone gives me step by step instructions on how to set php in rules to create that user when they fill in the form, I am nowhere...

regards