CiviCRM Community Forums (archive)

I have a custom report that I have written in PHP.

I is working fine except that I want to suppress the duplicate values of the receipt date after the first has been reported.

The relevant bit of the PHP is:

function __construct( )
  {
    $this->_columns =
      array(
        'Banking_Invoice_Summary' => array(
          'alias'  => 'bh',
          'dao'    => 'CRM_Contact_DAO_Contact',
          'fields' => array(
            'rdate'       => array('title' => ts('Receipt Date'),'required' => true,'no_repeat' => true),
            'description' => array('title' => ts('Description'), 'required' => true),
            'amount'      => array('title' => ts('Amount'),      'required' => true),
            'number'      => array('title' => ts('Number'),      'required' => true),
                           ),
          'filters' => array(    
            'rdate' => array('title' => 'Banking Date Range',
                             'operatorType' => CRM_Report_Form::OP_DATE ),
                            ),
                                  ),
      );
      parent::__construct( );
  }

I was hoping that the 'no_repeat' => true against the rdate field would work but it doesn't.

The SQL is properly sorted before the data rows are fed into the report.

Any suggestions as to what I can do? I have looked at how to do this in the actually MySQL SELECT statement but the lack of analytics seems to make this impossible to achieve.

regards
Simon