This is a migrated thread and some comments may be shown as answers.

Binding ScatterLineSeries Directly to SQLDataSource

3 Answers 138 Views

Chart (HTML5)

This is a migrated thread and some comments may be shown as answers.

Tyler asked on 09 Aug 2016, 06:25 PM

Hey everyone,

Thanks for reading. I have a RadHtmlChart and a SqlDataSource. The SqlDataSource is attached to a Stored Procedure that returns 2 columns: a date, and an amount.

I simply want to plot the dates along the X and the amount along the Y, however I'm having some difficulty achieving this. Please see the code below:

<telerik:RadScriptManager runat="server" ID="RadScriptManager1" />

<telerik:RadAjaxPanel runat="server" ID="RadAjaxPanel1" LoadingPanelID="RadAjaxLoadingPanel1">

<telerik:RadHtmlChart runat="server" ID="RadHtmlChart1" DataSourceID="sdsDeclineReport" Width="600px" Height="400px">

<PlotArea>

<Series>

<telerik:ScatterLineSeries DataFieldX="date" DataFieldY="amount">

<TooltipsAppearance Color="White" DataFormatString="{0:MM/dd}"></TooltipsAppearance>

<LabelsAppearance Visible="false">

</LabelsAppearance>

</telerik:ScatterLineSeries>

</Series>

</PlotArea>

<Legend>

<Appearance Visible="false"></Appearance>

</Legend>

<ChartTitle Text="Declines"></ChartTitle>

</telerik:RadHtmlChart>

</telerik:RadAjaxPanel>

The result looks like this:

http://i.imgur.com/TGtKTNxl.png

The "Amount" column ranges from 0-20, and the dates go from 2016-01-01 to 2017-01-01. Can someone point me in the right direction here in regards to the lack of any data, as well as where I went wrong with the axes? Thanks

Binding ScatterLineSeries Directly to SQLDataSource

3 Answers, 1 is accepted