|
|
|
Forum Newbie
Group: Forum Members
Last Login: 7/28/2008 1:04:07 PM
Posts: 3,
Visits: 7
|
|
Hi
I am trying to set up a multi-series line chart to read data from a table in SQL Server 2007. I have looked all over and cannot seem to find any way. Single series charts are easy enough to do, but this is making me pull my hair out... 
Can someone please provide a mock script as to how to do this, for example, sales for different products per month (i.e. each line would be a product)??? This needs to be dynamic like the single series graphs are. Setting up XML pages is confusing enough as I keep getting issues.
Any help would be GREATLY appreciated!!!
|
|
|
|
|
Supreme Being
Group: Moderators
Last Login: Today @ 8:03:52 AM
Posts: 625,
Visits: 1,912
|
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 7/28/2008 1:04:07 PM
Posts: 3,
Visits: 7
|
|
Thanks for this.
The structure is as follows...
SQL Table entitled [Monthly Sales]. Columns in the table are Month, datevalue, Product, SalesPerson, Amount.
I am connecting via a SQL Dsn named "Sales_Conn".
I need a multi-line graph depicting value of sales per product over the various months.
Sorry if I am still not providing you with all you need. Any mock database scripts connecting to a dsn and then charting it would be great! I have started trying to figure out the syntax of the xml, but am having issues in rendering category and series values from the database in a format a multi-line chart can read.
So now I am totally lost...
|
|
|
|
|
Supreme Being
Group: Moderators
Last Login: Today @ 8:03:52 AM
Posts: 625,
Visits: 1,912
|
|
| Hi bigjon001, Please follow the code for MS line depending on your data. I thing you can use it to build your Application.
Thanks,
Arindam FusionCharts Team
www.fusioncharts.com
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 7/28/2008 1:04:07 PM
Posts: 3,
Visits: 7
|
|
| Thanks. I can't access the file though, as it is re-routing me to the forum landing page. Please can you save it as txt?
|
|
|
|
|
Supreme Being
Group: Moderators
Last Login: Today @ 8:03:52 AM
Posts: 625,
Visits: 1,912
|
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 11/4/2008 1:54:55 PM
Posts: 1,
Visits: 1
|
|
| Having the same issue. Did you ever receive any code sample for creating the xml file using asp (vbs)? You are correct that the single serier work great but the logic appear to be different with the multi-series. I am trying to work with a dynamic array but am not having any luck. Appreciate any help...
Ken
|
|
|
|
|
Supreme Being
Group: Moderators
Last Login: Today @ 8:03:52 AM
Posts: 625,
Visits: 1,912
|
|
|
| |