CiviCRM Community Forums (archive)

hello,

I am new to custom report in CRM and tried creating the custom report for bookkeeping report that consist of event name and event ID filter in the report criteria, so I try adding : custom field into the bookkeeping.php that is located already on the custom_php folder so I dont overwrite the core codes :

here is the code :
  function __construct() {
    $this->_columns = array(
      'civicrm_contact' =>
      array(
        'dao' => 'CRM_Contact_DAO_Contact',
        'fields' =>
        array(
          'sort_name' =>
          array('title' => ts('Contact Name'),
            'required' => TRUE,
            'no_repeat' => TRUE,
          ),
          'id' =>
          array(
            'no_display' => TRUE,
            'required' => TRUE,
          ),
        ),
        'filters' =>
        array(
          'sort_name' =>
          array('title' => ts('Contact Name'),
            'operator' => 'like',
          ),
          'id' =>
          array('title' => ts('Contact ID'),
            'no_display' => TRUE,
          ),
        ),
        'grouping' => 'contact-fields',
      ),
      'civicrm_membership' =>
      array(
        'dao' => 'CRM_Member_DAO_Membership',
        'fields' =>
        array(
          'id' =>
          array('title' => ts('Membership #'),
            'no_display' => TRUE,
            'required' => TRUE,
          ),
        ),
      ),
      'civicrm_event' =>
      array(
        'dao' => 'CRM_Event_DAO_Event',
        'fields' =>
        array(
          'event_type_id' =>
          array('title' => ts('Event Name'),
            'required' => TRUE,
            'no_repeat' => TRUE,
          ),
        ),
        'filters' =>
        array(
          'event_type_id' =>
          array('title' => ts('Event Name'),
            'operator' => 'like',
          ),
        ),
      ),

in the custom_php\CRM\Report\Form\Contribute\bookkeeping.php and it is showing like DB error field not found.

help me understand how can I add 2 fields in the bookkeeping that is event :
- Event Name – standard field in CiviCRM event table
- Event Accounting Code – custom field tied to events

the default instance should be : civicrm/report/instance/18?reset=1

I tried extending the group by adding :
protected $_customGroupExtends = array('Membership', 'Event');
well all the fields shows but filter in preview report throws error syntax error, which I dont prefer of showing all the event fields, instead I only need those 2 fields to get filtered.

can anyone share a clue here? do I need to create own clean template and query one by one? or we can just extend it?

thank you for taking the time to read my post