how to show and hide a label based on string value in rdlc

priyanka

=IIF((Fields!ShippingCase.Value, "DS_Invoice") =="true", false, true)

Please help me in correcting the syntax.Here,I have to compare shippingcase value is true or not.

11 Replies

Know the answer? Post it — somebody with the same question will find it here.

Krishna Kumar9y ago
Good Work. Need to change the textbox value to .Tostring.
priyanka9y ago
I have solved this query.The working code is as follows
IIF((First(Fields!ShippingCase.Value, "DS_Invoice")).ToString().Equals("true"), false, true)
priyanka9y ago
it's nothing like that
=IIF((Fields!ShippingCase.Value&Fields! "DS_Invoice") =="true", false, true)
since we are using Fields!ShippingCase.Value&Fields it throws this error,when we will use
Fields!ShippingCase.Value it will remove this overloading error
Krishna Kumar9y ago
The error specifies that you are not reading the value of textbox properly. check on that and insert into that condition the it will work
priyanka9y ago
The Visibility.Hidden expression for the text box ‘SHIPPING_CHG’ contains an error: [BC30516] Overload resolution failed because no accessible 'IIf' accepts this number of arguments.

here textbox '' SHIPPING_CHG" is where i am putting expression
Krishna Kumar9y ago
What is the error message?
priyanka9y ago
=IIF((Fields!ShippingCase.Value&Fields! "DS_Invoice") =="true", false, true)

Not Yet Working,after using this

Try this

IIF((Fields!ShippingCase.Value&Fields! "DS_Invoice") =="true", false, true)

Krishna Kumar9y ago
You can use terinary operator rather than IIF

bool result=shippingcase.value=ds_invoice ? 1 : 0

It will give the result as 1 if the values are equal
and result as 0 if the values are not equal.
priyanka9y ago
The Visibility.Hidden expression contains a colon or a line terminator. Colons and line terminators are not valid in expression.

Please help me to resolve this.

Try this

 =IIF((Fields!ShippingCase.Value, "DS_Invoice") =="true" ? false : true)