<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
</div>
<asp:Chart ID="Chart1" runat="server" DataSourceID="SqlDataSource1"
Width="643px">
<series>
<asp:Series Name="Series1" XValueMember="ObjSub"
YValueMembers="Period_04" ChartType="Line" YValuesPerPoint="2" >
</asp:Series>
<asp:Series Name="Series2" XValueMember="ObjSub"
YValueMembers="Period_05" ChartType="Line" YValuesPerPoint="2">
</asp:Series>
</series>
<chartareas>
<asp:ChartArea Name="ChartArea1">
</asp:ChartArea>
</chartareas>
</asp:Chart>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:BUDGETReports %>"
SelectCommand="SELECT top 5 [ObjSub], sum([Period_04]) Period_04, sum([Period_01]) Period_05 FROM [BudgetData] where fy=14 and co=1 group by objsub">
</asp:SqlDataSource>
</form>
</body>
</html>
No comments:
Post a Comment