I can't do this in the designer, it needs to be set programmatically, I upgraded to 9.1 and  still can't get it working

I tried this code with no luck, no data is displayed under the groups

dt.Rows)

{

;

i=0; i<lstGroupingColumns.Items.Count;i++)

{

)lstGroupingColumns.Items[i];

try

+drow[li.ValueMember.ToString()].ToString(), drow[li.ValueMember.ToString()].ToString());

)

uggTemp.RowLayoutGroupInfo.ParentGroup = uggParent;

uggParent = uggTemp;

}

{

+drow[li.ValueMember.ToString()].ToString()];

}

(i == lstGroupingColumns.Items.Count - 1)

{

j = 0; j < lstGroupingMeasures.Items.Count; j++)

{

)lstGroupingMeasures.Items[j];

I'm having a hard time reading this code - it's sort've mangled and there are some peices missing.Perhaps you could copy it into NotePad and then copy and paste from there rather than copying directly from whatever application you copied from. Also, you can enclose your code in a "code" block and the forums will display it in a better way.

One thing I noticed here, though, is that you are adding groups, but you are not adding any columns to the groups.

Below is the code that I used to get it working, it was more of a data formatting issue than anything

            ultraGrid.DisplayLayout.Bands[0].RowLayoutStyle = RowLayoutStyle.GroupLayout;
            ultraGrid.DisplayLayout.Override.AllowRowLayoutColMoving = Infragistics.Win.Layout.GridBagLayoutAllowMoving.AllowAll;
            ultraGrid.DisplayLayout.Bands[0].Groups.Clear();

            DataTable dt = UltraGridMethods.CreateDataTableFromAllRowsAndAllColumnsInUltraGrid(ultraGrid);

            List<string> listGroupingColumns = new List<string>();
            List<string> listGroupingMeasures = new List<string>();
            List<string> listGroupingRows = new List<string>();
            for (int i = 0; i < lstGroupingColumns.Items.Count; i++)
            {
                ListItem li = (ListItem)lstGroupingColumns.Items[i];
                listGroupingColumns.Add(li.ValueMember.ToString());
            }
            for (int i = 0; i < lstGroupingMeasures.Items.Count; i++)
            {
                ListItem li = (ListItem)lstGroupingMeasures.Items[i];
                listGroupingMeasures.Add(li.ValueMember.ToString());
            }
            for (int i = 0; i < treDataSource.Nodes[0].Nodes.Count; i++)
                listGroupingRows.Add(treDataSource.Nodes[0].Nodes[i].Tag.ToString());

            DataTable dtPivot = PivotDataTable.DoReportPivot(listGroupingMeasures, listGroupingRows, listGroupingColumns, dt, false, null);
            ultraGrid.DataSource = dtPivot;
            ultraGrid.DataBind();
            UltraGridBand band = ultraGrid.DisplayLayout.Bands[0];
            for (int j = 0; j < dtPivot.Columns.Count; j++)
            {
                DataColumn dc = dtPivot.Columns[j];
                if (!listGroupingRows.Contains(dc.Caption))
                {
                    UltraGridGroup uggParent = null;
                    string[] strSplit = dc.Caption.Split(new string[] { "|" }, StringSplitOptions.RemoveEmptyEntries);
                    for (int i = 1; i < strSplit.Length; i++)
                    {
                        try
                        {
                            UltraGridGroup uggTemp = band.Groups.Add(i.ToString() + "-" + strSplit[i], strSplit[i]);
                            if (uggParent != null)
                                uggTemp.RowLayoutGroupInfo.ParentGroup = uggParent;
                            uggParent = uggTemp;
                        }
                        catch
                        {
                            uggParent = band.Groups[i.ToString() + "-" + strSplit[i]];
                        }
                        if (i == strSplit.Length - 1)
                        {
                            band.Columns[dc.Caption].Header.Caption = strSplit[0];
                            band.Columns[dc.Caption].RowLayoutColumnInfo.ParentGroup = uggParent;
                        }
                    }
                }
            }

The default SpanX and SpanY of a column are 2x2. So to avoid overlapping, you either need to set:

Column2.OriginX=2

or

Column1.SpanX=1

Pivoting data won't give me the grouped column headers I'm looking for

OK I set

Column1.OriginX=0 and Column1.OriginY=0

then I set

Column2.OriginX=1 and Column2.OriginY=0

the bottom grid is what I get and the top grid is what I'm looking for, in the bottom grid, the class column is actually behind the line column

if anyone can see how to change the code a few posts above from Mon, Jul 27 2009 3:57 PM to make the grid look like the first one, I'd really appreciate it

i gues you are taking the data from a database, has you tried a pivot table and then assign the results to the grid?  for mi is working perfectly, but im using sql2005 and vb net 2008.

Yes, that's the style you need if you are using multiple levels of nested groups.

When using a RowLayout, the grid uses a concept called a GridBagLayout to arrange the columns and groups. I'm sure there are probably some good web resources out there that explain GridBagLayouts better than I could.

But essentially think of it as a sort've virtual grid of logical rows and columns. Each column in the grid, and each group, has a position and a span as defined by the column.RowLayoutColumnInfo or group.RowLayoutGroupInfo. There are properties for OriginX and OriginY and SpanX and SpanY. And also ParentGroup so you can create a hierarchy.