Answers.Body: <p>welcome to the community!</p>
  
  <p>First up, I would <em>not</em> recommend learning to code by editing CiviCRM Reports.</p>
  
  <p>The thing to exhaust before reaching for your Dial-a-Coder is the CiviCRM Profile option for an Advanced Search. You can get the information that you need from Civi 99% of the time using cleverly created Profiles, and then using them as a "Search View" on an Advanced Search.</p>
  
  <p>If (and Only If!) you've exhausted that, then it may be best to ask a CiviCRM Partner organisation to help you. They can be found here: <a href="https://civicrm.org/partners-contributors" rel="nofollow noreferrer">https://civicrm.org/partners-contributors</a>.</p>
  
  <p>Good luck!</p>
  
  <p>JohnFF</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-04-02T22:50:24.003Z
Answers.LastActivityDate: 2017-04-02T22:50:24.003Z
Answers.UserDisplayName: JohnFF
Answers.Body: <p>This is now possible with the <a href="https://civicrm.org/extensions/extended-reports" rel="nofollow noreferrer">Extended Reports</a> extension, which you can install from the in-app extension explorer.  You'll need to rebuild your report in the corresponding Extended Report template.  Click the <strong>Advanced Report Configuration</strong> link to reorder columns.</p>
  
  <p>It's also possible with the <a href="https://civicrm.org/extensions/reportplus" rel="nofollow noreferrer">ReportPlus</a> extension, which I haven't used yet.</p>
  
  <p><a href="https://i.sstatic.net/4WEup.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/4WEup.png" alt="enter image description here"></a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-10-23T21:06:40.450Z
Answers.LastActivityDate: 2019-10-24T13:58:34.817Z
Answers.LastEditDate: 2019-10-24T13:58:34.817Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.Body: <p>One option is to run the report and export to CSV (there is a button at the top of the report results). You can then open it in Excel and order the columns as you wish.</p>
  
  <p>This is the quick way with no coding necessary.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-03-03T19:52:17.943Z
Answers.LastActivityDate: 2017-03-03T19:52:17.943Z
Answers.UserDisplayName: KilakwaBT
Answers.Body: <p>You've certainly stumbled on to a weak point of CiviCRM.  In addition to both of the answers already submitted, if you need better reporting you can also hook a reporting/business intelligence tool directly into CiviCRM.  I know CiviCRM folks using JasperReports, Pentaho BI, and Tableau.  I've also experimented with Google Data Studio.  They're all a bit tricky to set up, but you have a LOT more reporting power.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-08-31T07:56:28.110Z
Answers.Text: There's also Reportico (www.reportico.org) which is free and I found easy to set up.
Answers.UserDisplayName: Andy Clark
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-08-31T15:49:53.517Z
Answers.Text: Very good suggestion @AndyClark! I was unaware of a PHP-based open source reporting tool like Reportico.  Reportico could conceivably be packaged as a CiviCRM extension...
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-08-31T17:59:30.370Z
Answers.Text: There's also Forena which is Drupal based but Reportico will work with any MySql tables (and others) and is far easier to use than Forena (which I tried twice & gave up with twice).  I had a report running with Reportico in a day from scratch - supports seems reasonable as well.
Answers.UserDisplayName: Andy Clark
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-08-31T04:40:36.240Z
Answers.LastActivityDate: 2017-08-31T04:40:36.240Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Body: <p>I'm creating a basic custom report using constituent details. I'm hoping to find a way to reorder the columns in the report. For instance, I have a custom field that I'd like to go first, and then put the address second - to match a previous report format we used.</p>
  
  <p>Is there a non coding option for doing this? If I have to code, where can I go to learn how to build it?</p>
  
Tags: <wordpress><civireport><custom-reports>
Title: Reorder Report Columns
ThreadText: # Reorder Report Columns
  
  (Asked by: username_0 on 2017-03-03)
  
  I'm creating a basic custom report using constituent details. I'm hoping to find a way to reorder the columns in the report. For instance, I have a custom field that I'd like to go first, and then put the address second - to match a previous report format we used.
  
  Is there a non coding option for doing this? If I have to code, where can I go to learn how to build it?
  
  **Tags:** wordpress, civireport, custom-reports
  
  
  ---
  
  ## 4 answers
  
  ### Answer by username_1 on 2017-04-02. Score: 2
  
  welcome to the community!
  
  First up, I would *not* recommend learning to code by editing CiviCRM Reports.
  
  The thing to exhaust before reaching for your Dial-a-Coder is the CiviCRM Profile option for an Advanced Search. You can get the information that you need from Civi 99% of the time using cleverly created Profiles, and then using them as a "Search View" on an Advanced Search.
  
  If (and Only If!) you've exhausted that, then it may be best to ask a CiviCRM Partner organisation to help you. They can be found here: <https://civicrm.org/partners-contributors>.
  
  Good luck!
  
  username_1
  
  
  ---
  
  ### Answer by username_2 on 2019-10-23. Score: 2
  
  This is now possible with the [Extended Reports](https://civicrm.org/extensions/extended-reports) extension, which you can install from the in-app extension explorer. You'll need to rebuild your report in the corresponding Extended Report template. Click the **Advanced Report Configuration** link to reorder columns.
  
  It's also possible with the [ReportPlus](https://civicrm.org/extensions/reportplus) extension, which I haven't used yet.
  
  [![enter image description here](https://i.sstatic.net/4WEup.png)](https://i.sstatic.net/4WEup.png)
  
  
  ---
  
  ### Answer by username_3 on 2017-03-03. Score: 1
  
  One option is to run the report and export to CSV (there is a button at the top of the report results). You can then open it in Excel and order the columns as you wish.
  
  This is the quick way with no coding necessary.
  
  
  ---
  
  ### Answer by username_2 on 2017-08-31. Score: 0
  
  You've certainly stumbled on to a weak point of CiviCRM. In addition to both of the answers already submitted, if you need better reporting you can also hook a reporting/business intelligence tool directly into CiviCRM. I know CiviCRM folks using JasperReports, Pentaho BI, and Tableau. I've also experimented with Google Data Studio. They're all a bit tricky to set up, but you have a LOT more reporting power.
  
  > **Comments:**
  > **username_4**: There's also Reportico (www.reportico.org) which is free and I found easy to set up.  
  > **username_2**: Very good suggestion @AndyClark! I was unaware of a PHP-based open source reporting tool like Reportico.  Reportico could conceivably be packaged as a CiviCRM extension...  
  > **username_4**: There's also Forena which is Drupal based but Reportico will work with any MySql tables (and others) and is far easier to use than Forena (which I tried twice & gave up with twice).  I had a report running with Reportico in a day from scratch - supports seems reasonable as well.  
  
  ---
  
  