User (Legacy) Posted June 20, 2006 Report Posted June 20, 2006 Hi, I have a 3 col dataset that returns the following : name amount month ----------------------------------------- John 8 January John 4 March Peter 3 January Mark 9 March Ray 12 April Ray 8 March I want to have a line chart set to show the amount on the vertical (top to bottom values). and the months as the horizontal values( from left to right) I wan to then have the chart display each person as a series. My code just sets the datasource of the chart to the result set above, but doesn't show the data as i need it. Is there away to do what I want? Thanks
Software FX Posted June 21, 2006 Report Posted June 21, 2006 You need to use the CrossTab data provider. The Data Wizard (Adjust Data To Chart option in the Smart Tags) will help you do this very easily, simply select a dataset with this structure (string,string,numeric) and you will be guided through. For more information on the CrossTab data provider please refer to the programmer´s guide under "Passing Data -> Crosstab Data Provider". -- Francisco Padron www.chartfx.com
User (Legacy) Posted June 22, 2006 Author Report Posted June 22, 2006 Hi, Trying to convert the Sample C# code (which is not a language I use) into VB(as there are no examples) Sample : DataTableProvider dt = new DataTableProvider(ds.Tables[0]); CrosstabDataProvider cfxCT = new CrosstabDataProvider(); My attempt at VB.net Dim dt As New ChartFX.WinForms.DataProviders.DataTableProvider(DsDataSet.Tables("ChartData")) Dim ct As New ChartFX.WinForms.DataProviders. Problem is that there is no cross tab data provider in the dataproviders tool tip/autocomplete ... I guess I am doing this wrong... what should I have there. "SoftwareFX Support" <noreply@softwarefx.com> wrote in message news:quAIzvTlGHA.1788@webserver3.softwarefx.com... > You need to use the CrossTab data provider. The Data Wizard (Adjust Data > To Chart option in the Smart Tags) will help you do this very easily, > simply select a dataset with this structure (string,string,numeric) and > you will be guided through. > > For more information on the CrossTab data provider please refer to the > programmer´s guide under "Passing Data -> Crosstab Data Provider". > > -- > Francisco Padron > www.chartfx.com >
Software FX Posted June 22, 2006 Report Posted June 22, 2006 You need to add a reference to ChartFX.WinForms.Data.dll. -- Francisco Padron www.chartfx.com
User (Legacy) Posted June 24, 2006 Author Report Posted June 24, 2006 Hi, I have already got the imports chartfx.winforms, and when I type the following the tool tips/autocomplete (what its called when the hit the ´.´ key and VS pops up a box with the possible options) it contains only : datareaderprovider, datatableprovider, dataviewprovider, textorovider there is not crosstabdataprovider.... are there any VB.net sample you can point me to ? "SoftwareFX Support" <noreply@softwarefx.com> wrote in message news:dqVrwtklGHA.2400@webserver3.softwarefx.com... > You need to add a reference to ChartFX.WinForms.Data.dll. > > -- > Francisco Padron > www.chartfx.com >
Software FX Posted June 26, 2006 Report Posted June 26, 2006 As Frank said, you need to add a reference to ChartFX.WinForms.Data.dll This file is located here C:\Program Files\Chart FX for Visual Studio 2005\bin Your version of "C:\Program Files\Chart FX for Visual Studio 2005" might be different. 1) Open the Solution Explorer. 2) Right-Click on your project file and choose "Add Reference" 3) Choose Browse Tab - There you should need to browse to the aforementioned directory. Hope this helps. -c "Aussie Rules" <AussieRules@nospam.nospam> wrote in message news:e%23eZMu9lGHA.524@webserver3.softwarefx.com... > Hi, > > I have already got the imports chartfx.winforms, and when I type the > following the tool tips/autocomplete (what its called when the hit the ´.´ > key and VS pops up a box with the possible options) it contains only : > datareaderprovider, datatableprovider, dataviewprovider, textorovider > > there is not crosstabdataprovider.... > > are there any VB.net sample you can point me to ? > > > > "SoftwareFX Support" <noreply@softwarefx.com> wrote in message > news:dqVrwtklGHA.2400@webserver3.softwarefx.com... >> You need to add a reference to ChartFX.WinForms.Data.dll. >> >> -- >> Francisco Padron >> www.chartfx.com >> > >
Recommended Posts
Archived
This topic is now archived and is closed to further replies.