ASP.Net C#

FusionCharts Forum

Home

Members

Calendar

Who's On

Welcome Guest ( Login | Register )

ASP.Net C#

Rate Topic

Display Mode

Topic Options

Author

Message

ppr

Posted 6/10/2008 9:29:02 PM

Forum Newbie

Group: Forum Members
Last Login: 6/11/2008 11:37:08 PM
Posts: 1, Visits: 3

Hi all

I am trying to make drill down chart but when i run the page it just show the text chart twise. After that I copy and paste whole example given in fusionchart V3 and tryied again but the same output shown.

can any one help me .

the code is

for default page:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<html>

<head>

<title>Untitled Page</title>

//You need to include the above JS file, if you intend to embed the chart using JavaScript.

//Embedding using JavaScripts avoids the "Click to Activate..." issue in Internet Explorer

//When you make your own charts, make sure that the path to this JS file is correct. Else, you would get JavaScript errors.

</script>

function updateChart(factoryIndex)

{

var strURL = "FactoryData.aspx?factoryId=" + factoryIndex;

strURL = escape(strURL);

var chartObj = new FusionCharts('../FusionCharts/Column2D.swf', 'FactoryDetailed', '600', '250', '0', '0');

var chartObj = getChartFromId("FactoryDetailed");

chartObj.setDataURL(strURL);

}

function getTimeForURL(){

var dt = new Date();

var strOutput = "";

strOutput = dt.getHours() + "_" + dt.getMinutes() + "_" + dt.getSeconds() + "_" + dt.getMilliseconds();

return strOutput;

}

</script>

</head>

<body>

<%=GetFactorySummaryChartHtml()%>

<br>

<%=GetFactoryDetailedChartHtml()%>

</form>

</body>

</html>

code behind page:

using System;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using InfoSoftGlobal;

using System.Text;

using DataConnection;

public partial class _Default : System.Web.UI.Page

{

public string GetFactorySummaryChartHtml()

{

//xmlData will be used to store the entire XML document generated

StringBuilder xmlData = new StringBuilder();

xmlData.Append("<chart caption='Factory Output report' subCaption='By Quantity' pieSliceDepth='30' showBorder='1' formatNumberScale='0' numberSuffix=' Units' >");

//Create recordset to get details for the factories

string factoryQuery = "select a.FactoryId, a.FactoryName, sum(b.Quantity) as TotQ from .Factory_Master a, Factory_Output b where a.FactoryId=b.FactoryID group by a.FactoryId, a.FactoryName ";

DbConn oRs = new DbConn(factoryQuery);

//Iterate through each record

while (oRs.ReadData.Read())

{

xmlData.AppendFormat("<set label='{0}' value='{1}' link='javaScript:updateChart({2})' />", oRs.ReadData["FactoryName"].ToString(), oRs.ReadData["TotQ"].ToString(), oRs.ReadData["FactoryId"].ToString());

}

//Close chart element

xmlData.Append("</chart>");

//Create the chart - Pie 3D Chart with data from xmlData

return FusionCharts.RenderChart("../FusionCharts/Pie3D.swf", "" , xmlData.ToString() , "FactorySum", "500", "250", false, true);

}

public string GetFactoryDetailedChartHtml()

{

//Column 2D Chart with changed "No data to display" message

//We initialize the chart with <chart></chart>

return FusionCharts.RenderChart("../FusionCharts/Column2D.swf?ChartNoDataText=Please select a factory from pie chart above to view detailed data.", "", "<chart></chart>", "FactoryDetailed", "600", "250", false, true);

}

Regards
Ritesh

Post #6733

Sudipto Choudhury

Posted 6/11/2008 2:10:29 AM

Supreme Being

Group: Moderators
Last Login: Today @ 7:43:49 AM
Posts: 880, Visits: 1,415

Hi,

Could you please try once using RenderChartHTML() method instead of RenderChart() for the DrilledDown chart?

Regards,

Sudipto Choudhury
FusionCharts Team

Post #6740

« Prev Topic | Next Topic »

Permissions

All times are GMT -7:00, Time now is 10:50pm

Execution: 0.094.