From c783c0a0c03da5efee7dc890bc1c9bf78a489f1a Mon Sep 17 00:00:00 2001
From: Seamus Lee <seamuslee001@gmail.com>
Date: Tue, 7 Apr 2020 09:50:26 +1000
Subject: [PATCH] dev/core#1673 Ensure that SQL statements are not duplicated
 in the developer tab of reports

---
 CRM/Report/Form.php | 1 +
 1 file changed, 1 insertion(+)

diff --git a/CRM/Report/Form.php b/CRM/Report/Form.php
index 694b77b7e6..c454fc7803 100644
--- a/CRM/Report/Form.php
+++ b/CRM/Report/Form.php
@@ -1427,6 +1427,7 @@ class CRM_Report_Form extends CRM_Core_Form {
     ];
 
     $this->assignTabs();
+    $this->sqlFormattedArray = [];
     $this->sqlArray[] = $sql;
     foreach ($this->sqlArray as $sql) {
       foreach (['LEFT JOIN'] as $term) {
-- 
2.25.1