Hello.
I use data virtualization for my datasource collection which binded to XamDataGrid. I write own filter and sorting system, but I also want use Summary Calculators. The problem is that SummaryCalculator fetch all rows from datasource at Aggregate method before it returns result.
I need just execute query "SELECT COUNT(*) FROM DB" at EndCalculations method without aggregation. I can't leave Aggregate method blank because it get DataRecord in parameter (when xamdatagrid requests DataRecord it loads from DB and it takes a lot of time and memory).
Have you any ideas? :(
Sorry for my bad english.
Hello,
Thank you for your post. I have been looking into it and I can say that since you already have your summary calculated based on your records in the DB you can use a TextBlock bellow the XamDataGrid for example to display the calculated values instead of using the built in summary since you are not able to prevent it from iterating through the Records.
Hope this helps you.