This question is locked. New answers and comments are not allowed.
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.
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.
