Jump to content
Software FX Community

How to load multi pane results


IDalton
 Share

Recommended Posts

ok I see in the documentation on how to setup a multi-pane graph, but my confusion is how do I load the data into the different panes? I know how to load the data into a graph for a single series (see below), but that doesn't work for multiple series.

chart.Gallery = ChartFX.WinForms.Gallery.Lines

chart.DataSourceSettings.Fields.Add(New FieldMap("StartDate", FieldUsage.XValue))

chart.DataSourceSettings.Fields.Add(

New FieldMap("Result", FieldUsage.Value))

chart.DataSource = dt

 

Any help will be appreciated.

 

Ian

Link to comment
Share on other sites

You can add multiple series by adding multiple fields that contain a value. For example:

chart.DataSourceSettings.Fields.Add(New FieldMap("StartDate", FieldUsage.XValue))

chart.DataSourceSettings.Fields.Add(

New FieldMap("Result", FieldUsage.Value))

chart.DataSourceSettings.Fields.Add(New FieldMap("Result2", FieldUsage.Value))

chart.DataSourceSettings.Fields.Add(New FieldMap("Result3", FieldUsage.Value))

 Each of the results will be separate series.

Link to comment
Share on other sites

But what if my data is as such:

StartDate - Result - Category

and what I'm looking to do is have a different series for each category and the xvalue would be StartDate and Value would be result?

That is how my data is coming back.

Any help would be appreciated.

Link to comment
Share on other sites

I am trying to create a new CrosstabProvider, but it doesn't seem likes it's there even though my help files has documenttation on it.

I tried the following and can't find it:

Dim t As ChartFX.WinForms.DataProviders. (here is the list I have to choose from - DataReaderProvider, DataTableProvider, DataViewProvider & TextProvider)

 

What am I doing wrong?

Link to comment
Share on other sites

If you look in the resource center, there is a sample application that uses the CrossTab DataProvider. This is the code from it:

string mySelectQuery = "SELECT Product,Year,Sales from ProductSales";

string dataPath = Path.Combine(Application.StartupPath, "Samples.mdb");string myConnectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0; Data Source={0};", dataPath);

System.Data.OleDb.

OleDbConnection myConnection = new System.Data.OleDb.OleDbConnection(myConnectionString);System.Data.DataSet ds = new System.Data.DataSet();

System.Data.OleDb.

OleDbDataAdapter adapter = new System.Data.OleDb.OleDbDataAdapter(mySelectQuery, myConnection);adapter.Fill(ds, "ProductSales");

// Create and configure the Crosstab data providerDataTableProvider dt = new DataTableProvider(ds.Tables[0]);CrosstabDataProvider cfxCT = new CrosstabDataProvider();

cfxCT.DataSource = dt;

// Instruct Chart FX how to use the fields in the Crosstab. Refer to the Resource Center documentation

// for further details.chart1.DataSourceSettings.Fields.Add(new FieldMap("Product", FieldUsage.ColumnHeading));

chart1.DataSourceSettings.Fields.Add(

new FieldMap("Year", FieldUsage.RowHeading));chart1.DataSourceSettings.Fields.Add(new FieldMap("Sales", FieldUsage.Value));

chart1.DataSource = cfxCT;

You need to add a reference to ChartFX.WinForms.Data.dll to your project in order to get access to the CrossTab data provider.
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.

Guest
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.

 Share

×
×
  • Create New...