| <telerik:RadMultiPage ID="RadMultiPage1" runat="server" Width="100%" SelectedIndex="0"> |
| <telerik:RadPageView ID="Pageview1" runat="server"> |
| <div> |
| <telerik:RadAjaxManager runat="server" ID="RadAjaxManager1"> |
| <AjaxSettings> |
| <telerik:AjaxSetting AjaxControlID="radGridControls"> |
| <UpdatedControls> |
| <telerik:AjaxUpdatedControl ControlID="radGridControls" /> |
| </UpdatedControls> |
| </telerik:AjaxSetting> |
| <telerik:AjaxSetting AjaxControlID="radGridPages"> |
| <UpdatedControls> |
| <telerik:AjaxUpdatedControl ControlID="radGridPages" /> |
| </UpdatedControls> |
| </telerik:AjaxSetting> |
| <telerik:AjaxSetting AjaxControlID="radGridCustomPages"> |
| <UpdatedControls> |
| <telerik:AjaxUpdatedControl ControlID="radGridCustomPages" /> |
| </UpdatedControls> |
| </telerik:AjaxSetting> |
| </AjaxSettings> |
| </telerik:RadAjaxManager> |
| <telerik:RadGrid ID="radGridControls" runat="server" GridLines="None" OnDetailTableDataBind="radGridControls_DetailTableDataBind" |
| AutoGenerateColumns="False" OnUpdateCommand="radGridControls_UpdateCommand" OnItemDataBound="radGridControls_ItemDataBound" |
| OnItemCommand="radGridControls_ItemCommand" OnColumnCreated="radGridControls_ColumnCreated" |
| EnableAJAX="True"> |
| <MasterTableView> |
| <Columns> |
| <telerik:GridBoundColumn Visible="False" DataField="ID" UniqueName="ID" /> |
| <telerik:GridBoundColumn HeaderText="Name" DataField="Name" UniqueName="Name" /> |
| </Columns> |
| <DetailTables> |
| <telerik:GridTableView runat="server" Name="ControlFields" EditMode="InPlace" Width="100%"> |
| <ExpandCollapseColumn Visible="False"> |
| <HeaderStyle Width="19px" /> |
| </ExpandCollapseColumn> |
| <RowIndicatorColumn Visible="False"> |
| <HeaderStyle Width="20px" /> |
| </RowIndicatorColumn> |
| <Columns> |
| <telerik:GridEditCommandColumn EditImageUrl="~/images/edit.gif" UpdateImageUrl="~/images/Save.gif" |
| CancelImageUrl="~/images/Delete.gif" ButtonType="ImageButton"> |
| </telerik:GridEditCommandColumn> |
| <telerik:GridBoundColumn ReadOnly="True" DataField="LocalizationId" Visible="False" |
| UniqueName="column"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn ReadOnly="True" DataField="Key" UniqueName="Name" HeaderText="Name"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn ReadOnly="True" DataField="Type" UniqueName="Control" HeaderText="Control"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn ReadOnly="True" DataField="Value" UniqueName="DefaultValue" |
| HeaderText="Value"> |
| </telerik:GridBoundColumn> |
| <telerik:GridTemplateColumn UniqueName="TranslateValue" HeaderText="Selected Value"> |
| <ItemStyle VerticalAlign="Top" /> |
| <ItemTemplate> |
| <asp:Label ID="lblValue" runat="server" Text=""></asp:Label> |
| </ItemTemplate> |
| <EditItemTemplate> |
| <asp:TextBox ID="txtValue" runat="server" Text="" Width="95%"></asp:TextBox> |
| </EditItemTemplate> |
| </telerik:GridTemplateColumn> |
| </Columns> |
| </telerik:GridTableView> |
| </DetailTables> |
| <ExpandCollapseColumn> |
| <HeaderStyle Width="19px" /> |
| </ExpandCollapseColumn> |
| <RowIndicatorColumn Visible="False"> |
| <HeaderStyle Width="20px" /> |
| </RowIndicatorColumn> |
| </MasterTableView> |
| </telerik:RadGrid> |
| </div> |
| </telerik:RadPageView> |
| <telerik:RadPageView ID="Pageview2" runat="server"> |
| <div> |
| </div> |
| </telerik:RadPageView> |
| <telerik:RadPageView runat="server" ID="PageView3"> |
| </telerik:RadPageView> |
| </telerik:RadMultiPage> |
| protected void RadGrid1_PreRender(object sender, EventArgs e) | |
| { | |
| RadGrid1.MasterTableView.SwapColumns(2, 2); | |
| } |
| <pages theme="Default" styleSheetTheme="Default"> |
| <controls> |
| <add tagPrefix="telerik" namespace="Telerik.Web.UI" assembly="Telerik.Web.UI"/> |
| <add tagPrefix="asp" namespace="System.Web.UI" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/> |
| <add tagPrefix="asp" namespace="System.Web.UI.WebControls" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/> |
| </controls> |
| </pages> |
| <httpHandlers> |
| <remove verb="*" path="*.asmx"/> |
| <add verb="*" path="*.asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/> |
| <add verb="*" path="*_AppService.axd" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/> |
| <add verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false"/> |
| <add path="Telerik.Web.UI.WebResource.axd" type="Telerik.Web.UI.WebResource" verb="*" validate="false"/> |
| <add path="Telerik.Web.UI.SpellCheckHandler.axd" type="Telerik.Web.UI.SpellCheckHandler" verb="*" validate="false"/> |
| <add path="Telerik.Web.UI.DialogHandler.aspx" type="Telerik.Web.UI.DialogHandler" verb="*" validate="false"/> |
| </httpHandlers> |
| <httpModules> |
| <add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/> |
| </httpModules> |
<asp:SqlDataSource ID="YellowBookPeriodSummaryData" runat="server" ConnectionString="<%$ ConnectionStrings:Intranet_DBConnectionString %>"
SelectCommand="SELECT TOP 100 PERCENT Year, Period, SUM(Qty) AS Quantity, SUM(Volume) AS [Vol Sq Ft], SUM(NetSales) AS [Net Value], SUM(StdCost) * - 1 AS Cost, SUM(Margin) AS [Margin ()], (SUM(NetSales) + SUM(StdCost)) / SUM(NetSales) * 100 AS [Margin (%)] FROM Tbl_Sales_Downloads WHERE (SalesCategory IN (@Category)) GROUP BY Year, Period HAVING (Year = @Year) AND (Period = @Period)">
<SelectParameters>
<asp:ControlParameter ControlID="CheckBoxList1" Name="Category" PropertyName="SelectedValue"
Type="String" />
<asp:ControlParameter ControlID="CbxYear" Name="Year" PropertyName="SelectedValue"
Type="Int64" />
<asp:ControlParameter ControlID="CbxPeriod" Name="Period" PropertyName="SelectedValue"
Type="Int64" />
</SelectParameters>
</asp:SqlDataSource>