Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

using conditionals in SSRS for visibility

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")))
like image 241
singledee Avatar asked Jan 30 '26 23:01

singledee


1 Answers

Try using true instead of "true".

like image 145
Ross Bush Avatar answered Feb 01 '26 12:02

Ross Bush



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!