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

I also used custom summaries in the code I sent you and this is the custom summary class I am using. I was advised to write a seperate class for each custom summary calculation I do. So the Begin summary and End summary are to present for each summary calculation.

You can try this. 

Public Class clsImageRateCalculator

        Implements ICustomSummaryCalculator

        Private TotalTimeinSec As Integer = 0

        Private TotalImages As Integer = 0

        Private ImageRate As String = 0

        Private Sub BeginCustomSummary(ByVal summarySettings As SummarySettings, ByVal rows As RowsCollection) Implements ICustomSummaryCalculator.BeginCustomSummary

            ' Begins the summary for the SummarySettings object passed in. Implementation of

            ' this method should reset any state variables used for calculating the summary.

            Me.TotalImages = 0

            Me.TotalTimeinSec = 0

            Me.ImageRate = 0

        End Sub

        Private Sub AggregateCustomSummary(ByVal summarySettings As SummarySettings, ByVal row As UltraGridRow) Implements ICustomSummaryCalculator.AggregateCustomSummary

            Try

                Dim ElapsedTime As Object = row.GetCellValue(summarySettings.SourceColumn.Band.Columns("ELAPSED TIME"))

                Dim ImageCount As Object = row.GetCellValue(summarySettings.SourceColumn.Band.Columns("# IMAGES"))

                ' Handle null values

                If ElapsedTime Is DBNull.Value Then

                    Return

                End If

                ' Convert to decimal.

                Try

                    Me.TotalTimeinSec += Convert.ToInt32(ElapsedTime)

                    Me.TotalImages += Convert.ToInt32(ImageCount)

                Catch e As Exception

                    ' This should not happen if the columns are numeric.

                    Debug.Assert(False, "Exception thrown while trying to convert cell's value to decimal !")

                End Try

            Catch ex As Exception

                Throw (ex)

            End Try

            ' Here is where we process each row that gets passed in.

        End Sub

        Private Function EndCustomSummary(ByVal summarySettings As SummarySettings, ByVal rows As RowsCollection) Implements ICustomSummaryCalculator.EndCustomSummary

            ' This gets called when the every row has been processed so here is where we

            ' would return the calculated summary value.

            If TotalImages > 0 Then

                Me.ImageRate = Math.Round(Convert.ToDouble((TotalImages / TotalTimeinSec) * 3600), 1).ToString()

            End If

            Me.ImageRate = Me.ImageRate + " (images/hr)"

            Return Me.ImageRate

        End Function

    End Class

Thanks vpratti,

I also have separate classes for the summaries, however, I was not using BeginCustomSummary.

I will look at your code and try it out.  One of mine is as follows:

   Public Class TotalFtesCalculator
      Implements ICustomSummaryCalculator

      Private GridToUse As UltraGrid
      Private SummaryName As String
      Private HoursInMonth As Decimal

      Public Sub New(ByRef Grid_To_Use As UltraGrid, ByVal Summary_Name As String, ByVal Hours_In_Month As Decimal)
         Me.GridToUse = Grid_To_Use
         Me.SummaryName = Summary_Name
         Me.HoursInMonth = Hours_In_Month
      End Sub

      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

      Public Function EndCustomSummary(ByVal summarySettings As SummarySettings, ByVal rows As RowsCollection) As Object Implements ICustomSummaryCalculator.EndCustomSummary
         Dim SummaryValue As Decimal = CType(Me.GridToUse.Rows.SummaryValues(Me.SummaryName).Value, Decimal)
         Dim SumValue As Decimal = SummaryValue / HoursInMonth
         Return SumValue
      End Function

   End Class

Thanks,

Kelly

Thanks vpratti,

I updated my custom summary as follows and now it works --> I realized I had too many private variables that I didn't need!

Imports Infragistics.Win.UltraWinGrid

Public Class TotalFtesCalculator
   Implements ICustomSummaryCalculator

   Private SummaryName As Strings

   Public Sub New(ByVal Summary_Name As String)
      Me.SummaryName = Summary_Name
   End Sub

   Public Function EndCustomSummary(ByVal summarySettings _
      As SummarySettings, ByVal rows As RowsCollection) _
      As Object _
      Implements ICustomSummaryCalculator.EndCustomSummary
      Dim SummaryValue As Decimal = _
         CType(rows.SummaryValues(Me.SummaryName).Value, _
         Decimal)
      Dim FteValue As Decimal = _
         SummaryValue / CType(rows(0).GetCellValue _
         ("HoursInMonth"), Integer)
      Return FteValue
   End Function

End Class



Thanks again,
Kelly

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.
       

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.