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

[Solved] Pivot the data in GridView

1 Answer 153 Views
GridView
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Lance
Top achievements
Rank 1
Lance asked on 08 Mar 2011, 07:13 AM
Hi,

My Silverlight 4 application gets data from the database via WCF as below:
Client Executive     WeekCommencingDateForecastMade     ClientManagerForecast
Amy Young           07/03/2011                                                 775
Sonia Majkic         07/03/2011                                                 1850
Sonia Majkic         21/02/2011                                                 800
Amy Young           28/02/2011                                                 900
Sonia Majkic         28/02/2011                                                 700

I want it to appear in the gridview as below:
Client Executive     21/02/2011     28/02/2011     07/03/2011
Amy Young             NULL             900                 775
Sonia Majkic           800                 700                 1850

As you can see I want to pivot the data and the number of columns and their headers will depend on the data.

Is this possible to achieve this?

Please help.

1 Answer, 1 is accepted

Sort by
0
Vlad
Telerik team
answered on 08 Mar 2011, 08:25 AM
Hello,

 The closest option we can offer you is demonstrated on this blog post

Regards,
Vlad
the Telerik team
Registration for Q1 2011 What’s New Webinar Week is now open. Mark your calendar for the week starting March 21st and book your seat for a walk through all the exciting stuff we ship with the new release!
Tags
GridView
Asked by
Lance
Top achievements
Rank 1
Answers by
Vlad
Telerik team
Share this question
or