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

  • Question

  • 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

All replies

  • please post to the report controls forum. This forum is for improving this forum engine. 

    The following is signature, not part of post
    Please mark the post answered your question as the answer, and mark other helpful posts as helpful, so they will appear differently to other users who are visiting your thread for the same problem.
    Visual C++ MVP
    Thursday, February 17, 2011 11:17 PM
    Moderator