Jump to content
Software FX Community



Recommended Posts


I've got a query that pulls my data out into the following table;

Date     |   Type   |   Value


Jan       IS       10

Feb         SO       5

Jan       IS       11

Jun     SO   50


I've written the following code based on what i have read but i just can't seem to get it to work. Can anyone guide me in the right direction?

  Chart1.Gallery = ChartFX.WinForms.Gallery.Bar   Dim mySelectQuery As String = My.Resources.SQL_StockUsage   Dim myConnectionString As String = "Provider=sqloledb;Data Source=SERVERNAME;Initial Catalog=DATABASENAME;Integrated Security=SSPI;"      Dim myConnection As New System.Data.OleDb.OleDbConnection(myConnectionString)   Dim ds As New System.Data.DataSet()   Dim adapter As New System.Data.OleDb.OleDbDataAdapter(mySelectQuery, myConnection)   adapter.Fill(ds)   Dim dt As New ChartFX.WinForms.DataProviders.DataTableProvider(ds.Tables(0))   Dim cfxCT As New ChartFX.WinForms.DataProviders.CrosstabDataProvider   cfxCT.DataSource = dt   Chart1.DataSourceSettings.Fields.Add(New ChartFX.WinForms.FieldMap("Date", ChartFX.WinForms.FieldUsage.RowHeading))   Chart1.DataSourceSettings.Fields.Add(New ChartFX.WinForms.FieldMap("Type", ChartFX.WinForms.FieldUsage.ColumnHeading))   Chart1.DataSourceSettings.Fields.Add(New ChartFX.WinForms.FieldMap("Quantity", ChartFX.WinForms.FieldUsage.Value))   Chart1.DataSource = cfxCT   Chart1.Focus()




Link to comment
Share on other sites

I noticed that your data sample has two different values for two records with the same Date and Type, which is not allowed. You must ensure that each pair Date-Type appears no more than once. According to your Crosstab configuration you should obtain a chart with the Date in the X axis and using the different Types as series. Can you please elaborate on the problem you are getting?

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...