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;
Hi Brian,
I need to be able to do the same thing. From what I can infer from your example above, you would have to add a Group per salesperson programmicatlly. Is that right?
If at all possible, could you please post a full example?
Thanks,
Suthan
Please disregard my previous question as it is incomplete.
Is possible to convert a data source that is formatted as a table or object, such as the one below, to look like the pivot table posted by divu15.
Product
SalesPerson
SaleAmount
Quantity
Pens
John
350
200
Jane
54
521
Sally
1
21
Pencils
55
545
121
22
Notebooks
8
41
554
552
11
44
From your example, it would seem that I would need to create a column for each sales person and property you may want to pivot. So if we were to have 20 sales people, you would need to create 40 columns and 20 groups to achieve the pivot? By the way, would product be a group with one column associated with it?
Thanks
Hi Mark,
The PivotGrid control is relatively new, so in order to use it or see the samples, you would need to purchase the Infragistics control for a recent version that includes that control. So we cannot provide you with a sample of using the PivotGrid in v12 or under because the PivotGrid control did not exist in those versions.
Hello Boris
I do not see these samples.
Could you provide a link within the infragistics website that has this sample.
Also this sample should be with Infragistics version 12 and under as that version does not have the new pivot grid.
Thanks.
Hello merlon,
You could see a sample regarding this in our 'Windows Forms Feature Browser'.
If you have this installed(if you have marked 'Samples' when installing Net Advantage), you could run it from 'Start Menu' -> 'All Programs' -> 'Infragistics' -> 'Windows Forms' -> 'Samples' -> 'Samples (local)'.
When it loads, please navigate to the 'Grids' tab and then 'Launch' the 'Samples Explorer' sample. Or you can type in the 'Search:' "'Samples Explorer'". In the opened window please find 'V9.1 Groups in RowLayout Mode' sample, it could guide you in your scenario.
Please do not hesitate to contact us if you need any additional assistance.