xmldatasource xmldatasource reports/manager_report.xml AllLedgers name,System.String type,System.String TotalAmount,System.Nullable`1[System.Decimal] PTD,System.Nullable`1[System.Decimal] YTD,System.Nullable`1[System.Decimal] LedgerType,System.String sort,System.Int32 sortbyLedgerType,System.Int32 AllLedgers xmldatasource.allLedger Ledgers ADVopening_blance,System.String ADVcredits,System.String ADVdebits,System.String ADVclosing_balance,System.String Cityopening_blance,System.String Cityptd_opening_blance,System.String Cityytd_opening_blance,System.String Citycredit,System.String Cityptd_credit,System.String Cityytd_credit,System.String Citydebit,System.String Cityptd_debit,System.String Cityytd_debit,System.String Cityclosing_balance,System.String GuestbalanceBF,System.String GuestADTOGL,System.String Guestcharges,System.String Guestcredits,System.String Guestbalance,System.String GuestCarryForwardAdvDep,System.String Ledgers xmldatasource.ledger gropuvalues totalrooms,System.Decimal blockedrooms,System.Decimal ptdblockrooms,System.Decimal ytdblockrooms,System.Decimal totaladult,System.Nullable`1[System.Decimal] totalchild,System.Nullable`1[System.Decimal] ptdadult,System.Nullable`1[System.Decimal] ptdchild,System.Nullable`1[System.Decimal] ytdadult,System.Nullable`1[System.Decimal] ytdchild,System.Nullable`1[System.Decimal] totalreservations,System.Nullable`1[System.Decimal] totalreservationsptd,System.Nullable`1[System.Decimal] totalreservationsytd,System.Nullable`1[System.Decimal] totalnoshow,System.Nullable`1[System.Decimal] totalnoshowptd,System.Nullable`1[System.Decimal] totalnoshowytd,System.Nullable`1[System.Decimal] blockedroomsSection,System.Decimal ptdblockroomsSection,System.Decimal ytdblockroomsSection,System.Decimal totalroomsSection,System.Decimal ptdtotalrooms,System.Decimal ytdtotalrooms,System.Decimal gropuvalues xmldatasource.groupvalues DataSource1 particulars,System.String today,System.String ptd,System.String ytd,System.String totalpayment,System.String totaldata,System.String totalrevenue,System.String roomsummary,System.String totalroom,System.String blockroom,System.String noofguestadultchild,System.String totavailroomnights,System.String soldroom,System.String dayuseroom,System.String complimentaryroom,System.String noshowrooms,System.String avgguestperroom,System.String noofresconfirm,System.String noofresunconfirm,System.String noofwalkins,System.String statistics,System.String occupancyrate,System.String averagedailyrate,System.String revenueperavailroom,System.String cityledger,System.String openingbalance,System.String paymentreceived,System.String chargesraised,System.String closingbalance,System.String advancedepcollected,System.String baltransfertoguestledger,System.String carryforwardedadvdeposit,System.String chargepostedtoguestledger,System.String settlementbyguest,System.String transferfromadvdeposit,System.String guestledgerclosingbal,System.String printedon,System.String printedby,System.String title,System.String asondate,System.String status,System.String advancedepositledger,System.String guestledger,System.String DataSource1 xmldatasource.column Category1,user,user,System.String,,False,False Category1,hotel,hotel,System.String,,False,False Category1,date,date,manager_x0020_ledger_x0020_date,System.String,,False,False,False Category1,currency,currency,currency,System.String,,False,False,False Category1,hotel_code,hotel_code,System.String,,False,False Category1,firstdayofthemonth,firstdayofthemonth,System.String,,False,False Category1,firstdayoftheyear,firstdayoftheyear,System.String,,False,False Category1,ptddays,ptddays,System.Int32,_x0030_,False,False Category1,ytddays,ytddays,System.Int32,_x0030_,False,False Category1,totalroomssold,totalroomssold,System.Nullable`1[System.Decimal],_x0030_,False,False Category1,totalroomssoldptd,totalroomssoldptd,System.Nullable`1[System.Decimal],_x0030_,False,False Category1,totalroomssoldytd,totalroomssoldytd,System.Nullable`1[System.Decimal],_x0030_,False,False Category1,dayuserooms,dayuserooms,System.Nullable`1[System.Decimal],,False,False Category1,dayuseroomsptd,dayuseroomsptd,System.Nullable`1[System.Decimal],,False,False Category1,dayuseroomsytd,dayuseroomsytd,System.Nullable`1[System.Decimal],,False,False Category1,complimentoryrooms,complimentoryrooms,System.Nullable`1[System.Decimal],,False,False Category1,complimentoryroomsptd,complimentoryroomsptd,System.Nullable`1[System.Decimal],,False,False Category1,complimentoryroomsytd,complimentoryroomsytd,System.Nullable`1[System.Decimal],,False,False Category1,temp,temp,System.String,,False,False Category1,localdatetime,localdatetime,localdatetime,System.String,,False,False,False Category1,decimalpoint,decimalpoint,decimalpoint,System.Int32,,False,False,False Category1,dateformate,dateformate,System.String,,False,False Category1,numofreservation,numofreservation,numofreservation,System.Decimal,,False,False,False Category1,numofreservationptd,numofreservationptd,numofreservationptd,System.Nullable`1[System.Decimal],,False,False,False Category1,numofreservationytd,numofreservationytd,numofreservationytd,System.Nullable`1[System.Decimal],,False,False,False Category1,ignorezero,ignorezero,System.Int32,_x0031_,False,False Category1,fdate,fdate,System.String,,False,False ,sortmaxval,sortmaxval,System.Int32,,False,False GroupTotal,TotalGrevenue,TotalGrevenue,TotalGrevenue,System.Decimal,,False,False,False GroupTotal,TotalGPTDrevenue,TotalGPTDrevenue,TotalGPTDrevenue,System.Decimal,,False,False,False GroupTotal,TotalGYTDrevenue,TotalGYTDrevenue,TotalGYTDrevenue,System.Decimal,,False,False,False GroupTotal,TotalRevenue,TotalRevenue,System.Decimal,,False,False ,TotalRevenueToday,TotalRevenueToday,System.Decimal,,False,False ,TotalRevenuePTD,TotalRevenuePTD,System.Decimal,,False,False ,TotalRevenueYTD,TotalRevenueYTD,System.Decimal,,False,False cityledger,ShowCityLedgerPostingInvoice,ShowCityLedgerPostingInvoice,ShowCityLedgerPostingInvoice,System.Int32,_x0031_,False,False,False ,CarryForwardAdvDep,CarryForwardAdvDep,System.String,,False,False ,numofreservationwalkin,numofreservationwalkin,System.Decimal,,False,False ,numofreservationwalkinptd,numofreservationwalkinptd,System.Decimal,,False,False ,numofreservationwalkinytd,numofreservationwalkinytd,System.Decimal,,False,False ,numofreservationunconfirm,numofreservationunconfirm,System.Decimal,,False,False ,numofreservationunconfirmptd,numofreservationunconfirmptd,System.Decimal,,False,False ,numofreservationunconfirmytd,numofreservationunconfirmytd,System.Decimal,,False,False EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.2,7.67,1 Transparent True True 0,0,5.6,0.4 Verdana,12,Bold 0,0,0,0 Text5 {hotel} [0:0:92] HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Center Transparent True 5.6,0,2,0.4 Verdana,14,Bold Right 0,0,0,0 Text6 {IIF(DataSource1.status=="MANUAL",DataSource1.title,"Manager Report")} [141:43:43] HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Center Top, Bottom;Black;1;Solid;False;4;Black Transparent 0,0.4,7.6,0.3 Verdana,8,Italic 0,0,0,0 Text41 Black True Transparent True 0,0.4,0.8,0.3 Verdana,8,Bold|Italic 0,0,0,0 Text51 {IIF(DataSource1.status=="MANUAL",DataSource1.asondate,"As on Date")} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Center Transparent True 0.8,0.4,0.8,0.3 Verdana,8,Italic 0,0,0,0 Text24 {fdate} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Center Transparent True 0,0.8,1.9,0.2 Verdana,8,Bold 0,0,0,0 Text42 {IIF(DataSource1.status=="MANUAL",DataSource1.particulars,"Particulars")} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Transparent True 2,0.8,1.6,0.2 Verdana,8,Bold Right 0,0,0,0 Text113 {IIF(DataSource1.status=="MANUAL",DataSource1.today,"Today")} ({currency}) Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Transparent True 3.8,0.8,1.6,0.2 Verdana,8,Bold Right 0,0,0,0 Text39 {IIF(DataSource1.status=="MANUAL",DataSource1.ptd,"PTD")} ({currency}) Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Transparent True 5.6,0.8,1.6,0.2 Verdana,8,Bold Right 0,0,0,0 Text40 {IIF(DataSource1.status=="MANUAL",DataSource1.ytd,"YTD")} ({currency}) Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Transparent True 1.9,0.4,0.9,0.3 Verdana,8,Italic 0,0,0,0 Text4 {firstdayofthemonth} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Center Transparent True 1.6,0.4,0.3,0.3 Verdana,8,Bold|Italic 0,0,0,0 Text26 {IIF(DataSource1.status=="MANUAL",DataSource1.ptd,"PTD")} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Center Transparent True 3.6,0.4,1,0.3 Verdana,8,Italic 0,0,0,0 Text119 {firstdayoftheyear} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Center Transparent True 2.9,0.4,0.7,0.3 Verdana,8,Bold|Italic 0,0,0,0 Text120 {IIF(DataSource1.status=="MANUAL",DataSource1.ytd,"YTD")} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Center 0,1,7.6,0.01 Black Black HorizontalLinePrimitive1 Black PageHeaderBand1 Top;Black;1;Solid;False;4;Black Transparent 0,22.28,7.67,0.3 Transparent 3.2,0.11,0.7,0.2 Verdana,8,Bold Right 0,0,0,0 Text23 {IIF(DataSource1.status=="MANUAL",DataSource1.printedby,"Printed By")} Black Transparent 3.9,0.11,1,0.2 Verdana,8 0,0,0,0 Text2 {user} Black Transparent 0,0.11,0.8,0.2 Verdana,8,Bold 0,0,0,0 Text1 {IIF(DataSource1.status=="MANUAL",DataSource1.printedon,"Printed On")} Black Transparent 0.8,0.11,1.5,0.2 Verdana,8 Center 0,0,0,0 Text8 {localdatetime} Black yyyy/MM/dd hh:mm:ss Transparent 6.7,0.11,0.9,0.2 Verdana,8,Bold 0,0,0,0 Text3 {PageNofM} Black PageFooterBand1 Transparent 9.3,9.3,0.6,0.2 Verdana,8 0,0,0,0 Text46 {Variable1} Black Transparent 8.2,9.3,1.1,0.2 Verdana,8 0,0,0,0 Text47 Variable1 Black Transparent 0,1.6,7.67,0.2 Transparent True 0,0,1.9,0.2 Verdana,8,Bold 0,0,0,0 Text56 {AllLedgers.LedgerType} Black Bottom {AllLedgers.sort} GroupHeaderBand1 None Transparent 0,2.2,7.67,0.2 Transparent 0,0,1.9,0.2 Verdana,8 0,0,0,0 Text57 {AllLedgers.name} Black Center Transparent 2,0,1.6,0.2 Verdana,8 Right 0,0,0,0 Text58 {Replace(Format("{0:N" + decimalpoint + "}",AllLedgers.TotalAmount), " ", ",")} Black Center Transparent 3.8,0,1.6,0.2 Verdana,8 Right 0,0,0,0 Text59 {Replace(Format("{0:N" + decimalpoint + "}",AllLedgers.PTD), " ", ",")} Black Center Transparent 5.6,0,1.6,0.2 Verdana,8 Right 0,0,0,0 Text60 {Replace(Format("{0:N" + decimalpoint + "}",AllLedgers.YTD), " ", ",")} Black Center Transparent 7.2,0,0.2,0.2 Verdana,8 Right 0,0,0,0 Text121 {TotalGrevenue =IIF(AllLedgers.sort < 1,Sum(AllLedgers.TotalAmount),TotalGrevenue)} {TotalGPTDrevenue =IIF(AllLedgers.sort < 1,Sum(AllLedgers.PTD),TotalGPTDrevenue)} {TotalGYTDrevenue =IIF(AllLedgers.sort < 1,Sum(AllLedgers.YTD),TotalGYTDrevenue)} {TotalRevenueToday = TotalRevenueToday+IIF(AllLedgers.sortbyLedgerType< 5,AllLedgers.TotalAmount,0)} {TotalRevenuePTD= TotalRevenuePTD+IIF(AllLedgers.sortbyLedgerType< 5,AllLedgers.PTD,0)} {TotalRevenueYTD = TotalRevenueYTD+IIF(AllLedgers.sortbyLedgerType< 5,AllLedgers.YTD,0)} EmptyBrush Center Transparent 7.4,0,0.2,0.2 Verdana,8,Italic 0,0,0,0 Text127 {AllLedgers.sort} EmptyBrush Center AllLedgers DataBand4 Top, Bottom;Black;1;Dash;False;4;Black Transparent 0,2.8,7.67,0.2 Transparent 0,0,1.9,0.2 Verdana,8,Bold 0,0,0,0 Text122 {IIF(AllLedgers.sortbyLedgerType== 5,IIF(DataSource1.status=="MANUAL",DataSource1.totalpayment,"Total Payment"),IIF(DataSource1.status=="MANUAL",DataSource1.totaldata,"Total"))} Black Center Transparent 2,0,1.6,0.2 Verdana,8 Right 0,0,0,0 Text123 {Replace(Format("{0:N"+ decimalpoint +"}", Sum(AllLedgers.TotalAmount)), " ", ",")} Black Center Transparent 3.8,0,1.6,0.2 Verdana,8 Right 0,0,0,0 Text124 {Replace(Format("{0:N"+ decimalpoint +"}", Sum(AllLedgers.PTD)), " ", ",")} Black Center Transparent 5.6,0,1.6,0.2 Verdana,8 Right 0,0,0,0 Text125 {Replace(Format("{0:N" + decimalpoint + "}",Sum(AllLedgers.YTD)), " ", ",")} Black Center Top;Black;1;Dash;False;4;Black Transparent 0,0.2,7.6,0.2 Transparent 0,0,1.9,0.2 Verdana,8,Bold 0,0,0,0 Text126 {IIF(DataSource1.status=="MANUAL",DataSource1.totalrevenue,"Total Revenue")} Black Center Transparent 2,0,1.6,0.2 Verdana,8 Right 0,0,0,0 Text61 {Replace(Format("{0:N"+ decimalpoint +"}", TotalRevenueToday), " ", ",")} Black Center Transparent 3.8,0,1.6,0.2 Verdana,8 Right 0,0,0,0 Text62 {Replace(Format("{0:N"+ decimalpoint +"}", TotalRevenuePTD), " ", ",")} Black Center Transparent 5.6,0,1.6,0.2 Verdana,8 Right 0,0,0,0 Text63 {Replace(Format("{0:N"+ decimalpoint +"}", TotalRevenueYTD), " ", ",")} Black Center _x007B_AllLedgers_x002E_sortbyLedgerType_x0021__x003D_sortmaxval_x007D_,Red,Transparent,Arial_x002C_10,False,False,,,None Panel1 GroupFooterBand2 Transparent 0,3.4,7.67,2 Transparent 0,0.2,1.9,0.2 Verdana,8 0,0,0,0 Text66 {IIF(DataSource1.status=="MANUAL",DataSource1.totalroom,"Total Room")} Black Center Transparent 0,0.4,1.9,0.2 Verdana,8 0,0,0,0 Text68 {IIF(DataSource1.status=="MANUAL",DataSource1.blockroom,"Block Room")} Black Center Transparent 0,0.6,1.9,0.2 Verdana,8 0,0,0,0 Text70 {IIF(DataSource1.status=="MANUAL",DataSource1.noofguestadultchild,"No of Guest (Adult/Child)")} Black Center Transparent 0,0.8,1.9,0.2 Verdana,8 0,0,0,0 Text72 {IIF(DataSource1.status=="MANUAL",DataSource1.totavailroomnights,"Total Available Room nights")} Black Center Transparent 0,1,1.9,0.2 Verdana,8 0,0,0,0 Text82 {IIF(DataSource1.status=="MANUAL",DataSource1.soldroom,"Sold Room")} Black Center Transparent 0,1.2,1.9,0.2 Verdana,8 0,0,0,0 Text83 {IIF(DataSource1.status=="MANUAL",DataSource1.dayuseroom,"Day Use Room")} Black Center Transparent 0,1.4,1.9,0.2 Verdana,8 0,0,0,0 Text84 {IIF(DataSource1.status=="MANUAL",DataSource1.complimentaryroom,"Complimentary Room")} Black Center Transparent 0,1.6,1.9,0.2 Verdana,8 0,0,0,0 Text67 {IIF(DataSource1.status=="MANUAL",DataSource1.noshowrooms,"No Show Rooms")} Black Center Transparent 0,1.8,1.9,0.2 Verdana,8 0,0,0,0 Text69 {IIF(DataSource1.status=="MANUAL",DataSource1.avgguestperroom,"Average Guest Per Room")} Black Center Transparent 2.1,0.2,1.5,0.2 Verdana,8 Right 0,0,0,0 Text71 {gropuvalues.totalrooms} Black Center Transparent 5.6,0.2,1.6,0.2 Verdana,8 Right 0,0,0,0 Text74 {gropuvalues.ytdtotalrooms} Black Center Transparent 3.8,0.2,1.6,0.2 Verdana,8 Right 0,0,0,0 Text73 {gropuvalues.ptdtotalrooms} Black Center Transparent 2.1,0.4,1.5,0.2 Verdana,8 Right 0,0,0,0 Text75 {gropuvalues.blockedroomsSection} Black Center Transparent 5.6,0.4,1.6,0.2 Verdana,8 Right 0,0,0,0 Text76 {gropuvalues.ytdblockroomsSection} Black Center Transparent 3.8,0.4,1.6,0.2 Verdana,8 Right 0,0,0,0 Text77 {gropuvalues.ptdblockroomsSection} Black Center Transparent 2.1,0.6,1.5,0.2 Verdana,8 Right 0,0,0,0 Text78 {gropuvalues.totaladult}/{gropuvalues.totalchild} Black Center Transparent 5.6,0.6,1.6,0.2 Verdana,8 Right 0,0,0,0 Text79 {gropuvalues.ytdadult}/{gropuvalues.ytdchild} Black Center Transparent 3.8,0.6,1.6,0.2 Verdana,8 Right 0,0,0,0 Text80 {gropuvalues.ptdadult}/{gropuvalues.ptdchild} Black Center Transparent True 0,0,1.9,0.2 Verdana,8,Bold 0,0,0,0 Text65 {IIF(DataSource1.status=="MANUAL",DataSource1.roomsummary,"Room Summary")} Black Bottom Transparent 2.1,0.8,1.5,0.2 Verdana,8 Right 0,0,0,0 Text16 {(gropuvalues.totalrooms-gropuvalues.blockedrooms)} Black Center Transparent 5.6,0.8,1.6,0.2 Verdana,8 Right 0,0,0,0 Text81 {(gropuvalues.ytdtotalrooms-gropuvalues.ytdblockrooms)} Black Center Transparent 3.8,0.8,1.6,0.2 Verdana,8 Right 0,0,0,0 Text86 {gropuvalues.ptdtotalrooms-gropuvalues.ptdblockrooms} Black Center Transparent 2.1,1,1.5,0.2 Verdana,8 Right 0,0,0,0 Text87 {totalroomssold} Black Center Transparent 5.6,1,1.6,0.2 Verdana,8 Right 0,0,0,0 Text88 {totalroomssoldytd} Black Center Transparent 3.8,1,1.6,0.2 Verdana,8 Right 0,0,0,0 Text89 {totalroomssoldptd} Black Center Transparent 2.1,1.2,1.5,0.2 Verdana,8 Right 0,0,0,0 Text90 {dayuserooms} Black Center Transparent 5.6,1.2,1.6,0.2 Verdana,8 Right 0,0,0,0 Text91 {dayuseroomsytd} Black Center Transparent 3.8,1.2,1.6,0.2 Verdana,8 Right 0,0,0,0 Text92 {dayuseroomsptd} Black Center Transparent 2.1,1.4,1.5,0.2 Verdana,8 Right 0,0,0,0 Text93 {complimentoryrooms} Black 0 , 1 Center Transparent 5.6,1.4,1.6,0.2 Verdana,8 Right 0,0,0,0 Text94 {complimentoryroomsytd} Black 0 , 1 Center Transparent 3.8,1.4,1.6,0.2 Verdana,8 Right 0,0,0,0 Text95 {complimentoryroomsptd} Black 0 , 1 Center Transparent 2.1,1.6,1.5,0.2 Verdana,8 Right 0,0,0,0 Text99 {gropuvalues.totalnoshow} Black 0 , 1 Center Transparent 5.6,1.6,1.6,0.2 Verdana,8 Right 0,0,0,0 Text100 {gropuvalues.totalnoshowytd} Black 0 , 1 Center Transparent 3.8,1.6,1.6,0.2 Verdana,8 Right 0,0,0,0 Text101 {gropuvalues.totalnoshowptd} Black 0 , 1 Center Transparent 2.1,1.8,1.5,0.2 Verdana,8 Right 0,0,0,0 Text102 {IIF(totalroomssold==0,"0",Round(gropuvalues.totaladult/totalroomssold,2))}/{IIF(totalroomssold==0,"0",Round(gropuvalues.totalchild/totalroomssold,2))} Black Center Transparent 3.8,1.8,1.6,0.2 Verdana,8 Right 0,0,0,0 Text103 {IIF(totalroomssoldptd==0,"0",Round(gropuvalues.ptdadult/totalroomssoldptd,2))}/{IIF(totalroomssoldptd==0,"0",Round(gropuvalues.ptdchild/totalroomssoldptd,2))} Black Center Transparent 5.6,1.8,1.6,0.2 Verdana,8 Right 0,0,0,0 Text104 {IIF(totalroomssoldytd==0,"0",Round(gropuvalues.ytdadult/totalroomssoldytd,2))}/{IIF(totalroomssoldytd==0,"0",Round(gropuvalues.ytdchild/totalroomssoldytd,2))} Black Center [Not Assigned] DataBand5 Transparent 0,5.8,7.67,0.2 Transparent 0,0,1.9,0.2 Verdana,8 0,0,0,0 Text129 {IIF(DataSource1.status=="MANUAL",DataSource1.noofresconfirm,"No of Reservations (Confirm)")} Black Center Transparent 2.1,0,1.5,0.2 Verdana,8 Right 0,0,0,0 Text130 {numofreservation} Black Center Transparent 3.8,0,1.6,0.2 Verdana,8 Right 0,0,0,0 Text131 {numofreservationptd} Black Center Transparent 5.6,0,1.6,0.2 Verdana,8 Right 0,0,0,0 Text132 {numofreservationytd} Black Center DataBand7 Transparent 0,6.4,7.67,0.2 Transparent True 0,0,1.9,0.2 Verdana,8 0,0,0,0 Text133 {IIF(DataSource1.status=="MANUAL",DataSource1.noofresunconfirm,"No of Reservations (Unconfirm)")} Black Center Transparent True 2.1,0,1.5,0.2 Verdana,8 Right 0,0,0,0 Text134 {numofreservationunconfirm} Black Center Transparent True 3.8,0,1.6,0.2 Verdana,8 Right 0,0,0,0 Text135 {numofreservationunconfirmptd} Black Center Transparent True 5.6,0,1.6,0.2 Verdana,8 Right 0,0,0,0 Text136 {numofreservationunconfirmytd} Black Center DataBand9 Transparent 0,7,7.67,0.2 Transparent 0,0,1.9,0.2 Verdana,8 0,0,0,0 Text85 {IIF(DataSource1.status=="MANUAL",DataSource1.noofwalkins,"No of Walkins")} Black Center Transparent 2.1,0,1.5,0.2 Verdana,8 Right 0,0,0,0 Text96 {numofreservationwalkin} Black Center Transparent 3.8,0,1.6,0.2 Verdana,8 Right 0,0,0,0 Text97 {numofreservationwalkinptd} Black Center Transparent 5.6,0,1.6,0.2 Verdana,8 Right 0,0,0,0 Text98 {numofreservationwalkinytd} Black Center DataBand8 Transparent 0,7.6,7.67,0.8 Transparent True 0,0,1.9,0.2 Verdana,8,Bold 0,0,0,0 Text105 {IIF(DataSource1.status=="MANUAL",DataSource1.statistics,"Statistics")} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Bottom Transparent True 0,0.2,1.9,0.2 Verdana,8 0,0,0,0 Text107 {IIF(DataSource1.status=="MANUAL",DataSource1.occupancyrate,"Occupancy Rate(%)")} Black Center Transparent True 0,0.4,1.9,0.2 Verdana,8 0,0,0,0 Text108 {IIF(DataSource1.status=="MANUAL",DataSource1.averagedailyrate,"Average Daily Rate(ADR)")} Black Center Transparent True 0,0.6,1.9,0.2 Verdana,8 0,0,0,0 Text109 {IIF(DataSource1.status=="MANUAL",DataSource1.revenueperavailroom,"Revenue Per Available Room")} Black Center Transparent True 2.1,0.6,1.5,0.2 Verdana,8 Right 0,0,0,0 Text112 {Replace(Format("{0:N"+ decimalpoint +"}",TotalGrevenue/(gropuvalues.totalrooms-gropuvalues.blockedrooms)), " ", ",")} Black Center Transparent True 3.8,0.6,1.6,0.2 Verdana,8 Right 0,0,0,0 Text44 {Replace(Format("{0:N"+ decimalpoint +"}",TotalGPTDrevenue/(gropuvalues.ptdtotalrooms-gropuvalues.ptdblockrooms)), " ", ",")} Black Center Transparent True 5.6,0.6,1.6,0.2 Verdana,8 Right 0,0,0,0 Text110 {Replace(Format("{0:N"+ decimalpoint +"}",TotalGYTDrevenue/(gropuvalues.ytdtotalrooms-gropuvalues.ytdblockrooms)), " ", ",")} Black Center Transparent True 2.1,0.2,1.5,0.2 Verdana,8 Right 0,0,0,0 Text111 {Replace(Format("{0:N"+ decimalpoint +"}", (totalroomssold*100/(gropuvalues.totalrooms-gropuvalues.blockedrooms))), " ", ",")} Black Center Transparent True 3.8,0.2,1.6,0.2 Verdana,8 Right 0,0,0,0 Text114 {Replace(Format("{0:N"+ decimalpoint +"}",(totalroomssoldptd*100)/((gropuvalues.ptdtotalrooms)-(gropuvalues.ptdblockrooms))), " ", ",")} Black Center Transparent True 5.6,0.2,1.6,0.2 Verdana,8 Right 0,0,0,0 Text115 {Replace(Format("{0:N"+ decimalpoint +"}", (totalroomssoldytd*100)/((gropuvalues.ytdtotalrooms)-(gropuvalues.ytdblockrooms))), " ", ",")} Black Center Transparent True 2.1,0.4,1.5,0.2 Verdana,8 Right 0,0,0,0 Text116 {Format("{0:N" + decimalpoint + "}",TotalGrevenue/totalroomssold)} Black Center Transparent True 3.8,0.4,1.6,0.2 Verdana,8 Right 0,0,0,0 Text117 {Format("{0:N" + decimalpoint + "}",TotalGPTDrevenue/totalroomssoldptd)} Black Center Transparent True 5.6,0.4,1.6,0.2 Verdana,8 Right 0,0,0,0 Text118 {Format("{0:N" + decimalpoint + "}",TotalGYTDrevenue/totalroomssoldytd)} Black Center DataBand6 Transparent 0,8.8,7.67,1 Transparent True 0,0.2,1.9,0.2 Verdana,8 0,0,0,0 Text31 {IIF(DataSource1.status=="MANUAL",DataSource1.openingbalance,"Opening Balance")} Black Center Transparent True 2,0.2,1.6,0.2 Verdana,8 Right 0,0,0,0 Text32 {Replace(Format("{0:N"+ decimalpoint +"}", Ledgers.Cityopening_blance), " ", ",")} Black Center Transparent True 0,0.4,1.9,0.2 Verdana,8 0,0,0,0 Text33 {IIF(DataSource1.status=="MANUAL",DataSource1.paymentreceived,"Payment Received")} Black Center Transparent True 2,0.4,1.6,0.2 Verdana,8 Right 0,0,0,0 Text34 {Replace(Format("{0:N"+ decimalpoint +"}",Ledgers.Citycredit ), " ", ",")} Black Center Transparent True True 0,0.6,1.9,0.2 _x007B__x0028_ShowCityLedgerPostingInvoice_x003D__x003D_0_x0029__x007D_,Red,Transparent,Arial_x002C_10,False,False,,,None Verdana,8 0,0,0,0 Text35 {IIF(DataSource1.status=="MANUAL",DataSource1.chargesraised,"Charges Raised")} Black Center Transparent True True 2,0.6,1.6,0.2 _x007B__x007D_,Red,Transparent,Arial_x002C_10,False,False,,,None Verdana,8 Right 0,0,0,0 Text36 {Replace(Format("{0:N"+ decimalpoint +"}",Ledgers.Citydebit), " ", ",")} Black Center Transparent True 0,0.8,1.9,0.2 Verdana,8 0,0,0,0 Text37 {IIF(DataSource1.status=="MANUAL",DataSource1.closingbalance,"Closing Balance")} Black Center Transparent True 2,0.8,1.6,0.2 Verdana,8 Right 0,0,0,0 Text38 {Replace(Format("{0:N"+ decimalpoint +"}", Ledgers.Cityclosing_balance), " ", ",")} Black Center Transparent True 3.8,0.2,1.6,0.2 Verdana,8 Right 0,0,0,0 Text45 {Replace(Format("{0:N"+ decimalpoint +"}",Ledgers.Cityptd_opening_blance ), " ", ",")} Black Center Transparent True 3.8,0.4,1.6,0.2 Verdana,8 Right 0,0,0,0 Text48 {Replace(Format("{0:N"+ decimalpoint +"}", Ledgers.Cityptd_credit), " ", ",")} Black Center Transparent True True 3.8,0.6,1.6,0.2 _x007B__x007D_,Red,Transparent,Arial_x002C_10,False,False,,,None Verdana,8 Right 0,0,0,0 Text49 {Replace(Format("{0:N"+ decimalpoint +"}",Ledgers.Cityptd_debit), " ", ",")} Black Center Transparent True 3.8,0.8,1.6,0.2 Verdana,8 Right 0,0,0,0 Text50 {Replace(Format("{0:N"+ decimalpoint +"}", Ledgers.Cityclosing_balance), " ", ",")} Black Center Transparent True 5.6,0.2,1.6,0.2 Verdana,8 Right 0,0,0,0 Text52 {Replace(Format("{0:N"+ decimalpoint +"}", Ledgers.Cityytd_opening_blance), " ", ",")} Black Center Transparent True 5.6,0.4,1.6,0.2 Verdana,8 Right 0,0,0,0 Text53 {Replace(Format("{0:N"+ decimalpoint +"}",Ledgers.Cityytd_credit), " ", ",")} Black Center Transparent True True 5.6,0.6,1.6,0.2 _x007B__x007D_,Red,Transparent,Arial_x002C_10,False,False,,,None Verdana,8 Right 0,0,0,0 Text54 {Replace(Format("{0:N"+ decimalpoint +"}", Ledgers.Cityytd_debit), " ", ",")} Black Center Transparent True 5.6,0.8,1.6,0.2 Verdana,8 Right 0,0,0,0 Text55 {Replace(Format("{0:N"+ decimalpoint +"}", Ledgers.Cityclosing_balance), " ", ",")} Black Center Transparent True 0,0,1.9,0.2 Verdana,8,Bold 0,0,0,0 Text30 {IIF(DataSource1.status=="MANUAL",DataSource1.cityledger,"City Ledger")} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Bottom CityLedger DataBand3 Transparent 0,10.2,7.67,1 Transparent True True 0,0.2,1.9,0.2 Verdana,8 0,0,0,0 Text20 {IIF(DataSource1.status=="MANUAL",DataSource1.openingbalance,"Opening Balance")} Black Center Transparent True True 2,0.2,1.6,0.2 Verdana,8 Right 0,0,0,0 Text21 {Replace(Format("{0:N"+ decimalpoint +"}",Ledgers.ADVopening_blance), " ", ",")} Black Center Transparent True True 2,0.4,1.6,0.2 Verdana,8 Right 0,0,0,0 Text43 {Replace(Format("{0:N"+ decimalpoint +"}",Ledgers.ADVcredits), " ", ",")} Black Center Transparent True True 0,0.4,1.9,0.2 Verdana,8 0,0,0,0 Text22 {IIF(DataSource1.status=="MANUAL",DataSource1.advancedepcollected,"Advance Deposit Collected")} Black Center Transparent True 0,0,1.7,0.2 Verdana,8,Bold 0,0,0,0 Text18 {IIF(DataSource1.status=="MANUAL",DataSource1.advancedepositledger,"Advance Deposit Ledger")} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Bottom Transparent True True 2,0.8,1.6,0.2 Verdana,8 Right 0,0,0,0 Text27 {Replace(Format("{0:N"+ decimalpoint +"}",Ledgers.ADVclosing_balance), " ", ",")} Black Center Transparent True True 0,0.8,1.9,0.2 Verdana,8 0,0,0,0 Text28 {IIF(DataSource1.status=="MANUAL",DataSource1.closingbalance,"Closing Balance")} Black Center Transparent True True 0,0.6,2,0.2 Verdana,8 0,0,0,0 Text137 {IIF(DataSource1.status=="MANUAL",DataSource1.baltransfertoguestledger,"Balance Transfer to Guest Ledger")} Black Center Transparent True True 2,0.6,1.6,0.2 Verdana,8 Right 0,0,0,0 Text139 {Replace(Format("{0:N"+ decimalpoint +"}",Ledgers.ADVdebits), " ", ",")} Black Center AdvDepositLedger DataBand2 Transparent 0,11.6,7.67,2.2 Transparent True True 0,0.8,1.9,0.2 Verdana,8 0,0,0,0 Text11 {IIF(DataSource1.status=="MANUAL",DataSource1.settlementbyguest,"Settlement by Guest")} Black Center Transparent True True 0,1.2,1.9,0.2 Verdana,8 0,0,0,0 Text13 {IIF(DataSource1.status=="MANUAL",DataSource1.transferfromadvdeposit,"Transfer From Advance Deposit")}* Black Center Transparent True True 2,0.8,1.6,0.2 Verdana,8 Right 0,0,0,0 Text12 {Replace(Format("{0:N"+ decimalpoint +"}",Ledgers.Guestcredits), " ", ",")} Black Center Transparent True True 2,1.2,1.6,0.2 Verdana,8 Right 0,0,0,0 Text14 {Replace(Format("{0:N"+ decimalpoint +"}",Ledgers.GuestADTOGL), " ", ",")} Black Center Transparent True 0,0,1.7,0.2 Verdana,8,Bold 0,0,0,0 Text29 {IIF(DataSource1.status=="MANUAL",DataSource1.guestledger,"Guest Ledger")} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Bottom Transparent True True 2,0.2,1.6,0.2 Verdana,8 Right 0,0,0,0 Text15 {Replace(Format("{0:N"+ decimalpoint +"}",Ledgers.GuestbalanceBF), " ", ",")} Black Center Transparent True True 2,0.6,1.6,0.2 Verdana,8 Right 0,0,0,0 Text10 {Replace(Format("{0:N"+ decimalpoint +"}",Ledgers.Guestcharges), " ", ",")} Black Center Transparent True True 2,1,1.6,0.2 Verdana,8 Right 0,0,0,0 Text19 {Replace(Format("{0:N"+ decimalpoint +"}",Ledgers.Guestbalance), " ", ",")} Black Center Transparent True True 0,0.2,1.9,0.2 Verdana,8 0,0,0,0 Text7 {IIF(DataSource1.status=="MANUAL",DataSource1.openingbalance,"Opening Balance")} Black Center Transparent True True 0,0.6,1.9,0.2 Verdana,8 0,0,0,0 Text9 {IIF(DataSource1.status=="MANUAL",DataSource1.chargepostedtoguestledger,"Charge Posted to Guest Ledger")} Black Center Transparent True True 0,1,1.9,0.2 Verdana,8 0,0,0,0 Text17 {IIF(DataSource1.status=="MANUAL",DataSource1.closingbalance,"Closing Balance")}* Black Center Transparent True True 2,0.4,1.6,0.2 Verdana,8 Right 0,0,0,0 Text128 {Replace(Format("{0:N"+ decimalpoint +"}",Ledgers.GuestCarryForwardAdvDep), " ", ",")} Black Center Transparent True True 0,0.4,2,0.2 Verdana,8 0,0,0,0 Text64 {IIF(DataSource1.status=="MANUAL",DataSource1.carryforwardedadvdeposit,"Carry Forwarded Advance Deposit")} Black Center Top, Bottom;Black;1;Solid;False;4;Black Transparent 0,1.5,7.7,0.6 Verdana,8 0,0,0,0 Text138 *{IIF(DataSource1.status=="MANUAL",DataSource1.guestledgerclosingbal,"Guest Ledger Closing Balance")} = {IIF(DataSource1.status=="MANUAL",DataSource1.openingbalance,"Opening Balance")} - {IIF(DataSource1.status=="MANUAL",DataSource1.carryforwardedadvdeposit,"Carry forwarded Advance Deposit")} + {IIF(DataSource1.status=="MANUAL",DataSource1.chargepostedtoguestledger,"Charge Posted to Guest Ledger")} - {IIF(DataSource1.status=="MANUAL",DataSource1.settlementbyguest,"Settlement by Guest")} *{IIF(DataSource1.status=="MANUAL",DataSource1.transferfromadvdeposit,"Transfer From Advance Deposit")} = {IIF(DataSource1.status=="MANUAL",DataSource1.baltransfertoguestledger,"Balance Transfer To Guest Ledger")} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, GuestLedger DataBand1 7a6c7e3fd61faf584da97d9358c08f81 True 2 0.3,0.3,0.2,0.2 Page1 11.69 8.27 A4 Arial,100 [50:0:0:0] Report 11/18/2016 09:43:24 AM 01/01/2011 01:34:31 AM manager_report.mrt a3bfab99dd8732923cd275a39654740d Report Inches 2011.3.1107 CSharp