Including Custom Fields in OrderBy (Custom Report )

[darkchild]

I am not sure if this was the right way to do it but faced with a need to include Custom fields in the Order By/ Header Grouping section of reports (and  limited knowledge), I ended up using the following line:

Code: [Select]

protected $_autoIncludeIndexedFieldsAsOrderBys = array( 'Activity', 'Case' );
The code can be placed under the $_customGroupExtends like this:

Code: [Select]

class CRM_Report_Form_ProgramSummary extends CRM_Report_Form {
   
protected $_customGroupExtends = array( 'Activity', 'Case' );
protected $_customGroupGroupBy = true;
protected $_autoIncludeIndexedFieldsAsOrderBys = array( 'Activity', 'Case' );

Hopefully this may be of use to someone  else.

[ddunn]

This would be very handy for me. However I have even less knowledge, and I can't figure out which file this would sit in. Can you help? Thanks!

[ddunn]

Got it, Thanks!

I put

Code: [Select]

    protected $_autoIncludeIndexedFieldsAsOrderBys = array( 'Participant' ); at line 48 of civicrm/CRM/Report/Form/Event/ParticipantListing.php

just under   

Code: [Select]

  protected $_customGroupExtends = array( 'Participant' );
Thanks!