select unitofmeasure from tblmanufacturers where mfr_id = select 0 as rowNumber, * from qmd_opportunities order by caseamt desc order by weightamt desc select * from qmd_opportunities where rowNumber <= order by #_orderby# select 0 as rowNumber, * from qmd_opportunities order by #_orderby# select sum(caseamt) as caseamt, sum(incomeamt) as incomeamt, sum(weightAmt) as weightAmt from qmd_opportunities where statecode <> 'R'
  • #numberformat(_totalOriginalRecords,"9,999")# Opportunities
    Total Pounds: #numberformat(qryPlanStats.weightAmt,"9,999")#
    Total Cases: #numberformat(qryPlanStats.caseamt,"9,999")#
  • #companyname#
    •
#_lowerPagerDisplay#