图1

图2       

sql如下  

SELECT a.EXCELDATE,a.CONTRACTNAME,a.BIDDEPT,a.DEPTFLAG,a.INPUTDATE,

'批评:'+a.CRITICIZE as parseOrCriticize

FROM CGHSE_SafetyAss_8 a WHERE a.CRITICIZE<>''

UNION

SELECT b.EXCELDATE,b.CONTRACTNAME,b.BIDDEPT,b.DEPTFLAG,b.INPUTDATE,

'表扬:'+b.PRAISE as parseOrCriticize

FROM CGHSE_SafetyAss_8 b WHERE b.PRAISE<>''

大佬们这个需求帆软有办法实现吗？

我试了用条件属性更改字符串的颜色，因为我这个需求特殊，只能修改批评或者表扬的颜色，不能都改

replace($$$,"表扬","<font color='red'>表扬</font>")||

replace($$$,"批评","<font color='red'>批评</font>")