This is a migrated thread and some comments may be shown as answers.

transposing columns and rows

3 Answers 291 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Naresh
Top achievements
Rank 1
Naresh asked on 30 Jan 2012, 12:12 PM

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.

3 Answers, 1 is accepted

Sort by
0
Pavel Pavlov
Telerik team
answered on 31 Jan 2012, 10:19 AM
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

Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>

Beatriz
Top achievements
Rank 1
commented on 25 Apr 2023, 09:02 AM

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

0
Brad
Top achievements
Rank 1
answered on 22 Jul 2014, 09:42 PM
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.
0
Dimitrina
Telerik team
answered on 23 Jul 2014, 07:48 AM
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
 
Check out Telerik Analytics, the service which allows developers to discover app usage patterns, analyze user data, log exceptions, solve problems and profile application performance at run time. Watch the videos and start improving your app based on facts, not hunches.
 
Beatriz
Top achievements
Rank 1
commented on 25 Apr 2023, 09:02 AM

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
Telerik team
commented on 27 Apr 2023, 02:32 PM

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
Top achievements
Rank 1
commented on 28 Apr 2023, 05:09 PM

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 
Tags
GridView
Asked by
Naresh
Top achievements
Rank 1
Answers by
Pavel Pavlov
Telerik team
Brad
Top achievements
Rank 1
Dimitrina
Telerik team
Share this question
or