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

Transposing Rows->Grids and vice versa

3 Answers 355 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Mikael
Top achievements
Rank 1
Mikael asked on 03 Oct 2008, 08:43 PM
Just checking if this would be doable:

We have a need to transpose the content of the RadGrid, i.e. make columns in the source data become rows in the RadGrid, and vice-versa.
I know I could do this "manually" be transposing the source datatable, but I wonder if there's any support for this built-in.

Thanks!
/Fredrik

3 Answers, 1 is accepted

Sort by
0
Princy
Top achievements
Rank 2
answered on 06 Oct 2008, 04:13 AM
Hello Fredrik,

You can go through the following online demo which demonstrates how RadGrid can be bound to pivot table when you want to display the data in a reverse order but still keep the same presentation and structure in the source table.
Displaying pivot data

For more information on this you can also go throught he following help article.
Binding to Pivot table

Thanks
Princy.
0
Rakesh
Top achievements
Rank 1
answered on 09 Dec 2013, 08:03 PM
Is there a way to manipulate the data when we transpose the rows to columns? 
i.e I want to give the user a Excel like interface with transposing the rows to columns and vice versa. Is this possible?
Thanks
Rakesh
0
Konstantin Dikov
Telerik team
answered on 12 Dec 2013, 12:49 PM
Hi Rakesh,

With the current implementation of the RadGrid, transposing rows and columns (displaying pivot data) is supported only in display mode and no edit functionality could be achieved.

As you could see in the help article, once the DataTable is retrieved, it is being rotated, so it could simulate transposing between the rows and the columns.


Regards,
Konstantin Dikov
Telerik
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to the blog feed now.
Tags
Grid
Asked by
Mikael
Top achievements
Rank 1
Answers by
Princy
Top achievements
Rank 2
Rakesh
Top achievements
Rank 1
Konstantin Dikov
Telerik team
Share this question
or