报告中字段的条件格式 [英] Conditional formatting of field in report
问题描述
这是工资单报告
我有txtRegHrs和txtOThrs。如果常规时间> 40或者常规时间<40但是加班时间超过0,我想要进行条件格式化以更改背景颜色。我本周有一个案例是员工有38小时常规
时间和8小时的加班时间,但应该是40小时常规和6小时加班。
I have txtRegHrs and txtOThrs. I want to do conditional formatting to change the background color if regular hours >40 or if regular hours <40 but overtime hours are more than 0. I had a case this week were an employee got 38 hours of regular time and 8 hrs of overtime, but it should have been 40 Hours regular and 6 hours overtime.
价值 > 40个单独作品
Value >40 works by itself
值> 40 或值< 40和[txtothrs]> 0 - 不起作用
Value >40 or Value <40 and [txtothrs]>0 - does not work
推荐答案
尝试使用表达式。例如:
Try using an expression instead. For example:
表达式是:[txtRegHrs]> 40 OR([txtOTHrs]> 0和[txtRegHrs]< 40)
Expression Is: [txtRegHrs]>40 OR ([txtOTHrs]>0 AND [txtRegHrs]<40)
希望它有所帮助......
Hope it helps...
这篇关于报告中字段的条件格式的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!