#foreach($group in $lgreport.getReportGroups()) #if($group.getCount() > 0) #foreach($hit in $group.getHitTracker()) #set($userprofile = $lgreport.loadObjectByField("system","userprofile","id",$hit.id)) #if($userprofile) #set($lg = $group.getLearningGroupData()) #set($studentid = "N/A") #if($userprofile.studentid) $set($studentid = $userprofile.studentid) #end #set($orders = $group.loadAuthorizedOrdersForStudent($userprofile)) #foreach ($order in $orders) #set($cartitem = $order.getItems().get(0)) #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",$lg.id) $group.addMoney("tax",$order.getTax()) $group.addMoney("total",$order.getTotalPrice()) #if($vouchervalue != "N/A") $group.addMoney("voucher",$vouchervalue) #end $group.addMoneyAsString("discount","0") #end #end #set($userprofile = false) #end #set($cols = [1..13]) #set($summary = 5) #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	Student ID	Last Name	First Name	Discount Issuer	Status	Raw Score	Percentage	Payment Date	Payment Method	Payment Amount	HST	Owing
$lg.id	$lg	$context.getDate($lg.startdate)	$context.getDate($lg.enddate)	$studentid	$userprofile.firstName	$userprofile.lastName	N/A	Status	Raw	Percentage	$context.getDate($order.getDate())	$method	$order.getTotalPrice()	$order.getTax()	${D}0.00
Summary of Class ID #$group.getLearningGroupData().getId()		Number of Students	$group.getCount()
	Tax	$group.getMoney("tax","0")
	Total	$group.getMoney("total","0")
	Voucher	$group.getMoney("voucher","0")
	Discount	$group.getMoney("discount","0")