Forums Ultimate UI for Windows Forms
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
Close
DR
3550
Subtotals
posted

I want to do 3 groups, each group should show subtotals for amount.

the following code, shows subtotal just for the CURRENCY group. But I want to show the CCYAMT subtotals for each of the three groups, and also total summary, for all the data.

  basicInfraGrid1.DisplayLayout.Bands[0].SortedColumns.Add("SPOTPORT", false, true);
            basicInfraGrid1.DisplayLayout.Bands[0].SortedColumns.Add("FIXRATECODE", false, true);
            basicInfraGrid1.DisplayLayout.Bands[0].SortedColumns.Add("CURRENCY", false, true);
            SummarySettings st = basicInfraGrid1.DisplayLayout.Bands[0].Summaries.Add(SummaryType.Sum,
                 basicInfraGrid1.DisplayLayout.Bands[0].Columns["CCYAMT"]);
            st.SummaryDisplayArea = SummaryDisplayAreas.Bottom;
            st.SummaryPosition = SummaryPosition.UseSummaryPositionColumn;

  • 69832
    Offline posted

    Just like you added a member to the Summaries collection for the 'CYAMT' column, you would have to add members for the other columns as well. To show a summary column for "all the data", you could add an unbound column which holds the sum total for each column, and add a summary for that column.