jshollax Report post Posted September 19, 2008 (edited) I am a rookie with Fusion charts and XML. I am trying to use the VS2008 built in XML generator but fusion charts keeps saying invalid xml data. If I save the data to a file first the chart works just fine. public string GetMonthlyPassDownChartHtml(){ string tmpY = ""; switch (ddYear.SelectedValue) { case "2007": tmpY = "07"; break; case "2008": tmpY = "08"; break; case "2009": tmpY = "09"; break; case "2010": tmpY = "10"; break; default: break; } var passDownRaw = from p in db.PassDownLinqs select p; XElement xml = new XElement("chart", new XAttribute("caption", "PassDown Metrics"), new XAttribute("xAxisName", "Month"), new XAttribute("yAxisName", "Number of Entries"), new XElement("Set", new XAttribute("label", "'Jan'"), new XAttribute("value", passDownRaw.Where(c => c.Date >= Convert.ToDateTime("1/1/" + tmpY) && c.Date <= Convert.ToDateTime("1/" + DateTime.DaysInMonth(Convert.ToInt32(tmpY), 1) + "/" + tmpY)).Select(c => c.ID).Count())), new XElement("Set", new XAttribute("label", "'Feb'"), new XAttribute("value", passDownRaw.Where(c => c.Date >= Convert.ToDateTime("2/1/" + tmpY) && c.Date <= Convert.ToDateTime("2/" + DateTime.DaysInMonth(Convert.ToInt32(tmpY), 2) + "/" + tmpY)).Select(c => c.ID).Count())), new XElement("Set", new XAttribute("label", "'Mar'"), new XAttribute("value", passDownRaw.Where(c => c.Date >= Convert.ToDateTime("3/1/" + tmpY) && c.Date <= Convert.ToDateTime("3/" + DateTime.DaysInMonth(Convert.ToInt32(tmpY), 3) + "/" + tmpY)).Select(c => c.ID).Count())), new XElement("Set", new XAttribute("label", "'Apr'"), new XAttribute("value", passDownRaw.Where(c => c.Date >= Convert.ToDateTime("4/1/" + tmpY) && c.Date <= Convert.ToDateTime("4/" + DateTime.DaysInMonth(Convert.ToInt32(tmpY), 4) + "/" + tmpY)).Select(c => c.ID).Count())), new XElement("Set", new XAttribute("label", "'May'"), new XAttribute("value", passDownRaw.Where(c => c.Date >= Convert.ToDateTime("5/1/" + tmpY) && c.Date <= Convert.ToDateTime("5/" + DateTime.DaysInMonth(Convert.ToInt32(tmpY), 5) + "/" + tmpY)).Select(c => c.ID).Count())), new XElement("Set", new XAttribute("label", "'Jun'"), new XAttribute("value", passDownRaw.Where(c => c.Date >= Convert.ToDateTime("6/1/" + tmpY) && c.Date <= Convert.ToDateTime("6/" + DateTime.DaysInMonth(Convert.ToInt32(tmpY), 6) + "/" + tmpY)).Select(c => c.ID).Count())), new XElement("Set", new XAttribute("label", "'Jul'"), new XAttribute("value", passDownRaw.Where(c => c.Date >= Convert.ToDateTime("7/1/" + tmpY) && c.Date <= Convert.ToDateTime("7/" + DateTime.DaysInMonth(Convert.ToInt32(tmpY), 7) + "/" + tmpY)).Select(c => c.ID).Count())), new XElement("Set", new XAttribute("label", "'Aug'"), new XAttribute("value", passDownRaw.Where(c => c.Date >= Convert.ToDateTime("8/1/" + tmpY) && c.Date <= Convert.ToDateTime("8/" + DateTime.DaysInMonth(Convert.ToInt32(tmpY), 8) + "/" + tmpY)).Select(c => c.ID).Count())), new XElement("Set", new XAttribute("label", "'Sep'"), new XAttribute("value", passDownRaw.Where(c => c.Date >= Convert.ToDateTime("9/1/" + tmpY) && c.Date <= Convert.ToDateTime("9/" + DateTime.DaysInMonth(Convert.ToInt32(tmpY), 9) + "/" + tmpY)).Select(c => c.ID).Count())), new XElement("Set", new XAttribute("label", "'Oct'"), new XAttribute("value", passDownRaw.Where(c => c.Date >= Convert.ToDateTime("10/1/" + tmpY) && c.Date <= Convert.ToDateTime("10/" + DateTime.DaysInMonth(Convert.ToInt32(tmpY), 10) + "/" + tmpY)).Select(c => c.ID).Count())), new XElement("Set", new XAttribute("label", "'Nov'"), new XAttribute("value", passDownRaw.Where(c => c.Date >= Convert.ToDateTime("11/1/" + tmpY) && c.Date <= Convert.ToDateTime("11/" + DateTime.DaysInMonth(Convert.ToInt32(tmpY), 11) + "/" + tmpY)).Select(c => c.ID).Count())), new XElement("Set", new XAttribute("label", "Dec0" + tmpY), new XAttribute("value", passDownRaw.Where(c => c.Date >= Convert.ToDateTime("12/1/" + tmpY) && c.Date <= Convert.ToDateTime("12/" + DateTime.DaysInMonth(Convert.ToInt32(tmpY), 12) + "/" + tmpY)).Select(c => c.ID).Count())) ); //xml.Save("C:Documents and SettingsMy DocumentsVisual Studio 2008ProjectsPassDown MetricsPassDown MetricsDataData1.xml"); return FusionCharts.RenderChartHTML("../FusionCharts/Column3D.swf", "", xml.ToString(), "myFirst", "800", "600", false);} } The xml looks like this before it is saved to the file. <chart caption="PassDown Metrics" xAxisName="Month" yAxisName="Number of Entries"> <Set label="'Jan'" value="0" /> <Set label="'Feb'" value="0" /> <Set label="'Mar'" value="0" /> <Set label="'Apr'" value="0" /> <Set label="'May'" value="0" /> <Set label="'Jun'" value="0" /> <Set label="'Jul'" value="20" /> <Set label="'Aug'" value="79" /> <Set label="'Sep'" value="115" /> <Set label="'Oct'" value="94" /> <Set label="'Nov'" value="412" /> <Set label="Dec007" value="1266" /> </chart> When its saved to the file it works just fine and this is what it looks like. <?xml version="1.0" encoding="utf-8"?> <chart caption="PassDown Metrics" xAxisName="Month" yAxisName="Number of Entries"> <Set label="'Jan'" value="0" /> <Set label="'Feb'" value="0" /> <Set label="'Mar'" value="0" /> <Set label="'Apr'" value="0" /> <Set label="'May'" value="0" /> <Set label="'Jun'" value="0" /> <Set label="'Jul'" value="20" /> <Set label="'Aug'" value="79" /> <Set label="'Sep'" value="115" /> <Set label="'Oct'" value="94" /> <Set label="'Nov'" value="412" /> <Set label="Dec007" value="1266" /> </chart> Does the missing "<?xml version="1.0" encoding="utf-8"?>" from the data in memory cause the issue? Edited September 19, 2008 by Guest Share this post Link to post Share on other sites
Arindam Report post Posted September 20, 2008 (edited) Hi, Could you please modify your code? your Code: new XElement("Set", new XAttribute("label", "'Jan'"), Code Change to: new XElement("Set", new XAttribute("label", "Jan"), also change same code for all month. ================================ At Chart Render Time Please Change to this code ->> string strXML = xml.ToString();strXML = strXML.Replace(""", "'"); strXML = strXML.Replace("r", ""); strXML = strXML.Replace( "n", ""); return FusionCharts.RenderChartHTML("../FusionCharts/Column3D.swf", "", strXML, "myFirst", "800", "600", false); Edited September 20, 2008 by Guest Share this post Link to post Share on other sites
jshollax Report post Posted September 22, 2008 That worked perfect ty very much. Share this post Link to post Share on other sites
