Image 1 is the data I have to start with
Image 2 is how I need the data to be formatted.
Just pivoting this data is out of the question as it does not do what I need it to do.
I have tried to use band.Groups, but I can't get it to work and the example provided here http://help.infragistics.com/Help/NetAdvantage/NET/2008.3/CLR2.0/html/Infragistics2.Win.UltraWinGrid.v8.3~Infragistics.Win.UltraWinGrid.UltraGridGroup.html doesn't show me how to add multiple groups to a group
any help would be much appreciated
The WinGrid does not have any functionality to automatically pivot the data. The grid displays the data from the DataSource you give it. So in order to get a view like this, you would have to bind the grid to a DataSource which has the data in the structure you want.
Regarding the groups in the grid, you can't have nested groups using v8.3 of the grid. This was not supported in that version. Nested group functionality was added to v9.1 of the WinGrid along with the Groups in RowLayouts feature. The easiest way to set that up would be to use the grid designer and select "RowLayout with Groups" from the ColumnArrangement Overview section, and then you can create groups and arrange the columns in the designer.
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;
}
uggParent = band.Groups[i.ToString()+
+drow[li.ValueMember.ToString()].ToString()];
(i == lstGroupingColumns.Items.Count - 1)
j = 0; j < lstGroupingMeasures.Items.Count; j++)
)lstGroupingMeasures.Items[j];