From 1bfaf6a6b4cd50a73236e792069286ff8149c756 Mon Sep 17 00:00:00 2001
From: Deepak Srivastava <deepak.srivastava@webaccess.co.in>
Date: Thu, 20 Jun 2013 12:42:20 +0530
Subject: [PATCH] CRM-12623, count_distinct stat

----------------------------------------
* CRM-12623: Create CiviHR Report Template
  http://issues.civicrm.org/jira/browse/CRM-12623
---
 CRM/Report/Form.php | 8 ++++++++
 1 file changed, 8 insertions(+)

diff --git a/CRM/Report/Form.php b/CRM/Report/Form.php
index 4672148047..197686dfed 100644
--- a/CRM/Report/Form.php
+++ b/CRM/Report/Form.php
@@ -1736,6 +1736,14 @@ WHERE cg.extends IN ('" . implode("','", $this->_customGroupExtends) . "') AND
                     $this->_selectAliases[] = $alias;
                     break;
 
+                  case 'count_distinct':
+                    $select[] = "COUNT(DISTINCT {$field['dbAlias']}) as $alias";
+                    $this->_columnHeaders["{$tableName}_{$fieldName}_{$stat}"]['title'] = $label;
+                    $this->_columnHeaders["{$tableName}_{$fieldName}_{$stat}"]['type'] = CRM_Utils_Type::T_INT;
+                    $this->_statFields[$label] = $alias;
+                    $this->_selectAliases[] = $alias;
+                    break;
+
                   case 'avg':
                     $select[] = "ROUND(AVG({$field['dbAlias']}),2) as $alias";
                     $this->_columnHeaders["{$tableName}_{$fieldName}_{$stat}"]['title'] = $label;
-- 
2.25.1