CiviCRM Community Forums (archive)

One of my volunteers wants to create a report which lists the participant's / constituent's Date of Birth (or age). It doesn't appear to be listed as an available field in reports and since it's not a custom field I can't go and add it in.

Is DoB not reportable, or have I missed the setting to do it?

Thanks.
Ed

dynamic group of over 50's[/quote]

Almost forgot: happy birthday

Strange question perhaps, but what does your volunteer want to achieve with the DoB on a report? I have not checked the standard report yet but I use smart groups in combination with DoB to create for example a dynamic group of over 50's?
And you can use the Advanced Search option for DoB, does that help?

He runs our Learn to Row programme. He wants to do reports of e.g. (1) the ages of particpants in our learn to row events [a series of Events], or (2) to see a report of those waiting to learn to row (contacts tagged in a particular way).

I have said to him that he could, in theory, use Smart Groups to do some of this, but he finds CiviCRM pretty confusing already and telling him to go off in other screens and create other groups isn't helpful.

Ed, is this still an issue for you?  Is the standard template your volunteer wishes to use for the report "Event Participant Report (List) - Template"?  I could look at providing an example of how to add the DOB field as an option, if that would help.

This link gives very good detailed instructions on how to create your own report extensions if you can't find what you want in the standard report set:
http://wiki.civicrm.org/confluence/display/CRMDOC42/Create+a+Report-Template+Extension

In the targeted report template php file, add an entry for the birth date field to the civicrm_contact table's fields array in function __construct():

          'birth_date' =>
          array( 'title'     => ts( 'Birth date' ),
                 'name'      => 'birth_date',
          ),

e.g.
    $this->_columns = array(
      'civicrm_contact' =>
      array(
        'dao' => 'CRM_Contact_DAO_Contact',
        'fields' =>
        array(
          'sort_name_linked' =>
          array('title' => ts('Participant Name'),
            'required' => TRUE,
            'no_repeat' => TRUE,
            'dbAlias' => 'contact_civireport.sort_name',
          ),
  'first_name' => array('title' => ts('First Name'),
          ),
  'last_name' => array('title' => ts('Last Name'),
          ),
          'id' =>
          array(
            'no_display' => TRUE,
            'required' => TRUE,
          ),
          'employer_id' =>
          array('title' => ts('Organization'),
          ),
          'birth_date' =>
          array( 'title'     => ts( 'Birth date' ),
                 'name'      => 'birth_date',
          ),
        ),
        'grouping' => 'contact-fields',

(Belatedly) Thank you for this.