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

transposing columns and rows

3 Answers 201 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 >>

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.
 
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