Hiding a row

Question

Hiding a row

latingntlman

SSCarpal Tunnel

Points: 4348
More actions
June 23, 2009 at 12:27 pm

#206385

Is there a way to suppress/hide a detail row if there's no data for that record?
It would help save room.
thx,
John

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

happycat59 One Orange Chip Points: 29389 More actions · Answer 1

There is a row property that can be set to conditionally hide a row. You simply code an expression that returns either true or false. The expression would need to work out whether there is anything to show or whether the row should be hidde

e.g. =IIF( LEN(Fields!MyField.Value) = 0, TRUE, FALSE)

or

=LEN(Fields!MyField.Value) = 0

These are the same - the second example is just avoids the IIF function.

latingntlman SSCarpal Tunnel Points: 4348 More actions · Answer 2

latingntlman

SSCarpal Tunnel

Points: 4348

June 24, 2009 at 4:54 pm

#1014989

Thanks happycat; that works perfect.

John

dmounday SSC Eights! Points: 920 More actions · Answer 3

Is using the following expression in the Hidden property the same thing?

IIF(ISNOTHING(Fields!somefieldname.Value),True,False

happycat59 One Orange Chip Points: 29389 More actions · Answer 4

Subject to testing, it certainly looks like it could produce the same result.

mcgregor SSC Journeyman Points: 82 More actions · Answer 5

A better approach may be to filter the data out of your table. With SQL Server 2005 I have found that conditional visibility of detail rows can break the paging of reports.