I just found out about this wonderful PivotGrid but there is something I am concerned with. My dataset will be in the millions - while I'm not concerned with the time it takes to render, I was concerned about the memory the 5,000,000 example took. I understand that the PivotGrid sorts and aggregates an existing dataset, so I turned my attention to the PivotFieldList.
I want to limit the data that gets brought back, so I was hoping I'd be able to use the filtering options to create a specific where clause so I only get the data I want. This would be done by pointing the PivotFieldList to a different DataProvider that is simply there to give it mocked data, so it will always know of every choice. Then I'm hoping there could be some kind of event that I could capture that would assist me in digging into the internals and building a where clause that the actual PivotGrid's DataProvider would then apply.
Thanks
I want to limit the data that gets brought back, so I was hoping I'd be able to use the filtering options to create a specific where clause so I only get the data I want. This would be done by pointing the PivotFieldList to a different DataProvider that is simply there to give it mocked data, so it will always know of every choice. Then I'm hoping there could be some kind of event that I could capture that would assist me in digging into the internals and building a where clause that the actual PivotGrid's DataProvider would then apply.
Thanks