CiviCRM Community Forums (archive)

Hi community,

since hours i try to find out, why the Button "Add these Contacts to Group" is not working. "Print Report", "PDF" and Export to CSV just works fine. But not the very important Add button.

i reduced my code (built after "http://wiki.civicrm.org/confluence/display/CRMDOC/Report+Showing+Individuals+and+Related+Groups") to the minimum possible (of course i would like to do more fancy things with multiple left join's etc (which btw works also fine).

here is the reduced code:
<?php
 
require_once 'CRM/Report/Form.php';
class CRM_Report_Form_Contact_whoiswho extends CRM_Report_Form {
 
    function preProcess( ) {
        parent::preProcess( );
    }
 
    function __construct( ) {
parent::__construct( );
    }

 
    function postProcess( ) {
    $this->beginPostProcess( );   
   
    // the query parts
    $mySelect =     "SELECT civicrm_contact.id, civicrm_contact.sort_name ";
    $myFrom =   "FROM civicrm_contact  ";
    $myWhere =      "WHERE civicrm_contact.id=1 ";  
    $myOrderBy =    "";

 
 
 
    //concatenate the query parts to get the full query
    $myQuery = $mySelect . $myFrom . $myWhere . $myOrderBy;
        
    $this->_columnHeaders =
            array( 
                   
                   'sort_name' =>    array( 'title' => 'Name' ),
                   'id' =>        array( 'title' => 'CiviCRM ID' ),
                 );
                 
 
    // fetch the query results
    $this->buildRows ( $myQuery, $rows );
    $this->doTemplateAssignment( $rows );
    $this->endPostProcess( $rows );
    }
}

any hints where i have to look into? help would be appreciated!

thx in advance!

Cheers
3524

Hi jaapjansma,

thanks for the reply and so fast!

The user i am testing with has full rights (admin). Maybe i was not so clear. there is the functionality shown, but it does not add the contacts (or in my example the contact) to the group selected. it runns something, but also with the civicrm loggin functionality enabled, it does not even give an error.

This sentense i might not understand:
"It could be that you have customized the template of the report."
i have customized the template (it's in my "custom code" folder). and everything goes fine but the "add to group"- button

hope i could make myselfe more clear.

Ah ok, now i get it. thanks.

no, that's not the case. i have only the line "
{include file="CRM/Report/Form.tpl"}" in the template and no changes in the included template.

so i guess it is in the code. are there other reports, who are good as a basis to change? i need only contact information with some custom fields.

hm... changed it like this:
<?php
 
require_once 'CRM/Report/Form.php';
class CRM_Report_Form_Contact_whoiswho extends CRM_Report_Form {
 
    function preProcess( ) {
        parent::preProcess( );
    }
 
    function __construct( ) {
parent::__construct( );
    }

 
    function postProcess( ) {
    $this->beginPostProcess( );   
   
    // the query parts
    $mySelect =     "SELECT civicrm_contact.id as civicrm_contact_id, civicrm_contact.sort_name as civicrm_contact_sort_name ";
    $myFrom =   "FROM civicrm_contact ";
    $myWhere =      "WHERE civicrm_contact.id=1 ";  
    $myOrderBy =    "";

 
 
 
    //concatenate the query parts to get the full query
    $myQuery = $mySelect . $myFrom . $myWhere . $myOrderBy;
        
    $this->_columnHeaders =
            array( 
                   
                   'civicrm_contact_sort_name' =>    array( 'title' => 'Name' ),
                   'civicrm_contact_id' =>        array( 'title' => 'CiviCRM ID' ),
                 );
                 
 
    // fetch the query results
    $this->buildRows ( $myQuery, $rows );
    $this->doTemplateAssignment( $rows );
    $this->endPostProcess( $rows );
    }
}

changes in select and the _columnHeader array. but nothing changed so far. did i miss, what you ment?
i made the same with the second field (sort_name). it still works, but add to group still does not...

well i tried this allready, but not with the desired result... i think i will give "custom search" a chance for this problem, it might do the job too in our case.
anyway. many thanks to your help jaapjansma.
 i will post what solution i came up with, so maybe it's a help for someone else...