As it was an urgent requirement.. I had to give up the idea of putting chart representation.Anyway thanks for your support.It may be useful in any other venture.
Reshma
>Hi Reshma,
Thanks for your patience.
We regret to inform you that currently do not have direct support for creating Chart As given in the attached Document. However it is possible to achieve this by manipulating the Data using Distinct, Select queries on the Datatable and by creating a datatable with suitable dataTable structure to plot the chart accordingly.
Example:
The given table data can be converted to a suitable DataCollection that could be used with chart control as given below.
Original Data:
Product Group Nos
ABC GRP1 2
ABC GRP2 5
ABC GRP3 3
BDE GRP2 12
BDE GRP3 5
CSG GRP1 9
CSG GRP4 12
1) Get the unique values from Product (Product_DataSet)
ABC
BDE
CSG
2) Get unique values from Group (Group_DataSet)
GRP1
GRP2
GRP3
GRP4
3) Create Chartseries for each Product values by creating DataTable using Group and Nos for particular product. For products ( say BDE) that has missing group values, ( Example, BDE does not contain GRP1 And GRP4 ) new rows has been inserted with missing Group values at appropriate position with 0 values for Nos in the Datable.
I have attached the sample that illustrates the same in this link below.
http://websamples.syncfusion.com/samples/Chart.Windows/F78425/Sample1.htmPlease let us know if this meets your requirement. Thanks for your patience.
Regards,
Manohari.R