I am working with the Constituent Summary report and then saving a copy with the fields that I want displayed.

One of the fields is Modified Date, but when I go to SORTING, Modified Date is not one of the options.

How can I add Modified Date field to the sorting options of Reports?


1 Answer 1


You would have to create a new report type in an extension using code that extends the existing CRM_Report_Form_Contact_Summary class, and add modified_date into the order_by section. In here https://github.com/civicrm/civicrm-core/blob/539eb78da2cbf9834c5799e3e5e5a6ccbff08ff4/CRM/Report/Form/Contact/Summary.php#L65

  • the civix tool makes that pretty straightforward. Alternatively, you could submit a patch if you think adding the sort field the existing report would be generally of value to others.
    – Alan Dixon
    Aug 2, 2022 at 20:56
  • 1
    I actually ended up using Search Kit to create search I needed and duplicate report, and you can more easily re-arrange the columns and make all columns sortable.
    – jsherk
    Aug 5, 2022 at 21:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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