Employee ## ## Worked Hours
1 40
2 40
3 24
4 0
5 40
So I made this summary in Microsoft SQL Server Report Builder 2012 3.0.
Now I want to run this report but when I run it, it should not show the rows where the 'Worked Hours' are equal to 40
. I tried to base the row visibility on an IIf-expression
but it always gives me an error.
所以我在Microsoft SQL Server Report Builder 2012 3.0中做了这个总结。现在我想运行这个报告,但是当我运行它时,它不应该显示'Worked Hours'等于40的行。我试图将行可见性基于IIf表达式,但它总是给我一个错误。
This is the expression I used: = IIf(Fields!TotalHours.Value<>40, 1,0)
这是我使用的表达式:= IIf(Fields!TotalHours.Value <> 40,1,0)
Is there anyone around here? who can give me the correct answer?
这附近有人吗?谁能给我正确的答案?
1 个解决方案
#1
1
Have you tried as below in Show or Hide Based on Expression
option ?
您是否尝试过如下显示或隐藏基于表达式选项?
=IIF( Fields!TotalHours.Value = 40, True, False )
#1
1
Have you tried as below in Show or Hide Based on Expression
option ?
您是否尝试过如下显示或隐藏基于表达式选项?
=IIF( Fields!TotalHours.Value = 40, True, False )