Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
955
Dynamically show/hide totals
posted

Hi,

Is it possible to have show/hide the totals dynamically? Our users would like to do so by clicking a button.

We've been checking these posts:

http://es.infragistics.com/community/forums/t/84334.aspx

http://es.infragistics.com/community/forums/t/56405.aspx

It doesn't work very well. When we need to refresh the grid because the underlying data has changed and call PivotGrid.DataSource.RefreshGrid() the hidden rows come back.

We've tried to do the hiding/showing logic in the PivotGrid.LayoutUpdated event handler but we've noticed something else:

When the totals are hidden and we collapse any level, the level actually disappears until the we call again PivotGrid.DataSource.RefreshGrid(). This only happens when hiding the rows by setting IsVisible to false. If instead we do Height=0 this behaviour doesn't occur.

Is there a better way to handle this? Is it possible to avoid keeping hiding the rows in the LayoutUpdated event handler?

Thanks.