In a SSRS (BIDS) 2008 report that I have created, I have a conditional statement I'm trying to use to determine the Visibility of items in a column.
An expression almost identical to this works on the General tab, but not on the Visibility tab. I get the following error when trying to preview the report
An error occurred during local report processing. The Hidden expression used in textbox 'Status' returned a data type that is not valid.
I have pasted the conditional below for your reference. Do the rules/formatting for Visibility expressions differ from those of the General tab? Thanks!
=IIf(Fields!tagname.Value="3981.CompA1.Bool.CompA1StatusOnline"
And Fields!Status.Value="0","True",
iif(Fields!tagname.Value="3981.CompA1.Bool.CompA1StatusFaulted"
And Fields!Status.Value="1","True",
iif(Fields!tagname.Value="3981.CompA1.Bool.CompA1StatusOffline"
And Fields!Status.Value="0","True","False")))
Try using true instead of "true".
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With