#foreach($group in $lgreport.getReportGroups()) #if($group.getCount() > 0) #foreach($hit in $group.getHitTracker()) #set($userprofile = $lgreport.loadObjectByField("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	End Date	Class Value	Discount Value	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)	$context.getDate($lg.enddate)	$price	Discount Value	$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")