Hiding Table Rows

Is it possible to hide full table rows depending on data in a record?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
"MER78" wrote:
> Is it possible to hide full table rows depending on data in a record?|||When I do that... it hides the row... but instead I just get blank space
where the row would have been.
"Charles Kangai" wrote:
> 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)|||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
"MER78" wrote:
> When I do that... it hides the row... but instead I just get blank space
> where the row would have been.
> "Charles Kangai" wrote:
> > 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)