FusionCharts Forum / FusionCharts v3 / Using FusionCharts / FusionCharts and ASP.NET

Axis Label Wrapping

MartinS — Fri, 07 Nov 2008 05:29:30 GMT

I have three charts on a page, and the x-axis labels are the same on both charts.

One chart is 175px high by 350px wide, and the second is the same height but 550px wide. Only difference is that the second chart has a legend displayed to the right of the chart. The first chart does not display a legend.

With chart 1, the three labels word wrap, but on the second one they don't - is there a way to force the axis label word wrap?

Thanks

Martin

DragColumn2D ang button values.

JJ — Mon, 24 Nov 2008 10:27:03 GMT

Hi,

I am using the DragColumn2D.swf and would like to know how I change the text on the button(restore) and button(read data from chart) also my figures in the table display $ and I would like to get rid of this completely.

Thanks

embed multiple charts in single page

shockwave100 — Mon, 24 Nov 2008 00:02:42 GMT

Hi All,

I am wondering if its possible to embed multiple charts in the same page? New to the world of asp.net. I can manage to create a multigraph pulling info from our db, but would like to create other graphs on the same page that do this as well.

Has anyone been sucessful with this? and if so how the on earth did you do it?

Cheers

Shock

SSGrid (Grid Component)

JJ — Fri, 21 Nov 2008 03:52:48 GMT

Hi,

Can SSGrid (Grid Component) be used for multi series data and is it possible to add hyperlinks to the grid?

Thanks

cannot get sample asp.net chart to display graph ( vwd2005)

shockwave100 — Tue, 18 Nov 2008 17:55:43 GMT

HI All,

I am trying to play around with the simple charts in asp.net but with no luck. All I get is a blank page. I have added the reference "infosoftglobal.dll" so the code can call fusion objects, but i get an error with the code file saying that:

"the language of the file referenced by the codefile attribute does not match the language specified by the 'language' attribute in the current file"

I guess that makes sense since the langage is in "c#" but the file behind is in vb. Really not sure whether this makes a difference. So instead of using:

<%@ Page language="c#" Codebehind="BasicChart.aspx.vb" AutoEventWireup="false" Inherits="InfoSoftGlobal.GeneralPages.ASP.NET.BasicExample.BasicChart" %> <%@ Page language="c#" Codebehind="BasicChart.aspx.vb" AutoEventWireup="false" Inherits="InfoSoftGlobal.GeneralPages.ASP.NET.BasicExample.BasicChart" %>

VB.net uses the following and doesn't like the "codebehind" and instead used the "codefile". Kind of confused with the "InfoSoftGlobal.GeneralPages.ASP.NET.BasicExample.BasicChart" line. What do I need to do to get this to work????????.

<%@ Page language="c#" AutoEventWireup="false" CodeFile="BasicChart.aspx.vb" Inherits="BasicChart" %>

<HTML>

<HEAD>

<TITLE>FusionCharts - Simple Column 3D Chart </TITLE>

</HEAD>

<body>

<%=GetMonthlySalesChartHtml()%>

</form>

</body>

</HTML>

Catergories label alignment

JJ — Mon, 17 Nov 2008 08:16:57 GMT

Hi,

I have created a chart using the StackedBar2D.swf. The problem is I have long names for the catergories and will like to align them all to the left. I have played around with the margins,padding and labelDisplay but no joy. I have inserted the chart so you have an idea of what it currently looks like.

Thanks

[ code ]

<categories>

<category label="TestTestTest"/>

<category label="TestTestTestTest"/>

<category label="TestTestTestTestTestTest"/>

<category label="TestTestTestTestTestTestTestTestTestTest"/>

<category label="TestTestTestTestTestTes"/>

</categories>

<dataset seriesName="Test3" color="AFD8F8" showValues="1 " bgcolor="ffffff" decimals="1">

<set value="2.8" />

<set value="" />

<set value="2.8" />

<set value="" />

<set value="2.8" />

<set value="" />

</dataset>

<dataset seriesName="Test2" color="F6BD0F" showValues="1" decimals="1">

<set value="16.7" />

<set value="22.2" />

<set value="25" />

<set value="16.7" />

<set value="22.6" />

</dataset>

<dataset seriesName="Test1" color="8BBA00" showValues="1" decimals="1">

<set value="80.6" />

<set value="77.8" />

<set value="72.2" />

<set value="75" />

<set value="80.6" />

<set value="77.4" />

</dataset>

</chart>

[/ code ]

Converting Graph in ASP to ASP.net

shockwave100 — Mon, 17 Nov 2008 18:12:03 GMT

Hi all,

I am a newbie when it comes to web development and have been sucessful in creating a page in asp however I am having difficulty tring to convert this in to asp.net. Can anyone have a look at my code to see what parameter stuff I need to add in?

Been pulling my hair out trying to trouble shoot and fill in the blanks with my limited knowledge. Hoping that a kind individual will be able help me with a quick fix. I have attempted to try and change it to make it asp.net compliant, but it was a little dodgy so I have just supplied the raw code below that works in an asp page.

Here is the code:

<%@ Language=VBScript %>
<HTML>
<HEAD>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">

<SCRIPT LANGUAGE="Javascript" SRC="Charts/FusionCharts.js"></SCRIPT>

%>

<BODY>

<CENTER>
<h2>AAPT Australian Operations</h2>
<p>This chart can be relicated to suit view based on mdx query.</p>

<%

Dim cn
Dim cat
Dim cel
Dim strMDX
Dim sConnect
Dim sXML

'------------- Open up connection to OLAP database ----------------------

Set cn = Server.CreateObject("ADODB.Connection")
cn.Mode = 3
cn.CursorLocation = 2
cn.IsolationLevel = 4096

'Error when tyring to reference tm1 macro for parameter Location=" & Run("OPTGET", "AdminHost ")
'hardcoded instead

sConnect = "DATA SOURCE=mydatasource;PROVIDER=MYOLAP;Location=Aunswa155"
cn.Open sConnect, "username", "password"

'---------------------------------------------------------------------------------
' INSERT MDX STRING HERE

strMDX = "SELECT {[accounts].[AAPT_REV],[accounts].[COS],[accounts].[OP_COSTS],[accounts].[AAPTEBITDA]} ON COLUMNS,"
strMDX = strMDX & "{[Month].[Jul],[Month].[Aug],[Month].[Sep],[Month].[Oct],[Month].[Nov],[Month].[Dec],[Month].[Jan],[Month].[Feb],[Month].[Mar],[Month].[Apr],[Month].[May],[Month].[Jun]} ON ROWS"
strMDX = strMDX & " FROM [Reportingaapt]"
strMDX = strMDX & " WHERE ([Company].[TPWT],[transindicator].[All Indicators],[tradingindicator].[All tradingpartners],"
strMDX = strMDX & "[accessmethod].[ALLAccessMethods],[coo_ausext].[Au_ext],[measures].[Financial],[Year].[2008],[Version].[Reported],[product].[TOT_PRODUCT])"

'-----------------------------------------------------------------------------------
' OPEN Cellset Object

Set cel = Server.CreateObject("ADOMD.Cellset")
cel.Open strMDX,cn

'----------------------------------------------------------------------------------------------
'Get Dimension and position index to return data from cube

intDCO = cel.Axes(0).DimensionCount - 1
intDC1 = cel.Axes(1).DimensionCount - 1

intPCO = cel.Axes(0).Positions.Count - 1
intPC1 = cel.Axes(1).Positions.Count - 1

Response.Write "<BR><H4>Results:</H4>"

'------ Define headings and labels -------

sXML = sXML & "<chart caption='REVENUE v COS V OPEX V EBITDA (FY08)' numberPrefix='$' formatNumberScale='1' rotateValues='0' placeValuesInside='1' decimals='0'" & ">"
'sXML = sXML & "<chart caption='AAPT Australian Operations EBITDA V REVENUE' xAxisName='Month' yAxisName='Dollars' showValues='0' formatNumberScale='0' showBorder='1'" & ">"
sXML = sXML & "<categories" & ">"

'------ Define categories ---------------

For yy = 0 to IntPC1
For r = 0 to intDC1
sXML = sXML & "<category label=" & "'" & cel.Axes(1).positions(yy).Members(r).Caption & "'" & " />"
Next
Next
sXML = sXML & "</categories" & ">"

'------- define first dataset -------

sXML = sXML & "<dataset seriesName='Revenue'" & ">"
For yy = 0 to IntPC1
For z = 0 to intPC0
sXML = sXML & "<set value=" & "'" & FormatNumber(cel(z,yy).Value,0,,,0) & "'" & " />"
Next
Next
sXML = sXML & "</dataset" & ">"

'------- define second dataset -------

sXML = sXML & "<dataset seriesName='COS'" & ">"
For yy = 0 to IntPC1
For z = 0 to intPC0
sXML = sXML & "<set value=" & "'" & FormatNumber(cel(z + 1,yy).Value,0,,,0) & "'" & " />"
Next
Next
sXML = sXML & "</dataset" & ">"

'------- define third dataset -------

sXML = sXML & "<dataset seriesName='OPEX'" & ">"
For yy = 0 to IntPC1
For z = 0 to intPC0
sXML = sXML & "<set value=" & "'" & FormatNumber(cel(z + 2,yy).Value,0,,,0) & "'" & " />"
Next
Next
sXML = sXML & "</dataset" & ">"

'------- define forth dataset -------

'sXML = sXML & "<dataset seriesName='EBITDA'" & ">"
'For yy = 0 to IntPC1
'For z = 0 to intPC0
'sXML = sXML & "<set value=" & "'" & FormatNumber(cel(z + 3,yy).Value,0,,,0) & "'" & " />"
'Next
'Next
'sXML = sXML & "</dataset" & ">"

'--- close graph ----------

sXML = sXML & "<" & "/chart" & ">"

Call renderChart("Charts/MSLine.swf", "", sXML, "", 600, 300, false, false)
cn.close
Set cel = nothing
Set cat = nothing
Set cn = nothing

query strings, dates and complicated data!

tabbykitty — Fri, 14 Nov 2008 12:04:48 GMT

Hi there

I am a newbie using visual web designer with asp.net vb and i am using data from an access database.

I have a rather complicated query which displays cricket scores grouped by date for a particular player (url query string)

I would like to display bar columns for "balls bowled" and "runs conceded" and "wickets" grouped by the date of the match played (horizontal axis)

I have already got an asp.net graph working on the site that i am trying to do this for but i would obviously love to use fusioncharts free to display this information (for the existing graph go here: [url=http://www.allrounderacademy.co.za/profilebowlstats.aspx?UserID=62][/url])

I have followed the examples and have got a little way into making it work for me but i am stuck as i a) dont know how to get the user id from a query string for this and b) i need to group each column by date and it doesnt seem to like that and c) i dont know how to add another column let alone another 2 columns and d) how can i format the date displayed from the database !

Here is what i have done so far, i have hard coded the userid into this code for now just to get it working.

Here is my code from the code behind

[code]Imports DataConnection
Imports InfoSoftGlobal

Partial Class DBExample_BasicDBExample
Inherits System.Web.UI.Page

Public Function CreateChart() As String
'In this example, we show how to connect FusionCharts to a database.
'For the sake of ease, we've used an Access database which is present in
'../App_Data/FactoryDB.mdb. It just contains two tables, which are linked to each
'other.

'Database Objects - Initialization
Dim oRs As DbConn, strQuery As String
'strXML will be used to store the entire XML document generated
Dim strXML As String

'Generate the graph element
strXML = ""

'Iterate through each factory
strQuery = "SELECT ChartWicketQuery.*, ChartWicketQuery.UserID FROM(ChartWicketQuery)WHERE (((ChartWicketQuery.UserID)=34))"
oRs = New DbConn(strQuery)
While oRs.ReadData.Read()
'Now create second recordset to get details for this factory
strQuery = "SELECT ChartWicketQuery.MatchWickets, ChartWicketQuery.MatchDateFormatted, ChartWicketQuery.MatchBallsBowled, ChartWicketQuery.MatchRunsConceded FROM(ChartWicketQuery)WHERE (((ChartWicketQuery.UserID)=34) AND ((ChartWicketQuery.MatchDateFormatted)=" & oRs.ReadData("MatchDateFormatted").ToString()

Dim oRs2 As New DbConn(strQuery)
oRs2.ReadData.Read()
'Generate
strXML = strXML & ""
'Close recordset
oRs2.ReadData.Close()
End While
oRs.ReadData.Close()
'Finally, close element
strXML = strXML & ""

'Create the chart - Pie 3D Chart with data from strXML
Return FusionCharts.RenderChart("../FusionCharts/FCF_Column3D.swf", "", strXML, "FactorySum", "650", "450", False, False)
End Function
End Class
[/code]

This code doesnt work as i get an error which i believe is something to do with the date.

Could you please help me as i would really love to put this on the site and impress the players (one of whom is my son):)

Thank you in advance

Pie Chart

chithra_s — Fri, 14 Nov 2008 04:37:29 GMT

Hi,

Im using Pie chart. Can possible to create pie chart using FusionChart.js.

my code look like below.

var chart = new FusionCharts("Pid2D.swf", "ChartId", "400", "400", "0", "0");
chart.setDataXML("dailyreport.xml");
chart.render("chartdiv2D");

Need to render the chart into htm. is it possible using above code.?

could anyone help me to acheive this ?

Chithra.S

Stacked chart

chithra_s — Wed, 12 Nov 2008 07:24:27 GMT

Hi All,

I want to create one stacked chart based on 3 values.could anyone suggest me which swf should i use..?

Chithra

How do I make Pie Chart links pass parameters to a GridView - HELP

thoth — Wed, 07 May 2008 18:39:53 GMT

Hello all,

I've been racking my brain for three days trying to find a solution to this problem. I hope someone here can help me.

I have a pie chart and a GridView on the same page. I want to make each slice of the pie chart act as a parameter that changes the GridView. I've thoroughly read the documentation and toyed with the examples. Ive even downloaded and examined the blueprint application, but I cannot find a working example of this scenario to learn from.

As a temporary work around, I am passing parameters from the pie chart as a query string in a url to another page via the charts link element. This target page contains a gridview and it's loaded into an iframe below the pie chart. While this work around does its job, its not really what I want to do.

How can I pass parameters from the chart to a gridview that resides on the same page so I can make the gridview change using an ajax partial page refresh?

Any help would greatly be appreciated.

passing parameters in fusion chart my front end is jsp

manikantaprasad — Mon, 10 Nov 2008 06:59:07 GMT

hi fusion charts team
can u pls post one sample code for passing the parameters in the fusion charts drill down
pls give one example

thank u

B.MANIKANTAPEASAD

Can I Stop Chart from Redrawing?

MartinS — Fri, 07 Nov 2008 05:26:22 GMT

I have a webpage with three fusion bar charts on it, and the chart data is calculated based on slider control selections made - the numbers are regenerated and the charts then redraw in entirety, so it is not easy to see which way the chart has changed.

Is there any way to assign a new dataset without a complete redraw?

Thanks

Martin

InfoSoftGlobal.dll

suma — Fri, 07 Nov 2008 06:05:55 GMT

Hi,

Can you please tell me where can i find the InfoSoftGlobal.dll in download? I dont think its avialable in my download version. I want to use charts in ASP.Net basically i need to use the method RenderChart() of FusionChart class.

Cheers,

Suma

Two series Pie Chart

suma — Fri, 07 Nov 2008 10:48:53 GMT

Hi,

could you tell me how to implement a Pie chart with two series i.e similar to 'Multi series Bar Chart', I tried with Multi-level Pie chart but the sections it draws will not be proportional to the value which i provide in <Category> element.

Could any one please advice me on this quickly?

Thanks,

Suma

How to Display x-axis value in a chart

gv_subash — Wed, 05 Nov 2008 20:20:54 GMT

Hi Friends,

In my x-axis and y-axis i am passing values from database. I am able to plot correctly.in Y-axis the values displayed are 1,2,3,4,5,6,7,......100. for each value in x-axis its geetting exactly mapped to y-axis values. but due to 100 values in x-axis the values are getting overlap. i need the values displayed as 5,10,15,20,...... How to define values in x-axis as 5,10,15,20...
ix for each pixel it should take value 1.

Please help me in resolving this issue.my code is

String XMLDataS = string.Empty;
XMLDataS = String.Format("", "For Node no:" + Node, TimeFrom, TimeTo);
XMLDataS = XMLDataS + "";

foreach (DataRow dr in ds.Tables[0].Rows)
{
XMLDataS = XMLDataS + String.Format("", dr["TIMESTAMP"].ToString());
}
XMLDataS = XMLDataS + "";

if (sen11)
{
XMLDataS = XMLDataS + String.Format("");
foreach (DataRow dr in ds.Tables[0].Rows)
{

XMLDataS = XMLDataS + String.Format("", dr["SENSOR1"].ToString());
}
XMLDataS = XMLDataS + "";

}

My ASP page does not display FusionChart

maksuda — Fri, 31 Oct 2008 11:03:40 GMT

Hi:

I have developed a fusion chart in ASP(C#). It's coding and XML pages are ok as it's working properly, but when I try to call the function on a On Button_Click event , it does not display, it displays only when I call the function from my .aspx page. I tried both ways.....

[Code]

protected void Button1_Click(object sender, EventArgs e)

{

GetYearlySummaryChartHtml();

}

[/Code]

it's not working.........

please need help.................

setTransparent with InfoSoftGlobal dll

garnold — Mon, 03 Nov 2008 13:48:22 GMT

Question, I can use setTransparent like this with javascript
chart.setTransparent(true);

How do I do this when using the dll to render the chart within codebehide?

Much Thanks!

Hover to see new chart

JJ — Mon, 03 Nov 2008 05:31:35 GMT

Hi All,

Can someone please tell me if it is possible to hover over a column and see a detailed chart and also be able to click on the chart to open in a new window. I have found an example on how to open in a new window but no example on how to hover over a column.

Thanks

PERCENTAGE sign is on the wrong side of the numbers

dannytammyuk — Fri, 24 Oct 2008 08:33:46 GMT

Hi I have set up a Chat with gets the data from Arrays, it works fine apart from one little problem,

The percentage sign is on the wrong side of the numbers eg;(%100) and I need it like this (100%)

Save Chart as Image

cielo — Mon, 20 Oct 2008 03:19:31 GMT

hi, im new in fusionchart

can anyone help me how to dynamically save chart as image without using right click and then save??

i have also problem with displaying label for each dot,example i want to have 1,2,3,4,5 and so on...for each dot, i use <value> attribute to set its label but still it displays wrong label..it displays the <y> value which is quantity sold..

anyway im using scatter(xy plot)..

ASP.NET.AJAX UpdatePanel Sample #1

Sudipto Choudhury — Sun, 04 Nov 2007 06:27:48 GMT

HI all,
Here goes a simple example using FusionCharts in ASP.NET AJAX UpdatePanel.
Please try this and shoot us your valuable feedback.

Read Post :

http://www.fusioncharts.com/forum/FindPost2949.aspx

Here is the link to downlod :
[url]http://www.fusioncharts.com/forum/Attachment147.aspx[/url]

Updatepanel and multiple charts getting refreshed

aleks1429 — Fri, 26 Sep 2008 11:41:03 GMT

Hi all,

Does anyone know if there is a way to stop charts from refreshing when another chart is being created?

Here is my case:
I have an ASP.NET 2.0 page that has 4 chart controls. Each chart is parent of another chart for example:

Drop Down

Chart 1 > Chart 2 > Chart 3 > Chart 4

All of these charts are in an updatepanel.

When I select from drop down. first chart appears. When I click on the first chart bar, second chart appears, etc....

however, when i click on the second bar chart, i don't want for the first chart to refresh.
or when i click on the 3 chart i don't want for 1 and 2 one to refresh and reload.

Is there a way around this?

Thanks,
Al

Display issue with IE 7 v/s FF

pmamp — Tue, 23 Sep 2008 10:11:02 GMT

I have some issue with rendering charts in IE 7. I get just a text 'o display' instead of chart.

This occures when using FusionCharts.RenderChartHTML. When I try it with JS mode (FusionCharts.RenderChart) it shows 'chart' as text. The same code works okay in Firefox 2/3.

PLEASE HELP TO WHAT IS GOING ON HERE..

If you would like to take a look at site it is: http://reports.iupui.edu/webreports/default.aspx/overview#fiscal

Display chart caption and sub caption when data does not exist

dreid — Mon, 15 Sep 2008 16:39:51 GMT

I am trying to show the chart caption when data does not exist. I have resorted to using separate labels instead of assigning values to the caption and sub caption attributes. Currently, when a chart is rendered with no data the message "No data exists" is rendered and the caption and sub caption disappear.

Has anyone ran into this issue? If so, where you able to resolve it?

Thanks,

D. Reid
HealthString, LLC

Change colors in Cloumn graph

Powderworks — Sun, 14 Sep 2008 01:28:09 GMT

How do I change the colors in a Column 2D Graph

Thanks

Disable Slicing and Exploding Menu Options..

pdaniel — Tue, 02 Sep 2008 08:44:30 GMT

When users right click on the pie chart (after it has been rendered on the page), the context menu has options to slice or explode the slices. Can this be removed similar to how I can rmeove the Fusion Charts options by using showFCMenuItem='0'? I have read conflicting messages on this. Most state that it cannot be done, while one stated that it could be done with menu='0' or something along those lines. I tried to implement to no avail. I want to be able to have the flash on the chart (for the various rendering effects), but not the ability for users to perform the exploding, etc..

Thanks!

Patrick

links

sarvesh — Thu, 11 Sep 2008 05:26:18 GMT

how to give links to bars in column2d chart

Chart does not appear in my ASP.NET page!

dataAccess — Wed, 10 Sep 2008 15:18:32 GMT

Hi, the chart does not appear in my page, I spent 2 hours on this but failed, I doubled check the paths to the Fusionchart.js and the path to Oie3D.swf they both correct. The following is my code:

In the front page I included the name of the function:

<%=GetEmpChartHtml()%>

and here is the body of the function in the code behind:

Public Function GetEmpChartHtml() As String

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

Dim xmlData As New StringBuilder()

'Generate the chart element

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

Dim strConnection As String = ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString

Dim objConnection As New SqlConnection(strConnection)

Dim strSQL As String = "SELECT Emp_Name, id FROM employee;"

Dim objCommand As New SqlCommand(strSQL, objConnection)

Try

If objConnection.State = 0 Then _

objConnection.Open()

Dim dr As SqlDataReader = objCommand.ExecuteReader(CommandBehavior.CloseConnection)

If dr.HasRows() Then

While dr.Read()

xmlData.Append("<set label='" & dr.Item("Emp_Name").ToString() & "' value='" & dr.Item("ID").ToString() & "' />")

End While

End If

dr.Close()

Catch e As Exception

Finally

objConnection.Close()

End Try

'Close chart element

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

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

Return InfoSoftGlobal.FusionCharts.RenderChart("../../Charts/Pie3D.swf", "", xmlData.ToString, "FactorySum", "600", "300", False, False)

End Function

Two Charts on the one page

Powderworks — Wed, 03 Sep 2008 19:16:40 GMT

Having trouble getting two charts to display on the one page

Here is the code You can see I have duplicated the GetFactorySummaryChartHtml()

The first one displays but the second doesn't display

public string GetFactorySummaryChartHtml()

{

//In this example, we show how to connect FusionCharts to a database.

//For the sake of ease, we've used an Access database which is present in

//../App_Data/FactoryDB.mdb. It just contains two tables, which are linked to each

//other.

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

StringBuilder xmlData=new StringBuilder();

//Generate the chart element

xmlData.Append("<chart caption='Recommendation Progress Report' subCaption='' pieSliceDepth='30' showBorder='1' formatNumberScale='0' numberSuffix=''>");

//Create recordset to get details for the factories

//string factoryQuery = " SELECT Count(Recommendations) as TotNo FROM recommendations WHERE Complete = "No" , Count(Recommendation) as TotYes FROM recommendations WHERE Complete = "Yes"" ;

string factoryQuery = " SELECT complete, Count(*) as TotQ FROM recommendations GROUP BY Complete";

DbConn oRs = new DbConn(factoryQuery);

//Iterate through each record

while (oRs.ReadData.Read())

{

//Generate <set name='..' value='..' />

String lablecompleted = " ";

if (oRs.ReadData["Complete"].ToString() == "Yes")

{

lablecompleted = "Completed";

}

if (oRs.ReadData["Complete"].ToString() == "No")

{

lablecompleted = " Not Completed";

}

xmlData.AppendFormat("<set label='{0}' value='{1}' />", lablecompleted , oRs.ReadData["TotQ"].ToString());

//xmlData.AppendFormat("<set label='{0}' value='{1}' />", oRs.ReadData["Complete"].ToString(), oRs.ReadData["TotQ"].ToString());

}

oRs.ReadData.Close();

//Close chart element

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

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

return FusionCharts.RenderChart("../FusionCharts/Column3D.swf", "", xmlData.ToString(), "FactorySum", "400", "200", false, false);

}

public string GetFactorySummaryChartHtml2()

{

//In this example, we show how to connect FusionCharts to a database.

//For the sake of ease, we've used an Access database which is present in

//../App_Data/FactoryDB.mdb. It just contains two tables, which are linked to each

//other.

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

StringBuilder xmlData = new StringBuilder();

//Generate the chart element

xmlData.Append("<chart caption='Recommendation Progress Report' subCaption='' pieSliceDepth='30' showBorder='1' formatNumberScale='0' numberSuffix=''>");

//Create recordset to get details for the factories

//string factoryQuery = " SELECT Count(Recommendations) as TotNo FROM recommendations WHERE Complete = "No" , Count(Recommendation) as TotYes FROM recommendations WHERE Complete = "Yes"" ;

string factoryQuery = " SELECT complete, Count(*) as TotQ FROM recommendations GROUP BY Complete";

DbConn oRs = new DbConn(factoryQuery);

//Iterate through each record

while (oRs.ReadData.Read())

{

//Generate <set name='..' value='..' />

String lablecompleted = " ";

if (oRs.ReadData["Complete"].ToString() == "Yes")

{

lablecompleted = "Completed";

}

if (oRs.ReadData["Complete"].ToString() == "No")

{

lablecompleted = " Not Completed";

}

xmlData.AppendFormat("<set label='{0}' value='{1}' />", lablecompleted, oRs.ReadData["TotQ"].ToString());

//xmlData.AppendFormat("<set label='{0}' value='{1}' />", oRs.ReadData["Complete"].ToString(), oRs.ReadData["TotQ"].ToString());

}

oRs.ReadData.Close();

//Close chart element

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

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

return FusionCharts.RenderChart("../FusionCharts/Column3D.swf", "", xmlData.ToString(), "FactorySum", "400", "200", false, false);

}

saving chart dynamically as an image

cisco2103 — Tue, 06 May 2008 07:39:21 GMT

I am looking through this forum and not really finding what I need. I am trying to load a chart and my a user clicks export to PDF or Excel, save the chart as an image and then I can attach the image to a PDF or excel sheet. I can't imagine the only way to save an image is to right click save.

Any help on this would be great.

Thanks,

Cisco2103

Label Overlapping

ravishwaran — Thu, 28 Aug 2008 00:44:36 GMT

when i generate a report. the x-axis label ( Legends) are overlapping, can i roll the text vertical in these reports!

Thanks

saveAsImage Example

tnikola — Tue, 26 Aug 2008 22:14:24 GMT

Hello, I am new with FusionCharts 3.0.6 and I need a sample how to save pie3d chart as image. I have latest version of FusionCharts.js and FusionCharts.dll

Here is my code for building the chart:

Public Function doChart() As String

Dim str As String = "<chart imageSave='1' imageSaveURL='http://mydomain/a.aspx'>" & _

"<set label='test 1' value='23' />" & _

"<set label='test 2' value='33' />" & _

"<set label='test 3' value='75' />" & _

"<set label='test 4' value='34' />" & _

"</chart>"

Return FusionCharts.RenderChart("../charts/Pie3D.swf", "", str, "pie3dchart", 300, 300, False, True, True)

End Function

The problem is how to take image from the request of my this particular page a.aspx and save this image to temporary folder on the HDD.

Please provide some code or example(Code could be given on asp net, jsp or php)

Any help is appreciated

Thank you

Nicholas

FusionCharts Update Panel example #2 ASP.NET.AJAX

Sudipto Choudhury — Sat, 24 Nov 2007 00:19:33 GMT

Hi all,

here goes another FusionChats ASP.NET.AJAX sample using Update Panel.

Negotiate Positions of Labels / Values for Series MSColumn3DLineDY

AlexOlivier — Mon, 04 Aug 2008 21:56:32 GMT

Hi.

Is there a way to negotiate the positions of the series labels, so that they do not overwrite each other as per the screen capture?

Thank you for your assistance.

Alex

Secondary Y axis, Decimals. How to remove?

AlexOlivier — Tue, 29 Jul 2008 20:08:05 GMT

Hi there.

I am using the commercial version of fusion report. Im trying to suppres the secondary Y axis decimals.

Im using as follows:-

XElement chart = new XElement( "chart" );
XElement categories = new XElement ("categories");
XElement dataset = new XElement( "dataset" );
XElement dataset2 = new XElement( "dataset" );

chart.Add( new XAttribute( "PYAxisName", "RPM Peak" ) );
chart.Add( new XAttribute( "SYAxisName", "Event Count" ) );

chart.Add( new XAttribute( "decimals", "0" ) );

chart.Add( new XAttribute( "numberSuffix", " RPM " ) );
chart.Add( new XAttribute( "formatNumberScale", "0" ) );
chart.Add( new XAttribute( "formatNumber", "0" ) );
chart.Add( new XAttribute( "labelDisplay", "WRAP" ) );

chart.Add( new XAttribute( "adjustDiv", "0" ) );
chart.Add( new XAttribute( "numDivLines", "4" ) );

chart.Add( new XAttribute( "SYAxisAdjustDiv", "1" ) );
chart.Add( new XAttribute( "SYAxisValuesDecimals", "0" ) );
chart.Add( new XAttribute( "SYAxisMinValue", "1" ) );
chart.Add( new XAttribute( "SYAxisMaxValue", "50" ) );

chart.Add( new XAttribute( "slantLabels", "1" ) );
chart.Add( new XAttribute( "xAxisName", "Date" ) );
dataset.Add( new XAttribute( "seriesName", "RPM Peak" ) );
dataset2.Add( new XAttribute( "seriesName", "Event Count" ) );
dataset2.Add( new XAttribute( "parentYAxis", "S" ) );

chart.Add( categories );
chart.Add( dataset );
chart.Add( dataset2 );

Could someone please give me some advice.

Thanks
Alex

JavaScipt Error: EXPECTED ')' CODE: 0...Whats The Cause?

thoth — Sat, 02 Aug 2008 16:15:16 GMT

I have a FusionWidget Angular Gauge, I call it up in the code behind the same exact way I do for some of my Fusion Charts. The code below works and the gauge appears on the screen, however, internet explore still shows the little error icon in the bottom left corner of the web browser:

Line 1
Char 49
Error Expected ')'
Code: 0

I can't seem to figure out whats causing this so maybe someone can look at the relevent code and help:

[code]

private void MedianChartDefault()
{

//xmlData will be used to store the entire XML document generatedStringBuilder
StringBuilder xmlData = new StringBuilder();

//Generate the chart element
xmlData.Append("<chart lowerLimit='0' upperLimit='100' lowerLimitDisplay='OVER' upperLimitDisplay='UNDER' gaugeStartAngle='180' gaugeEndAngle='0' palette='1' numberSuffix='%25' tickValueDistance='20' showValue='1'>");
xmlData.Append("<colorRange>");
xmlData.Append("<color minValue='0' maxValue='50' code='FF654F'/>");
xmlData.Append("<color minValue='50' maxValue='90' code='F6BD0F'/>");
xmlData.Append("<color minValue='90' maxValue='100' code='8BBA00'/>");
xmlData.Append("</colorRange>");
xmlData.Append("<dials>");
xmlData.Append("<dial value='50' rearExtension='10'/>");
xmlData.Append("</dials>");
xmlData.Append("</chart>");

//outPut will store the HTML of the chart rendered as string
//when an ajax call is made we use RenderChartHTML methodstring
string outPut6 = "";

outPut6 = FusionCharts.RenderChartHTML("../../FusionCharts/AngularGauge.swf", "", xmlData.ToString(), "MedianHitGauge", "330", "200", false, false);

//Clear panel which will contain the chart
Panel6.Controls.Clear();

//Add Litaral control to Panel which adds the chart from outPut string
Panel6.Controls.Add(new LiteralControl(outPut6));
}

[/code]

I hope someone knows the answer. I've been working on it for going on 3 hours now and to no avail.

Fusion Charts and Widget Gauge...trying to program in code-behind..need a lilttle help.

thoth — Sat, 02 Aug 2008 11:14:51 GMT

Ive been using datareaders and strings to produce most of my charts in the code-behinds of my aspx pages. I'm getting the hange of if for the FusionCharts but I cant seem the do the same with a gauge.

[code]

private void MedianChart()

{

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

StringBuilder xmlData = new StringBuilder();

//Generate the chart element

xmlData.AppendFormat("<chart lowerLimit='0' upperLimit='100' lowerLimitDisplay='Bad' upperLimitDisplay='Good' gaugeStartAngle='180' gaugeEndAngle='0' palette='1' numberSuffix='%' tickValueDistance='20' showValue='1'>");
xmlData.Append("<colorRange>");
xmlData.Append("<color minValue='0' maxValue='75' code='FF654F'/>");
xmlData.Append("<color minValue='75' maxValue='90' code='F6BD0F'/>");
xmlData.Append("<color minValue='90' maxValue='100' code='8BBA00'/>");
xmlData.Append("</colorRange>");
xmlData.Append("<dials>");
xmlData.Append("<dial value='75' rearExtension='10'/>");
xmlData.Append("</dials>");
xmlData.Append("</chart>");

//outPut will store the HTML of the chart rendered as string

//when an ajax call is made we use RenderChartHTML method

string outPut2 = "";
outPut2 = FusionCharts.RenderChartHTML("../../FusionCharts/AngularGauge.swf", "", xmlData.ToString(), "MedianHitGauge", "330", "300", false, true);

//Clear panel which will contain the chart
Panel6.Controls.Clear();
//Add Litaral control to Panel which adds the chart from outPut string
Panel6.Controls.Add(new LiteralControl(outPut2));
}

[/code]

This doesnt work for the widget angular gauge. I get an error saying "invalid XML data". I have managed to use the data url method and set the url to an aspx page that generates XML but I what I really need to do is something similar to above that can be directly placed in the pages code-behind. Eventually, I want to add a data reader to pull the values for the dial from a database (based on a parameter that is passed to it). Are there any examples I can work with. There not really anything in the widget documentation on using c# and asp.net.

Any help would be great

Z Order Problems with Fusion Charts

Matt — Tue, 29 Jul 2008 14:28:25 GMT

I have rendered a web page with a chart. I have another 3rd party control on the page for selecting a date. It looks like a combo box, but when the button is pushed on the control a calendar opens.

The problem is that the Fusion Chart remains in front of the calendar. What can I do so that the calendar control opens in front of the chart?

--Thanks

How can I put multiple JavaScript functions in a single chart link?

thoth — Tue, 29 Jul 2008 23:13:27 GMT

I have a column3d chart and I want to place two or three JavaScript functions in a single link. (each column on the chart contains a link). Is this possible and if so how can it be done?

My current link looks like this:
string link = "javascript:updateChart(%26apos;" + oRs.ReadData["STRAIGHT"].ToString() + "%26apos;)";

I want the link to contain 2 or 3 functions, something like...

string link = "javascript:updateChart(%26apos;" + oRs.ReadData["STRAIGHT"].ToString() + "%26apos;)" AND javascript:updateStats(%26apos;" + oRs.ReadData["STRAIGHT"].ToString() + "%26apos;)";

Is it possible and what would the correct syntax be?