RPTDOCV2ÀÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿV#ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ‹ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ�Ø  ÿÿÿÿÿÿÿÿÿÿÿÿ'v ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ;"ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÂÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿDÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ!ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ¬ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ nÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿDÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ~ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ�ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ° ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ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ÉÝZxp 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}stringEntermediaData 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"]stringtotalshippingShippingdataSetRow["totalshipping"]stringtaxTaxdataSetRow["tax"]stringtotalTotaldataSetRow["total"]stringpaymentmethodPayment 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}"]string
NewStyle
NewTableGroup1row["paymentmethod"]row["paymentmethod"]false
OuterGroupif (row["paymentmethod"] == "prepaidcode") "Prepaid Code" else "Credit Card Payments"html
BottomLine-DoubleBottomLine-DoubleCurrencyAggregationCurrencyAggregation_3CurrencyAggregation_4
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}CurrencysubtotalCurrencytaxCurrencytotalpaymentmethodcardnumbermaskedcardexpirydate
boxedcellsCurrencyAggregation_1CurrencyAggregation_6CurrencyAggregation_7
 3.2.23 ø 2.6.1ÿð style_17 data-format $ #,##0.00{RoundingMode=HALF_UP}ÿÿÿÿ style_2 text-align center background-color rgb(229, 229, 229) font-weight bold font-size larger style_3 can-shrink true font-weight bold font-size larger style_4 can-shrink true border-bottom-width thin border-bottom-style double style_5 data-format $ #,##0.00{RoundingMode=HALF_UP}ÿÿÿÿ style_13 data-format $ #,##0.00{RoundingMode=HALF_UP}ÿÿÿÿ style_14 border-top-width thin can-shrink true border-bottom-width thin border-bottom-style solid border-top-style solid style_15 data-format $ #,##0.00{RoundingMode=HALF_UP}ÿÿÿÿ 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_16 data-format $ #,##0.00{RoundingMode=HALF_UP}ÿÿÿÿ style_1 font-size 12pt style_6 data-format $ #,##0.00{RoundingMode=HALF_UP}ÿÿÿÿ style_7 data-format $ #,##0.00{RoundingMode=HALF_UP}ÿÿÿÿ style_8 padding-top 3pt can-shrink false border-bottom-style groove style_9 font-size larger font-style oblique style_10 data-format M/d/yyÿÿÿÿ style_12 data-format $ #,##0.00{RoundingMode=HALF_UP}ÿÿÿÿ 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()ùó 3� style_1n Revenue 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 ÿÿÿÿÿÿÿþ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 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 ÿÿÿÿÿÿÿü2  style_4  style_4d d d d d d d d  d !d  xd  'd  ,/ style_5y Aggregation )d  .n style_6y Aggregation_3 *d  .o style_7y Aggregation_4 +d ,d -d v3 NewTableGroup2û row["${orderstatus.name}"]() auto* auto- auto+ ÿÿÿÿÿÿÿû2 4 style_8 5dg noneh 4d style_9y ${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 Idg none Jdg none Kdg none ÿÿÿÿÿÿÿú2 L Md Nd Od Pd Qd Rd Sd Ud Vd Wd  wd  ]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_10y 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_11y subtotal Äd  %Å style_12y tax Æd  'Ç style_13y total Èd Éy paymentmethod Êd "Ëy cardnumbermasked Ìd Íy cardexpirydate ÿÿÿÿÿÿÿø2 Î style_14 Ïd Ðd Ñd Òd Ód Ôd Õd ×d Ød Ùd  yd  ßd  /0 style_15y Aggregation_1 ád  /q style_16y Aggregation_6 âd  /r style_17y Aggregation_7 ã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-10-01 to 2014-11-30ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ�´  __bookmark_1 /2.3695è /3814ÿÿÿÿ /3815ÿÿÿÿ /3816ÿÿÿÿ /3817ÿÿÿÿ /3818ÿÿÿÿ /3819ÿÿÿÿ /3820ÿÿÿÿ /3822ÿÿÿÿ /3823ÿÿÿÿ /3824ÿÿÿÿ /3962ÿÿÿÿ /3830ÿÿÿÿ /3832ÿÿÿÿ /3833ÿÿÿÿ /3834ÿÿÿÿ /3835ÿÿÿÿ /3836ÿÿÿÿ¿Ë /0.-2(QuRs0:0)„�ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ /0.3696 ¿«Y= __TOC_0 /1.3837(QuRs0:0) creditcard`• /0.-3(QuRs0:0)„YÿÿÿÿÿÿÿÿÕ$ /0.3838 # 1.0•ÿÿÿÿÿÿÿÿ /0.3839Õÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ@ /0.3890� text/html‘ Credit Card Payments/»? __TOC_0_0 /1.3891(QuRs0:0) Authorized`7÷ /0.-5(QuRs0:0)„»ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ$ /0.3892 # 2.0`³s /1.-7(QuRs0:0)„7ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ$ /0.3743 # 3.0`ÿÿÿÿÿÿÿÿï /2.-6(QuRs0:0)„³ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ$ /0.3916 # 2.0ÿÿÿÿÿÿÿÿk /2.-4(QuRs0:0)„/ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ$ /0.3862 # 1.0¿ÿÿÿÿÿÿÿÿç /2.-8(QuRs0:0)„«ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ /0.3790   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 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ÿÿÿÿ WEB0000024 festi1I¢_`€ Authorized Smith 484 Napier Collingwood Ontario L9y3t7 Canada 943.83 0.00@�~£× =q creditcard ***************4242 12/18 Tom Canada0`�ÀîN~ Aggregation_7 SUM@�~£× =q Aggregation_6 SUM Aggregation_5 SUM Aggregation_4 SUM@�~£× =q Aggregation SUM@�~£× =q Aggregation_3 SUM Aggregation_2 SUM Aggregation_1 SUM@�~£× =qÿÿÿÿ __Version : 3.0ÿÿÿÿ@ /ÿÿÿÿÿÿÿÿÿÿÿÿÿÿ€0 __TOC_0 creditcardýÿÿÿÿÿÿÿÿÿÿ2 __TOC_0_0 Authorized3ÿÿ billing-city billing-city total total billing-zip billing-zip billing-country billing-country 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} ${customer:userprofile.country} ${customer:userprofile.country} tax tax cardnumbermasked cardnumbermasked billing-address1 billing-address1" 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}"] _$$_dte_inner_row_id_$$_ dataSetRow._rowPosition¬ Simple MasterPage /0.3969  /2.3695¿ /2.-8(QuRs0:0)« /0.3790ç /16.3813ÿÿÿÿÿÿÿÿ Simple MasterPage __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_0 __bookmark_1¿ /2.3695¿ __TOC_0_0 __TOC_0_03 __TOC_0__TOC_0ý __bookmark_1 __bookmark_1o