Return third column (filed) value by comparing two coulmns (fileds) in rdlc

• Question

• 

  

  0

  Sign in to vote

  Hi,

  I need to compare something like

  three fields of a table are -  1) stage_id 2) status_id  3) task_count

  book_id    stage_id    status_id    task_count
  24              5                2               40
  24              3                1               20
  24              11               2               50
  .

  .

  .

  based on stage_id and status_id fields i need to display task_count.

  =IIF(Fields!stage_id =3 and Fields!status_id =2  , Fields!task_count.Value, 0)

  but it didn't work ...

  Please somebody help!!!!!!!

   

  Thanks!

  Thursday, February 17, 2011 2:08 PM