all groups > sql server reporting services > november 2004 >
You're in the

sql server reporting services

group:

Hiding Table Rows



Hiding Table Rows MER78
11/25/2004 6:51:01 AM
sql server reporting services:
RE: Hiding Table Rows Charles Kangai
11/25/2004 7:25:02 AM
Yes. Highlight a table row in Layout view. Expand the Visibility property.
Underneath there is a Hidden property. You can set this to an expression. So
you could do something like:

=iif(MyCondition, True, False)

HTH

Charles Kangai, MCT, MCDBA

[quoted text, click to view]

RE: Hiding Table Rows MER78
11/25/2004 7:33:03 AM
When I do that... it hides the row... but instead I just get blank space
where the row would have been.

[quoted text, click to view]
RE: Hiding Table Rows Charles Kangai
11/25/2004 9:05:06 AM
I see. Then do the following:
1) Remove all previous expressions.
2) Highlight the entire detail row again.
3) In the Properties sheet, select the Grouping property and click on the
ellipsis button to its right.
4) On the General tab, select a unique expression in the Expression column.
You want a unique expression for each row so that each row is in its own
group. You are not really grouping, but just pretending to, so that we can
use the Visibility feature.
5) Now click on the Visibility tab. For the Initial visibility radio button,
select Expression.
6) Now enter your expression, such as =IIF(Fields!MyRevenue.Value<100,True,
False)

This will now hide the (entire) row if MyRevenue is less than 100. You will
not get blank rows like before.

HTH this time

Charles Kangai, MCT, MCDBA

[quoted text, click to view]
AddThis Social Bookmark Button