报表定义及发布-考勤汇总表，显示第一段上班时间和第一段下班时间，并只显示小时和分钟，请参考红色字体，在原有数据源上添加：SELECT"atsResult_adOrg.displayName","atsResult_adOrg.name","ats_person.number","ats_person.name","ATS_RESULT.attenceDate","ATS_RESULT.S16","ATS_RESULT.S17","ATS_RESULT.S19","ATS_RESULT.S21","ATS_RESULT.S23","ATS_RESULT.S28","ATS_RESULT.S45","ATS_RESULT.S48","ATS_RESULT.S42","ATS_RESULT.S52","ATS_RESULT.S54","ATS_RESULT.S63","ATS_RESULT.S55","ATS_RESULT.S56","ATS_RESULT.S58","ATS_RESULT.S59","ATS_RESULT.S60","ATS_RESULT.S35","ATS_RESULT.S36","ATS_RESULT.S37","ATS_RESULT.S32","ATS_RESULT.S33","ATS_RESULT.S34",substring("ATS_RESULT.S1",12,5)as"上班时间",substring("ATS_RESULT.S2",12,5)as"下班时间"from(SELECTDISTINCT"ATSRESULT_ADORGT".FDisplayName_l2AS"atsResult_adOrg.displayName","ATSRESULT_ADORG".FName_l2AS"atsResult_adOrg.name","ATS_PERSON".FNumberAS"ats_person.number","ATS_PERSON".FName_l2AS"ats_person.name","ATS_RESULT".FAttenceDateAS"ATS_RESULT.attenceDate","ATS_RESULT".S16AS"ATS_RESULT.S16","ATS_RESULT".S17AS"ATS_RESULT.S17","ATS_RESULT".S19AS"ATS_RESULT.S19","ATS_RESULT".S21AS"ATS_RESULT.S21","ATS_RESULT".S23AS"ATS_RESULT.S23","ATS_RESULT".S28AS"ATS_RESULT.S28","ATS_RESULT".S45AS"ATS_RESULT.S45","ATS_RESULT".S48AS"ATS_RESULT.S48","ATS_RESULT".S42AS"ATS_RESULT.S42","ATS_RESULT".S52AS"ATS_RESULT.S52","ATS_RESULT".S54AS"ATS_RESULT.S54","ATS_RESULT".S63AS"ATS_RESULT.S63","ATS_RESULT".S55AS"ATS_RESULT.S55","ATS_RESULT".S56AS"ATS_RESULT.S56","ATS_RESULT".S58AS"ATS_RESULT.S58","ATS_RESULT".S59AS"ATS_RESULT.S59","ATS_RESULT".S60AS"ATS_RESULT.S60","ATS_RESULT".S35AS"ATS_RESULT.S35","ATS_RESULT".S36AS"ATS_RESULT.S36","ATS_RESULT".S37AS"ATS_RESULT.S37","ATS_RESULT".S32AS"ATS_RESULT.S32","ATS_RESULT".S33AS"ATS_RESULT.S33","ATS_RESULT".S34AS"ATS_RESULT.S34",to_char("ATS_RESULT".S1,'yyyy-mm-ddhh24:mi:ss')AS"ATS_RESULT.S1",to_char("ATS_RESULT".S2,'yyyy-mm-ddhh24:mi:ss')AS"ATS_RESULT.S2"FROMT_HR_ATS_ATTENDANCEFILEAS"ATTENDANCEFILE"LEFTJOINT_HR_ATS_ATTENDANCERESULTAS"ATS_RESULT"ON"ATS_RESULT".FProposerID="ATTENDANCEFILE".FPROPOSERIDLEFTJOINT_ORG_ADMINHISAS"ATSRESULT_ADORG"ON"ATSRESULT_ADORG".FhistoryRelateID="ATS_RESULT".FADMINORGUNITIDLEFTJOINT_ORG_ADMINORGTREEHISAS"ATSRESULT_ADORGT"ON"ATSRESULT_ADORG".FhistoryRelateID="ATSRESULT_ADORGT".FAdminOrgIDAND"ATSRESULT_ADORGT".FEFFDT<={ts'2019-03-2300:00:00'}AND"ATSRESULT_ADORGT".FLEFFDT>={ts'2019-03-2300:00:00'}LEFTJOINT_BD_PERSONHISAS"ATS_PERSON"ON"ATS_PERSON".FhistoryRelateID="ATTENDANCEFILE".FPROPOSERIDLEFTJOINT_ORG_ADMINHISAS"ATSRESULT_HRORG"ON"ATSRESULT_HRORG".FhistoryRelateID="ATS_RESULT".FATTADMINORGUNITIDLEFTJOINT_ORG_ADMINORGTREEHISAS"ATSRESULT_HRORGT"ON"ATSRESULT_HRORG".FhistoryRelateID="ATSRESULT_HRORGT".FAdminOrgIDAND"ATSRESULT_HRORGT".FEFFDT<={ts'2019-03-2300:00:00'}AND"ATSRESULT_HRORGT".FLEFFDT>={ts'2019-03-2300:00:00'}WHERE(("ATS_RESULT".FAdminOrgUnitIDin(SELECTFIDFROMT_ORG_AdminWHERE(FLongNumber='@adminOrg'OR(FLongNumberLIKE'@adminOrg%')))or"ATS_RESULT".FAttadminOrgUnitIDin(SELECTFIDFROMT_ORG_AdminWHERE(FLongNumber='@adminOrg'OR(FLongNumberLIKE'@adminOrg%'))))and"ATS_RESULT".FAttenceDate>={ts'@startDate'}and"ATS_RESULT".FAttenceDate<={ts'@endDate'}and"ATSRESULT_ADORG".FEFFDT<={ts'2019-03-2300:00:00'}and"ATSRESULT_ADORG".FLEFFDT>={ts'2019-03-2300:00:00'}and"ATSRESULT_HRORG".FEFFDT<={ts'2019-03-2300:00:00'}and"ATSRESULT_HRORG".FLEFFDT>={ts'2019-03-2300:00:00'}and"ATS_PERSON".FEFFDT<={ts'2019-03-2300:00:00'}and"ATS_PERSON".FLEFFDT>={ts'2019-03-2300:00:00'}))tempTT
