ansaurus

Question

Set a table's visibility to false when it has no rows (in reporting services)

Answer 1

+5 A:

Try setting the table's "Visibility.Hidden" property to this expression:

=CountRows() = 0

Matt Hamilton 2009-02-05 00:59:28

Thanks :) That's nice and concise too

Sophia 2009-02-05 01:48:40

Should it be =CountRow() == 0

Chris KL 2009-02-05 23:58:23

No, Reporting Service's internal expression language is VB, which just uses a single = for comparison (as well as assignment).

Matt Hamilton 2009-02-06 00:23:05

My expression always seemed to do the opposite of what I expected. No wonder, the expression is setting "Visibility.Hidden" as opposed to "Initial visibility" as the dialog implies. Grrrrr!

Even Mien 2010-05-21 19:00:06

Answer 2

+1 A:

Found the answer on my own, it's pretty simple.

I found this article which mentions the CountRows() function.

So to set the Visibilty / Hidden property to hide when there are no rows, it's simply

= Iif (CountRows() > 0, false, true)

Sophia 2009-02-05 00:59:46

Answer 3

A:

I need to carry this one level further. I have a report with a subreport that I would like to suppress when there are no subreport records.

I have added the "= Iif (CountRows() > 0, false, true)" in the subreport textbox, the subreport detail handle, the main report subreport box, and the main report subreport line handle.

However the blank line is still there if there are no subreport records returned.

Any ideas?

TIA!

2009-02-19 16:00:14

Answer 4

A:

Yaa , i have same type of problem that Rik describe. Any one please help.

sahil kaundal 2010-06-21 05:39:20

ansaurus

tags:

views:

answers:

Set a table's visibility to false when it has no rows (in reporting services)

related questions