This module is not currently broker client compatible!

 select distinct parentTerritoryId from request.qmd_userTerritoryHierarchy where localMarket = 1 select * from request.qmd_userTerritoryHierarchy where ( localMarket = 1 or territoryId in ( ) ) and upper(territoryName) like '%#ucase(url.keyWord)#%' select * from qryTerritories order by annualqty_ty desc, territoryName order by annualqty_ty asc, territoryName order by qtyIncrease desc, territoryName order by qtyIncrease asc, territoryName
  • Invoice Data #dateformat(_calendarVars.tyPlanStartDate,"m/d/yy")# - #dateformat(_calendarVars.tyPlanEndDate,"m/d/yy")#, as of #dateformat(_calendarVars.asOfDate,"m/d/yy")#
    •  select 0 , sum(annualqty_TY) annualqty_TY, sum(annualqty_LY) annualqty_LY , sum(annualdollars_TY) annualdollars_TY, sum(annualdollars_LY) annualdollars_LY , sum(annualalt_TY) annualalt_TY, sum(annualalt_LY) annualalt_LY , sum(qtyIncrease) qtyIncrease from qryTerritories where parentterritoryid = where territoryid =

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

    select firstname, lastname from tbl_fspro_members with (nolock) where ownerid = and fsl_tablecode = and fspro_userid =

  • #territoryName#

    #qryManager.firstname# #qryManager.lastname#

    #_salesDataDisplay#
    • select brokerId, brokerofficeid from tbl_SMA_BrokerOfficeLink with (nolock) where mfr_id = and territoryId = and primaryOffice = 'Y' select broker_name AS CompanyName from tblBrokers with (nolock) where broker_id =

  • #territoryName#

    #_brokers[qryBroker.brokerId]['name']#

    #_salesDataDisplay#
#_lowerPagerDisplay#