CiviCRM Community Forums (archive)

Hello,

Is there any way to include Contacts' addresses in Relationship Report?

Thank you.

Hi Erik,

I have just finished editing report and received your email. Thanks for heads up though.

Not sure why, but I had to comment below lines;

if ( !empty($this->_params['country_id_value']) ||
     !empty($this->_params['state_province_id_value']) ){

Below is the code I added in CRM/Report/Form/Contact/Relationship.php

'civicrm_address'  =>
    array( 'dao'       => 'CRM_Core_DAO_Address',
         'fields' =>
         array( 'street_address' =>
                array( 'title'  => ts('Street Address of Contact A'),
                       'name'   => 'street_address',
                       'default' => true, ),
                'city' =>
                array( 'title'  => ts('Suburb of Contact A'),
                       'name'   => 'city',
                       'default' => true, ),
                'postal_code' =>
                array( 'title'  => ts('Postcode of Contact A'),
                       'name'   => 'postal_code',
                       'default' => true, ),
                'state_province_id' =>
                array( 'title'  => ts('State of Contact A'),
                       'name'   => 'state_province_id',
                       'default' => true, ),),
         'filters'   =>             
         array( 'country_id' =>
                array( 'title'        => ts( 'Country' ),
                       'operatorType' => CRM_Report_Form::OP_MULTISELECT,
                       'options'      => CRM_Core_PseudoConstant::country(),
                       ),
                'state_province_id' => 
                array( 'title'        => ts( 'State/Province' ),
                       'operatorType' => CRM_Report_Form::OP_MULTISELECT,
                       'options'      => CRM_Core_PseudoConstant::stateProvince( ),
                       ),
                ),
         'grouping'  => 'contact-fields',
         ),