We have a requirement of building an editable grid that looks something like below. Can you tell us if this is possible with minimal work using any of your controls.. including pivot control if possible. We are looking at purchasing around 8-10 developer licenses. Remember the control must support 2-way binding such that if a user changes any data in the grid, then it must correctly update the field of the correct element in the object collection:
Date |
1/1/2012 |
1/2/2012 |
1/3/2012 |
1/4/2012 |
Customer |
Cust 1 |
Cust 2 |
Cust 3 |
Cust 4 |
Bill Amount |
100 |
200 |
120 |
50 |
As you can see it is basically a transposed list and the data format is per row/cell and not per column. Will really appreciate if someone can point me to the control that would fit this need with some directions/links etc. Also the no. of columns will be dynamic, so the grid needs to generate the appropriate no. of columns at runtime.