select territoryId, name as territoryName from tbl_ter_territories where ownerid = and fsl_tablecode = and territoryid = and datediff( day, ih.invoiceDate, getDate() ) <= 365 group by cdr.cdr_recordId, cdr.cdr_dstCode, cdr.cdr_dstName order by cdr_dstname --->

Distributor Purchasing
#qryTerritory.territoryName#

#_mfrUOM.unitOfMeasurePlural#

#_deltaCases.deltaPercent##_deltaCases.indicatorCharacter#

Dollars

#_deltaDollars.deltaPercent##_deltaDollars.indicatorCharacter#

startDate="#_calendarVars.tyStartDate#" endDate="#_calendarVars.tyEndDate#" planEndDate="#_calendarVars.tyPlanEndDate#" columnSuffix="_ty"> startDate="#_calendarVars.lyStartDate#" endDate="#_calendarVars.lyEndDate#" planEndDate="#_calendarVars.lyPlanEndDate#" lastMonthRate="#_calendarVars.lastMonthRate#" columnSuffix="_ly" addYearOverYearColumns=true > select sum( annualqty_TY ) as annualqty_TY, sum( annualqty_LY ) as annualqty_LY, sum( annualdollars_TY ) as annualdollars_TY, sum( annualdollars_LY ) as annualdollars_LY from qryDistributors

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

#qryDistributors.companyname#

#qryDistributors.city#, #qryDistributors.state#

0% #_qtyDelta.deltaPercent##_qtyDelta.indicatorCharacter# #ucase(_mfrUOM.unitOfMeasureAbreviated)# #numberformat(qryDistributors.annualqty_ty,"9,999")#

0% #_dollarsDelta.deltaPercent##_dollarsDelta.indicatorCharacter# $ #numberformat(qryDistributors.annualdollars_ty,"9,999")#

Direct Ship Operators

0% #_qtyDelta.deltaPercent##_qtyDelta.indicatorCharacter# #ucase(_mfrUOM.unitOfMeasureAbreviated)# #numberformat(_directAnnualQty_TY,"9,999")#

0% #_dollarsDelta.deltaPercent##_dollarsDelta.indicatorCharacter# $ #numberformat(_directAnnualDOllars_TY,"9,999")#

no distributors found