Issue with Cross tab data provider

[Narasimha]

Hi,

 

Iam using ChartFx Crosstab provider for below data which comes in datatable

 

 

Date Total Hours GenPump

10/10/2008 48   Gen Number of Hours10/24/2008 24 Gen Number of Hours

 

and Iam using the following code to generate the graph

 

Dim

dt As DataTableProvider

Dim cfxCT As CrosstabDataProvider

chrtOOS.Gallery = Gallery.Bar

dt = New DataTableProvider(dst.Tables(0))

cfxCT = New CrosstabDataProvider(dt)

chrtOOS.AxisX.LabelsFormat.Format = AxisFormat.DateTime

chrtOOS.AxisX.LabelsFormat.CustomFormat = "M/d"

chrtOOS.DataSourceSettings.Fields.Add(New FieldMap("GenPump", FieldUsage.ColumnHeading))

chrtOOS.DataSourceSettings.Fields.Add(New FieldMap("TotalHours", FieldUsage.Value))

chrtOOS.DataSourceSettings.Fields.Add(New FieldMap("Date", FieldUsage.RowHeading))

chrtOOS.DataSource = cfxCT

 

Iam getting chart displayed with each Date displayed 2 times like "10/10/200810/10/2008" on X-axies for each bar . I want that to displayed only once.

Any help would be greatly appreciated.