CODEWITHSUNDEEP
sqlreporting-servicesssrs-2012
Jorgen V
Jorgen V

Reputation: 313

Hide a row in Microsoft SQL Server Report Builder 2012 3.0 based on an expression

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.

This is the expression I used: = IIf(Fields!TotalHours.Value<>40, 1,0)

Is there anyone around here? who can give me the correct answer?

Upvotes: 1

Views: 164

Answers (1)

bmsqldev
bmsqldev

Reputation: 2735

Have you tried as below in Show or Hide Based on Expression option ?

=IIF( Fields!TotalHours.Value = 40, True, False )

Upvotes: 1

Related Questions