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 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.