startDate="#_calendarVars.lyStartDate#" endDate="#_calendarVars.lyEndDate#" planEndDate="#_calendarVars.lyPlanEndDate#" lastMonthRate="#_calendarVars.lastMonthRate#" columnSuffix="_ly" addYearOverYearColumns=true > select * from qcf_accounts order by distance asc order by annualQty_ty desc, companyname order by dataset, myacctsort, priority, companyname order by dataset, companyname order by annualqty_ty desc, companyname order by annualqty_ty asc, companyname order by qtyIncrease desc, companyname order by qtyIncrease asc, companyname select * from qcf_accounts where rowNumber <= 10 startDate="#_calendarVars.lyStartDate#" endDate="#_calendarVars.lyEndDate#" planEndDate="#_calendarVars.lyPlanEndDate#" lastMonthRate="#_calendarVars.lastMonthRate#" columnSuffix="_ly" addYearOverYearColumns=true >

provide additional search criteria
to view results

no accounts found

add new operator

Accounts Near Me Top Ten Distributors #numberformat(_totalOriginalRecords,"9,999")# Found

#iif(client.ownerid eq 26,de('add new operator'),de('new opr'))#

Invoice Data #dateformat(_calendarVars.tyPlanStartDate,"m/d/yy")# - #dateformat(_calendarVars.tyPlanEndDate,"m/d/yy")#, as of #dateformat(_calendarVars.asOfDate,"m/d/yy")#

#replace(priority,'*','A+')# Priority Accounts

#ucase(companyname)#

#numberformat(distance,"9.99")# #distanceUOM# #replace(priority,'*','A+')# ERF #REReplace(city, "\b(\S)(\S*)\b", "\u\1\L\2", "all")#, #ucase(state)#

0% #_qtyDelta.deltaPercent##_qtyDelta.indicatorCharacter# 0% #_altDelta.deltaPercent##_altDelta.indicatorCharacter# 0% #_dollarsDelta.deltaPercent##_dollarsDelta.indicatorCharacter# #numberformat(annualqty_ty,"9,999")# #_mfrUOM.unitOfMeasurePlural# #numberformat(annualalt_ty,"9,999")# #_mfrUOM.altUnitOfMeasurePlural# Units $#numberformat(annualdollars_ty,"9,999")# Dollars #numberformat(qtyIncrease,"9,999")# #_mfrUOM.unitOfMeasurePlural# Delta

#_lowerPagerDisplay#