报告服务- SSRS，比较两行，如果为零则突出显示

Question

TOTALBILLAMOUNT TAXAMOUNT   DEPOSITE CASH
80000              0          0
90001              0          9825
100000             0          15000
110000             0          24113
120004            1000        133565

如果存款大于5000，那么taxamount不应该等于零。

Answer 1

进入所需的单元格属性-> background color-> expression:

=IIf((Fields!DEPOSITECASH.Value > 5000) AND (Fields!TAXAMOUNT.Value = 0),"Red","Transparent")