I have some issues with the xamPivotGrid where i cant find any solution or answer to it. Please help..
1. Row Sort
I found a property which sould allow this on the PivotGrid:
this.pivotGrid.AllowHeaderRowsSorting = true;
But this property changes nothing. I went thru all the provided samples and there is not a single sample, where i can sort the rows like i can sort the columns.
Please see attached picture for further explenation.
2. Hide / Show Totals
When i define a hierarchy for a FlatDataSource there is generated a total for the hierarchy. Is it possible to hide this total?
3. Width/Height Row Dimensions
In which object i can get and set the width and height for the dimensions or hierarchies? I save the layout in a xml document and i want to store the users change on the gui.
Hello Andreas,
When setting AllowHeaderRowsSorting to true will enable sorting within the records of the hierarchy. To hide/show totals can be done by setting IsVisible to true in the PivotDataRow. In the PivotDataColumn contains the ColumnWidth property that can be changed.
I have attached a sample. When running the project you can expand All Products and then Product 1. There is a sorting indicator that is shown when hovering over Product 1 that can be clicked.
Hi,
Tried this sample in a WPF application. It hides the columns and rows. But , now
Expand all the rows and columns are expanded
Now collapse the rows and columns again.
rows and columns gets disappeared.
Would you please provide the solution asap. It's quite urgent.
I am attaching the sample application for your reference.
Regards
Anu
Hello Anublr,
I have investigated you issue with all of the rows disappearing when then Totals are hidden and I have asked our engineering staff to examine this further. To ensure that it will receive attention, I have logged this behavior in our internal tracking system with a Development ID of 133817.
I have also created a private case, CAS-111165-D5C8C6, for you to track this issue.
Please let me know if you have any questions.
Sincerely,
Valerie
Developer Support Engineer
Infragistics, Inc
www.infragistics.com/support
any update on this? i'm facing the same problem (all rows disappear when collapsing an area if totals are hidden)
Hello Shril,
I spoke with development on this issue and this is the desired behavior of this feature. Actually when user hides total rows and after that he collapses the one row, the total row is already hidden and the grid doesn’t display it because it is hidden.
See attachment for Initial State 1.png and hide total 2.png.
When the user collapses the ‘All products’ row the grid will not display total row because it is already hidden (by user choice).
Let me know if you have any questions.
Infragistics
Desired is relative... for my requirements this is not the desired behavior.We happen to use both Infragistics and DevExpress controls in our application. Hiding totals and still being able to collapse the sections is possible in the DevExpress pivot control so for my requirements I will use their control.Thanks