Bob Tiamsic

Members
  • Content count

    6
  • Joined

  • Last visited

Posts posted by Bob Tiamsic


  1. 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);
    
    

  2. Here it is, Im using C# to build string for DataString.

     

    assume that you have a database

     StringBuilder strXMLChart = new StringBuilder();
                    strXMLChart.Append("<chart caption='Summation of Ovetime Hours per Month' subcaption='Figure in Hours' showBorder='0' xAxisName='Month' yAxisName='Overtime in Hours' showValues='1' formatNumberScale='0' showBorder='1' canvasPadding='30'>");
    
    
                    for (i = 0; i <= dt.Rows.Count - 1; i++)
                    {
                        strXMLChart.AppendFormat("<set label='{0}' value='{1}'  link='P-detailsPopUp,width=600,height=300,left=300,top=100,toolbar=no,scrollbars=no,resizable=yes-{2}'/>", dt.Rows[i]["MonthName_"].ToString(), dt.Rows[i]["TotalOTHrs"].ToString(), ("../ChartsDrillDown/AdminOvertimeDetails.aspx?Id=" + empno + "-" + dt.Rows[i]["MonthName_"].ToString()));
                    }
                    strXMLChart.Append("<styles><definition>");
                    strXMLChart.Append("<style name='lineBevel' type='bevel' distance='3' /><style name='myShadow' type='lineshadow' angle='45' distance='5'/>");
                    strXMLChart.Append("<style name='linetoolTip' type='font' font='Verdana' size='12' bold='1' />");
                    strXMLChart.Append("</definition><application>");
                    strXMLChart.Append("<apply toObject='Dataplot' styles='lineBevel,lineshadow' /><apply toObject='ToolTip' styles='lineTooltip' />");
                    strXMLChart.Append("</application></styles>");
                    strXMLChart.Append("</chart>");
                    Literal1.Text = FusionCharts.RenderChart("../FusionCharts/Line.swf", "", strXMLChart.ToString(), "chart1", "690", "300", false, true);