Hi,

I'm sorry, but I still don't understand what you want here. It looks like you want the grid to combine several rows into one row. The only way to do that is by grouping. In this case, you would have to group by two field: first by Due Date and then by Order Type.

This would result in a 3-level hierarchy in the grid - the first two level would show GroupBy Rows and the third level would be the only one that shows data rows that have cells in them.

The grid will never display a GroupByRow with normal editable data cells in it, although you could have summaries in a GroupByRow which appear aligned with the column like cells.

What you are showing here with the text in your post are data rows where the values of some cells have been combined into a single row and summed up. So this would have to be done by using a summary, or else you would have to do this on your data source and not in the grid.

So... you are hiding the column via the column chooser and the grid is still grouped by that column.

If the grid is grouped by a column, then by default, that column is already hidden automatically. You cannot hide it using the ColumnChooser, because the ColumnChooser will already show it as unchecked (hidden). 

Assuming you changed this, but setting HiddenWhenGroupBy on the column to false, then I guess you are asking how to ungroup the column when it gets hidden by the user.

That's very easy to do:

        private void ultraGrid1_AfterColPosChanged(object sender, AfterColPosChangedEventArgs e)
        {
            if (e.PosChanged == PosChanged.HiddenStateChanged)
            {
                UltraGridColumn column = e.ColumnHeaders[0].Column;
                if (column.Hidden &&
                    column.IsGroupByColumn)
                {
                    column.Band.SortedColumns.Remove(column);
                }
            }
        }

sorry if this taking so long, but let me try it this way..

this is actually equivalent to the screenshot's columns:

select customer code, order type,  due date, amount, sum(data1) as 1 month,  sum(data2) as 2 month
group by due date, customer code, order type

and everything here is binded in the grid, no unbound column

if i take out customer code (via column chooser), my display should be the result equivalent to this query:

select order type,  due date, amount, sum(data1) as 1 month,  sum(data2) as 2 month
group by due date, order type