lms Server=localhost;Database=lms;Port=3306;User=lmsdbo;Password=lmsdbo12345678; lms branch branchid,System.String branchcname,System.String branchename,System.String branchcadddr,System.String brancheadddr,System.String branchtel,System.String branchfax,System.String branchlicence,System.String monthinterest,System.Decimal createby,System.String createdate,System.DateTime updateby,System.String updatedate,System.DateTime 30 branch lms select * from branch where branchid = '{p1}' loaninfo id,System.Int32 contractid,System.String branchid,System.String applydate,System.DateTime loanstatus,System.String loanamt,System.Decimal 30 loaninfo lms select id, contractid, branchid, applydate, loanamt, loanstatus from loaninfo where branchid = '{p1}' and applydate >= '{d1}' and applydate <= '{d2}' and loanstatus <> 'C' and loanstatus <> 'R' loanclient loanid,System.Int32 branchid,System.String clientid,System.Int32 seq,System.Int32 cname,System.String ename,System.String gender2,System.String 30 loanclient lms SELECT a.loanid, a.branchid, a.clientid, a.seq, b.cname, b.ename, if( b.gender = 'M', '男', if( b.gender = 'M', '男', '女')) as gender2 FROM loanclients AS a, clients AS b WHERE a.clientid = b.id order by a.loanid, a.seq payment1 id,System.Int32 contractid,System.String loanstatus,System.String loanid,System.Int32 paidamt,System.Decimal paidstatus,System.String newcontractid,System.String sumpaidamt1,System.Decimal 30 payment1 lms SELECT a.id, a.contractid, a.loanstatus, b.id, b.loanid, b.paidamt, b.paidstatus, b.newcontractid, sum(b.paidamt) as sumpaidamt1 FROM loaninfo AS a, payment AS b WHERE b.newcontractid = a.contractid and a.branchid = '{p1}' and b.paidstatus = 'F' group by b.newcontractid payment2 id,System.Int32 loanid,System.Int32 paidamt,System.Decimal paidstatus,System.String newcontractid,System.String 30 payment2 lms SELECT id, loanid, paidamt, paidstatus, newcontractid, paidamt FROM payment WHERE branchid = '{p1}' and paidstatus = 'F' and newcontractid is not null and newcontractid <> '' payment id,System.Int32 loanid,System.Int32 paidamt,System.Decimal paidstatus,System.String newcontractid,System.String sumpaidamt,System.Decimal 30 payment lms SELECT id, loanid, paidamt, paidstatus, newcontractid, sum(paidamt) as sumpaidamt FROM payment WHERE paidstatus = 'F' and newcontractid <> '' and newcontractid is not null group by newcontractid loanclient_loaninfo loanid loanclient_loaninfo loanclient_loaninfo id loaninfo_payment newcontractid loaninfo_payment loaninfo_payment contractid ,p1,p1,branch,System.String,KF,False,False,False ,p2,p2,user,System.String,AAA,False,False,False ,d1,d1,fromdaterange,System.String,_x0032_011_x002D_01_x002D_01,False,False,False ,sumSettle,sumSettle,sumSettle,System.Decimal,_x0030_,False,False,False ,d2,d2,todaterange,System.String,_x0032_012_x002D_12_x002D_31,False,False,False EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.4,19,0 ReportTitleBand1 PaleTurquoise True 0,1.2,19,2.4 Transparent True 6.6,1.2,2.4,0.6 JC12Bold 新細明體,12,Bold 0,0,0,0 Text23 {loaninfo.applydate} Black M月 Transparent True 5.2,1.2,1.4,0.6 JC12Bold 新細明體,12,Bold 0,0,0,0 Text24 月份： Black Transparent True 8.2,1.8,3.6,0.6 JC12 新細明體,12 Right 0,0,0,0 Text13 Loan Amount Black Transparent True 12,1.8,3.2,0.6 JC12 新細明體,12 Right 0,0,0,0 Text15 Settle Amount Black Transparent True 0,1.8,3.8,0.6 JC12 新細明體,12 0,0,0,0 Text7 合約號碼 Black Transparent True 4,1.8,4,0.6 JC12 新細明體,12 0,0,0,0 Text8 客戶姓名 Black Transparent True True 8,0,3,1.2 JC15Bold 新細明體,15,Bold 037e7b500e33c65d14f9700127a9cf53 Center 0,0,0,0 Text2 Loan Sheet Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression Center Transparent True True 0,0,8,1.2 JC15Bold 新細明體,15,Bold 14c239c860afa58f8a46700127a9ebdc 0,0,0,0 Text3 {branch.branchcname} Black yyyy, MMMM HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression Center Transparent True True 15.2,0,3.8,0.6 JC12 新細明體,12 40d2731b82da892df348700127a9cb51 0,0,0,0 Text1 {ToUpperCase(p1)}-{p2} Black yyyy, MMMM HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression Transparent True True 12.6,0,2.6,0.6 JC12 新細明體,12 0c9f566cd681ca86b1fe700127a96c1d 0,0,0,0 Text4 列印用戶： Black yyyy, MMMM HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression Transparent True True 12.6,0.6,2.6,0.6 JC12 新細明體,12 57d3b5ec0aa12a3866f9700127aae720 0,0,0,0 Text5 列印時間： Black yyyy, MMMM HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression Transparent True 15.2,0.6,3.8,0.6 JC12 新細明體,12 0,0,0,0 Text6 {Time} Black yyyy-MM-dd HH:mm:ss Transparent True 1.6,1.2,3.4,0.6 JC12Bold 新細明體,12,Bold 0,0,0,0 Text9 {loaninfo.applydate} Black yyyy年M月d日 Transparent True 0,1.2,1.4,0.6 JC12Bold 新細明體,12,Bold 0,0,0,0 Text20 日期： Black Transparent True 15.4,1.8,3.6,0.6 JC12 新細明體,12 Right 0,0,0,0 Text14 Settle Amount2 Black {loaninfo.applydate.ToString("yyyyMMdd")} GroupHeaderBand1 Transparent True 0,4.4,19,1.4 Transparent True 8.2,0,3.6,0.6 JC12 _x007B_payment_x002E_paidstatus_x0021__x003D__x0022_F_x0022__x007D_,Red,Transparent,Arial_x002C_10,False,False,,,None 新細明體,12 Right 0,0,0,0 Text12 {loaninfo.loanamt} Black , 1 0 False Transparent True 0,0,3.6,0.6 _x007B_payment_x002E_paidstatus_x0021__x003D__x0022_F_x0022__x007D_,Red,Transparent,Arial_x002C_10,False,False,,,None Arial,10 0,0,0,0 Text10 {loaninfo.contractid} Black Transparent 3.8,0,4.2,0.6 True SubReport1 5f3f004bdecd504874a0745659c71c4d Transparent True 15.4,0,3.6,0.6 JC12 False 新細明體,12 Right 0,0,0,0 Text17 {loaninfo.contractid==payment.newcontractid?payment.sumpaidamt:0} Black , 1 0 False Transparent 12,0,3.2,0.6 SubReport2 4513abaf84161e670df460085c9bc920 Transparent True 3,0.8,12.2,0.6 JC12 False 新細明體,12 Right 0,0,0,0 Text16 {payment1.newcontractid==loaninfo.contractid?payment1.sumpaidamt1:0} Black , 1 0 False Top, Bottom;Black;1;Solid;False;4;Black Transparent True 15.6,0.8,3.4,0.6 Arial,10 Right 0,0,0,0 Text22 {sumSettle=SumIf(DataBand1,payment1.sumpaidamt1,payment1.newcontractid==loaninfo.contractid)} [255:0:0] , 1 0 False loaninfo Data2 DataBand1 Data1 Transparent True 0,6.6,19,0.8 Top, Bottom;Black;1;Double;False;4;Black Transparent True 12,0,3.2,0.6 JC12TopBottom 新細明體,12 Right 0,0,0,0 Text31 {Sum(payment1.newcontractid==loaninfo.contractid?payment1.sumpaidamt1:0)} [65:105:225] , 1 0 False Top, Bottom;Black;1;Double;False;4;Black Transparent True 15.4,0,3.6,0.6 JC12TopBottom 新細明體,12 Right 0,0,0,0 Text32 {Sum(DataBand1,sumSettle)} [255:165:0] , 1 0 False Top, Bottom;Black;1;Double;False;4;Black Transparent True 8.2,0,3.6,0.6 JC12TopBottom 新細明體,12 Right 0,0,0,0 Text37 {Sum(DataBand1,loaninfo.loanamt)} Black , 1 0 False Top, Bottom;Black;1;Solid;False;4;Black Transparent True 3.4,0,3.4,0.6 Arial,10 0,0,0,0 Text19 {SumIf(DataBand1,payment1.sumpaidamt1,payment1.newcontractid==payment1.loaninfo_payment.contractid && payment1.loaninfo_payment.id==loaninfo.id)} Black , 1 0 False GroupFooterBand1 513a9a5555ba3fe382486ffce57f0358 1,1,1,1 Page1 29.7 21 Arial,100 [50:0:0:0] None;Black;2;Solid;False;4;Black Transparent Transparent True 0,0.4,4.2,0.6 Transparent True True 0,0,4,0.6 Arial,10 0,0,0,0 Text21 {loanclient.cname} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, loanclient _x007B_loanclient_x002E_loanid_x003D__x003D_loaninfo_x002E_id_x007D_ DataBand2 5f3f004bdecd504874a0745659c71c4d 1,1,1,1 Page_SubReport1 29.7 6.2 Arial,100 [50:0:0:0] None;Black;2;Solid;False;4;Black Transparent Transparent 0,1.8,3.2,0 {payment1.newcontractid} _x007B_payment1_x002E_newcontractid_x0021__x003D_loaninfo_x002E_contractid_x007D_,Red,Transparent,Arial_x002C_10,False,False,,,None False GroupHeaderBand2 Transparent True 0,0.4,3.2,0.6 Transparent True 0,0,3.2,0.6 _x007B_payment1_x002E_newcontractid_x0021__x003D_loaninfo_x002E_contractid_x007D_,Red,Transparent,Arial_x002C_10,False,False,,,None Arial,10 Right 0,0,0,0 Text11 {payment1.newcontractid==loaninfo.contractid?payment1.sumpaidamt1:0} [153:50:204] , 1 0 False _x007B_payment1_x002E_newcontractid_x0021__x003D_loaninfo_x002E_contractid_x007D_,Red,Transparent,Arial_x002C_10,False,False,,,None loaninfo_payment payment1 False _x007B_payment1_x002E_newcontractid_x003D__x003D_loaninfo_x002E_contracatid_x007D_ DataBand3 Transparent True 0,1.8,3.2,0.8 Top, Bottom;Black;1;Double;False;4;Black Transparent True 0,0,3.2,0.6 JC12TopBottom _x007B_payment1_x002E_newcontractid_x0021__x003D_loaninfo_x002E_contractid_x007D_,Red,Transparent,Arial_x002C_10,False,True,_x0030_,,None 新細明體,12 Right 0,0,0,0 Text18 {Sum(DataBand3, payment1.sumpaidamt1)} Black , 1 0 False False GroupFooterBand2 4513abaf84161e670df460085c9bc920 1,1,1,1 Page_SubReport2 29.7 5.2 Arial,100 [50:0:0:0] Report 12/07/2012 11:23:25 AM 07/10/2012 04:24:01 PM C:\xampp\htdocs\lms\reports\reports\LoanSheetReport_Problem.mrt bee94e0078ee6cc51e4f73639b68fa3b Report Centimeters 2012.2.1311 CSharp Transparent JC15Bold 新細明體,15,Bold JC15Bold Black Transparent 新細明體,12,Bold JC12Bold Black Bottom;Black;1;Solid;False;4;Black Transparent Times New Roman,12,Bold JC12BoldBottom Black Bottom;Black;1;Solid;False;4;Black Transparent Times New Roman,12 JC12Bottom Black Transparent 新細明體,11,Bold JC11Bold Black Transparent 新細明體,12 JC12 Black Transparent 新細明體,10 JC10 Black Transparent 新細明體,10,Underline JC10U Black Bottom;Black;1;Solid;False;4;Black Transparent 新細明體,10 JC10UBottom Black Top, Bottom;Black;1;Double;False;4;Black Transparent 新細明體,12 JC12TopBottom Black False None;[193:152:89];1;Solid;False;4;Black Transparent Arial,19 Right Title1 [193:152:89] Center False None;[102:77:38];1;Solid;False;4;Black Transparent Arial,9 Title2 [102:77:38] Center False None;[193:152:89];1;Solid;False;4;Black Transparent Arial,19 Header1 [193:152:89] Center False None;[193:152:89];1;Solid;False;4;Black Transparent Arial,12,Bold Center Header2 [193:152:89] Center False All;[193:152:89];1;Solid;False;4;Black [242:234:221] Arial,9,Bold Center Header3 [193:152:89] Center False None;[193:152:89];1;Solid;False;4;Black Transparent 新細明體,10 Data1 Black Center False False False False False [240:237:232] 新細明體,12 Data2 Black False None;[193:152:89];1;Solid;False;4;Black [240:237:232] Arial,9 Data3 [102:77:38] Center False Top;[193:152:89];1;Solid;False;4;Black Transparent Arial,9 Footer1 [102:77:38] Center False None;[193:152:89];1;Solid;False;4;Black Transparent Arial,12,Bold Right Footer2 [193:152:89] Center