Completely hide a crosstab with the empty data source

[Nikolay]

I apologize in advance if the question was asked earlier (although I looked through the forum).
I need to completely hide the crosstab when its data source contains no records. All report controls located below should be shifted up on the page. Currently the crosstab header and footer rows are shown when no data is present. I tried to set CanShrink = true for all cells in the crosstab and use the conditional formatting (font size = 0 pt) but anyway the other report controls are on their places, not shifted up.

[Steve]

Hi Nikolay,

The easiest way to achieve your requirement is to set a Binding for a table "header" Textbox.

Property Path	Expression
Parent.Visible	=IIF(Count(1)>0, True, False)

Check out the attached sample report that illustrates the suggested approach.

About shifting the items up when you hide an item, please review the Design Considerations for Report Item Layout help article for more info.

Regards,
Steve
the Telerik team

[Nikolay]

Thank you, Steve. Bindings really works, although it is not an obvious solution :)