开发者

Show and Hide Tablix and shrink the space

开发者 https://www.devze.com 2023-03-30 17:54 出处:网络
I am new to Reporting Services. I am using Report Builder 3.0. I have created 6 Tablix on my report and would like to show and hide depending on the field value. Each table has 20 lines of text with h

I am new to Reporting Services. I am using Report Builder 3.0. I have created 6 Tablix on my report and would like to show and hide depending on the field value. Each table has 20 lines of text with header. So I need to shrink the space also. Is this right way of doing it? Please let me know. I appreciate an开发者_高级运维y help.

Thank you.


You can write an expression in the Hidden property of the Tablix. For example in the hidden property if you wanted to hide a Tablix when the Sales value is zero, you could use the following expression in the Hidden property:

=IIF(Fields!Sales.Value=0, True, False)

More information is here.


how to go about this expression if the Field.value is in another Dataset assigned to the Tablix.

=IIF(Fields!Sales.Value=0, True, False)

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号