select unitofmeasure from tblmanufacturers where mfr_id = select sum(caseamt) as caseamt, sum(incomeamt) as incomeamt, sum(weightAmt) as weightAmt from qmd_opportunities where statecode <> 'R' select 0 as rowNumber, * from qmd_opportunities order by #url.orderby# select * from qmd_opportunities where rownumber >= #_startRow# and rownumber <= #_endRow#
Page #url.pg# of #_pageCount#
  
  • #numberformat(_totalOriginalRecords,"9,999")# Opportunities
    Total Pounds: #numberformat(qryPlanStats.weightAmt,"9,999")#
    Total Cases: #numberformat(qryPlanStats.caseamt,"9,999")#
     Total Dollars: $#numberformat(qryPlanStats.incomeamt,"9,999")#
  • #companyname#
    •