本人试做了网页用红绿灯表示进度,供领导参考。 SQL是 SELECT MSP_WEB_ASSIGNMENTS.ASSN_START_DATE AS startdate, MSP_WEB_ASSIGNMENTS.ASSN_FINISH_DATE AS finishdate, MSP_WEB_ASSIGNMENTS.TASK_NAME AS taskname, MSP_WEB_PROJECTS.PROJ_NAME AS projname, MSP_WEB_ASSIGNMENTS.WASSN_COMMENTS AS comments, MSP_WEB_ASSIGNMENTS.WASSN_PCT_COMP AS pctcomp, MSP_WEB_RESOURCES.RES_NAME AS resname, MSP_WEB_RESOURCES_1.RES_NAME AS Mgr, MSP_WEB_PROJECTS.PROJ_ID AS projid, MSP_WEB_ASSIGNMENTS.TASK_UID AS taskuid FROM MSP_WEB_ASSIGNMENTS INNER JOIN MSP_WEB_PROJECTS ON MSP_WEB_ASSIGNMENTS.WPROJ_ID = MSP_WEB_PROJECTS.WPROJ_ID INNER JOIN MSP_WEB_RESOURCES ON MSP_WEB_ASSIGNMENTS.WRES_ID = MSP_WEB_RESOURCES.WRES_ID INNER JOIN MSP_WEB_RESOURCES MSP_WEB_RESOURCES_1 ON MSP_WEB_ASSIGNMENTS.WRES_ID_MGR = MSP_WEB_RESOURCES_1.WRES_ID WHERE (MSP_WEB_ASSIGNMENTS.WASSN_IS_CONFIRMED = 1) AND (MSP_WEB_ASSIGNMENTS.WASSN_DELETED_IN_PROJ = 0) AND (MSP_WEB_ASSIGNMENTS.WASSN_PCT_COMP < 100) ORDER BY MSP_WEB_ASSIGNMENTS.ASSN_FINISH_DATE