Hi guys:
My app has 500 test rows with 18 columns. I have a summation for each column. If I restrict the number of rows to about 10 the performance is blazingly fast.
But if I raise the number of rows to 500 the initialization take about 1+ minutes. Do you have any experience with this issue?
Thx
Perfect again!
I'm doing a custom calculator, but that's another thread.
Thx !!
Well, you can use a Count calculator instead and then set the StringFormat property to display what you want in the summary area. This will still perform the summary though so there will be a little overhead for that (not much really). You can also try creating your own summary calculator that does nothing but sets the name of the summary so it has something to display in the summary cell.
Perfect!! thx
But I do want a 'Summary' on the Bucket column, I just want the word 'Total' to appear, no calculation, is that possible?
Hi nar,
Thanks. I was able to download that one.
I took a quick look and yes, on the surface it appears as though it's caused by having the debugger attached. This is because there are tons of first chance exception messages being sent to the Visual Studio Output window. Generally, displaying messages in the output window is quite expensive so doing it this often can cripple an application while debugging. The reason for the exceptions however, is because of the summary you have enabled on the Bucket column. If you look at what most of the exceptions are, you will see that they are FormatExceptions. These exceptions are occurring because the Bucket property in the Model class is a string and the summary being applied is a Sum. Sum is normally meant for use with numeric data types so it's throwing exceptions trying to handle the string data type. Take out the SummaryDefinition for Bucket and you will see the issue disappear.
Here you go: