		Month (#DateFormat(_mFromDateTY,"mmm/dd/yyyy")# - #DateFormat(_mToDateTY,"mmm/dd/yyyy")#)		Year To Date Rolling 12 Months (#DateFormat(_yFromDateTY,"mmm/dd/yyyy")# - #DateFormat(_yToDateTY,"mmm/dd/yyyy")#)
		Cases			Dollars			Net Wt				Cases			Dollars			Net Wt
Mfr Sku / Dist Sku	Description	TY	LY	#ShowVar(_showVar,"%")#	TY	LY	#ShowVar(_showVar,"%")#	TY	LY	#ShowVar(_showVar,"%")#		TY	LY	#ShowVar(_showVar,"%")#	TY	LY	#ShowVar(_showVar,"%")#	TY	LY	#ShowVar(_showVar,"%")#

SELECT ManufacturerName, DistributorName, CategoryDescription ,SUM(QuantityMTY) QuantityMTY, SUM(WeightMTY) WeightMTY, SUM(AmountMTY) AmountMTY ,SUM(QuantityMLY) QuantityMLY, SUM(WeightMLY) WeightMLY, SUM(AmountMLY) AmountMLY ,SUM(QuantityYTY) QuantityYTY, SUM(WeightYTY) WeightYTY, SUM(AmountYTY) AmountYTY ,SUM(QuantityYLY) QuantityYLY, SUM(WeightYLY) WeightYLY, SUM(AmountYLY) AmountYLY ,COUNT(*) as Cnt FROM qmd_Results WHERE 1=1 AND ManufacturerName = AND DistributorName = AND CategoryDescription = GROUP BY ManufacturerName,DistributorName,CategoryDescription SELECT ManufacturerName, DistributorName ,SUM(QuantityMTY) QuantityMTY, SUM(WeightMTY) WeightMTY, SUM(AmountMTY) AmountMTY ,SUM(QuantityMLY) QuantityMLY, SUM(WeightMLY) WeightMLY, SUM(AmountMLY) AmountMLY ,SUM(QuantityYTY) QuantityYTY, SUM(WeightYTY) WeightYTY, SUM(AmountYTY) AmountYTY ,SUM(QuantityYLY) QuantityYLY, SUM(WeightYLY) WeightYLY, SUM(AmountYLY) AmountYLY ,COUNT(*) as Cnt FROM qmd_Results WHERE 1=1 AND ManufacturerName = AND DistributorName = GROUP BY ManufacturerName,DistributorName SELECT ManufacturerName ,SUM(QuantityMTY) QuantityMTY, SUM(WeightMTY) WeightMTY, SUM(AmountMTY) AmountMTY ,SUM(QuantityMLY) QuantityMLY, SUM(WeightMLY) WeightMLY, SUM(AmountMLY) AmountMLY ,SUM(QuantityYTY) QuantityYTY, SUM(WeightYTY) WeightYTY, SUM(AmountYTY) AmountYTY ,SUM(QuantityYLY) QuantityYLY, SUM(WeightYLY) WeightYLY, SUM(AmountYLY) AmountYLY ,COUNT(*) as Cnt FROM qmd_Results WHERE 1=1 AND ManufacturerName = GROUP BY ManufacturerName

#Manufacturername#

#DistributorName#

#CategoryDescription#

#Itemcode# #DisplayDistSku(DistributorItemcode)#

#fixLongStr(htmleditformat(Description),_col2br,"br")#

#FormatCellValue(QuantityMTY)#

#FormatCellValue(QuantityMLY)#

#getVar(QuantityMLY,QuantityMTY,_showVar)#

#FormatCellValue(AmountMTY)#

#FormatCellValue(AmountMLY)#

#getVar(AmountMLY,AmountMTY,_showVar)#

#FormatCellValue(WeightMTY)#

#FormatCellValue(WeightMLY)#

#getVar(WeightMLY,WeightMTY,_showVar)#

#FormatCellValue(QuantityYTY)#

#FormatCellValue(QuantityYLY)#

#getVar(QuantityYLY,QuantityYTY,_showVar)#

#FormatCellValue(AmountYTY)#

#FormatCellValue(AmountYLY)#

#getVar(AmountYLY,AmountYTY,_showVar)#

#FormatCellValue(WeightYTY)#

#FormatCellValue(WeightYLY)#

#getVar(WeightYLY,WeightYTY,_showVar)#

#qmd_CatST.CategoryDescription#
Category Total

#FormatCellValue(qmd_CatST.QuantityMTY)#

#FormatCellValue(qmd_CatST.QuantityMLY)#

#getVar(qmd_CatST.QuantityMLY,qmd_CatST.QuantityMTY,_showVar,_NewLine)#

#FormatCellValue(qmd_CatST.AmountMTY)#

#FormatCellValue(qmd_CatST.AmountMLY)#

#getVar(qmd_CatST.AmountMLY,qmd_CatST.AmountMTY,_showVar,_NewLine)#

#FormatCellValue(qmd_CatST.WeightMTY)#

#FormatCellValue(qmd_CatST.WeightMLY)#

#getVar(qmd_CatST.WeightMLY,qmd_CatST.WeightMTY,_showVar,_NewLine)#

#FormatCellValue(qmd_CatST.QuantityYTY)#

#FormatCellValue(qmd_CatST.QuantityYLY)#

#getVar(qmd_CatST.QuantityYLY,qmd_CatST.QuantityYTY,_showVar,_NewLine)#

#FormatCellValue(qmd_CatST.AmountYTY)#

#FormatCellValue(qmd_CatST.AmountYLY)#

#getVar(qmd_CatST.AmountYLY,qmd_CatST.AmountYTY,_showVar,_NewLine)#

#FormatCellValue(qmd_CatST.WeightYTY)#

#FormatCellValue(qmd_CatST.WeightYLY)#

#getVar(qmd_CatST.WeightYLY,qmd_CatST.WeightYTY,_showVar,_NewLine)#

#qmd_DstST.DistributorName#
Distributor Total

#FormatCellValue(qmd_DstST.QuantityMTY)#

#FormatCellValue(qmd_DstST.QuantityMLY)#

#getVar(qmd_DstST.QuantityMLY,qmd_DstST.QuantityMTY,_showVar,_NewLine)#

#FormatCellValue(qmd_DstST.AmountMTY)#

#FormatCellValue(qmd_DstST.AmountMLY)#

#getVar(qmd_DstST.AmountMLY,qmd_DstST.AmountMTY,_showVar,_NewLine)#

#FormatCellValue(qmd_DstST.WeightMTY)#

#FormatCellValue(qmd_DstST.WeightMLY)#

#getVar(qmd_DstST.WeightMLY,qmd_DstST.WeightMTY,_showVar,_NewLine)#

#FormatCellValue(qmd_DstST.QuantityYTY)#

#FormatCellValue(qmd_DstST.QuantityYLY)#

#getVar(qmd_DstST.QuantityYLY,qmd_DstST.QuantityYTY,_showVar,_NewLine)#

#FormatCellValue(qmd_DstST.AmountYTY)#

#FormatCellValue(qmd_DstST.AmountYLY)#

#getVar(qmd_DstST.AmountYLY,qmd_DstST.AmountYTY,_showVar,_NewLine)#

#FormatCellValue(qmd_DstST.WeightYTY)#

#FormatCellValue(qmd_DstST.WeightYLY)#

#getVar(qmd_DstST.WeightYLY,qmd_DstST.WeightYTY,_showVar,_NewLine)#

#qmd_MfrST.ManufacturerName#
Manufacturer Total

#FormatCellValue(qmd_MfrST.QuantityMTY)#

#FormatCellValue(qmd_MfrST.QuantityMLY)#

#getVar(qmd_MfrST.QuantityMLY,qmd_MfrST.QuantityMTY,_showVar,_NewLine)#

#FormatCellValue(qmd_MfrST.AmountMTY)#

#FormatCellValue(qmd_MfrST.AmountMLY)#

#getVar(qmd_MfrST.AmountMLY,qmd_MfrST.AmountMTY,_showVar,_NewLine)#

#FormatCellValue(qmd_MfrST.WeightMTY)#

#FormatCellValue(qmd_MfrST.WeightMLY)#

#getVar(qmd_MfrST.WeightMLY,qmd_MfrST.WeightMTY,_showVar,_NewLine)#

#FormatCellValue(qmd_MfrST.QuantityYTY)#

#FormatCellValue(qmd_MfrST.QuantityYLY)#

#getVar(qmd_MfrST.QuantityYLY,qmd_MfrST.QuantityYTY,_showVar,_NewLine)#

#FormatCellValue(qmd_MfrST.AmountYTY)#

#FormatCellValue(qmd_MfrST.AmountYLY)#

#getVar(qmd_MfrST.AmountYLY,qmd_MfrST.AmountYTY,_showVar,_NewLine)#

#FormatCellValue(qmd_MfrST.WeightYTY)#

#FormatCellValue(qmd_MfrST.WeightYLY)#

#getVar(qmd_MfrST.WeightYLY,qmd_MfrST.WeightYTY,_showVar,_NewLine)#

SELECT SUM(QuantityMTY) QuantityMTY, SUM(WeightMTY) WeightMTY, SUM(AmountMTY) AmountMTY ,SUM(QuantityMLY) QuantityMLY, SUM(WeightMLY) WeightMLY, SUM(AmountMLY) AmountMLY ,SUM(QuantityYTY) QuantityYTY, SUM(WeightYTY) WeightYTY, SUM(AmountYTY) AmountYTY ,SUM(QuantityYLY) QuantityYLY, SUM(WeightYLY) WeightYLY, SUM(AmountYLY) AmountYLY ,COUNT(*) as Cnt FROM qmd_Results SELECT ManufacturerName, COUNT(*) Cnt FROM qmd_Results GROUP BY ManufacturerName

	Month (#DateFormat(_mFromDateTY,"mmm/dd/yyyy")# - #DateFormat(_mToDateTY,"mmm/dd/yyyy")#)		Rolling 12 Months (#DateFormat(_yFromDateTY,"mmm/dd/yyyy")# - #DateFormat(_yToDateTY,"mmm/dd/yyyy")#)
Grand Total	Cases			Dollars			Net Wt				Cases			Dollars			Net Wt
	TY	LY	#ShowVar(_showVar,"%")#	TY	LY	#ShowVar(_showVar,"%")#	TY	LY	#ShowVar(_showVar,"%")#		TY	LY	#ShowVar(_showVar,"%")#	TY	LY	#ShowVar(_showVar,"%")#	TY	LY	#ShowVar(_showVar,"%")#
	#FormatCellValue(qmd_GT.QuantityMTY)#	#FormatCellValue(qmd_GT.QuantityMLY)#	#getVar(qmd_GT.QuantityMLY,qmd_GT.QuantityMTY,_showVar)#	#FormatCellValue(qmd_GT.AmountMTY)#	#FormatCellValue(qmd_GT.AmountMLY)#	#getVar(qmd_GT.AmountMLY,qmd_GT.AmountMTY,_showVar)#	#FormatCellValue(qmd_GT.WeightMTY)#	#FormatCellValue(qmd_GT.WeightMLY)#	#getVar(qmd_GT.WeightMLY,qmd_GT.WeightMTY,_showVar)#		#FormatCellValue(qmd_GT.QuantityYTY)#	#FormatCellValue(qmd_GT.QuantityYLY)#	#getVar(qmd_GT.QuantityYLY,qmd_GT.QuantityYTY,_showVar)#	#FormatCellValue(qmd_GT.AmountYTY)#	#FormatCellValue(qmd_GT.AmountYLY)#	#getVar(qmd_GT.AmountYLY,qmd_GT.AmountYTY,_showVar)#	#FormatCellValue(qmd_GT.WeightYTY)#	#FormatCellValue(qmd_GT.WeightYLY)#	#getVar(qmd_GT.WeightYLY,qmd_GT.WeightYTY,_showVar)#

---> " & _Return & ""> " & FormatCellValue(_Return) & ""> #mid(myString,maxLen+1,len(myString))#">