From 493bc048bbc2ce10c15fa37b2b23e5946d8819cc Mon Sep 17 00:00:00 2001
From: JKingsnorth <john@johnkingsnorth.co.uk>
Date: Thu, 13 Jul 2017 16:47:37 +0100
Subject: [PATCH] CRM-20863 Improve report list ordering

---
 CRM/Report/Page/InstanceList.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/CRM/Report/Page/InstanceList.php b/CRM/Report/Page/InstanceList.php
index fa4e74e390..f614582022 100644
--- a/CRM/Report/Page/InstanceList.php
+++ b/CRM/Report/Page/InstanceList.php
@@ -130,7 +130,7 @@ class CRM_Report_Page_InstanceList extends CRM_Core_Page {
 
           WHERE v.is_active = 1 {$report}
                 AND inst.domain_id = %1
-          ORDER BY  v.weight";
+          ORDER BY  v.weight ASC, inst.title ASC";
 
     $dao = CRM_Core_DAO::executeQuery($sql, array(
       1 => array(CRM_Core_Config::domainID(), 'Integer'),
-- 
2.25.1