CiviCRM Community Forums (archive)

Hey everyone, so my non-profit has a number of delegates who collect member dues.  I would like to be able to run a report that would tell me how many of different membership types each delegate has collected in the last month.  However the only two options for 'sort by column' are 'member since' and 'member type'.  Is there a way to 'sort by column' based on custom fields that I made such as 'delegate' or 'report number'?

If you use the variable

protected $_customGroupExtends = array('Individual','Contact')

in the report file (under CRM/Report/Form/*)
then any available custom fields that pertain the the dataset you are extracting will automatically be added to the columns, filters, and sort_by areas of the report. This may add things you don't want but it will include the things you do.