CODEWITHSUNDEEP
ssrs-2008visibilityconditional-statements
singledee
singledee

Reputation: 47

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")))

Upvotes: 3

Views: 3864

Answers (1)

Ross Bush
Ross Bush

Reputation: 15155

Try using true instead of "true".

Upvotes: 4

Related Questions