Hi
Please help me.
I am using evaluation chart.
It says "no data to display"
Public Function GetFactorySummayChartHtml() As String
Dim xmlData As New StringBuilder()
xmlData.Append("<chart caption='Website Ranking for the year 2006' xAxisName='Month' yAxisName='Revenue' showValues='0' numberPrefix='$'>")
Dim factoryQuery As String = "exec test "
Dim oRs As New DbConn(factoryQuery)
While oRs.ReadData.Read()
xmlData.Append("<set label='" & oRs.ReadData("SectionName").ToString() & "' value='" & oRs.ReadData("Rank").ToString & "' />")
End While
oRs.ReadData.Close()
xmlData.Append("</chart>")
Return FusionCharts.RenderChart("../Charts/InverseMSColumn2D.swf", "", xmlData.ToString(), "FactorySum", "600", "250", False, False)
End Functionits not working. its working with column2D chart. But not with InverseMSColumn2D. But its working with your xml data not mine,
But when i try your xml data than its working . Why is that.xml data below. Why is that.
<chart caption='Business Results 2005 v 2006' xAxisName='Month' yAxisName='Revenue' showValues='0' numberPrefix='$'><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <categories><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <category label='Jan' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <category label='Feb' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <category label='Mar' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <category label='Apr' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <category label='May' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <category label='Jun' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <category label='Jul' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <category label='Aug' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <category label='Sep' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <category label='Oct' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <category label='Nov' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <category label='Dec' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> </categories><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <dataset seriesName='2006'><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='27400' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='29800'/><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='25800' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='26800' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='29600' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='32600' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='31800' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='36700' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='29700' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='31900' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='34800' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='24800' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> </dataset><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <dataset seriesName='2005'><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='10000'/><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='11500'/><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='12500'/><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='15000'/><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='11000' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='9800' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='11800' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='19700' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='21700' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='21900' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='22900' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='20800' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> </dataset><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <trendlines><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <line startValue='26000' color='91C728' displayValue='Target' showOnTop='1'/><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> </trendlines><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <styles><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <definition><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <style name='CanvasAnim' type='animation' param='_xScale' start='0' duration='1' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> </definition><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <application><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <apply toObject='Canvas' styles='CanvasAnim' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> </application> <br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> </styles><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"></chart>