condition in RDLC RRS feed

  • Question

  • hi

     i had three columns in RDLC file one is site name , 2nd one is compilance result and third one is column group under which file and record count are there.

    i need to update the 2nd column value by specifying the conditions  c2  = if (file count and record count contains non zero values count those divided by the count the date column ) * 100

    how to specify the condition in RDLC

    Thank you in Advance

    - Ram

    Wednesday, February 6, 2013 2:14 PM

All replies

  • Attach a formula to the column with a nested if (for both conditions) and the math if it passes.

    The script to evaluate datasource objects is like this. You can nest IIF statement.

    =Iif(Fields!LineTotal.Value > 100, True, False)

    =Iif(Fields!PctComplete.Value >= .8, "Green",
          Iif(Fields!PctComplete.Value >= .5, "Amber", "Red"))

    Monday, February 11, 2013 11:19 PM