RE: Stacked chart problem

tessy790 — Sun, 10 Feb 2008 11:48:03 GMT

*Problem solved*

Stacked chart problem

tessy790 — Fri, 08 Feb 2008 09:32:09 GMT

I am trying to create a stacked chart reading data from a database. I dont understand how to display all the data.

I have am testing it using one category which has three results (week 1, 20, 30, 40)

I've changed <> with {} so that I could get it showing up properly.

Do you have to loop through the database?

sql string is - string strSQL = "SELECT Student_kudos.points, Kudos.week, Kudos.Title FROM Kudos INNER JOIN Student_kudos ON Kudos.KudosID = Student_kudos.KudosID WHERE (Student_kudos.studentID = 'xxxxxx') AND (Student_kudos.status = 'true')AND Kudos.week ='1'order by Kudos.week";

strXML.AppendFormat("{chart palette='1' caption='Weekly Kudos Breakdown' shownames='1' showvalues='0' numberPrefix='$' showSum='1' decimals='0' overlapColumns='0'}");
strXML.AppendFormat("{categories}{category label='week 1'/}{/categories}");
strXML.AppendFormat("{dataset seriesName='1' showValues='0'}");
strXML.AppendFormat("{set value='{0}'/}", oRs.ReadData["points"].ToString());
strXML.AppendFormat("{set value='{0}'/}", oRs.ReadData["points"].ToString());
strXML.AppendFormat("{set value='{0}'/}", oRs.ReadData["points"].ToString());
strXML.AppendFormat("{/dataset}");

Thanks in advance

FusionCharts Forum / FusionCharts v3 / Using FusionCharts / FusionCharts and ASP.NET / Stacked chart problem / Latest Posts

RE: Stacked chart problem

Stacked chart problem