CiviCRM Community Forums (archive)

Hi,
Not sure if this is the right board...maybe belongs under Developers, but I started on a document at http://wiki.civicrm.org/confluence/display/CRMDOC/CiviReport and if anyone who knows more about it wants to improve it that would be great.

One thing I wasn't able to figure out was how to get the same field name to appear more than once in the list of fields for the user to select, and I'm not sure if it's a limitation or if I just couldn't figure it out. For example suppose the report uses the contact table twice, e.g. to list a contact and their father in the same row, and you want both "display_name"'s to appear, one titled "Contact" and one titled "Father". It works in the output, but on the report generation page both fields appear with the same title. Snippet:

               'civicrm_contact' =>
                   array( 'dao'       => 'CRM_Contact_DAO_Contact',
                          'fields'    =>
                          array( 'display_name'           =>
                                 array( 'title' => ts('Contact'),
                                        'default'  => true, ),
                                ),
                        ),
               'father' =>
                   array( 'dao'       => 'CRM_Contact_DAO_Contact',
                          'fields'    =>
                          array( 'display_name'           =>
                                 array( 'title' => ts('Father'),
                                        'default'  => true, ),
                                ),
                        ),

Thanks. I think the thing I was missing was the 'name' parameter, but I'm still slightly confused about the relationships between the parameters 'name', 'alias' and 'the key for the array', but I think mostly it's just "make it match with whatever else you are doing in the rest of the file".