RPTDOCV2ÀÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿV'ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ‹ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ©�  ÿÿÿÿÿÿÿÿ1ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ;&ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÂÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿØÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿDÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ$ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿîÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ôÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ;ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿtÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ¢ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿŒ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ!ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ !"ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ°%ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ#ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿB(ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ)ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿR*ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ!+ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ¼,ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ reportdocument CORE_VERSION_2 2.1.3-2.2RC0  page hint version 3 BIRT ENGINE BUILD NUMBER µfile:/vol/sites/festi.netevolved.com/webapps/ROOT/WEB-INF/lib/org.eclipse.birt.runtime_4.2.2.v20130216-1152.jar!/org/eclipse/birt/report/engine/internal/util/BundleVersionUtil.class BIRT ENGINE VERSION 2.6.1ÿÿÿÿ  model {¬íur[Ljava.lang.Object;�ÎXŸs)lxpsrjava.util.HashMapÚÁÃ`ÑF loadFactorI thresholdxp?@ wxp root š¬íur[Ljava.lang.Object;�ÎXŸs)lxpsr java.io.File-¤E äÿLpathtLjava/lang/String;xpt,/vol/sites/festi.netevolved.com/webapps/ROOTw/xp context fromdate s¬íur[Ljava.lang.Object;�ÎXŸs)lxpsr java.sql.DateúFh?5f—xrjava.util.Datehj�KYtxpwH/^’xp moduleManager userManager todate s¬íur[Ljava.lang.Object;�ÎXŸs)lxpsr java.sql.DateúFh?5f—xrjava.util.Datehj�KYtxpwIÿØ€xp beanFactory pageManager searcherManager log out Eclipse BIRT Designer Version 4.3.1.v201309091055 Build <4.3.1.v20130917-1035>in/templates/blank_report.gifauto layoutltr96falseFirst Date in RangeFrom Datestaticdatetrue2013-09-01simpletext-boxUnformattedLast Date in RangeTo Datestaticdatetrue2013-09-30simpletext-boxUnformattedorg.ijsolutions.reporting.EnterMediaEventHandler1idstring2learninggroupstring3${learninggroup:learningGroup.name}string4${learninggroup:learningGroup.startdate}string5${learninggroup:learningGroup.enddate}string6orderdatedate7${orderstatus.name}string8transactionidstring9prepaidstring10${customer:userprofile.studentid}string11${customer:userprofile.lastName}string12billing-address1string13billing-citystring14billing-statestring15billing-zipstring16billing-countrystring17subtotalstring18totalshippingstring19taxfloat20totalfloat21paymentmethodstring22cardnumbermaskedstring23cardexpirydatestring24${customer:userprofile.firstName}string25${customer:userprofile.country}string26feefloat27netfloatidOrder #learninggroupClass ID${learninggroup:learningGroup.name}Class Name${learninggroup:learningGroup.startdate}Start Date${learninggroup:learningGroup.enddate}End DateorderdateOrder Date${orderstatus.name}StatustransactionidTrans IDprepaidVoucher Code${customer:userprofile.studentid}Student ID${customer:userprofile.lastName}Last Namebilling-address1Addressbilling-cityCitybilling-stateStatebilling-zipPostal Codebilling-countryCountrysubtotalSubtotaltotalshippingShippingtaxTaxtotalTotalpaymentmethodPayment MethodcardnumbermaskedCC #cardexpirydateCC Expiry${customer:userprofile.firstName}First Name${customer:userprofile.country}CountryfeeTransaction FeesnetNetbetweenrow["orderdate"]params["fromdate"].valueparams["todate"].value1idstring2learninggroupstring3${learninggroup:learningGroup.name}string4${learninggroup:learningGroup.startdate}string5${learninggroup:learningGroup.enddate}string6orderdatedate7${orderstatus.name}string8transactionidstring9prepaidstring10${customer:userprofile.studentid}string11${customer:userprofile.lastName}string12billing-address1string13billing-citystring14billing-statestring15billing-zipstring16billing-countrystring17subtotalstring18totalshippingstring19taxstring20totalstring21paymentmethodstring22cardnumbermaskedstring23cardexpirydatestring24${customer:userprofile.firstName}string25${customer:userprofile.country}string26feestring27netstringEntermediaData Source1htmlnew Date()]]>"Dates Reported: " + params["fromdate"].value + " to " + params["todate"].valuehtmlstoreOrderidOrder #dataSetRow["id"]stringlearninggroupClass IDdataSetRow["learninggroup"]string${learninggroup:learningGroup.name}Class NamedataSetRow["${learninggroup:learningGroup.name}"]string${learninggroup:learningGroup.startdate}Start DatedataSetRow["${learninggroup:learningGroup.startdate}"]string${learninggroup:learningGroup.enddate}End DatedataSetRow["${learninggroup:learningGroup.enddate}"]stringorderdateOrder DatedataSetRow["orderdate"]date${orderstatus.name}StatusdataSetRow["${orderstatus.name}"]stringtransactionidTrans IDdataSetRow["transactionid"]stringprepaidVoucher CodedataSetRow["prepaid"]string${customer:userprofile.studentid}Student IDdataSetRow["${customer:userprofile.studentid}"]string${customer:userprofile.lastName}Last NamedataSetRow["${customer:userprofile.lastName}"]stringbilling-address1AddressdataSetRow["billing-address1"]stringbilling-cityCitydataSetRow["billing-city"]stringbilling-stateStatedataSetRow["billing-state"]stringbilling-zipPostal CodedataSetRow["billing-zip"]stringbilling-countryCountrydataSetRow["billing-country"]stringsubtotalSubtotaldataSetRow["subtotal"]floattruetotalshippingShippingdataSetRow["totalshipping"]stringtaxTaxdataSetRow["tax"]floatfalsetotalTotaldataSetRow["total"]floattruepaymentmethodPayment MethoddataSetRow["paymentmethod"]stringcardnumbermaskedCC #dataSetRow["cardnumbermasked"]stringcardexpirydateCC ExpirydataSetRow["cardexpirydate"]stringAggregationfloatNewTableGroup1SUMExpressionrow["subtotal"]trueAggregation_1Overall SubtotalfloatSUMExpressionrow["subtotal"]trueAggregation_2floatNewTableGroup1SUMExpressionrow["totalshipping"]trueAggregation_3floatNewTableGroup1SUMExpressionrow["tax"]trueAggregation_4floatNewTableGroup1SUMExpressionrow["total"]trueAggregation_5floatSUMExpressionrow["totalshipping"]trueAggregation_6floatSUMExpressionrow["tax"]trueAggregation_7floatSUMExpressionrow["total"]true${customer:userprofile.firstName}First NamedataSetRow["${customer:userprofile.firstName}"]string${customer:userprofile.country}CountrydataSetRow["${customer:userprofile.country}"]stringfeeTransaction FeesdataSetRow["fee"]floattruenetNetdataSetRow["net"]floattrueAggregation_8floatNewTableGroup1SUMExpressionrow["fee"]trueAggregation_9floatNewTableGroup1SUMExpressionrow["net"]trueAggregation_10floatSUMExpressionrow["fee"]trueAggregation_11floatSUMExpressionrow["net"]trueColumn Binding(dataSetRow["subtotal"]-dataSetRow["fee"]+dataSetRow["tax"])/2floattrueAggregation_12floatNewTableGroup1SUMExpressionrow["Column Binding"]trueAggregation_13floatSUMExpressionrow["Column Binding"]true
NewStyle
NewTableGroup1row["paymentmethod"]row["paymentmethod"]false
OuterGroupif (row["paymentmethod"] == "prepaidcode") "Prepaid Code" else "Credit Card Payments"html
BottomLine-DoublesolidmediumsolidmediumBottomLine-DoubleCurrencyAggregationCurrencyAggregation_3CurrencyAggregation_4Currency$###0.00{RoundingMode=HALF_UP}Aggregation_8Currency$###0.000{RoundingMode=HALF_EVEN}Aggregation_9Currency$###0.00{RoundingMode=HALF_UP}Aggregation_12
NewTableGroup2row["${orderstatus.name}"]row["${orderstatus.name}"]false
BottomLineNewStyle1${orderstatus.name}
idlearninggroup${learninggroup:learningGroup.name}${learninggroup:learningGroup.startdate}${learninggroup:learningGroup.enddate}CustomM/d/yyorderdate${orderstatus.name}prepaid${customer:userprofile.studentid}${customer:userprofile.lastName}${customer:userprofile.firstName}CurrencysubtotalCurrencytaxCurrencytotalCurrency$ #,##0.00{RoundingMode=HALF_UP}feeCurrency$###0.00{RoundingMode=HALF_UP}netCurrency$###0.00{RoundingMode=HALF_UP}Column Bindingpaymentmethodcardnumbermaskedcardexpirydate
boxedcellsautoCurrencyAggregation_1CurrencyAggregation_6CurrencyAggregation_7Currency###0.00{RoundingMode=HALF_UP}Aggregation_10Currency$###0.00{RoundingMode=HALF_UP}Aggregation_11Currency$###0.00{RoundingMode=HALF_UP}Aggregation_13
 3.2.23 ø 2.6.1ÿð style_27 data-format $###0.00{RoundingMode=HALF_UP}ÿÿÿÿ style_26 data-format $###0.00{RoundingMode=HALF_UP}ÿÿÿÿ style_25 data-format ###0.00{RoundingMode=HALF_UP}ÿÿÿÿ style_24 data-format $ #,##0.00{RoundingMode=HALF_UP}ÿÿÿÿ style_22 data-format $ #,##0.00{RoundingMode=HALF_UP}ÿÿÿÿ style_23 data-format $ #,##0.00{RoundingMode=HALF_UP}ÿÿÿÿ style_20 data-format $###0.00{RoundingMode=HALF_UP}ÿÿÿÿ style_21 border-top-width thin can-shrink true border-bottom-width thin border-bottom-style solid border-top-style solid style_2 text-align center background-color rgb(229, 229, 229) font-weight bold font-size larger style_17 data-format $ #,##0.00{RoundingMode=HALF_UP}ÿÿÿÿ style_3 can-shrink true font-weight bold font-size larger style_18 data-format $ #,##0.00{RoundingMode=HALF_UP}ÿÿÿÿ style_4 border-top-width medium can-shrink true border-bottom-width medium border-bottom-style solid border-top-style solid style_19 data-format $###0.00{RoundingMode=HALF_UP}ÿÿÿÿ style_5 can-shrink true border-bottom-width thin border-bottom-style double style_13 font-size larger font-style oblique style_14 data-format M/d/yyÿÿÿÿ style_0 text-indent 0em line-height normal color black text-linethrough none widows 2 font-weight normal font-variant normal text-transform none white-space normal text-overline none orphans 2 font-size 10pt font-style normal word-spacing normal text-underline none font-family sans-serif letter-spacing normal page-break-inside auto style_15 data-format $ #,##0.00{RoundingMode=HALF_UP}ÿÿÿÿ style_1 font-size 12pt style_16 data-format $ #,##0.00{RoundingMode=HALF_UP}ÿÿÿÿ style_6 data-format $ #,##0.00{RoundingMode=HALF_UP}ÿÿÿÿ style_7 data-format $ #,##0.00{RoundingMode=HALF_UP}ÿÿÿÿ style_8 data-format $ #,##0.00{RoundingMode=HALF_UP}ÿÿÿÿ style_9 data-format $###0.00{RoundingMode=HALF_UP}ÿÿÿÿ style_10 data-format !$###0.000{RoundingMode=HALF_EVEN}ÿÿÿÿ style_12 padding-top 3pt can-shrink false border-bottom-style groove style_11 data-format $###0.00{RoundingMode=HALF_UP}ÿÿÿÿ style_0þõö÷ò � Simple MasterPageÈ us-letterÉ in@!ÿÿÿÿ in@&ÿÿÿÿÊ in?Ðÿÿÿÿ in?Ðÿÿÿÿ in?Ðÿÿÿÿ in?ÐÿÿÿÿË autoÕ in?àÿÿÿÿÖ in?àÿÿÿÿ D‚ htmln new Date()ùó :� style_1n Profit Sharing Report t~Œ html�û O"Dates Reported: " + params["fromdate"].value + " to " + params["todate"].value ½o(F æQ çQ èQ éQ êQ ëQ ìQ îQ ïQ ðQ zQ öQ øQ ùQ ‘Q ‰Q ¡Q úQ ûQ üQ ÿÿÿÿÿÿÿþ2 p style_2 qd rn Order # sd tn Class ID ud vn Class Name wd xn Start Date yd zn End Date {d "|n Payment Date }d ~n Status �d "‚n Voucher Code ƒd „n Student ID …d  †n Last Name sd  {n First Name ‘d  ’n Subtotal •d  –n Tax —d  ˜n Total Šd &’n Transaction Fees ‚d ”n Net šd "¢n Profit Share ™d $šn Payment Method ›d œn CC # �d žn CC Expiry pý NewTableGroup1û row["paymentmethod"]() auto* auto- auto+ ÿÿÿÿÿÿÿý2 þ ÿdg noneh ‰2 style_3Œ html�û Uif (row["paymentmethod"] == "prepaidcode") "Prepaid Code" else "Credit Card Payments" dg none dg none dg none dg none dg none dg none dg none dg none  d g none td g none d g none d g none d g none ‹dg none ƒdg none ›dg none dg none dg none dg none ÿÿÿÿÿÿÿü2  style_4  style_5d ¥n TOTALS: d d d d d d d  d !d  xd  'd  ,/ style_6y Aggregation )d  .n style_7y Aggregation_3 *d  .o style_8y Aggregation_4 �d .– style_9y Aggregation_8 ‡d /— style_10y Aggregation_9 Ÿd 0¤ style_11y Aggregation_12 +d ,d -d v3 NewTableGroup2û row["${orderstatus.name}"]() auto* auto- auto+ ÿÿÿÿÿÿÿû2 4 style_12 5dg noneh 5d style_13y ${orderstatus.name} 6dg none 7dg none 8dg none 9dg none :dg none ;dg none =dg none >dg none ?d g none ud g none Ed g none Gd g none Hd g none Œdg none „dg none œdg none Idg none Jdg none Kdg none ÿÿÿÿÿÿÿú2 L Md Nd Od Pd Qd Rd Sd Ud Vd Wd  wd  ]d  _d  `d  Žd †d žd ad bd cd ÿÿÿÿÿÿÿù2 Ÿ  d ¡y id ¢d £y learninggroup ¤d 5¥y #${learninggroup:learningGroup.name} ¦d :§y (${learninggroup:learningGroup.startdate} ¨d 8©y &${learninggroup:learningGroup.enddate} ªd +« style_14y orderdate ¬d %­y ${orderstatus.name} °d ±y prepaid ²d 3³y !${customer:userprofile.studentid} ´d  2µy ${customer:userprofile.lastName} vd  3|y !${customer:userprofile.firstName} Àd  *Á style_15y subtotal Äd  %Å style_16y tax Æd  'Ç style_17y total �d %“ style_18y fee …d %• style_19y net �d 0£ style_20y Column Binding Èd Éy paymentmethod Êd "Ëy cardnumbermasked Ìd Íy cardexpirydate ÿÿÿÿÿÿÿø2 Î style_21 Ïd 4¦‚ auton Overall Total: ù Ðd Ñd Òd Ód Ôd Õd ×d Ød Ùd  yd  ßd  /0 style_22y Aggregation_1 ád  /q style_23y Aggregation_6 âd  /r style_24y Aggregation_7 �d 0˜ style_25y Aggregation_10 ˆd 0™ style_26y Aggregation_11  d 0§ style_27y Aggregation_13 ãd äd ådÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ¼  Simple MasterPage /1.2¼ auto½ us-letter¾ in@&ÿÿÿÿ¿ in@!ÿÿÿÿÀ in?àÿÿÿÿÁ in?àÿÿÿÿÄ in?ÐÿÿÿÿÅ in?ÐÿÿÿÿÆ in?ÐÿÿÿÿÇ in?ÐÿÿÿÿÈéÿÿÿÿÿÿÿÿ /0.-1ÿÿÿÿÿÿÿÿ /1.-1ÿÿÿÿÿÿÿÿC /2.-1ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿá /0.3� text/template‘ ²¬íur[Ljava.lang.Object;�ÎXŸs)lxppsrjava.util.HashMapÚÁÃ`ÑF loadFactorI thresholdxp?@ wt new Date()srjava.util.Datehj�KYtxpwI¥+ÝxxÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿOÿÿÿÿÿÿÿÿ /0.3969ÿÿÿÿÿÿÿÿ¿ÿÿÿÿÿÿÿÿT /1.3966� text/html‘ (Dates Reported: 2014-09-01 to 2014-11-30ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÔù  __bookmark_1 /2.3695è /3814ÿÿÿÿ /3815ÿÿÿÿ /3816ÿÿÿÿ /3817ÿÿÿÿ /3818ÿÿÿÿ /3819ÿÿÿÿ /3820ÿÿÿÿ /3822ÿÿÿÿ /3823ÿÿÿÿ /3824ÿÿÿÿ /3962ÿÿÿÿ /3830ÿÿÿÿ /3832ÿÿÿÿ /3833ÿÿÿÿ /3985ÿÿÿÿ /3977ÿÿÿÿ /4001ÿÿÿÿ /3834ÿÿÿÿ /3835ÿÿÿÿ /3836ÿÿÿÿ¿E /0.-2(QuRs0:0)„Ôÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ /0.3696 ¿èž= __TOC_0 /1.3837(QuRs0:0) creditcardE¥Ú /0.-3(QuRs0:0)„žÿÿÿÿÿÿÿÿ$ /0.3838 # 1.0ÚÿÿÿÿÿÿÿÿI /0.3839ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ@ /0.3890� text/html‘ Credit Card PaymentsEl? __TOC_0_0 /1.3891(QuRs0:0) Authorized¥|< /0.-5(QuRs0:0)„ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ$ /0.3892 # 2.0¥ø¸ /1.-7(QuRs0:0)„|ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ$ /0.3743 # 3.0¥t4 /2.-7(QuRs0:1)„øÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ$ /0.3743 # 3.1¥ð° /3.-7(QuRs0:2)„tÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ$ /0.3743 # 3.2¥ÿÿÿÿÿÿÿÿ, /4.-6(QuRs0:2)„ðÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ$ /0.3916 # 2.0Eÿÿÿÿÿÿÿÿ¨ /2.-4(QuRs0:2)„lÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ$ /0.3862 # 1.0¿ÿÿÿÿÿÿÿÿ$ /2.-8(QuRs0:2)„èÿÿÿÿÿÿÿÿY /0.3790 $ÿÿÿÿÿÿÿÿŽ /0.3791fYÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ* /0.4006Y Overall Total:  QuRs0ÜÜ* id id dataSetRow["id"] Total.OVERALL learninggroup learninggroup dataSetRow["learninggroup"] Total.OVERALL #${learninggroup:learningGroup.name} #${learninggroup:learningGroup.name} 1dataSetRow["${learninggroup:learningGroup.name}"] Total.OVERALL (${learninggroup:learningGroup.startdate} (${learninggroup:learningGroup.startdate} 6dataSetRow["${learninggroup:learningGroup.startdate}"] Total.OVERALL &${learninggroup:learningGroup.enddate} &${learninggroup:learningGroup.enddate} 4dataSetRow["${learninggroup:learningGroup.enddate}"] Total.OVERALL orderdate orderdate dataSetRow["orderdate"] Total.OVERALL ${orderstatus.name} ${orderstatus.name} !dataSetRow["${orderstatus.name}"] Total.OVERALL transactionid transactionid dataSetRow["transactionid"] Total.OVERALL prepaid prepaid dataSetRow["prepaid"] Total.OVERALL !${customer:userprofile.studentid} !${customer:userprofile.studentid} /dataSetRow["${customer:userprofile.studentid}"] Total.OVERALL ${customer:userprofile.lastName} ${customer:userprofile.lastName} .dataSetRow["${customer:userprofile.lastName}"] Total.OVERALL billing-address1 billing-address1 dataSetRow["billing-address1"] Total.OVERALL billing-city billing-city dataSetRow["billing-city"] Total.OVERALL billing-state billing-state dataSetRow["billing-state"] Total.OVERALL billing-zip billing-zip dataSetRow["billing-zip"] Total.OVERALL billing-country billing-country dataSetRow["billing-country"] Total.OVERALL subtotal subtotal dataSetRow["subtotal"] Total.OVERALL totalshipping totalshipping dataSetRow["totalshipping"] Total.OVERALL tax tax dataSetRow["tax"] Total.OVERALL total total dataSetRow["total"] Total.OVERALL paymentmethod paymentmethod dataSetRow["paymentmethod"] Total.OVERALL cardnumbermasked cardnumbermasked dataSetRow["cardnumbermasked"] Total.OVERALL cardexpirydate cardexpirydate dataSetRow["cardexpirydate"] Total.OVERALL Aggregation Aggregation SUM row["subtotal"] Total.OVERALL NewTableGroup1 Aggregation_1 Aggregation_1 SUM row["subtotal"] Total.OVERALL Aggregation_2 Aggregation_2 SUM row["totalshipping"] Total.OVERALL NewTableGroup1 Aggregation_3 Aggregation_3 SUM row["tax"] Total.OVERALL NewTableGroup1 Aggregation_4 Aggregation_4 SUM row["total"] Total.OVERALL NewTableGroup1 Aggregation_5 Aggregation_5 SUM row["totalshipping"] Total.OVERALL Aggregation_6 Aggregation_6 SUM row["tax"] Total.OVERALL Aggregation_7 Aggregation_7 SUM row["total"] Total.OVERALL !${customer:userprofile.firstName} !${customer:userprofile.firstName} /dataSetRow["${customer:userprofile.firstName}"] Total.OVERALL ${customer:userprofile.country} ${customer:userprofile.country} -dataSetRow["${customer:userprofile.country}"] Total.OVERALL fee fee dataSetRow["fee"] Total.OVERALL net net dataSetRow["net"] Total.OVERALL Aggregation_8 Aggregation_8 SUM row["fee"] Total.OVERALL NewTableGroup1 Aggregation_9 Aggregation_9 SUM row["net"] Total.OVERALL NewTableGroup1 Aggregation_10 Aggregation_10 SUM row["fee"] Total.OVERALL Aggregation_11 Aggregation_11 SUM row["net"] Total.OVERALL Column Binding Column Binding >(dataSetRow["subtotal"]-dataSetRow["fee"]+dataSetRow["tax"])/2 Total.OVERALL Aggregation_12 Aggregation_12 SUM row["Column Binding"] Total.OVERALL NewTableGroup1 Aggregation_13 Aggregation_13 SUM row["Column Binding"] Total.OVERALL NewTableGroup1 row["paymentmethod"] NewTableGroup2 row["${orderstatus.name}"] id id java.lang.Stringÿÿÿÿ learninggroup learninggroup java.lang.Stringÿÿÿÿ #${learninggroup:learningGroup.name} #${learninggroup:learningGroup.name} java.lang.Stringÿÿÿÿ (${learninggroup:learningGroup.startdate} (${learninggroup:learningGroup.startdate} java.lang.Stringÿÿÿÿ &${learninggroup:learningGroup.enddate} &${learninggroup:learningGroup.enddate} java.lang.Stringÿÿÿÿ orderdate orderdate java.sql.Dateÿÿÿÿ ${orderstatus.name} ${orderstatus.name} java.lang.Stringÿÿÿÿ transactionid transactionid java.lang.Stringÿÿÿÿ prepaid prepaid java.lang.Stringÿÿÿÿ !${customer:userprofile.studentid} !${customer:userprofile.studentid} java.lang.Stringÿÿÿÿ ${customer:userprofile.lastName} ${customer:userprofile.lastName} java.lang.Stringÿÿÿÿ billing-address1 billing-address1 java.lang.Stringÿÿÿÿ billing-city billing-city java.lang.Stringÿÿÿÿ billing-state billing-state java.lang.Stringÿÿÿÿ billing-zip billing-zip java.lang.Stringÿÿÿÿ billing-country billing-country java.lang.Stringÿÿÿÿ subtotal subtotal java.lang.Stringÿÿÿÿ totalshipping totalshipping java.lang.Stringÿÿÿÿ tax tax java.lang.Doubleÿÿÿÿ total total java.lang.Doubleÿÿÿÿ paymentmethod paymentmethod java.lang.Stringÿÿÿÿ cardnumbermasked cardnumbermasked java.lang.Stringÿÿÿÿ cardexpirydate cardexpirydate java.lang.Stringÿÿÿÿ !${customer:userprofile.firstName} !${customer:userprofile.firstName} java.lang.Stringÿÿÿÿ ${customer:userprofile.country} ${customer:userprofile.country} java.lang.Stringÿÿÿÿ fee fee java.lang.Doubleÿÿÿÿ net net java.lang.Doubleÿÿÿÿ WEB0000024 festi1I¢_`€ Authorized Smith 484 Napier Collingwood Ontario L9y3t7 Canada 943.83 0.00@�~£× =q creditcard ***************4242 12/18 Tom Canada@;«…¸Qì@Œ¡G®zá WEB0000023 festi1H�ÄR Authorized Smith 484 Napier Collingwood Alberta L9y3t7 Canada 199.00 6.00@i  creditcard ************4242 06/18 Tom Canada WEB0000021 festi1H�ÄR Authorized Smith 484 Napier Collingwood Ontario L9Y3T7 Canada 200.63 0.00@i(õÂ�\ creditcard ************4242 08/19 Tom Canada#/.^޾îN~®Þ@q¢ Aggregation SUM@”ý× =p¤ Aggregation_9 SUM@Œ¡G®zá Aggregation_8 SUM@;«…¸Qì Aggregation_7 SUM@•× =p¤ Aggregation_6 SUM Aggregation_5 SUM@ Aggregation_4 SUM@•× =p¤ Aggregation_3 SUM Aggregation_2 SUM@ Aggregation_1 SUM@”ý× =p¤ Aggregation_13 SUM@„�(õÂ�\ Aggregation_12 SUM@„�(õÂ�\ Aggregation_11 SUM@Œ¡G®zá Aggregation_10 SUM@;«…¸Qìÿÿÿÿ __Version : 3.0ÿÿÿÿ@ /ÿÿÿÿÿÿÿÿÿÿÿÿÿÿ€0 __TOC_0 creditcardýÿÿÿÿÿÿÿÿÿÿ2 __TOC_0_0 Authorized3ÿÿ Column Binding billing-city billing-city total total billing-zip billing-zip billing-country billing-country net net paymentmethod paymentmethod billing-state billing-state id id ${customer:userprofile.lastName} ${customer:userprofile.lastName} transactionid transactionid totalshipping totalshipping cardexpirydate cardexpirydate &${learninggroup:learningGroup.enddate} &${learninggroup:learningGroup.enddate} !${customer:userprofile.studentid} !${customer:userprofile.studentid} prepaid prepaid (${learninggroup:learningGroup.startdate} (${learninggroup:learningGroup.startdate} learninggroup learninggroup orderdate orderdate ${orderstatus.name} ${orderstatus.name} subtotal subtotal #${learninggroup:learningGroup.name} #${learninggroup:learningGroup.name} !${customer:userprofile.firstName} !${customer:userprofile.firstName} fee fee ${customer:userprofile.country} ${customer:userprofile.country} tax tax cardnumbermasked cardnumbermasked billing-address1 billing-address1T@|¡G®zâ@Xà@Y(õÂ�\ + id dataSetRow["id"] learninggroup dataSetRow["learninggroup"] #${learninggroup:learningGroup.name} 1dataSetRow["${learninggroup:learningGroup.name}"] (${learninggroup:learningGroup.startdate} 6dataSetRow["${learninggroup:learningGroup.startdate}"] &${learninggroup:learningGroup.enddate} 4dataSetRow["${learninggroup:learningGroup.enddate}"] orderdate dataSetRow["orderdate"] ${orderstatus.name} !dataSetRow["${orderstatus.name}"] transactionid dataSetRow["transactionid"] prepaid dataSetRow["prepaid"] !${customer:userprofile.studentid} /dataSetRow["${customer:userprofile.studentid}"] ${customer:userprofile.lastName} .dataSetRow["${customer:userprofile.lastName}"] billing-address1 dataSetRow["billing-address1"] billing-city dataSetRow["billing-city"] billing-state dataSetRow["billing-state"] billing-zip dataSetRow["billing-zip"] billing-country dataSetRow["billing-country"] subtotal dataSetRow["subtotal"] totalshipping dataSetRow["totalshipping"] tax dataSetRow["tax"] total dataSetRow["total"] paymentmethod dataSetRow["paymentmethod"] cardnumbermasked dataSetRow["cardnumbermasked"] cardexpirydate dataSetRow["cardexpirydate"] Aggregation Aggregation_1 Aggregation_2 Aggregation_3 Aggregation_4 Aggregation_5 Aggregation_6 Aggregation_7 !${customer:userprofile.firstName} /dataSetRow["${customer:userprofile.firstName}"] ${customer:userprofile.country} -dataSetRow["${customer:userprofile.country}"] fee dataSetRow["fee"] net dataSetRow["net"] Aggregation_8 Aggregation_9 Aggregation_10 Aggregation_11 Column Binding >(dataSetRow["subtotal"]-dataSetRow["fee"]+dataSetRow["tax"])/2 Aggregation_12 Aggregation_13 _$$_dte_inner_row_id_$$_ dataSetRow._rowPosition¬ Simple MasterPage Simple MasterPage /0.3969  /2.3695¿ /2.-8(QuRs0:2)è /0.3790$ /19.3813ÿÿÿÿÿÿÿÿ __version__2 -1 3695 QuRs0 -1/Data/hierarchy/DataEngine/NamingRelation(/DataEngine/QueryIdBasedVersioningStream /DataEngine/VesionInfo /QuRs0/AggrIndex/QuRs0/AggrValue/QuRs0/DataSetData/QuRs0/DataSetLens/QuRs0/ExprMetaInfo/QuRs0/ExprRowLen/QuRs0/ExprValue/QuRs0/GroupInfo/QuRs0/QueryDefn/QuRs0/ResultClass /bookmark/content/content.dat /content/page.dat /content/page.idx /core/dataEngine/queryStartingID/design /design.ir/pages /pages_index /reportlet/reportletBookmarks/toc  __bookmark_1 QuRs0  3695 QuRs0 __TOC_0_0¥ __TOC_0E __bookmark_1¿ /2.3695¿ __TOC_0_0 __TOC_0_03 __TOC_0__TOC_0ý __bookmark_1 __bookmark_1o