how to apply if Condition in rdlc report to display "Yes" if the column return true value and if it display false return "No"
Asked Answered
C

2

6

i am working on rdlc report , i have a column in rdlc report , and i want if there is true value , return me "YES" and if there is false return "NO" i have tried the following code but it not working

=iif(Field!Application.value)="True","Yes","No"))

thanks in advance.

Chess answered 25/4, 2014 at 10:49 Comment(0)
W
7

I thought it was like this

=IIf(Field!Application.Value = true,"yes","no")

1) 'V' is supposed to be capital 2) parenthesis should be at the end.

Woollen answered 25/4, 2014 at 20:59 Comment(1)
Field needs to be FieldsInopportune
L
5

You can use the IIf command:

=IIf(<Expression as Boolean>, <TruePart as Object>, <FalsePart as Object>) as Object

Like this:

=IIf(Fields!Application.Value = true, "Yes", "No")

This works to me, bye!

Lennyleno answered 19/10, 2017 at 16:25 Comment(0)

© 2022 - 2024 — McMap. All rights reserved.