#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()) #end #end #set($userprofile = false) #end #set($cols = [1..11]) #set($summary = 3) #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	First Name	Last Name	Status	Grading	Results	Achievement	Payment Status	Payment Amount	Payment Date
$lg.id	$lg	$context.getDate($lg.startdate)	$context.getDate($lg.enddate)	$studentid	$userprofile.firstName	$userprofile.lastName	Status	Grade	Results	Achievement	$method	$order.getTotalPrice()	$context.getDate($order.getDate())
Summary of Class ID #$group.getLearningGroupData().getId()		Number of Students	$group.getCount()
	Tax	$group.getMoney("tax","0")
	Total	$group.getMoney("total","0")