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.
COL A COL B COL C
A1 B1 C1
A1 B1 C2
summary C1+C2
A1 B2 C3
A1 B2 C4
summary C3+ C4
A2 B4 C5
A2 B4 C6
summary C5+ C6
Is it possible to get summary at COL A level also i.e. C1+C2+C3+C4 & C5+C6
and at top level also i.e C1+C2+C3+C4+C5+C6
Is it possible to add summary footer at different levels of group?
consider the scenario:
Col A Col B Col C
Hi Mike. I am trying to do teh same thing (group by column summaries) with a UltraWEBGrid. Can you please help?
Thanks,
Alex
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