Hi,

Yes I am talking about a summary on the Root band only

I also have Child band but I dont summaries them and this work

My Root band is also summaries.

My goal is to summary all columns but only the first row of the Band root  but in each root band we have 2 rows

and actualy all rows are summaries which is the defaut behavior.

I have a invisible columns LineType that indicate me if the actual row is the first or second row

So if the invisible columns LineType=1 then summarise the values

 LineType  ColumnsA   ColumnsB

          1            10              20

          2             5               11

Summary         10                20   <== (This is what i would like to have as a result)

Actualy I have   15                31  <== (This is what i have as a result)

Is there a way or a condition in a formula that I can  summaries only the linetype 1?

Thanks in advance! :)

Hi again,

I try your suggestion but no total appears in the summary row.

May be there is something wrong or that i dont understand.

The first scenario is when I use the formula with out the UltraCalcManager

Dim strFormula As String

gridGestionProjetExecution.DisplayLayout.Bands(BAND_NAME_ROOT).Summaries(i.ToString).DisplayFormat = "{0}"

'strFormula = "[\\gridGestionProjetExecution\" + BAND_NAME_ROOT + "(0)\" + i.ToString & "]"

'strFormula = "[//gridGestionProjetExecution/" + BAND_NAME_ROOT + "(0)/" + i.ToString & "]"

'strFormula = "[//gridGestionProjetExecution/" + BAND_NAME_ROOT + "/" + i.ToString & "(0)]"

strFormula = "[\\gridGestionProjetExecution\" + BAND_NAME_ROOT + "\" + i.ToString & "(0)]"

Next

The second Scenario is with the  UltraCalcManager

Do you have an idea of the problem ?

Do I have to use the UltraCalcManager?

Thanks in advance

yannh said:

Do I have to use the UltraCalcManager?

Yes, you have to have an UltraCalcManager in order to use Formulas. 

The error message you have listed here don't make any sense. A "Key Already Exists" message indicates that you are attempting to add an item to a collection with a key that already exists in the collection.  So you need to find out what you are adding and make sure it has a unique key.

The circularity error means that you have two formulas that point to each other in an infinite loop. 

Hi,

Ok I finaly arrive to use the formula "Sum([ColumnsA(0)])" with the UltraCalcManager but the result is not what a was looking for. The actual result summarize only the first row of the Band root of the entire grid.

root    LineType  ColumnsA   ColumnsB

               1               10               20

               2                 5              11

root         1                 7                5               

               2                 15               8 

Total                          17             25   <== (This is what i would like to have as a result)

Actualy I have             10             20  <== (This is what i have as a result)

The total summarize only the first row of the root band but of the first row of the grid only

My goal is to summarize all values of the root band where linetype=1

Is that possible?

Thanks in advance

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. 

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!!

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