transposing columns and rows

[Naresh]

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.

[Pavel Pavlov]

Hi Naresh ,

With the current version of our dlls you can use the approach demonstrated in this blog post. We are also at the late stages of development of an out-of-the box pivot grid , which will be available in one of our next major releases.

Regards,
Pavel Pavlov
the Telerik team

[Beatriz]

Hi, 
is there some update about this question? "ability to have different data types in each row.  So, in row 1 we'd need a date picker, in row 2 we'd need a textbox, and in row 3 we'd need a control that accepts only ints (or floats or whatever)."

Thank you

[Brad]

1) I don't think that blog post does a good job of what Naresh asked for.  I think what he was looking for (and I know it's what I'm looking for) is the ability to have different data types in each row.  So, in row 1 we'd need a date picker, in row 2 we'd need a textbox, and in row 3 we'd need a control that accepts only ints (or floats or whatever).
2) I've looked through the demos for the pivot grid and I see nothing there that would address this need.

Any help on this would be much appreciated!
Brad.

[Dimitrina]

Hi Brad,

RadGridView does not suggest such a functionality transposing columns and rows.

As to your first requirement on having different editors in different rows, you can check the CellTemplateSelector option to return a proper template with right values based on the type of the data populated in a column.

Regards,
Didie
Telerik

 

 

[Beatriz]

Hi, 
is there some update about this question? "ability to have different data types in each row.  So, in row 1 we'd need a date picker, in row 2 we'd need a textbox, and in row 3 we'd need a control that accepts only ints (or floats or whatever)."

Thank you

[Martin Ivanov]

If you need only to have a different editor in each cell, then you can use the CellTemplateSelector options suggested by Didie. If you need to change the orientation of the column, and order them vertical (where each column is a new row), then this is not supported out of the box. You can still use the CellTempalteSelector to mimic similar behavior. Also, there is a feature request to create such functionality.

[Beatriz]

Thanks Martin, 
I used the CellTemplateSelector for having a different type depending on the row and it works, thanks. I would also need to change the orientation, so added new columns dynamically and I am trying to use the example of the blog propose by Pavel.
I voted for the new feature request. Thanks