Search the Community

Hey there! Im using fusionCharts to show some information of my database. But when I try to generate ASP.NET chart (RenderChartHTML) in IE, my title (caption) and subtitled (SubCaption) are being presented with "..." at the end, without displaying the full sentence. But when I generate in Google Chrome, everything is OK. I need to generate these graphics in IE, I can not use another browser. This is FusionCharts.RenderChartHTML method: public static string RenderChartHTML(string chartSWF, string strURL, string strXML, string chartId, string chartWidth, string chartHeight, bool debugMode) { StringBuilder builder = new StringBuilder(); string str = string.Empty; if (strXML.Length == 0) { str = string.Format("&chartWidth={0}&chartHeight={1}&debugMode={2}&dataURL={3}", new object[] { chartWidth, chartHeight, boolToNum(debugMode), strURL }); } else { str = string.Format("&chartWidth={0}&chartHeight={1}&debugMode={2}&dataXML={3}", new object[] { chartWidth, chartHeight, boolToNum(debugMode), strXML }); } builder.AppendFormat("<!-- START Code Block for Chart {0} -->" + Environment.NewLine, chartId); builder.AppendFormat("<object classid=\"clsid:d27cdb6e-ae6d-11cf-96b8-444553540000\" codebase=\"http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=8,0,0,0\"width=\"{0}\" height=\"{1}\" name=\"{2}\">" + Environment.NewLine, chartWidth, chartHeight, chartId); builder.Append("<param name=\"allowScriptAccess\" value=\"always\" />" + Environment.NewLine); builder.AppendFormat("<param name=\"movie\" value=\"{0}\"/>" + Environment.NewLine, chartSWF); builder.AppendFormat("<param name=\"FlashVars\" value=\"{0}\" />" + Environment.NewLine, str); builder.Append("<param name=\"quality\" value=\"high\" />" + Environment.NewLine); builder.Append("<param name=\"wmode\" value=\"transparent\" />" + Environment.NewLine); builder.AppendFormat("<embed src=\"{0}\" FlashVars=\"{1}\" quality=\"high\" width=\"{2}\" height=\"{3}\" name=\"{4}\" allowScriptAccess=\"always\" type=\"application/x-shockwave-flash\" pluginspage=\"http://www.macromedia.com/go/getflashplayer\"/>" + Environment.NewLine, new object[] { chartSWF, str, chartWidth, chartHeight, chartId }); builder.Append("</object>" + Environment.NewLine); builder.AppendFormat("<!-- END Code Block for Chart {0} -->" + Environment.NewLine, chartId); return builder.ToString(); } } The chart image is attached. Anyway, thanks.

Hello. Is it possible when we click on a data plot in bar chart, it will execute a C# function? How can we do this? please help me with my problem.

Hello. Is there a different syntax for inserting a new line in tooltext of dataplot? Im using ASP.Net and C# for building my DATA String for my chart. When I insert {br} in tooltext for creating new line, it gives me an error that the string is in invalid format. Please help me with this. Thanks in advance and have a good day! StringBuilder xmlString = new StringBuilder(); xmlString.AppendFormat("<chart caption='Summary of Late by Employee for the month of {1}' subcaption='Employee: {0}' showValues='1' xAxisName='Month' yAxisName = 'Late (in Minutes)' showBorder='0' bgColor='66a4ff,FFFFFF' bgRatio='60,40' canvasPadding='30' PYAxisMinValue='0' vDivlineColor='c2c2c2' rotateValues='1' anchorRadius='5' valuePadding='5' labelDisplay='rotate' slantLabels='1'>", dt.Rows[0]["EmpName"].ToString(), MonthName_); for (i = 0; i <= count - 1; i++) { xmlString.AppendFormat("<set label='{0}' value='{1}' tooltext='{0}{br} Time In: {2}' />", dt.Rows[i]["DateF_"].ToString(), dt.Rows[i]["LateMinutes"].ToString(), dt.Rows[i]["TimeInF"].ToString()); } //xmlString.Append("<set label='Sample' value='3' tooltext='name: Bob {br} Age:21' />"); xmlString.Append("<styles><definition>"); xmlString.Append("<style name='captions' type='font' font='Arial' size='12' bold='1' />"); xmlString.Append("<style name='axisLabelBevel' type='bevel' angle='0' />"); xmlString.Append("<style name='valuesAnim' type='animation' param='_y' start='$canvasStartY' duration='1' />"); xmlString.Append("<style name='acnhorBevel' type='bevel' distance='2' />"); xmlString.Append("</definition><application>"); xmlString.Append("<apply toObject='Caption' styles='captions' />"); xmlString.Append("<apply toObject='subcaption' styles='captions' />"); xmlString.Append("<apply toObject='xAxisName' styles='captions' />"); xmlString.Append("<apply toObject='yAxisName' styles='captions' />"); xmlString.Append("<apply toObject='Datavalues' styles='valuesAnim' />"); xmlString.Append("<apply toObject='anchors' styles='acnhorBevel' />"); xmlString.Append("</application></styles>"); xmlString.Append("</chart>"); ltrDrillDown.Text = FusionCharts.RenderChart("../FusionCharts/Column3D.swf", "", xmlString.ToString(), "LateDetailsChart", "600", "300", false, true);

Hi, I created a multi series stacked bar chart with ease. Now i need to show manual values for show sum attribute. Is this possible? If not possible post me some work around to achieve the same. attached my chart image. Suresh

Hi there, I have several posts in this forum asking about tactical questions, however with time I learned that I have to start with a question about the best practice as I am not aware about FusionCharts capabilities with regard to the development technology I am using. My solution and used technology: I am developing Visual Studio C# 2010 project to create a report web page that has several buttons (each present a country) and a graph (column 3d showing countries versus balance) in the middle of the page. Each time the user clicks on one of the buttons, the graph filter changes and display the new results accordingly. The page loads the country buttons dynamically using C# code that connects with an Oracle DB (11g on Unix) to get the list of countries. The Country balance is also in Oracle DB. So basically I have a web page with a main table that looks like the following: <%@ Assembly Name="$SharePoint.Project.AssemblyFullName$" %> <%@ Assembly Name="Microsoft.Web.CommandUI, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> <%@ Register Tagprefix="SharePoint" Namespace="Microsoft.SharePoint.WebControls" Assembly="Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> <%@ Register Tagprefix="Utilities" Namespace="Microsoft.SharePoint.Utilities" Assembly="Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> <%@ Register Tagprefix="asp" Namespace="System.Web.UI" Assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" %> <%@ Import Namespace="Microsoft.SharePoint" %> <%@ Register Tagprefix="WebPartPages" Namespace="Microsoft.SharePoint.WebPartPages" Assembly="Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> <%@ Control Language="C#" AutoEventWireup="true" CodeBehind="360MainScreenUserControl.ascx.cs" Inherits="_360Report._360MainScreen._360MainScreenUserControl" %> <%@ Register assembly="System.Web.DataVisualization, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" namespace="System.Web.UI.DataVisualization.Charting" tagprefix="asp" %> <asp:TableRow ID="TableRow2" runat="server"> <asp:TableCell> <asp:Table ID="CountrySection" runat="server"> </asp:Table> </asp:TableCell> <asp:TableCell> <asp:Table ID="GraphSection" runat="server"> </asp:Table> </asp:TableCell> <asp:TableCell> <asp:ListBox ID="lbAgreement" runat="server" onselectedindexchanged="lbAgreement_SelectedIndexChanged" onprerender="lbAgreement_PreRender" AutoPostBack="True" ForeColor="#006F5F" Width="180" Height="750" Font-Names="Calibri" Font-Size="14" > </asp:ListBox> </asp:TableCell> </asp:TableRow> each section (table) is filled by C# code that connects to Oracle. What I need is to use FusionChart to fill the GraphSection (show the graph in a table cell) and make it sensitive to user selection (when choosing any of the buttons that are dynamically created and shown in the CountrySection in the above code). Now my questions are: 1- What is the best practice or recommended approach? - Do I use the SharePoint collaboration to create my chart as a web part and then use it from the code to show this web part in the cell in GraphSection? - Or I should only work with FusionChart XT for .net and create and render to chart into the cell in GraphSection using C# code? 2- Following one of the practices above, how can I pass the parameters to the chart and refresh it? 3- The most important question: I am facing difficulties as I am trying both solutions and found no complete example. Can you please lead me to one. Many thanks,