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
when you say "RowLayouts" what does that mean? if this is set?
ultraGrid.DisplayLayout.Bands[0].RowLayoutStyle = RowLayoutStyle.GroupLayout;
Hi,
I'm afraid you have completely lost me. You didn't ask about reordering the columns. Your question was about adding columns to the right. I'm not entirely sure exactly what that means, but I guessed that you meant you wanted your columns aligned to the right-hand side of the grid.
What does "add columns to the right" mean?
You have total control over the order of the columns. You can position them in any order you like. If you are using RowLayouts, you would use the column.RowLayoutColumnInfo.OriginX and OriginY to position the column. If you are using the standard (non-RowLayout) mode, you would use the column.Header.VisiblePosition.
so there is no way to reorder columns when there are grouped columns?
There's no way to align the columns in the grid to the right. They always go left to right.
With this code, the groups are added to the front(left) side of the grid and I want them created on the back(right) side, any ideas on how to do that?