Thanks for quick reply. I did the samething.  But that visually changes a lot. I need this first row to appear as normal first column or atmost column with merged cellstyle but definitely not as a separate band. I tried setting GroupByColumnsHidden = DefaultableBoolean.False but could not figure out how to get rid of GroupByRows. Also this ColA is not necessarily the first column, it could be any column in the table. 

please advice.
Thank you
bhavani

Hi Mike,

I finally got through reading some of the documentation and doing some sample projects for the calc manager.

In the two grids, each column summary in the summary row is named as follows: Month#Count (where # ranges from 1-18). So how to I go about referencing those summaries in the formula of the calc manager?

Since I want the difference of the two summary rows to show up in the second grid, do I add another summary for each of the 18 month columns?, i.e.

Your help or reference to an example would be most appreciated!
~Kelly

Update:

This is what I have for the formula, but I get a #REF! error since I do not know how to reference the correct summary in the other grid:

Hi Mike,

Thank you so much for your research into this matter and for taking the time to create a sample application.

When following along with the sample projects from the support website, I was able to reference the summary in another grid; however, it references it as follows (I would attach a sample, but it is larger than 200kb):

   [//UltraGrid1/Order Details/Grid1Sum()]

Whereas the summary in the current grid is simply referenced as:

   [Grid2Sum()]

In the example, data is bound via the gui, whereas for my project it will be bound programmatically; therefore, my Band(0) does not have a key to reference. Is that why I am unable to reference my band that contains the summary correctly?

Thanks again!
~Kelly

Update:

My sample was working, but I just tried running it again and I do get the null reference exception as you mentioned.  I suppose I will submit an incident report, but in the meantime attempt to do it via your other suggestion - ICustomSummaryCalculator - if you could point me in the right direction with that I would be most appreciative.

 Okay. Here's a quick sample of using an ICustomSummaryCalculator to do the same thing. 

Hi Mike,

Sorry to be such a bother, but i was wondering if you could point me in the right direction in converting part of your class from c to vb.

This is what I have so far, but I was not sure how to convert this part:

   Public Function EndCustomSummary(ByVal summarySettings As SummarySettings, ByVal rows As RowsCollection) As Object Implements ICustomSummaryCalculator.EndCustomSummary
      Dim mySummaryValue As Decimal = CType(rows.SummaryValues(0).Value, Decimal)
      Dim otherGridSummary As Decimal = CType(Me.FirstGrid.Rows.SummaryValues(0).Value, Decimal)
      Return mySummaryValue + otherGridSummary
   End Function

   Public Sub BeginCustomSummary(ByVal summarySettings As SummarySettings, ByVal rows As RowsCollection) Implements ICustomSummaryCalculator.BeginCustomSummary
      ' do not need
   End Sub

   Public Sub AggregateCustomSummary(ByVal summarySettings As SummarySettings, ByVal row As UltraGridRow) Implements ICustomSummaryCalculator.AggregateCustomSummary
      ' do not need
   End Sub

End Class


Mike,

I think same code what I have for the custom summary works just fine with a new grid. For some reson the old grid is having troubles with it.

For now , I am good.

Thanks a lot , Venkat.

Thank you very much for taking time to look into this.

You are right in saying summary formula line is commented but in the actual code its not.

If I follow you correct , scrolling down to the bottm should calulate the summaries but I dont see the correct summaries. SO I was running the same code in debugger , then I see that the custom class New method getting called but dont any other methods getting called and eventually summaries are not currect.

I am not sure why those beginSummary and other methods are not gettting called when step though debugger. Any clue ?

In the other post that I had posted the complete code.

I really appreciate your help on this as I am in crunch state of the project.

Thanks, Venkat.

Hi Venkat,

Well, the line of code you have here which adds the summary is commented out. :)

Assuming that's just a typo here in this forum post and that this line is not commented out in your actual code, then my next guess would be that the summary is not yet visible on the screen. The summaries don't get calculated until they are needed. So if your summary is at the bottom of the rows collection (which is the default), the calculation will not occur until you scroll down to the bottom of the rows and bring the summary into view.

Hi all ,

I followed this thread and wrote my customSummary class and used the Custom summaryType.Tried using the same but my methods inside the custom class didn't get fired. Ami doing anything wrong.

InterCompGrid3.DisplayLayout.Bands(0).Columns("CGDTH").AllowRowSummaries = AllowRowSummaries.True
        'InterCompGrid3.DisplayLayout.Bands(0).Summaries.Add("summaryCGDTH", SummaryType.Custom, New InterCompCustomSummary("CGDTH"), InterCompGrid3.DisplayLayout.Bands(0).Columns("CGDTH"), SummaryPosition.UseSummaryPositionColumn, Nothing)

Can anybody give a qucik pointer.

Thanks a Lot, Venkat.
       

I'm not sure off the top of my head, but if there is a way, it would probably be via the SummaryDisplayAreas property on the Override.