Dears ,
am trying to bind the pivot grid to xamdatachart
1- i would like to know how, i already did the binding of the pivot grid, but i dont know hot to bind it to xamdatachart.
2-i wrote the editing code as the samples, but no luck, i still cant edit the cells,
3- the columns header and row header are sorted alphabetically, i dont want them to be like that, i want them to be as the order of the list
4-i want to still be able to swap the columns and rows.
please find atatched the code.
any help will be appreciated
its urgent :S
Hi
First which version of control do you use: Silverlight or WPF. You posted your question in WPF forum, but you use Silverlight dll. Am I correct.
To your questions:
1. To able to see data chart series you should set also x-axis and y-axis. I did not see the code about this in attached sample. BTW how do you get follow namespace: xmlns:igWebChart="http://schemas.infragistics.com/xamWebChart"
2. To be able to edit cell you should add measure to EditableMeasure collection. I did not find code about this. I saw only remove from collection in your Measures_CollectionChanged event handler method.
3. This issue is revert back to normal in our last SR, so if you want this feature you should use latest SR of control.
4. There is a pivotGrid.DataSource.PivotGrid() method that you can use.
Regards,
Todor
As for the cell editing, i was checking the cell editing sample, and it only shows
this.pivotGrid.DataSource.Measures.CollectionChanged += Measures_CollectionChanged; this.pivotGrid.CellEdited += pivotGrid_CellEdited;
and nothing about adding measure to EditableMeasure collection, so how can i know about this stuff? is there is an example?
If you look at the sapmle http://samples.infragistics.com/sldv/RunSamples.aspx?cn=pivot-grid#/pivot-grid/cell-editing in
In Measures_CollectionChanged method implementation there is a code which add measure to editable measure collection.
if (mvm.Caption != "Amount of sale")
this.pivotGrid.EditSettings.EditableMeasures.Add(mvm.Measure);
About chart there is not automatic binding for chart to pivot data. The dev should extract the data which he want to be visible in chart and to put it to the right property of the control.
For sample you can look at this link http://samples.infragistics.com/sldv/RunSamples.aspx?cn=pivot-grid#/pivot-grid/pivot-grid-and-bar-charts
Starting from 11.2 we are going to introduce integration of chart with olap data.
can't we do the same sample of pivotgrid with bar charts with datachart???