ccs Server=localhost;Port=3306;Database=ccs;User=root; Password= ccs False a id,System.Int32 branchid,System.String agentid,System.String cname,System.String ename,System.String hkid,System.String gender,System.String dob,System.DateTime address,System.String hometel,System.String mobile,System.String pager,System.String applydate,System.DateTime latestpaydate,System.DateTime totalloanamt,System.Decimal contractid,System.String remarks,System.String source,System.String status,System.String isbadlist,System.String isdebt,System.String createby,System.String createdate,System.DateTime updateby,System.String updatedate,System.DateTime 30 a ccs SELECT id, branchid, cname, ename, hkid, if(gender='F','女', if(gender='M','男','')) as gender, dob, address, hometel, mobile, pager, applydate, latestpaydate, totalloanamt, contractid, remarks, source, status, if(isbadlist='Y','是','否') as isbadlist, if(isdebt='Y','是','否') as isdebt FROM badclients ORDER BY id EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,18.6,27.7,0.4 None;[193:152:89];1;Solid;False;4;Black Transparent 6.8,0,12.2,0.4 Footer1 Arial,9 Right 0,0,0,0 Text6 {PageNofM} [102:77:38] Center PageFooterBand1 Transparent 0,0.4,27.7,2 Bottom;[193:152:89];1;Solid;False;4;Black Transparent 9.4,0,18.2,0.8 Title1 Arial,19 426e9ac30a6840e7b47553f34723b8df Right 0,0,0,0 Text20 [193:152:89] Expression Center Bottom;[193:152:89];1;Solid;False;4;Black Transparent 0,0,9.4,0.8 Title1 Arial,19 1bc08e78ae20472481fe55b04ade5b6a 0,0,0,0 Text23 黑名單報表 [193:152:89] Expression Center None;[102:77:38];1;Solid;False;4;Black Transparent True 0,1,14.6,0.8 Title2 Arial,9 75b851754174412ab8c478e5c8479f92 0,0,0,0 Text17 列印日期： {Today.ToString("dd-MMMM-yyyy")} [102:77:38] HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression None;[102:77:38];1;Solid;False;4;Black Transparent True 14.6,1,13,0.8 Title2 Arial,9 65f5c368912b4240a21d18c95400ea00 Right 0,0,0,0 Text18 [102:77:38] yyyy, MMMM HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression 0e78e53250ce4a74baab882ac9d3f6e0 ReportTitleBand2 Transparent 0,3.2,27.7,0.6 All;[193:152:89];1;Solid;False;4;Black [242:234:221] 6,0,1.6,0.6 Header3 Arial,9,Bold Center 0,0,0,0 Text11 身份証號碼 [193:152:89] Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 7.6,0,0.8,0.6 Header3 Arial,9,Bold Center 0,0,0,0 Text12 DecreasingSize, OnlyInWidthOfComponent 性別 [193:152:89] Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 8.4,0,1.6,0.6 Header3 Arial,9,Bold Center 0,0,0,0 Text13 出生日期 [193:152:89] Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 0,0,0.8,0.6 Header3 Arial,9,Bold Center 0,0,0,0 Text10 號碼 [193:152:89] Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 0.8,0,1.6,0.6 Header3 Arial,9,Bold Center 0,0,0,0 Text4 公司名稱 [193:152:89] Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 2.4,0,1.6,0.6 Header3 Arial,9,Bold Center 0,0,0,0 Text7 中文名 [193:152:89] Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 4,0,2,0.6 Header3 Arial,9,Bold Center 0,0,0,0 Text9 英文名 [193:152:89] Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 10,0,1.6,0.6 Header3 Arial,9,Bold Center 0,0,0,0 Text32 開始日期 [193:152:89] Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 11.6,0,1.6,0.6 Header3 Arial,9,Bold Center 0,0,0,0 Text33 完結日期 [193:152:89] Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 13.2,0,1.6,0.6 Header3 Arial,9,Bold Center 0,0,0,0 Text34 欠款總數 [193:152:89] Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 14.8,0,1.6,0.6 Header3 Arial,9,Bold Center 0,0,0,0 Text35 合約編號 [193:152:89] Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 16.4,0,1.6,0.6 Header3 Arial,9,Bold Center 0,0,0,0 Text36 備註 [193:152:89] Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 18,0,1.6,0.6 Header3 Arial,9,Bold Center 0,0,0,0 Text37 來貨 [193:152:89] Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 26,0,1.6,0.6 Header3 Arial,9,Bold Center 0,0,0,0 Text38 欠款 [193:152:89] Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 19.6,0,1.6,0.6 Header3 Arial,9,Bold Center 0,0,0,0 Text39 住址電話 [193:152:89] Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 21.2,0,1.6,0.6 Header3 Arial,9,Bold Center 0,0,0,0 Text40 手提電話 [193:152:89] Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 22.8,0,1.6,0.6 Header3 Arial,9,Bold Center 0,0,0,0 Text41 其他電話 [193:152:89] Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 24.4,0,1.6,0.6 Header3 Arial,9,Bold Center 0,0,0,0 Text42 住址 [193:152:89] Center HeaderBand1 True Transparent True 0,4.6,27.7,0.8 Transparent True 0,0,0.8,0.6 Arial,10 0,0,0,0 Text2 {a.id} Black Transparent True 0.8,0,1.6,0.6 Arial,10 0,0,0,0 Text1 {a.branchid} Black Transparent True 2.4,0,1.6,0.6 Arial,10 0,0,0,0 Text3 {a.cname} Black Transparent True 4,0,2,0.6 Arial,10 0,0,0,0 Text5 {a.ename} Black Transparent True 6,0,1.6,0.6 Arial,10 0,0,0,0 Text14 {a.hkid} Black Transparent True 7.6,0,0.8,0.6 Arial,10 0,0,0,0 Text15 {a.gender} Black Transparent True 8.4,0,1.6,0.6 Arial,10 0,0,0,0 Text19 {a.dob} Black Transparent True 10,0,1.6,0.6 Arial,10 0,0,0,0 Text16 {a.applydate} Black Transparent True 11.6,0,1.6,0.6 Arial,10 0,0,0,0 Text22 {a.latestpaydate} Black Transparent True 13.2,0,1.6,0.6 Arial,10 0,0,0,0 Text25 {a.totalloanamt} Black Transparent True 14.8,0,1.6,0.6 Arial,10 0,0,0,0 Text21 {a.contractid} Black Transparent True 16.4,0,1.6,0.6 Arial,10 0,0,0,0 Text24 {a.remarks} Black Transparent True 18,0,1.6,0.6 Arial,10 0,0,0,0 Text27 {a.source} Black Transparent True 19.6,0,1.6,0.6 Arial,10 0,0,0,0 Text26 {a.hometel} Black Transparent True 21.2,0,1.6,0.6 Arial,10 0,0,0,0 Text29 {a.mobile} Black Transparent True 22.8,0,1.6,0.6 Arial,10 0,0,0,0 Text28 {a.pager} Black Transparent True 24.4,0,1.6,0.6 Arial,10 0,0,0,0 Text30 {a.address} Black Transparent True 26,0,1.6,0.6 Arial,10 0,0,0,0 Text31 {a.isdebt} Black a DataBand1 Transparent 0,6.2,27.7,0.2 Top;[193:152:89];1;Solid;False;4;Black Transparent True 0,0,27.6,0.2 Data1 Arial,9 True dcc6258185da48c0bee4c3c0395fb37d 0,0,0,0 Text8 [102:77:38] HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Center FooterBand1 True 366bfdc35bcf48f3aeb38f2b5f58db21 1,1,1,1 Page1 Landscape 21 29.7 Arial,100,Bold [50:0:0:0] StandardAndDotMatrix 33538047 System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Base.Dll Stimulsoft.Controls.Dll Stimulsoft.Report.Dll Simple List Stimulsoft 03/23/2012 06:47:12 PM 05/29/2004 10:59:00 AM The sample demonstrates how to create a simple list report. C:\xampp\htdocs\ccs\report\reports\BadClientRpt.mrt adfff3477de97adbc2253f2ad0b2ffc5 Report Centimeters 2012.1.1207 CSharp 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 Arial,9 Data1 [102:77:38] Center False False False False False [240:237:232] Arial,9 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