This is a migrated thread and some comments may be shown as answers.
Trouble binding Label field to Column
1 Answer 32 Views
This is a migrated thread and some comments may be shown as answers.
Nick
Top achievements
Rank 1
Nick asked on 08 Oct 2008, 05:15 PM
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

1 Answer, 1 is accepted

Sort by
0
Ves
Telerik team
answered on 09 Oct 2008, 07:04 AM
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.
Asked by
Nick
Top achievements
Rank 1
Answers by
Ves
Telerik team
Share this question
or