RadChart inside DataList Problem

[CS Teacher]

Hi,
I'm building a survey management tool and I'm now in the phase of showing the survey result. Some of the survey questions have the matrix type, so I'm using a column radchart control within a datalist to show their results and the radchart consists of multiple series.
My aspx looks like the following

<asp:DataList ID="ResultDataList" runat="server" Width="100%" >
<ItemTemplate>
<table width="100%">
<tr>
<td>
<%#Eval("Question")%>
    <asp:HiddenField ID="QuestionIDField" runat="server" Value='<%#Eval("QuestionID") %>' />
</td>
</tr>
<tr>
<td >
<telerik:RadChart ID="RadChart1" runat="server" Width="500" Height="250" ChartTitle-Visible="false" CreateImageMap="false"   DataGroupColumn="ColumnText">

                                 <PlotArea>
                        <XAxis DataLabelsColumn="OptionText">
                </XAxis>

               </PlotArea>


                            </telerik:RadChart>
</td>
</tr>
<tr><td><hr /></td></tr>
</table>
</ItemTemplate>
</asp:DataList>
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:SurveyDBConnectionString %>"
            SelectCommand="select optiontext,text,isnull((select COUNT(resultid)  from SurveyResult where OptionID=SurveyOption.OptionID and ColumnID=ColumnOption.ColumnOptionID   group by OptionID ),'0') as RespondentCount from SurveyOption,ColumnOption  where  SurveyOption.QuestionID=ColumnOption.QuestionID and SurveyOption.QuestionID= @QID">
            <SelectParameters>
                <asp:Parameter Name="QID" />
            </SelectParameters>
        </asp:SqlDataSource>

and my code behind page looks like this:

 Protected Sub ResultDataList_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DataListItemEventArgs) Handles ResultDataList.ItemDataBound
        If (Not e Is Nothing) Then
            Dim chart As RadChart = CType(e.Item.FindControl("RadChart1"), RadChart)
            Dim h As HiddenField = CType(e.Item.FindControl("QuestionIDField"), HiddenField)

            SqlDataSource2.SelectParameters(0).DefaultValue = h.Value
            chart.DataSource = SqlDataSource2.Select(DataSourceSelectArguments.Empty)
            chart.Legend.Appearance.GroupNameFormat = "ColumnText"
           chart.DataBind()
        End If
    End Sub

my problems are the following:
1) The legend take the value from XAxis DataLabelsColumn "OptionText" and I wanna show the series value "ColumnText"
2) the labels above the sries showed the YAxis value "RespondentCount" and I wanna show series value "ColumnText"

Any help please...
Thank's in advance..

[CS Teacher]

you will find in the attachment shot for my result:

[CS Teacher]

Telerik Developer Please any help in my problem????

[CS Teacher]

I need your help here ....:(

[Ves]

Hello,

You can wire the ItemDataBound event and update each ChartSeriesItem individually. Set e.SeriesItem.Label.TextBlock.Text with the string you need to appear as label  and e.SeriesItem.Name with the string that you need to appear in the legend. You can find this task discussed in details in this blog post.

Best regards,
Ves
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[CS Teacher]

Sorry but that didn't help can u give an example of a radchart within datalist.....

[Ves]

Hi,

I have attached a small example, showing how to configure and format labels in RadChart within a DataList.

Greetings,
Ves
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.