Hi all,
I have a grid where I want to switch columns and rows, so the column header should be displayed lefthand:
Normal grid:
I want:
I've found some old postings from 2007 and 2009 recommending this demo http://demos.telerik.com/aspnet-ajax/grid/examples/programming/pivot/defaultvb.aspx but the postings are already 2 years old and I wonder whether this is now possible easier? I also need to have the filters but it seems with current demo it just creates one large table, removing all the advantages (filtering, sorting, etc.) which are offered by RadGrid normally.
Many thanks!
I have a grid where I want to switch columns and rows, so the column header should be displayed lefthand:
Normal grid:
Firstname - Lastname - Country Joe - Black - USA Tom - Cruise - USA Tom - Hanks - USA I want:
Firstname: Joe - Tom - Tom LastName: Black - Cruise - Hanks Country: USA - USA - USA I've found some old postings from 2007 and 2009 recommending this demo http://demos.telerik.com/aspnet-ajax/grid/examples/programming/pivot/defaultvb.aspx but the postings are already 2 years old and I wonder whether this is now possible easier? I also need to have the filters but it seems with current demo it just creates one large table, removing all the advantages (filtering, sorting, etc.) which are offered by RadGrid normally.
Many thanks!
2 Answers, 1 is accepted
0
Princy
Top achievements
Rank 2
Rank 2
answered on 13 Dec 2011, 06:18 AM
Hello,
I have tried the following demo and it worked as expected.
Grid / Displaying Pivot Data
Thanks,
Princy.
I have tried the following demo and it worked as expected.
Grid / Displaying Pivot Data
Thanks,
Princy.
0
Kai
Top achievements
Rank 2
Rank 2
answered on 21 Dec 2011, 11:03 AM
Hi Princy,
as you see in my initial post I've already seen this demo. Regarding "it worked as expected" it's always the question what one expects ... The demo explicit says:
Note, however, that features like paging, sorting, grouping, filtering, etc. will behave in a different way because the type of the data in the grid columns can vary (for example integers, strings, dates, etc.). This is due to the "vertical grid" effect. That is why sometimes they may return unexpected results and you should consider whether to enable them or execute your custom logic to manipulate the data in the grid.
As already said in my initial posting, this example simply switches rows and columns without providing the default features like filter, sort, etc. Therefore I created this thread to ask whether there is any newer option available.
Thanks
as you see in my initial post I've already seen this demo. Regarding "it worked as expected" it's always the question what one expects ... The demo explicit says:
Note, however, that features like paging, sorting, grouping, filtering, etc. will behave in a different way because the type of the data in the grid columns can vary (for example integers, strings, dates, etc.). This is due to the "vertical grid" effect. That is why sometimes they may return unexpected results and you should consider whether to enable them or execute your custom logic to manipulate the data in the grid.
As already said in my initial posting, this example simply switches rows and columns without providing the default features like filter, sort, etc. Therefore I created this thread to ask whether there is any newer option available.
Thanks