X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fsearch%2Freport_rt_transaction.html;h=0232b807097a5ceedf814fd78b80a5943572d8e5;hb=e168ca3db2702bd9a540316cd9bd840238dd19ce;hp=61445bd1e857d6ecc7d8c86292bcd004124bb209;hpb=4f25d34901fb6a358af5b5009608c5162e745042;p=freeside.git

diff --git a/httemplate/search/report_rt_transaction.html b/httemplate/search/report_rt_transaction.html
index 61445bd1e..0232b8070 100644
--- a/httemplate/search/report_rt_transaction.html
+++ b/httemplate/search/report_rt_transaction.html
@@ -50,6 +50,7 @@ if ( @pkgparts ) {
     'addl_from' => ' LEFT JOIN cust_svc USING ( svcnum ) '.
                    ' LEFT JOIN cust_pkg USING ( pkgnum ) ',
     'extra_sql' => 'WHERE pkgpart IN ('. join(',', @pkgparts). ')',
+    'order_by'  => 'ORDER BY username',
   });
 }