Well, it's hard for me to suggest any ways you might optimize the sumaries, since you didn't include the code for your CustomSummaryCalcuator here. 

UltraCalcManager summaries are calculated asynchronously (by default), so you might get more responsive UI using CalcManager instead. 

Hi Mike,

I finaly obtain the result I want with the CustomSummaryCalculator

The problem I got now is that when I change a value in my grid it took around 20 second to update all the summary columns

This is the way I use the CustomSummaryCalculator and I implement the CTotalSummaryWithOutPoTerms class with the condition I want in it

Is there something I can do to optimise the calculation?

I dont use any CalcManager . Is that the raison of my problem?

For i As Integer = 1 To NumberOfcolumnToShow

   myBand.Summaries.Add(i.ToString, SummaryType.Custom, New CTotalSummaryWithOutPoTerms(i.ToString), myBand.Columns(i.ToString), SummaryPosition.UseSummaryPositionColumn, Nothing)

   myBand.Summaries(i.ToString).SummaryDisplayArea = SummaryDisplayAreas.BottomFixed

   myBand.Summaries(i.ToString).DisplayFormat = "{0}"

   myBand.Summaries(i.ToString).Appearance.TextHAlign = HAlign.Right

Next

End Sub

Thanks in advance

calvinchan said:

Forgive me for jumping into you guys' conversation.

So I am trying to use my CustomSummaryCalculator to do the calculations. How can I get the rows that only belong to that group then? Is there like a property that I can use to get the group number or something in the BeforeSummaryDialog event handler?

Thanks!!

I found the solution. Event BeginCustomSummary actually give me all the rows belong to the the same group.

Thank you anyways.

Calvin

Forgive me for jumping into you guys' conversation.

So I am trying to use my CustomSummaryCalculator to do the calculations. How can I get the rows that only belong to that group then? Is there like a property that I can use to get the group number or something in the BeforeSummaryDialog event handler?

Thanks!!

Okay, that's a different story.

There are several ways to do this. 

1) If you group by the LineType column, then the summaries will be broken up automatically into each group. 

2)You could add an unbound column to the for each LineType and set the Formula of that column to use an 'if' function. Basically, the unbound column's formula would be something like this: 

if (  [LineType] = 1, [ColumnsA], 0 )

Then you could sum this unbound column to get the sum of everything in ColumnsA where LineType is 1. 

3) You could use a CustomSummaryCalculator and do the calculations yourself.