Connection Initial Catalog=AMSWEBDB;Integrated Security=False;Password=admin123;User ID=sa;Data Source=DEV-SERVER Connection ViewEmpSummary DepID,System.Int64 EmpNameAr,System.String EmpID,System.String EmpCardID,System.String NatID,System.Int64 EmpStatus,System.String SsmDate,System.DateTime SsmShift,System.Int64 DepNameEn,System.String EmpJoinDate,System.DateTime EmpLeaveDate,System.DateTime UsrName,System.String GapID,System.Int64 GapDate,System.DateTime GapShift,System.Int64 GapStartTime,System.DateTime GapEndTime,System.DateTime GapDuration,System.Int64 GapGraceFlag,System.String GapDesc,System.String ExcID,System.Int64 ExcNameAr,System.String ExcNameEn,System.String ExcInitialEn,System.String ExcMaxSecPerMonth,System.Int64 ExcIsPaid,System.String ExcDesc,System.String ExcInitialAr,System.String SsmActualWorkDuration,System.Int64 SsmWorkDuration,System.Int64 SsmShiftDuration,System.Int64 SsmPunchIn,System.DateTime SsmPunchOut,System.DateTime SsmBeginEarly,System.Int64 SsmBeginLate,System.Int64 SsmOutEarly,System.Int64 SsmOutLate,System.Int64 SsmExtratime,System.Int64 SsmOverTime,System.Int64 SsmGapDuration,System.Int64 SsmGapUnpaidDuration,System.Int64 SsmGapPaidDuration,System.Int64 SsmGrace,System.Int64 SsmAlert,System.String SsmInUser,System.String SsmOutUser,System.String SsmGraceFlag,System.String DepNameAr,System.String EmpPWD,System.String EmpAutoOut,System.String EmpAutoIn,System.String EmpTypeID,System.Int64 EmpJobTitleAr,System.String EmpJobTitleEn,System.String EmpBlood,System.String EmpGender,System.String EmpCreatedBy,System.String EmpCreatedDate,System.DateTime EmpModifiedBy,System.String EmpModifiedDate,System.DateTime EmpDeletedBy,System.String EmpDeletedDate,System.DateTime EmpDeleted,System.String EmpSendEmailAlert,System.String EmpSendSMSAlert,System.String EmpDescription,System.String EmpDomainUserName,System.String EmpMaxOvertimePercent,System.Int64 EmpEmailID,System.String EmpMobileNo,System.Int64 RlsID,System.Int64 EmpNationalID,System.String EmpNameEn,System.String CatID,System.Int64 30 ViewEmpSummary Connection select * from ViewEmpSummary where Convert(varchar(12),SsmDate, 103) = {ParamDate} ,ParamDate,ParamDate,System.String,,False,False EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.4,19,2.47 Transparent 0,-0.02,19.01,2.51 a1410cff1da549ef8bbcc3da85563d50 SubReport1 True PageHeaderBand1 Transparent 0,3.67,19,1.42 [240:240:240] 0,0.2,19,0.8 Arial,20.25,Bold| Underline 8f77e76a74284741963f224fbf023acf Center 0,0,0,0 Text17 Department Employees Late Come Per Day MediumBlue Expression Center ReportTitleBand1 Transparent 0,5.89,19,1.65 All;[193:152:89];1;Solid;False;4;Black [242:234:221] 0,0.05,2.21,0.61 Arial,9,Bold a254a3289afb4e66962094c80c5c89fe Center 0,0,0,0 Text52 Department : [193:152:89] Expression Center All;[193:152:89];1;Solid;False;4;Black Transparent 2.39,0.05,3.99,0.61 Arial,9 977c342f18144823b8bbf4c388bf8b1e Center 0,0,0,0 Text51 {ViewEmpSummary.DepNameEn} [102:77:38] DataColumn Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 0.81,0.92,2.99,0.61 Arial,9,Bold,Point,False,0 6c909eaf4b5b4867a33291d395f9f7db Center 0,0,0,0 Text10 Department Name [193:152:89] Expression Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 4.01,0.92,3.8,0.61 Arial,9,Bold,Point,False,0 02f2b41a8db544abbd1a24381df519e1 Center 0,0,0,0 Text11 Manager Name [193:152:89] Expression Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 8,0.92,5.01,0.61 Arial,9,Bold,Point,False,0 d0515564fc5243eda631c4c92fb5a7e1 Center 0,0,0,0 Text14 DecreasingSize, OnlyInWidthOfComponent Employee Name [193:152:89] Expression Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 0,0.92,0.61,0.61 Arial,9,Bold,Point,False,0 1273e014fa08499ebb9f43e89cfe93d2 Center 0,0,0,0 Text1 No [193:152:89] Expression Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 13.2,0.92,2.79,0.61 Arial,9,Bold,Point,False,0 41bfab59cd864ec8b69914c29bf997df Center 0,0,0,0 Text5 DecreasingSize, OnlyInWidthOfComponent Late Come [193:152:89] Expression Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 16.19,0.92,2.81,0.61 Arial,9,Bold,Point,False,0 f6defed6a911431d9a9068f5f0f00e39 Center 0,0,0,0 Text6 DecreasingSize, OnlyInWidthOfComponent Early Leave [193:152:89] Expression Center {ViewEmpSummary.DepNameEn} c0a6a46ab4984ff499c5da912dbd7a6f True GroupHeaderBand2 None;[149:159:172];1;Solid;False;4;Black White 0,8.34,19,0.86 All;Black;1;Solid;False;4;Black Transparent 0.81,0.01,3,0.6 Arial,9,Regular,Point,False,0 Center 0,0,0,0 Text2 {ViewEmpSummary.DepNameEn} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, DataColumn Center All;Black;1;Solid;False;4;Black Transparent 4,0.01,3.81,0.6 Arial,9,Regular,Point,False,0 Center 0,0,0,0 Text3 {ViewEmpSummary.UsrName} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, DataColumn Center All;Black;1;Solid;False;4;Black Transparent 8,0,5,0.6 Arial,9,Regular,Point,False,0 Center 0,0,0,0 Text4 {ViewEmpSummary.EmpNameEn} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, DataColumn Center All;Black;1;Solid;False;4;Black Transparent 0,0,0.6,0.6 Arial,9,Regular,Point,False,0 a2afa97f1330479d807948dd53e8d7b8 Center 0,0,0,0 Text19 {Line} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, SystemVariables Center All;Black;1;Solid;False;4;Black Transparent 13.21,0.01,2.79,0.6 Arial,9,Regular,Point,False,0 5aa97038125c4a0d801852b8d3da722a Center 0,0,0,0 Text8 {ViewEmpSummary.SsmBeginLate} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, DataColumn Center All;Black;1;Solid;False;4;Black Transparent 16.2,0.01,2.77,0.6 Arial,9,Regular,Point,False,0 c13e882233ca47568a3957be76ee7a9d Center 0,0,0,0 Text9 {ViewEmpSummary.SsmOutEarly} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, DataColumn Center ViewEmpSummary DataBand1 Collection_Data1_Odd Style 84b7e53fc4454499aad3ce405b62682e 1,1,1,1 Page1 29.7 21 Arial,100 [50:0:0:0] System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll Report 9/8/2012 2:55:22 PM 7/23/2012 1:38:34 PM C:\Documents and Settings\malwahidi\Desktop\AMS-Reports\Department Reports\EmpLateComePerDay.mrt f9ad065164934d4cb2bc5fb9bca28d6d Report Centimeters 2012.1.1300 CSharp True None;[149:159:172];1;Solid;False;4;Black [199:209:222] Collection Text, Primitive, Image GreaterThanOrEqualTo Header ComponentType, Placement, PlacementNestedLevel Arial,8,Bold Collection_Header1 [0:9:22] True None;[149:159:172];1;Solid;False;4;Black Transparent Collection Text, Primitive, Image GreaterThanOrEqualTo Data ComponentType, Placement, PlacementNestedLevel Arial,8 Collection_Data1 [0:9:22] True None;[149:159:172];1;Solid;False;4;Black [255:255:255] Collection GreaterThanOrEqualTo DataOddStyle Placement, PlacementNestedLevel Arial,8 Collection_Data1_Odd Style [0:9:22] True None;[149:159:172];1;Solid;False;4;Black [236:246:255] Collection GreaterThanOrEqualTo DataEvenStyle Placement, PlacementNestedLevel Arial,8 Collection_Data1_Even Style [0:9:22] True None;[149:159:172];1;Solid;False;4;Black [209:219:232] Collection Text, Primitive, Image Footer ComponentType, Placement, PlacementNestedLevel Arial,8 Collection_Footer1 [0:9:22]