Change label in pie chart for bound SqlDataSource

[Chad Steinhauser]

I am using a Pie Chart from Telerik Reporting Q2 2010 and would like to change the numeric values it used to create the pie slice with a percentage concatenated with an identifier.  The datasource is a SqlDataSource and I'm using the ItemDataBound event to set various items.

There are two columns in the datasource a TotalCost and Product column.  

I've tried setting a variety of different properties but to no avail.

Chad

Private Sub Chart1_ItemDataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles Chart1.ItemDataBound

       Chart1.Series(0).DataYColumn = "TOTALCOST"

        Chart1.Series(0).DataXColumn = "PRODUCT"

        Chart1.Series(0).DataLabelsColumn = "PRODUCT"

    End Sub

    Private Sub Chart1_ItemDataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles Chart1.ItemDataBound

        Chart1.Series(0).DataYColumn = "TOTALCOST"

        Chart1.Series(0).DataXColumn = "PRODUCT"

        Chart1.Series(0).DataLabelsColumn = "PRODUCT"

    End Sub

    Private Sub Chart1_ItemDataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles Chart1.ItemDataBound

        Chart1.Series(0).DataYColumn = "TOTALCOST"

        Chart1.Series(0).DataXColumn = "PRODUCT"

        Chart1.Series(0).DataLabelsColumn = "PRODUCT"

    End Sub

    Private Sub Chart1_ItemDataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles Chart1.ItemDataBound

        Chart1.Series(0).DataYColumn = "TOTALCOST"

        Chart1.Series(0).DataXColumn = "PRODUCT"

        Chart1.Series(0).DataLabelsColumn = "PRODUCT"

    End Sub

    Private Sub Chart1_ItemDataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles Chart1.ItemDataBound

        Chart1.Series(0).DataYColumn = "TOTALCOST"

        Chart1.Series(0).DataXColumn = "PRODUCT"

        Chart1.Series(0).DataLabelsColumn = "PRODUCT"

    E

Private

 Chart1.Series(0).DataYColumn = "TOTALCOST"

        Chart1.Series(0).DataXColumn = "PRODUCT"

        Chart1.Series(0).DataLabelsColumn = "PRODUCT"

Sub Chart1_ItemDataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles Chart1.ItemDataBound

        Chart1.Series(0).DataYColumn = "TOTALCOST"

        Chart1.Series(0).DataXColumn = "PRODUCT"

        Chart1.Series(0).DataLabelsColumn = "PRODUCT"

    End Sub

Private Sub Chart1_ItemDataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles Chart1.ItemDataBound

        Chart1.Series(0).DataYColumn = "TOTALCOST"

        Chart1.Series(0).DataXColumn = "PRODUCT"

        Chart1.Series(0).DataLabelsColumn = "PRODUCT"

    End Sub

Private Sub Chart1_ItemDataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles Chart1.ItemDataBound

        Chart1.Series(0).DataYColumn = "TOTALCOST"

        Chart1.Series(0).DataXColumn = "PRODUCT"

        Chart1.Series(0).DataLabelsColumn = "PRODUCT"

    End Su

Private Sub Chart1_ItemDataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles Chart1.ItemDataBound

        Chart1.Series(0).DataYColumn = "TOTALCOST"

        Chart1.Series(0).DataXColumn = "PRODUCT"

        Chart1.Series(0).DataLabelsColumn = "PRODUCT"

    End Sub

Private Sub Chart1_ItemDataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles Chart1.ItemDataBound

        Chart1.Series(0).DataYColumn = "TOTALCOST"

        Chart1.Series(0).DataXColumn = "PRODUCT"

        Chart1.Series(0).DataLabelsColumn = "PRODUCT"

    End Sub

[Peter]

Hi Chad Steinhauser,

Our suggestion is to add Calculated Fields to your SqlDataSource to return a percentage concatenated with an identifier. Then you can set the calculated field to the Series.DataLabelsCoumn property.

Greetings,
Peter
the Telerik team