X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2Fsearch%2Fcust_bill_pkg.cgi;h=a87e44651c90444e321cc553df7577ab120d67a4;hp=b9743049ded29065d6b1132b9c2056aa03eb219b;hb=afc02cadca8e8033285bb213bcde620cb8fa4f99;hpb=184cfcddbb0f9148d0ef1c01756647946b8c2df9 diff --git a/httemplate/search/cust_bill_pkg.cgi b/httemplate/search/cust_bill_pkg.cgi index b9743049d..a87e44651 100644 --- a/httemplate/search/cust_bill_pkg.cgi +++ b/httemplate/search/cust_bill_pkg.cgi @@ -463,8 +463,11 @@ if ( $cgi->param('pkg_tax') ) { } else { - #$count_query = "SELECT COUNT(*), "; - $count_query = "SELECT COUNT(DISTINCT billpkgnum), "; + if ( $use_usage ) { + $count_query = "SELECT COUNT(*), "; + } else { + $count_query = "SELECT COUNT(DISTINCT billpkgnum), "; + } if ( $use_usage eq 'recurring' ) { $count_query .= "SUM(setup + recur - usage)";