Connection +TjNKFZP2e1pWuXMeCXnL95wwUnWSnvN4Ue5QE7MKBvR6PXN3WtCmXlJpcl5TORn9NCBz+9ZMQlFE6XwcVQlXsU6dy1NSwGZa0uk3MPsoL/9Vr/vSVzz8UUVYfjqGKAP2Wy/CU1Z 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 _x0040_ParamDateFrom,ParamDateFrom,31,0 _x0040_ParamDateTo,ParamDateTo,31,0 select * from ViewEmpSummary ,ParamDateFrom,ParamDateFrom,System.DateTime,_x0039__x002F_13_x002F_2012_x0020_12:26:16_x0020_PM,False,False ,ParamDateTo,ParamDateTo,System.DateTime,_x0039__x002F_13_x002F_2012_x0020_12:26:34_x0020_PM,False,False EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.4,19,2.51 Transparent 0.01,0,19.01,2.51 73586b780f524eaabf6bc24f2b7f1b78 SubReport1 True 934d0bde7cab48d5bba7cfabe8ddfabb PageHeaderBand1 Transparent 0,3.71,19,1.6 [240:240:240] 0,0.2,19,0.8 Arial,20.25,Underline 8f77e76a74284741963f224fbf023acf Center 0,0,0,0 Text17 Early and Late Come Report Black Expression Center ReportTitleBand1 None;[193:152:89];1;Solid;False;4;Black Transparent 0,6.11,19,2.2 Transparent 0,0.03,19,2.17 b9cb74f476f040b7ace0bf3f2c691dff SubReport2 0916da4d02354fad93d5ffb5835ea648 Data1 ViewEmpSummary 4d1f54fac5524963b022d2c5454ef431 True KeepDetailsTogether DataBand2 84b7e53fc4454499aad3ce405b62682e 1,1,1,1 Page1 29.7 21 A4 Arial,100 [50:0:0:0] None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.4,19,2.23 None;[193:152:89];1;Solid;False;4;Black White 0.18,0.73,2.5,0.5 Arial,9,Bold ae86730c92194adb8c3677d180e68e2a Center 0,0,0,0 Text2 Employee ID : Black Expression Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 1.07,1.59,2.39,0.5 Arial,9,Bold 4be27e51ee1c4437b922c387257bd45c Center 0,0,0,0 Text11 Punch In Black Expression Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 11.7,1.59,2.61,0.5 Arial,9,Bold 41adfcf1a37b4cb381871eba38441cca Center 0,0,0,0 Text12 Leave Early Black Expression Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 14.36,1.6,2,0.5 Arial,9,Bold 30191f58f9dc4ecb8c6199fa39dc1b6c Center 0,0,0,0 Text13 Leave Late Black Expression Center None;[193:152:89];1;Solid;False;4;Black Transparent 2.55,0.94,2.04,0.5 Arial,9 8fb9ecf9789e49d2a53b145caf0be98b Center 0,0,0,0 Text5 {ViewEmpSummary.EmpID} Black DataColumn Center None;[193:152:89];1;Solid;False;4;Black White 5.22,0.95,2.65,0.5 Arial,9,Bold 12588e239333480e81de7b1ba3b4a0f0 Center 0,0,0,0 Text6 Employee Name : Black Expression Center None;[193:152:89];1;Solid;False;4;Black Transparent 8.01,0.95,3.68,0.5 Arial,9 46aeaab96204433e8a191ebc07ba1082 0,0,0,0 Text7 {ViewEmpSummary.EmpNameEn} Black Expression Center None;[193:152:89];1;Solid;False;4;Black White 12.71,0.95,2.65,0.5 Arial,9,Bold 4501c3bd471e4dcab5bfad173875042a Center 0,0,0,0 Text8 Department : Black Expression Center None;[193:152:89];1;Solid;False;4;Black Transparent 15.43,0.97,2.78,0.5 Arial,9 3a9e62b8b7ca42e58f7709d132ffff62 0,0,0,0 Text14 {ViewEmpSummary.DepNameEn} Black DataColumn Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 3.52,1.59,2.41,0.5 Arial,9,Bold 090991283104480ab1a3b48b46356501 Center 0,0,0,0 Text15 Punch Out Black Expression Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 5.99,1.59,2.81,0.5 Arial,9,Bold a5d847e7e36c442f82f25f60d706e3d3 Center 0,0,0,0 Text18 Begin Early Black Expression Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 8.86,1.59,2.8,0.5 Arial,9,Bold f7c5c84b3c324b83b68d5221e636f2ff Center 0,0,0,0 Text20 Begin Late Black Expression Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 16.42,1.6,2.55,0.5 Arial,9,Bold ddb2685541664f90adfa0a511b12a3c5 Center 0,0,0,0 Text22 Total Work Hours Black Expression Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 0,1.59,1.01,0.5 Arial,9,Bold,Point,False,0 30ca4f38584745498add92da887099dd Center 0,0,0,0 Text1 No Black Expression Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 6.92,0.08,2.41,0.5 Arial,9,Bold 892be77bff034ad58462909eebd1f097 Center 0,0,0,0 Text4 Date Black Expression Center None;[193:152:89];1;Solid;False;4;Black Transparent 9.5,0.04,3.68,0.5 Arial,9 3f12eeec530a47658c61c69d55799da3 0,0,0,0 Text25 {ViewEmpSummary.SsmDate} Black DataColumn Center 6.63,1.9,0,0 StartPointPrimitive3 e62cb4b924c74f54963923fa37121897 {ViewEmpSummary.EmpNameEn} b23c8dd358b94bebacbd50668180a803 True GroupHeaderBand2 Transparent True 0,3.43,19,0.65 All;[193:152:89];1;Solid;False;4;Black Transparent True True 1.07,0,2.39,0.5 Arial,9 True 13ac8052657c41ce83537b01081f9307 Center 0,0,0,0 Text3 {Hour(ViewEmpSummary.SsmPunchIn)}:{Minute(ViewEmpSummary.SsmPunchIn)}:{Second(ViewEmpSummary.SsmPunchIn)} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression Center All;[193:152:89];1;Solid;False;4;Black Transparent True True 11.71,0,2.61,0.5 Arial,9 True 24fa776beece49ee871e3f8c4b00e5a1 Center 0,0,0,0 Text9 {IntToTime(ViewEmpSummary.SsmOutEarly)} Black , 0 0 HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression Center All;[193:152:89];1;Solid;False;4;Black Transparent True True 14.38,0,2,0.5 Arial,9 True ab7d645e78b647a1b7557634709b78d2 Center 0,0,0,0 Text10 {IntToTime(ViewEmpSummary.SsmOutLate)} Black , 1 HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression Center All;[193:152:89];1;Solid;False;4;Black Transparent True True 3.52,0,2.41,0.5 Arial,9 True 69045052984b4c3c8b332a5778b586dd Center 0,0,0,0 Text16 {Hour(ViewEmpSummary.SsmPunchOut)}:{Minute(ViewEmpSummary.SsmPunchOut)}:{Second(ViewEmpSummary.SsmPunchOut)} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression Center All;[193:152:89];1;Solid;False;4;Black Transparent True True 5.99,0,2.81,0.5 Arial,9 True 641159c850154df283c2df9ab55dc169 Center 0,0,0,0 Text19 {IntToTime(ViewEmpSummary.SsmBeginEarly)} Black , 0 0 HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression Center All;[193:152:89];1;Solid;False;4;Black Transparent True True 8.86,0,2.8,0.5 Arial,9 True ff3db67871724c31be10d775215dcde6 Center 0,0,0,0 Text21 {IntToTime(ViewEmpSummary.SsmBeginLate)} Black , 0 0 HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression Center All;[193:152:89];1;Solid;False;4;Black Transparent True True 16.42,0,2.55,0.5 Arial,9 True b8f3df4729de494b89b92836ce5f68bf Center 0,0,0,0 Text23 {IntToTime(ViewEmpSummary.SsmActualWorkDuration)} Black , 1 HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression Center All;[193:152:89];1;Solid;False;4;Black Transparent True True 0,0,1.01,0.5 Arial,9 True 5f5c43fccc3b420fa1cd5a9127a99b50 Center 0,0,0,0 Text24 {Line} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression Center ViewEmpSummary f899e43f46444c6dbd937d1ce858d45a True KeepDetailsTogether True DataBand1 Transparent 0,4.88,19,0.86 All;Black;1;Solid;False;4;Black Transparent 14.39,0.12,2.02,0.6 Arial,9,Regular,Point,False,0 fed295a14dd84da18cec42c72759d111 Center 0,0,0,0 Text29 {Sum(ViewEmpSummary.SsmOutLate)} Black Expression Center All;Black;1;Solid;False;4;Black Transparent 11.69,0.12,2.65,0.6 Arial,9,Regular,Point,False,0 35356b1f131941c894003f226d47b297 Center 0,0,0,0 Text30 {Sum(ViewEmpSummary.SsmOutEarly)} Black Expression Center All;Black;1;Solid;False;4;Black Transparent 8.81,0.12,2.83,0.6 Arial,9,Regular,Point,False,0 a17184b1cc9946219300b550491f36c8 Center 0,0,0,0 Text33 {Sum(ViewEmpSummary.SsmBeginLate)} Black Expression Center All;Black;1;Solid;False;4;Black Transparent 5.89,0.12,2.85,0.6 Arial,9,Regular,Point,False,0 07ccf6b79abc4465b735fe671dc66c4b Center 0,0,0,0 Text34 {IntToTime({Sum(ViewEmpSummary.SsmBeginEarly)})} Black Expression Center All;Black;1;Solid;False;4;Black Transparent 0.26,0.12,5.49,0.6 Arial,9,Regular,Point,False,0 fc2bedf4f3c0473e92fc169984cb19c4 Right 0,0,0,0 Text35 Total: Black Expression Center bc9ddf2bf2214cab8b0cbe2b6f13b11c GroupFooterBand1 19.72,1.24,0,0 EndPointPrimitive2 975ef1509e6e424bacf5567928ab049a 25.44,3.3,0,0 EndPointPrimitive3 e62cb4b924c74f54963923fa37121897 0916da4d02354fad93d5ffb5835ea648 1,1,1,1 subReport_1 27.94 21 Letter 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 11/18/2012 11:47:54 AM 7/23/2012 1:38:34 PM C:\Documents and Settings\malwahidi\Desktop\Reports Done\Employees\LateAndEarlyCome.mrt 4e07b8d21da34ec4bef2e66da18fdbc7 Report Centimeters 2012.2.1400 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]