Access to field Supplemental Address 1 in a Membership Report

[David Hepper]

Am I missing something to enable the use of Supplemental Address 1 in a Membership Report? Only Street Address is selectable. I can see custom fields for the Contact record (thanks, Eileen) but not this important field for creating an address list.

[Eileen]

If you replace 

      'civicrm_address' =>
      array(
        'dao' => 'CRM_Core_DAO_Address',
        'fields' =>
        array(
          'street_address' => NULL,
          'city' => NULL,
          'postal_code' => NULL,
          'state_province_id' =>
          array('title' => ts('State/Province'),
          ),
          'country_id' =>
          array('title' => ts('Country'),
          ),
        ),
        'grouping' => 'contact-fields',
      ),

with

   + $this->getAddressColumns()

you will get a more full set of address fields.

If you have trouble getting the syntax CRM_Report_Form_Contribute_TopDonor uses this method of grabbing address fields

[David Hepper]

Thanks again, Eileen. That's working. I wonder why it isn't standard to show all fields? In the UK there are vast numbers of cases where the street address is insufficient. Also, it is standard to put the 'supplemental' as defined by Civi post-help before the Street Address.

[Eileen]

I think it's more the organic growth thing than a decision.  You might post the alteration you are using as an issue in JIRA (preferably with a patch or even better a Pull request) & note that question on the issue.