Is it possible to have multiple summary rows in a single band. I have data like below and need to show Summaries as Subtotal for each unique ColA value. Is it possible to show as below without manupulating data in underlying datasource.
Thank you
ColA ColB Col C
1 a 2 1 b 51 c 3
SubTotal 10
2 x 12 z 2
SubTotal 3
3 i 43 j 103 k 43 i 5 Subtotal 23
What you can do is apply a summary to Col C, then use the OutlookGroupBy feature of the grid and group by Col A.
Set grid.DisplayLayout.ViewStyleBand to OutlookGroupBy. Then use the SortedColumns.Add method on the Band to sort column A and specifiy true for groupBy.
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 youbhavani
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.UltraWinGridPublic 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 FunctionEnd Class
Imports Infragistics.Win.UltraWinGridPublic 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 FunctionEnd Class
Thanks again,Kelly
Now that the custom summary issue has been resolved, does anyone know if there is a way to have a total of each of the groups, i.e. a total of totals, at the bottom of the topmost group?
Here is an example - for the two groups of the column 'Proj' there are summaries. I would like to know if there is a way to have a summary of the totals in the next level group, 'Eff Mgr':
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.
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.
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.
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.