#foreach($group in $areport.getReportGroups()) #if($group.getCount() > 0) #foreach($hit in $group.getHitTracker()) #set($order = $group.load($hit)) #set($cartitem = $order.getItems().get(0)) #set($classlist = $cartitem.getProduct().get("classlist")) #set($classdata = $areport.loadObjectByField("learningGroup","id",$classlist)) #set($product = $cartitem.getProduct()) #set($method = "") #set($vouchernumber = "N/A") #set($vouchervalue = "N/A") #if($order.getPaymentMethod().getType() == "prepaidcode") #set($method = "Voucher") #set($vouchernumber = $order.getPaymentMethod().getPrepaidCode()) #set($vouchervalue = $order.getSubTotal()) #elseif($order.getPaymentMethod().getType() == "creditcard") #set($method = $order.getPaymentMethod().getCreditCardType()) #end #set($price = "N/A") #if($product.getPriceSupport().getRetailPrice()) #set($price = $product.getPriceSupport().getRetailPrice()) #end $group.incrementUniqueCount("classid",$cartitem.getSku()) $group.addMoney("tax",$order.getTax()) $group.addMoney("total",$order.getTotalPrice()) #if($vouchervalue != "N/A") $group.addMoney("voucher",$vouchervalue) #end $group.addMoneyAsString("discount","0") $group.addMoneyAsString("accommodations","0") $group.addMoneyAsString("travel","0") $group.addMoneyAsString("meals","0") #end #set($cols = [1..11]) #set($summary = 9) #foreach($i in $cols) #end #foreach($i in $cols) #end #foreach($i in $cols) #end #foreach($i in $cols) #end #foreach($i in $cols) #end #foreach($i in $cols) #end #foreach($i in $cols) #end #foreach($i in $cols) #end #foreach($i in $cols) #end #end #end

Class ID	Class Name	Start Date	End Date	Class Value	Payment Date	Payment Method	Payment Amount	HST	Owing	Discount Amount	Discount Issuer	Voucher Number	Voucher Amount
$cartitem.getSku()	$cartitem.getName()	$!context.getDate($classdata.startdate)	$!context.getDate($classdata.enddate)	$price	$context.getDate($order.getDate())	$method	$order.getTotalPrice()	$order.getTax()	${D}0.00	${D}0.00	N/A	$vouchernumber	$vouchervalue
Summary		Number of Orders	$group.getCount()
	Number of Unique Classes	$group.sumAllUniqueOccurrences("classid")
	Tax	$group.getMoney("tax","0")
	Total	$group.getMoney("total","0")
	Voucher	$group.getMoney("voucher","0")
	Discount	$group.getMoney("discount","0")
	Accommodations	$group.getMoney("accommodations","0")
	Travel	$group.getMoney("travel","0")
	Meals	$group.getMoney("meals","0")