I will use XamPivotDataSelector and XamPivotGrid. But don't want to use olap to calculate the data.
My purpose is use XamPivotDataSelector to select Filter, Columns, Rows, Measures. Then click Update Layout button, get the data from backend server, Binding the datasource with XamPivotGrid. only user click the update layout button, the data in XamPivotGrid will be change. And the calcualtion operation will be done in backend server. Be a black box for frontend.
Anyone who know?
My source data is keyvaluepair. How to put them into the XamPivotGrid?
Hello Chaojun,
Thank you for your post. I have been looking into it and I can suggest you see this forum thread:
http://www.infragistics.com/community/forums/p/73570/371989.aspx
where a similar question is asked. Also you may find this link from our documentation about using FlatDataSource helpful:
http://help.infragistics.com/Help/Doc/WPF/2013.2/CLR4.0/html/xamPivotGrid_DataBinding_Using_FlatDataSource.html
Please let me know if this helps you or you need further assistance on this matter.
Looking forward for your reply.
I am just checking the progress of this issue and was wondering if you managed to achieve your goal or if you need any further assistance on the matter.
More questions, now I would using a datable as the source, but the datas in the table needn't further calculation. XamPivotGrid only should show the table and do somes filters. No olap calculation. Actually I can make the job easier if I use a datagird directly. But I hope to use the XamPivotGrid because it was more flexible.