[Issue with Cross tab data provider]

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.

[Problem with displaying 2 lables on X-axis....help needed]

Hey

Nobody has a solution for this problem. Please respond me if you need any further info.

[Problem with displaying 2 lables on X-axis....help needed]

Iam using ChartFx7 in asp.net 2008.  I want to display graph which has 2 labels for X-axis. Those 2 lables are "Date" and "Hour" which are 2 different fields.  Each date will have hours from 0 to 20. I have added these 2 lables to chart with below code.

 

chrtMain.DataSourceSettings.Fields.Add(New FieldMap("Date", FieldUsage.Label))

chrtMain.DataSourceSettings.Fields.Add(New FieldMap("Hour", FieldUsage.Label))

 

When I use the above code. fields are displayed like below

 

10/09/2008 - 0 10/09/2008 - 1  10/09/2008 - 2 .....................  10/10/2008 - 0 10/10/2008 - 1  10/10/2008 - 2 .............

 

I want the date to be displayed only once until next date. I do not want it to be appended to each hour. I tried different properties and methods, I didn't get the solution. I want the fields displayed as below

 

0 1   2 3 4  ............................. 0 1   2 3 4

 10/09 10/10

 

 

 

Any help greatly appreciated.

 

 

Thanks

 

 

 

 

 

 

 

[Problem with showing 2 labels on x-axis....Help needed]

I need to show 2 lables "Date" and "Hour" on x-axis of curve graph. Each date have hours from 1 to 23.

I tried below code and its working but date is appearing for each hour. But I need date should appear once until next date.  Can anyone help me what to do?

 chrtMain.DataSourceSettings.Fields.Add(New FieldMap("Date", FieldUsage.Label))

chrtMain.DataSourceSettings.Fields.Add(New FieldMap("Hour", FieldUsage.Label))