2

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?

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!

JohnFF

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.

1

This is now possible with the 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 extension, which I haven't used yet.

enter image description here

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.

  • 1
    There's also Reportico (www.reportico.org) which is free and I found easy to set up. – Andy Clark Aug 31 '17 at 7:56
  • 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... – Jon G - Megaphone Tech Aug 31 '17 at 15:49
  • 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. – Andy Clark Aug 31 '17 at 17:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.