hi
i want to pivot a ultragrid in the following format
plz help
The grid does not support pivot views but you can use row layouts and/or groups to arrange the column headers and cells to present the data like it is in your screenshot. For example, assuming the data source has a price and quantity column for each salesperson, you could add a group for each salesperson, then assign the appropriate group to the Group property of the column that represents that salesperson.
Example:UltraGridGroup group = this.grid.DisplayLayout.Bands[0].Groups.Add( "John" );this.grid.DisplayLayout.Bands[0].Columns["Price_John"].Group = group;this.grid.DisplayLayout.Bands[0].Columns["Quantity_John"].Group = group;