Management Provider=Microsoft.ACE.OLEDB.12.0;Data Source=e:\Management.mdb;Persist Security Info=False Micromanager Management Timelogs ID,System.String LinkID,System.String LinkIDCategory,System.String Archived,System.Boolean ArchiveDate,System.DateTime ArchivedByID,System.String ArchivedBy,System.String LinkIDEmployee,System.String LinkIDWorkOrder,System.String LinkIDGroup,System.String LinkIDProduct,System.String LinkIDPart,System.String LinkIDStation,System.String LinkIDOperation,System.String Type,System.Int32 TimeStampIn,System.DateTime TimeStampOut,System.DateTime RecordDate,System.DateTime TotalTime,System.Double TimeLogNotes,System.String RecordMemo,System.String TimeLogAction,System.String RecordFlagModified,System.Int32 RecordFlagOpen,System.Boolean RecordFlagAdvanced,System.String AddInfo1,System.String AddInfo2,System.String AddInfo3,System.String AddInfo4,System.String AddInfo5,System.String TimeINDec,TimeINDec,System.Nullable`1[System.Decimal],_x0028_Hour_x0028_Timelogs.TimeStampIn_x0029__x002A_60_x002A_60_x002B_Minute_x0028_Timelogs.TimeStampIn_x0029__x002A_60_x002B_Second_x0028_Timelogs.TimeStampIn_x0029__x0029_ TimeOUTDec,TimeOUTDec,System.Nullable`1[System.Decimal],_x0028_Hour_x0028_Timelogs.TimeStampOut_x0029__x002A_60_x002A_60_x002B_Minute_x0028_Timelogs.TimeStampOut_x0029__x002A_60_x002B_Second_x0028_Timelogs.TimeStampOut_x0029__x0029_ DateINSerial,DateINSerial,System.Int64,DayOfYear_x0028_Timelogs.TimeStampIn_x0029_ DBStartDate,DBStartDate,System.Nullable`1[System.DateTime],Timelogs.TimeStampIn.Date 30 Timelogs Micromanager Management select * from TimeLogs ,TimeIn,TimeIn,Rounded_x0020_Start_x0020_Time,System.Decimal,Min_x0028_GroupHeader2_x002C_Timelogs.TimeINDec_x0029_,False,True,False ,PaidHours,PaidHours,System.Double,,False,False ,Val,Val,System.Double,,False,False EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,9.92,7.72,0.3 Transparent 4.3,0.09,0.6,0.2 Arial,9,Italic 0,0,0,0 Text16 {PageNumber} Black Bottom Transparent 3.8,0.09,0.4,0.2 Arial,9,Italic 0,0,0,0 Text17 Page Black Bottom Transparent 5,0.08,0.7,0.2 Arial,9,Italic,Point,False,0 Center 0,0,0,0 Text3 Printed On: Black Expression Bottom Transparent 5.7,0.08,1.8,0.2 Arial,9,Italic,Point,False,0 Center 0,0,0,0 Text5 {Time} Black SystemVariables Bottom PageFooter1 Transparent 0,0.2,7.72,0.7 All;Black;1;Solid;False;4;Black Transparent 3.2,0,4.2,0.6 Transparent 0,0,4.3,0.3 Arial,14.25,Bold,Point,False,0 Center 0,0,0,0 Text11 Employee Payroll Time Report by Date Black Bottom Transparent 0,0.35,4.3,0.2 Arial,11 Center 0,0,0,0 Text12 Payroll Period: {Format("{0:MM/dd/yyyy}", StartDate.Value)} to {Format("{0:MM/dd/yyyy}", EndDate.Value)} Black Expression Panel1 Header1 Transparent 0,1.3,7.72,0.2 Transparent 0,0,0.7,0.2 Arial,10 0,0,0,0 Text2 Employee Black Transparent 2.5,0,0.8,0.2 Arial,9.75,Regular,Point,False,0 0,0,0,0 Text4 Clock In Black Transparent 3.6,0,0.8,0.2 Arial,9.75,Regular,Point,False,0 0,0,0,0 Text6 Clock Out Black Transparent 4.5,0,1,0.2 Arial,9.75,Regular,Point,False,0 444fc64476264b89bee0806d2da3a754 0,0,0,0 Text23 Hours Worked Black Transparent 5.5,0,1,0.2 Arial,9.75,Regular,Point,False,0 d7c7e6781edd431ea8e671bfdeffda86 0,0,0,0 Text25 Unpaid Lunch Black Transparent 6.6,0,1,0.2 Arial,9.75,Regular,Point,False,0 b15d2d30fd3a42e788cc28b28461ddf6 0,0,0,0 Text26 Paid Hours Black Transparent 0.8,0,1.6,0.2 Arial Narrow,12,Bold 0,0,0,0 Text1 {Timelogs.LinkIDEmployee} Black {Timelogs.LinkIDEmployee} GroupHeader3 Transparent 0,1.9,7.72,0.2 Transparent 0,0,0.7,0.2 Arial,10 0,0,0,0 Text8 {(Timelogs.TimeStampIn)} Black Transparent 0.9,0,0.6,0.2 Arial,10 0,0,0,0 Text20 False {Min(GroupHeader2,Timelogs.TimeINDec)} EmptyBrush Transparent 1.7,0,0.6,0.2 Arial,10 0,0,0,0 Text21 False {Max(GroupHeader2,Timelogs.TimeOUTDec)} EmptyBrush Transparent 2.6,0,0.6,0.2 Arial,10,Bold 0b3b97135bed46948f76a245d4152d93 0,0,0,0 Text10 {TimeSerial(Floor((Ceiling((Min(GroupHeader2,Timelogs.TimeINDec)-5*60)/60/15)*60*15)/60/60),(((Ceiling((Min(GroupHeader2,Timelogs.TimeINDec)-5*60)/60/15)*60*15)/60/60-(Floor((Ceiling((Min(GroupHeader2,Timelogs.TimeINDec)-5*60)/60/15)*60*15)/60/60)))*60),0)} Black Transparent 3.6,0,0.6,0.2 Arial,10,Bold e4dd5797584b463d8d96fb0a837be507 0,0,0,0 Text18 {TimeSerial(Floor((Floor((Max(GroupHeader2,Timelogs.TimeOUTDec)+0*60)/60/15)*60*15)/60/60),(((Floor((Max(GroupHeader2,Timelogs.TimeOUTDec)+0*60)/60/15)*60*15)/60/60-(Floor((Floor((Max(GroupHeader2,Timelogs.TimeOUTDec)+0*60)/60/15)*60*15)/60/60)))*60),0)} Black Expression Transparent 4.7,0,0.6,0.2 Arial,10 9c19a7c3c6df4b6093438f6ffd97c6f8 0,0,0,0 Text22 {((Floor((Max(GroupHeader2,Timelogs.TimeOUTDec)+5*60)/60/15)*60*15)-(Ceiling((Min(GroupHeader2,Timelogs.TimeINDec)-5*60)/60/15)*60*15))/60/60} Black Transparent 5.7,0,0.6,0.2 Arial,10 072b5290ed224247936731fadc8693cc 0,0,0,0 Text24 {IIF(((Floor((Max(GroupHeader2,Timelogs.TimeOUTDec)+0*60)/60/15)*60*15)-(Ceiling((Min(GroupHeader2,Timelogs.TimeINDec)-5*60)/60/15)*60*15))/60/60>5,.5,0)} Black Expression Val = Val + ((System.Math.Floor((Totals.Max(GroupHeader2,Timelogs.TimeOUTDec)+0*60)/60/15)*60*15)-(System.Math.Ceiling((Totals.Min(GroupHeader2,Timelogs.TimeINDec)-5*60)/60/15)*60*15))/60/60-IIF(((System.Math.Floor((Totals.Max(GroupHeader2,Timelogs.TimeOUTDec)+0*60)/60/15)*60*15)-(System.Math.Ceiling((Totals.Min(GroupHeader2,Timelogs.TimeINDec)-5*60)/60/15)*60*15))/60/60>5,0.5,0) PaidHours Transparent 6.6,0,0.6,0.2 Arial,9.75,Bold,Point,False,0 cc65ab45a22d418f96e66cdb1d25bf98 0,0,0,0 Text27 {((Floor((Max(GroupHeader2,Timelogs.TimeOUTDec)+0*60)/60/15)*60*15)-(Ceiling((Min(GroupHeader2,Timelogs.TimeINDec)-5*60)/60/15)*60*15))/60/60-IIF(((Floor((Max(GroupHeader2,Timelogs.TimeOUTDec)+0*60)/60/15)*60*15)-(Ceiling((Min(GroupHeader2,Timelogs.TimeINDec)-5*60)/60/15)*60*15))/60/60>5,0.5,0)} Black Expression [132:162:198] 7.2,0,0.5,0.2 Arial,8 0,0,0,0 Text7 {Val} Black {Timelogs.DateINSerial} True GroupHeader2 Bottom;Black;1;Solid;False;4;Black Transparent 0,2.5,7.72,0 ContactsTimeLogs Timelogs _x007B_IIF_x0028_Timelogs.DBStartDate_x0020__x003E__x003D__x0020_StartDate.Value.Date_x002C__x0020_TRUE_x002C__x0020_FALSE_x0029__x007D_ Type,NotEqualTo,_x0031_1,_x0031_2,Numeric _x007B_IIF_x0028_Timelogs.DBStartDate_x003C__x003D__x0020_EndDate.Value.Date_x002C__x0020_TRUE_x002C__x0020_FALSE_x0029__x007D_ True True DataTimelogs ASC TimeStampIn Transparent 0,2.9,7.72,0 GroupHeaderBand1 Top;Black;1;Solid;False;4;Black Transparent 0,3.3,7.72,0.2 EmptyBrush 5.1,0,0.9,0.2 False Arial,11 50abe99ea21e46059798012ee131d231 0,0,0,0 Text13 Total Hours: Black Expression GroupFooter1 348d97dadd7241f88f46f197112d72fd 0.39,0.39,0.39,0.39 Page1 11 8.5 Arial,100 [50:0:0:0] Control 200,88,96,24 OK Microsoft Sans Serif,8 Black 200, 88 Button1 96, 24 OK Window 8,56,152,20 Microsoft Sans Serif,8 Black 8, 56 12/31/9998 12:00:00 AM 1/1/2008 12:00:00 AM StartDate 152, 20 7/13/2010 11:02:02 AM Window 200,56,152,20 Microsoft Sans Serif,8 Black 200, 56 12/31/9998 12:00:00 AM 1/1/2008 12:00:00 AM EndDate 152, 20 7/13/2010 11:02:49 AM Control 8,16,144,24 Microsoft Sans Serif,8 Black 8, 16 Label1 144, 24 Start Date Control 200,16,144,24 Microsoft Sans Serif,8 Black 200, 16 Label 2 144, 24 End Date Microsoft Sans Serif,8 2c9f758b10b1433ebc9d35cd861fc94c 0, 0 Form1 376, 152 Form1 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 5/30/2012 12:25:06 PM 6/11/2010 9:28:33 AM E:\Generic Payroll Time Log - Weekly.mrt 71cc3eafe0b24726a4710cadedc5c56e Report Inches 2012.2.1306 VB