Jul 31, 2012, 7:41 AM
Problem with Ext.Net Chart - Column
Hello together,
I want to use the Ext.Net Column Chart. I want to fill the chart with a stored procedure... But nothing happens.. my Chart don't show anything..
Did I forgot anything? Make something wrong?
I hope you can help me..
SourceCode Panel + Chart:
I want to use the Ext.Net Column Chart. I want to fill the chart with a stored procedure... But nothing happens.. my Chart don't show anything..
Did I forgot anything? Make something wrong?
I hope you can help me..
SourceCode Panel + Chart:
<!-- Grafik - VerloreneCalls -->
<ext:Panel ID="pnlGrafikVerloreneCalls"
runat="server"
Title="<center>Calls</center>"
StyleSpec="position:absolute;"
Frame="True"
Html=""
Floating="true"
Width="1010px"
Height = "550px"
Cls="my-panel"
X="605"
Y="475" BodyStyle="background-color:FFFAFA" Header="true" TitleAlign="Center" Draggable="true">
<Items>
<ext:Chart
ID="CallsChart"
runat="server"
Shadow="true"
StyleSpec="background:#fff"
Animate="true">
<Store>
<ext:Store ID="Store1"
runat="server"
DataSourceID="CallsDataSource"
AutoDataBind="true">
<Parameters>
<ext:StoreParameter Value="USER" Name="account" />
<ext:StoreParameter Value="07/07/2012" Name="Date" />
</Parameters>
<Model>
<ext:Model ID="Model1" runat="server">
<Fields>
<ext:ModelField Name="Name" />
<ext:ModelField Name="Data1" />
</Fields>
</ext:Model>
</Model>
</ext:Store>
</Store>
<Axes>
<ext:NumericAxis
Fields="Data1"
Grid="true"
Title="Number of Hits"
Minimum="0">
<Label>
<Renderer Handler="return Ext.util.Format.number(value, '0,0');" />
</Label>
</ext:NumericAxis>
<ext:CategoryAxis
Position="Bottom"
Fields="Name"
Title="Month of the Year"
/>
</Axes>
<Series>
<ext:ColumnSeries
Axis="Left"
Highlight="true"
XField="Name"
YField="Data1">
<Tips ID="Tips1" runat="server" TrackMouse="true" Width="140" Height="28">
<Renderer Handler="this.setTitle(storeItem.get('Name') + ': ' + storeItem.get('Data1'));" />
</Tips>
<Label
Display="InsideEnd"
Field="Data1"
Orientation="Horizontal"
Color="#333"
TextAnchor="middle" >
<Renderer Handler="return Ext.util.Format.number(value, '0');" />
</Label>
</ext:ColumnSeries>
</Series>
</ext:Chart>
</Items>
<DraggableConfig ID="DraggableConfig8" runat="server">
<CustomConfig>
<ext:ConfigItem Name="insertProxy" Value="false" Mode="Raw" />
</CustomConfig>
</DraggableConfig>
</ext:Panel>
SourceCode SQL Datasource: <asp:SqlDataSource ID="CallsDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:BusinessIntelligenceConnectionString %>"
SelectCommand="Reporting__InboundCallsByWorkgroup"
SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:Parameter DefaultValue="USER" Name="account" Type="String" />
<asp:Parameter DefaultValue="07/07/2012" Name="Date" Type="DateTime" />
</SelectParameters>
</asp:SqlDataSource>