adding a column to the standard relationships report in Contact Reports

Question

Using the standard relationships report under Contact Reports, I would like to be able to add another column under Contact B. That column would pull the supplemental 1 address field.

Using the current template what do i need to add in order for that to work? Do i need to modify any other php files as well?

Answer 1

As ErikH stated it is always good practice to create a new extension or create a custom folder to override core files

So In order to add a supplement address in the report you need to add a new column to the report first

 'civicrm_address' => array(
    'dao' => 'CRM_Core_DAO_Address',
      'fields' => array(
      'supplemental_address_1' => array(
        'title' => ts('supplemental address 1'),
        'default' => TRUE,

      ),
    ),

The above code will add a column to the report and next you need to add address table to the from function

if ($this->_params['fields']['supplemental_address_1']){
    $this->_from .= "
        INNER  JOIN civicrm_address {$this->_aliases['civicrm_address']}
                     ON (( {$this->_aliases['civicrm_address']}.contact_id =
                           {$this->_aliases['civicrm_contact']}.id  OR
                           {$this->_aliases['civicrm_address']}.contact_id =
                           {$this->_aliases['civicrm_contact_b']}.id ) AND
                           {$this->_aliases['civicrm_address']}.is_primary = 1 ) ";

} else if (!empty($this->_params['country_id_value']) ||
  !empty($this->_params['state_province_id_value'] )
) {
  $this->_from .= "
        INNER  JOIN civicrm_address {$this->_aliases['civicrm_address']}
                     ON (( {$this->_aliases['civicrm_address']}.contact_id =
                           {$this->_aliases['civicrm_contact']}.id  OR
                           {$this->_aliases['civicrm_address']}.contact_id =
                           {$this->_aliases['civicrm_contact_b']}.id ) AND
                           {$this->_aliases['civicrm_address']}.is_primary = 1 ) ";
}

By doing the above you can achieve what you wanted

But still you need to add condition to your address table based on the location type or select only primary flag

I guess this helps !!!

Answer 2

Perhaps it will help you to read the documentation on CiviCRM Reports: https://wiki.civicrm.org/confluence/display/CRMDOC/CiviReport+Reference. It is not complete but it should help you on your way?

I would not recommend just changing the template, I would recommend creating an extension with your customized report. And then you would need to update the php files as well, check https://wiki.civicrm.org/confluence/display/CRMDOC/Create+a+Module+Extension#CreateaModuleExtension-Addareport

Or am I stating something which you already know by heart :-)