Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
560
Multiple Summary Rows in single band
posted

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               5
1              c               3

              SubTotal    10

2               x              1
2               z              2

                SubTotal    3

3                i              4
3                j             10
3                k             4
3                i              5
                 Subtotal   23

 

Parents
No Data
Reply
  • 469350
    Offline posted

    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. 

Children