Making Table invisible when there is no data

[Srinath]

Hi,

I have a table in report header which displays summary data.
I want the table not to be disabled when there is no summary data.
I have created a binding on table with [Property path = Visible] and [Expression =IIF(Count(1)>0,True,False)].
 It gives me the below error when i run the report.
An error has occurred while processing Table 'table1': Aggregate node 'Count(Const(1))' not found. 

I think the expression value is incorrect. What expression will return me the rowcount. so that if the rowcount = 0 then i can make visible property = false.
Your help will be appreciated.

Thanks.
Srinath. 

[IvanY]

Hello Srinath,

You can easily do this with Report Parameters. Just create a new Report Parameter, give it:

DataSource =   // the same as the table you want to hide
Value =        = Count(Fields.ContactID) // it will be best to use an ID field as they always have value

ValueMember =         = Count(Fields.ContactID)
Visible =       False

Then in the conditional formatting of the table create new rule with this expression:

0  =       =Parameters.YourParameter.Value

Of course the parameter will not be visible for the users.

For more information please check our Report Parameters help article.

Greetings,
IvanY
the Telerik team

[Richard]

This answer did not work for me to hide the table if it had no data.. What worked is to set NoDataStyle visible property to false and just put a space in NoDataMessage. Without the space in the NoDataMessage the empty table is displayed.  (reference:https://www.telerik.com/forums/set-a-table's-visibility-to-true-when-it-has-no-rows)