Answers.Body: <p>Take a look at the "Contributions by Organization Report".  <code>CRM/Report/Form/Contribute/OrganizationSummary.php</code> and the line:</p>
  
  <pre><code>$rows[$rowNum]['civicrm_address_state_province_id'] = CRM_Core_PseudoConstant::stateProvinceAbbreviation($value, FALSE);
  </code></pre>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-02-27T18:12:42.583Z
Answers.Text: Thanks – this core report helped me tweak the custom report I have been using enough to get what I need. I appreciate the pointer.
Answers.UserDisplayName: Laryn
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-02-27T10:14:48.653Z
Answers.LastActivityDate: 2018-02-27T10:14:48.653Z
Answers.UserDisplayName: Aidan
Body: <p>Similar to <a href="https://civicrm.stackexchange.com/questions/21743/how-to-export-with-state-abbreviations">this question</a>, I'm interested in having my reports export states/provinces with the abbreviation instead of the full name. The accepted answer in that case was to use an Advanced Search rather than a Report -- but <a href="https://civicrm.stackexchange.com/questions/22717/searching-filtering-by-the-date-a-contact-was-added-to-a-group">in my case there is no advanced search to get the contacts I need</a> and I'm using a custom report, so I need to figure out how to do this in the CiviReport side.</p>
  
Tags: <civireport><custom-reports>
Title: Can I make reports export the state/province abbreviation instead of full name?
ThreadText: # Can I make reports export the state/province abbreviation instead of full name?
  
  (Asked by: username_0 on 2018-02-26)
  
  Similar to [this question](https://civicrm.stackexchange.com/questions/21743/how-to-export-with-state-abbreviations), I'm interested in having my reports export states/provinces with the abbreviation instead of the full name. The accepted answer in that case was to use an Advanced Search rather than a Report -- but [in my case there is no advanced search to get the contacts I need](https://civicrm.stackexchange.com/questions/22717/searching-filtering-by-the-date-a-contact-was-added-to-a-group) and I'm using a custom report, so I need to figure out how to do this in the CiviReport side.
  
  **Tags:** civireport, custom-reports
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2018-02-27. Score: 1 | Accepted answer
  
  Take a look at the "Contributions by Organization Report".  CRM/Report/Form/Contribute/OrganizationSummary.php and the line:
  $rows[$rowNum]['civicrm_address_state_province_id'] = CRM_Core_PseudoConstant::stateProvinceAbbreviation($value, FALSE);
  
  > **Comments:**
  > **username_0**: Thanks – this core report helped me tweak the custom report I have been using enough to get what I need. I appreciate the pointer.  
  
  ---
  
  