I am running my RadPivotGrid off of a SQL Server datasource. We are running on a decently large initial result set (about 3000 records) and so in the datasource "selecting" method I check to see if this is a postback or not. If it is, I cancel the event (so we don't have to wait to load results the first time around before proper filters are applied).
I haven't seen a lot of discussion on the forum on this EnableCaching property and how it is supposed to work. What I have noticed is that if I cancel that first event (and have EnableCaching="true") the PivotGrid never again displays any results.
The search form, to which the datasource is connected is activated with each click of the Search button by this event handler:
'Bind the pivot grid.
Is there some other method I should use?
Secondarily, I noticed that there is a property on the PivotGrid for Performance Optimization using the IQueryable type results but for the life of me can't find any real documentation or samples of what that is all about... I need to speed up the performance of the PivotGrid beyond its current speed or I am going to have the users complaining all over the place :)