Hi,
Not really sure if this should be under WinPivotGrid or under FlatDataSource, feel free to move it if it is in the wrong place.
I'm trying to save the state in which a user has left a WinPivotGrid, specifically the Rows, Columns, Filters and Measures as used in the FlatDataSourceInitialSettings:
Dim settings = New FlatDataSourceInitialSettings() With { _ .Rows = "[Sales].[Product]", _ .Columns = "[Sales].[SalesPerson]", _ .Measures = "[Sales].[Amount]" .Filters = "" _}
The final goal is to be able to save the configuration of Rows, Columns, Measures and Filters used so a user can go back to the report as it was with a simple click, so I would have to know the Rows, Columns, Measures and Filters to be able to pass it as FlatDataSourceInitialSettings when reloading the cube.
I have tried to obtain that from the WinPivotGrid and from the FlatDataSource, I can see that they are set inside the FlatDataSource in DirectCast(MyDS.dataSource, Infragistics.Olap.FlatData.FlatDataSourceInternal).RowAxis for example, but since that is "Internal / Friend" I can't enumerate it at runtime.
What would be the best way to achieve what I need?
Regards
Hello Edgar,
Saving and loading a layout for the PivotGrid including selected measures , dimensions, columns rows, and filters, etc. has been determined to be a new product idea for our Windows Forms platform. You can suggest new product ideas for future versions (or vote for existing ones) at <http://ideas.infragistics.com>.
As an alternative you can implement the WPF privot grid, which supports Save and Load Data Source Customizations, and host the control in your Windows Forms application.
Let me know if you have any questions regarding this matter.
Thanks for your response. I understand that the WinPivotGrid and the FlatDataSource controls are new hence they don't necessarily have all the standard functionality that you would expect from them when they mature. I will post as "New Ideas" both the "Save and Load Layout" and the "Export to Excel" just to document them (I don't really think they "new" ideas, I see them as basic/standard stuff that is supported by all your other grids).
Sadly, I don't have license for WPF controls, so I cant use your recommendation, so I just wanted to verify if there is any other way just to get the currently selected measures , dimensions, columns rows, and filters, so I can save them on my own and use them as the initial configuration for the FlatDataSource later.
Regards,