根据表达式在Microsoft SQL Server Report Builder 2012 3.0中隐藏行

时间:2021-01-25 08:11:23

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 )