From e05e0dbaa47f61fc7498d98d9207450e2536a93a Mon Sep 17 00:00:00 2001 From: Eileen McNaughton Date: Thu, 26 Mar 2015 13:45:05 +1300 Subject: [PATCH] CRM-16182 strip with rollup from sql in add2group function --- CRM/Report/Form.php | 1 + 1 file changed, 1 insertion(+) diff --git a/CRM/Report/Form.php b/CRM/Report/Form.php index 5ab76ff1bf..9b10b4ff26 100644 --- a/CRM/Report/Form.php +++ b/CRM/Report/Form.php @@ -4190,6 +4190,7 @@ LEFT JOIN civicrm_contact {$field['alias']} ON {$field['alias']}.id = {$this->_a $select = str_ireplace('SELECT SQL_CALC_FOUND_ROWS ', $select, $this->_select); $sql = "{$select} {$this->_from} {$this->_where} {$this->_groupBy} {$this->_having} {$this->_orderBy}"; + $sql = str_replace('WITH ROLLUP', '', $sql); $dao = CRM_Core_DAO::executeQuery($sql); $contact_ids = array(); -- 2.25.1