#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..15]) #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

Student ID	Last Name	First Name	Class ID	Class Name	Start Date	Registration Status	Registration Date	Grade	Results	Achievement	Payment Date	Payment Method	Payment Amount	HST	Owing	Discount Amount	Discount Issuer	Voucher Number	Voucher Amount
$studentid	$userprofile.firstName	$userprofile.lastName	$lg.id	$lg	$context.getDate($lg.startdate)	Registration Status	Registration Date	Grade	Results	Achievement	$context.getDate($order.getDate())	$method	$order.getTotalPrice()	$order.getTax()	${D}0.00	${D}0.00	N/A	$vouchernumber	$vouchervalue
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")