英文:
How do I set the a hide or visibility of a text box in SSRS using an expression?
问题
I'm trying to hide the Reset column in the textbox. For example, if the score is 1, the Reset column should not appear, but if the score is 2, the Reset column should appear. I tried this expression:
=IIF(First(Fields!paroleHearingDecision.Value=2," Reset:______________________________________”)
But it's not working. What's the best way to write the visibility property of each tablix?
Also, I started with this expression at the beginning:
=IIf(Parameters!paroleHearingDecisionID.Value=1,"Ordered","Denied")
英文:
I'm try to hide the Reset column in textbox like for an example if they score a 1 the Reset column should not appear but if they score a 2 then the Reset column should appear
I try this expression =IIF(First(Fields!paroleHearingDecision.Value=2," Reset:______________________________________”) but it work what is the best way I need to write in visibility property of each tablix
Also, I start off with this expression in the begin =IIf(Parameters!paroleHearingDecisionID.Value=1
,"Ordered"
,"Denied"
)
答案1
得分: 1
=IIF(First(Fields!paroleHearingDecision.Value) = 2, True, False)
如果没有分组，不需要使用FIRST。
英文:
For a tablix, the Visibility expression would be on the row. The actual property is Hidded so TRUE makes it hidden and FALSE will allow it to show.
=IIF(First(Fields!paroleHearingDecision.Value) = 2, True, False)
If there is no grouping, the FIRST is not needed.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论