Hi
I have a pivot grid operating in server mode on a datasource which has in excess of 100 available fields.
When I go to show the Prefilter dialog the application just appears to hang. Looking at the output from the EF logger I can see that it's submitting loads of queries to get all the distinct values for the fields,
Surely it would make more sense to only grab the values when you select the field to filter by?
Is there a setting that I've missed that will invoke that more efficient behaviour?
Many Thanks
Pete
Hi Pete,
I have managed to reproduce this behavior on my side and passed this ticket to our developers for further research.
As an immediate workaround, I suggest you replace the built-in PivotGrid's prefilter with an external FilterControl. You can populate FilterControl's FilterColumns collection manually from PivotGrid's fields and retrieve field values before a field is shown in FilterControl by handling the BeforeShowValueEditor event. Let me know if this workaround is acceptable for you and you need a sample project that illustrates this approach.
John
We're up against time a bit on this so a sample to get us started would be much appreciated.
Many Thanks
Pete
Ok Pete,
Give me some additional time to prepare such a sample.
Hi Pete,
Attached is a small sample project that illustrates the previously described approach. Try it and let me know whether or not it meet your requirements.