Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
30
ultragrid pivoting
posted

hi

i want to pivot a ultragrid in the following format

plz help

 

Parents
No Data
Reply
  • 69832
    Offline posted

    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;

Children