使用SSRS中的条件来获得可见性(using conditionals in SSRS for visibility)

 在我创建的SSRS（BIDS）2008报告中，我有一个条件语句，我试图用来确定列中项目的可见性。 
 
 与此类似的表达式在“常规”选项卡上有效，但在“可见性”选项卡上则无效。 尝试预览报表时出现以下错误 
 
 
 
 本地报告处理期间发生错误。 文本框“状态”中使用的隐藏表达式返回了无效的数据类型。 
 
 
 我已粘贴以下条件供您参考。 可见性表达式的规则/格式是否与“常规”选项卡的规则/格式不同？ 谢谢！ 
 
=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")))

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

原文：https://stackoverflow.com/questions/15126166