Author Topic: Custom Fields Sum() in Report (Read 4462 times)

FrTommy · September 24, 2010, 10:00:08 pm

I did that and it works sort of. It returns the message properly yet when I run the report for a date range in which there are records returned the code skips the first record. For example I have 3 notes entered and it only returns the Note2 and Note 3.

Code: [Select]

               $sql = $select . ' ' . $clause;

        $dao = CRM_Core_DAO::executeQuery( $sql );
        if (! $dao->fetch( ) ) {
          $statistics['groups2'][$i] = array( 'title' => '',
                              'value' =>  '</td><td>There were no notes entered for the date range selected.</td><td>' );
        }
        else {
        $i = 0;
        while ( $dao->fetch( ) ) {
         $statistics['groups2'][$i] = array( 'title' => '',
                      'value' =>  $dao->n_date . '</td><td>' . $dao->n_name . '</td><td>'  . $dao->n_note );  
         $i++;
           }
    }
        return $statistics;

FrTommy · September 25, 2010, 01:38:07 am

finally after a friend sat down and helped me with it we figured it out. below is the snippet of code that works

Code: [Select]

 $sql = $select . ' ' . $clause;

        $dao = CRM_Core_DAO::executeQuery( $sql );

        $i = 0;
        while ( $dao->fetch( ) ) {
         $statistics['groups2'][$i] = array( 'title' => '',
                      'value' =>  $dao->n_date . '</td><td>' . $dao->n_name . '</td><td>'  . $dao->n_note );
         $i++;
           }
         if (count($statistics['groups2']) == 0 || !(isset($statistics['groups2']))) {
            $statistics['groups2'][$i] = array( 'title' => '',
                              'value' =>  '</td><td>There were no notes entered for the date range selected.</td><td>' );
         }

        return $statistics;

 }

CiviCRM Community Forums (archive)

News:

Author Topic: Custom Fields Sum() in Report (Read 4462 times)

FrTommy

Re: Custom Fields Sum() in Report

FrTommy

Re: Custom Fields Sum() in Report