Trouble binding Label field to Column

Thread is closed for posting
2 posts, 0 answers
  1. Nick
    Nick avatar
    3 posts
    Member since:
    Aug 2008

    Posted 08 Oct 2008 Link to this post

    I need to display what should be a pretty basic Pie Chart, but am having trouble with the Labels.

    The data is all coming from a SQL database, and it's only two columns.  The "Chart Label" is a pre-calculated Label that I'd like to use on each slice of the pie chart.  Occurences are, the values that the chart will be.... charting....

    --------------------------------------
    Occurrences     |    Chart Label
    --------------------------------------
    2                      |   Item Label 1 (2)
    5                      |   Item Label 2 (5)
    6                      |   Item Label 3 (6)
    2                      |   Item Label 4 (2)
    3                      |   Item Label 5 (3)

    So in my ASPX code, I have the following:
    <telerik:RadChart ID="RadChart1" runat="server" DataSourceID="SqlDataSource1" DefaultType="Pie" Skin="WebBlue" IntelligentLabelsEnabled="True" AutoTextWrap="True" AutoLayout="True" SeriesOrientation="Horizontal"
            <Series> 
                <telerik:ChartSeries DataLabelsColumn="ChartLabel" DataYColumn="Occurrences" Name="Occurrences" Type="Pie"
                    <Appearance> 
                        <LabelAppearance Distance="15"
                        </LabelAppearance> 
                        <Border Color="73, 86, 101" /> 
                        <TextAppearance TextProperties-Color="140, 140, 140"
                        </TextAppearance> 
                        <FillStyle FillType="ComplexGradient" MainColor="94, 117, 142"
                            <FillSettings> 
                                <ComplexGradient> 
                                    <telerik:GradientElement Color="94, 117, 142" /> 
                                    <telerik:GradientElement Color="116, 138, 162" Position="0.5" /> 
                                    <telerik:GradientElement Color="139, 160, 183" Position="1" /> 
                                </ComplexGradient> 
                            </FillSettings> 
                        </FillStyle> 
                    </Appearance> 
                </telerik:ChartSeries> 
            </Series> 
    ... 
    </telerik:RadChart> 
     
    ... 
     
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
            SelectCommand="SELECT COUNT(*) AS [Occurrences], incidentCode + ' (' + CAST(COUNT(*) AS nvarchar) + ')' AS [ChartLabel] FROM Incidents GROUP BY incidentCode"
    </asp:SqlDataSource> 
    ... 
     

    Note that I'm trying to bind the label text to the "Chart Label" field.  Am I going about this in the wrong way, because it is not working... instead, the label is displaying the value in the "Occurrences" field. 

    Even if I go into the Chart Wizard to set the Label field to "Chart Label" - nothing happens and the value is not saved.

    Thanks!

    Nick
  2. Ves
    Admin
    Ves avatar
    2926 posts

    Posted 09 Oct 2008 Link to this post

    Hi Nick,

    Your code seems to be correct, but you have hit an old bug in RadChart. It has already been fixed. Please, download the latest release and give it a try.

    Sincerely,
    Ves
    the Telerik team

    Check out Telerik Trainer, the state of the art learning tool for Telerik products.
Back to Top