X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2FReport%2FFCC_477.pm;h=3749bfebe2a35fcd9166fe9ff159f5a2ee25cea8;hb=8e635ac832696698fab3299f68acf0f58781c248;hp=0f5d4cedc89433af0430cf302fc234400a24609e;hpb=10dbf48db68e0ca9264865cb98c24cb05c104824;p=freeside.git

diff --git a/FS/FS/Report/FCC_477.pm b/FS/FS/Report/FCC_477.pm
index 0f5d4cedc..3749bfebe 100644
--- a/FS/FS/Report/FCC_477.pm
+++ b/FS/FS/Report/FCC_477.pm
@@ -382,7 +382,8 @@ sub fbd_sql {
   );
   push @where, "agentnum = $agentnum" if $agentnum;
 
-  my $order_by = 'censusblock, agentnum, technology, is_consumer, is_business';
+  #my $order_by = 'censusblock, agentnum, technology, is_consumer, is_business';
+  my $order_by = 'censusblock, technology';
 
   "SELECT DISTINCT ".join(', ', @select) . "
   FROM $from