File manager - Edit - G:/PleskVhosts/fullscreenksa.com/Falafel.fullscreenksa.com/Financialreports/FinalReport.aspx
Back
<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage/Master_Page.Master" AutoEventWireup="true" CodeBehind="FinalReport.aspx.cs" Inherits="Erp_TotalReport.StoresReports.FinalReport" %> <%@ Register assembly="DevExpress.Web.v16.2, Version=16.2.6.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web" tagprefix="dx" %> <asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server"> <div class="panel panel-default"> <div class="panel-heading"> <div align="center" ><font size="4" color="#2196f3">Consolidated Financial Report</font></div> <div align="center" ></div> <div align="center" > <table class="modal-full-width"> <tr> <td align="left" width="15%"> <font size="4" color="#ff9933">Export Mode : </font></td> <td align="left"><dx:ASPxComboBox ID="txtexport" runat="server" Theme="SoftOrange" HorizontalAlign="Center" Font-Bold="True" Font-Size="Medium"> <Items> <dx:ListEditItem Text="None" Value="None" /> <dx:ListEditItem Text="Expanded" Value="Expanded" /> <dx:ListEditItem Text="All" Value="All" /> </Items> </dx:ASPxComboBox> </td> </tr> </table> </div> </div> </div> <div class="panel panel-default"> <div class="panel-heading"> <table class="modal-full-width"> <tr> <td align="center"> <div class="panel-heading"> <div align="center" ><font size="4" color="black">Total Sales Report</font></div> </div> </td> </tr> <tr> <td> <table class="modal-full-width"> <tr> <td> <dx:ASPxGridView ID="grdSales" runat="server" Width="100%" AutoGenerateColumns="False" DataSourceID="DSTotalSales" EnableTheming="True" Theme="Office2010Black" KeyFieldName="CompID"> <SettingsDetail ShowDetailRow="True" ExportMode="Expanded" /> <Templates> <DetailRow> <dx:ASPxGridView ID="grdSalesType" runat="server" AutoGenerateColumns="False" DataSourceID="DSTotalSalesTypes" EnableTheming="True" Theme="DevEx" Width="100%" OnBeforePerformDataSelect="grdSalesType_BeforePerformDataSelect"> <Settings ShowFooter="True" /> <SettingsDataSecurity AllowDelete="False" AllowEdit="False" AllowInsert="False" /> <Columns> <dx:GridViewDataTextColumn Caption="Invoice Type" FieldName="company" Name="company" VisibleIndex="0"> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle BackColor="#FFFFCC" Font-Bold="True" HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="January " FieldName="_1" Name="Jan" VisibleIndex="2"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="February " FieldName="_2" Name="February " VisibleIndex="3"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="March " FieldName="_3" Name="March " VisibleIndex="4"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="April " FieldName="_4" Name="April " VisibleIndex="5"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="May " FieldName="_5" Name="May " VisibleIndex="6"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="June " FieldName="_6" Name="June " VisibleIndex="7"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="July " FieldName="_7" Name="July " VisibleIndex="8"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="August " FieldName="_8" Name="August " VisibleIndex="9"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="September " FieldName="_9" Name="September " VisibleIndex="10"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="October " FieldName="_10" Name="October " VisibleIndex="11"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="November " FieldName="_11" Name="November " VisibleIndex="12"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="December " FieldName="_12" Name="December " VisibleIndex="13"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="NetSales" FieldName="total" Name="NetSales" VisibleIndex="14"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle BackColor="#CCFFFF" Font-Bold="True" ForeColor="#000066" HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> </Columns> <TotalSummary> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_1" ShowInColumn="Jan" SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_2" ShowInColumn="February " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_3" ShowInColumn="March " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_4" ShowInColumn="April " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_5" ShowInColumn="May " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_6" ShowInColumn="June " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_7" ShowInColumn="July " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_8" ShowInColumn="August " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_9" ShowInColumn="September " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_10" ShowInColumn="October " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_11" ShowInColumn="November " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_12" ShowInColumn="December " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="total" ShowInColumn="NetSales" SummaryType="Sum" /> </TotalSummary> </dx:ASPxGridView> </DetailRow> </Templates> <Settings ShowFooter="True" /> <SettingsDataSecurity AllowDelete="False" AllowEdit="False" AllowInsert="False" /> <Columns> <dx:GridViewDataTextColumn FieldName="CompID" Name="CompID" ShowInCustomizationForm="True" Visible="False" VisibleIndex="1"> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="BranchName" FieldName="company" Name="company" ShowInCustomizationForm="True" VisibleIndex="0"> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle BackColor="#CCFFFF" Font-Bold="True" HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="January " FieldName="_1" Name="Jan" ShowInCustomizationForm="True" VisibleIndex="2"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="February " FieldName="_2" Name="February " ShowInCustomizationForm="True" VisibleIndex="3"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="March " FieldName="_3" Name="March " ShowInCustomizationForm="True" VisibleIndex="4"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="April " FieldName="_4" Name="April " ShowInCustomizationForm="True" VisibleIndex="5"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="May " FieldName="_5" Name="May " ShowInCustomizationForm="True" VisibleIndex="6"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="June " FieldName="_6" Name="June " ShowInCustomizationForm="True" VisibleIndex="7"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="July " FieldName="_7" Name="July " ShowInCustomizationForm="True" VisibleIndex="8"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="August " FieldName="_8" Name="August " ShowInCustomizationForm="True" VisibleIndex="9"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="September " FieldName="_9" Name="September " ShowInCustomizationForm="True" VisibleIndex="10"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="October " FieldName="_10" Name="October " ShowInCustomizationForm="True" VisibleIndex="11"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="November " FieldName="_11" Name="November " ShowInCustomizationForm="True" VisibleIndex="12"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="December " FieldName="_12" Name="December " ShowInCustomizationForm="True" VisibleIndex="13"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="NetSales" FieldName="total" Name="NetSales" ShowInCustomizationForm="True" VisibleIndex="14"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle BackColor="#FFFFCC" Font-Bold="True" ForeColor="#000066" HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> </Columns> <TotalSummary> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_1" ShowInColumn="Jan" SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_2" ShowInColumn="February " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_3" ShowInColumn="March " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_4" ShowInColumn="April " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_5" ShowInColumn="May " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_6" ShowInColumn="June " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_7" ShowInColumn="July " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_8" ShowInColumn="August " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_9" ShowInColumn="September " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_10" ShowInColumn="October " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_11" ShowInColumn="November " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_12" ShowInColumn="December " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="total" ShowInColumn="NetSales" SummaryType="Sum" /> </TotalSummary> </dx:ASPxGridView> </td> <%-- <td valign="top" width="60"> <div ID="back_image"> <div ID="vertical-text" align="center" style="border: medium groove #800080"> المبيعات النقديه</div> </div> </td>--%> </tr> </table> </td> </tr> <tr> <td align="center"> <dx:ASPxGridViewExporter ID="ASPxGridViewExporter1" runat="server" GridViewID="grdSales"> </dx:ASPxGridViewExporter> <asp:ImageButton runat="server" ImageUrl="~/assets/export/Ex.png" Height="40px" Width="40px" ID="exl0" OnClick="exl_Click"></asp:ImageButton> <asp:SqlDataSource ID="DSTotalSales" runat="server" ConnectionString="<%$ ConnectionStrings:ErpCS %>" OnSelecting="SqlDataSource1_Selecting" SelectCommand="SalesAroundYear" SelectCommandType="StoredProcedure"> </asp:SqlDataSource> <asp:SqlDataSource ID="DSTotalSalesTypes" runat="server" ConnectionString="<%$ ConnectionStrings:ErpCS %>" OnSelecting="SqlDataSource1_Selecting" SelectCommand="SalesAroundYearByType" SelectCommandType="StoredProcedure"> <SelectParameters> <asp:SessionParameter Name="CompID" SessionField="CompID1" Type="Int32" /> </SelectParameters> </asp:SqlDataSource> </td> </tr> <tr> <td></td> </tr> <tr> <td style="height: 20px" align="center"> </td> </tr> <tr> <td style="height: 20px"><div align="center" ><font size="4" color="red">Net Sales Profit Report</font></div></td> </tr> <tr> <td style="height: 20px" align="center"> <dx:ASPxGridView ID="grdSales0" runat="server" Width="100%" AutoGenerateColumns="False" DataSourceID="DSTotalSalesProfit" EnableTheming="True" Theme="Office2010Black" KeyFieldName="CompID"> <SettingsDetail ShowDetailRow="True" /> <Templates> <DetailRow> <dx:ASPxGridView ID="grdSalesType0" runat="server" AutoGenerateColumns="False" DataSourceID="DSTotalSalesTypesprofit" EnableTheming="True" Theme="DevEx" Width="100%" OnBeforePerformDataSelect="grdSalesType0_BeforePerformDataSelect"> <Settings ShowFooter="True" /> <SettingsDataSecurity AllowDelete="False" AllowEdit="False" AllowInsert="False" /> <Columns> <dx:GridViewDataTextColumn Caption="Invoice Type" FieldName="company" Name="company" VisibleIndex="0"> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle BackColor="#FFFFCC" Font-Bold="True" HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="January " FieldName="_1" Name="Jan" VisibleIndex="2"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="February " FieldName="_2" Name="February " VisibleIndex="3"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="March " FieldName="_3" Name="March " VisibleIndex="4"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="April " FieldName="_4" Name="April " VisibleIndex="5"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="May " FieldName="_5" Name="May " VisibleIndex="6"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="June " FieldName="_6" Name="June " VisibleIndex="7"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="July " FieldName="_7" Name="July " VisibleIndex="8"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="August " FieldName="_8" Name="August " VisibleIndex="9"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="September " FieldName="_9" Name="September " VisibleIndex="10"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="October " FieldName="_10" Name="October " VisibleIndex="11"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="November " FieldName="_11" Name="November " VisibleIndex="12"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="December " FieldName="_12" Name="December " VisibleIndex="13"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="NetProfit" FieldName="total" Name="NetProfit" VisibleIndex="14"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle BackColor="#CCFFFF" Font-Bold="True" ForeColor="#000066" HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="Profit Percentage" FieldName="Pre" Name="Profit Percentage" VisibleIndex="15"> <PropertiesTextEdit DisplayFormatString="{0:P}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle BackColor="#FFCCCC" HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> </Columns> <TotalSummary> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_1" ShowInColumn="Jan" SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_2" ShowInColumn="February " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_3" ShowInColumn="March " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_4" ShowInColumn="April " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_5" ShowInColumn="May " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_6" ShowInColumn="June " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_7" ShowInColumn="July " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_8" ShowInColumn="August " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_9" ShowInColumn="September " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_10" ShowInColumn="October " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_11" ShowInColumn="November " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_12" ShowInColumn="December " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="total" ShowInColumn="NetProfit" SummaryType="Sum" /> </TotalSummary> </dx:ASPxGridView> </DetailRow> </Templates> <Settings ShowFooter="True" /> <SettingsDataSecurity AllowDelete="False" AllowEdit="False" AllowInsert="False" /> <Columns> <dx:GridViewDataTextColumn FieldName="CompID" Name="CompID" ShowInCustomizationForm="True" Visible="False" VisibleIndex="1"> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="BranchName" FieldName="company" Name="company" ShowInCustomizationForm="True" VisibleIndex="0"> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle BackColor="#CCFFFF" Font-Bold="True" HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="January " FieldName="_1" Name="Jan" ShowInCustomizationForm="True" VisibleIndex="2"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="February " FieldName="_2" Name="February " ShowInCustomizationForm="True" VisibleIndex="3"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="March " FieldName="_3" Name="March " ShowInCustomizationForm="True" VisibleIndex="4"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="April " FieldName="_4" Name="April " ShowInCustomizationForm="True" VisibleIndex="5"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="May " FieldName="_5" Name="May " ShowInCustomizationForm="True" VisibleIndex="6"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="June " FieldName="_6" Name="June " ShowInCustomizationForm="True" VisibleIndex="7"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="July " FieldName="_7" Name="July " ShowInCustomizationForm="True" VisibleIndex="8"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="August " FieldName="_8" Name="August " ShowInCustomizationForm="True" VisibleIndex="9"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="September " FieldName="_9" Name="September " ShowInCustomizationForm="True" VisibleIndex="10"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="October " FieldName="_10" Name="October " ShowInCustomizationForm="True" VisibleIndex="11"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="November " FieldName="_11" Name="November " ShowInCustomizationForm="True" VisibleIndex="12"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="December " FieldName="_12" Name="December " ShowInCustomizationForm="True" VisibleIndex="13"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="NetProfit" FieldName="total" Name="NetProfit" ShowInCustomizationForm="True" VisibleIndex="14"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle BackColor="#FFFFCC" Font-Bold="True" ForeColor="#000066" HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="Profit Percentage" FieldName="Pre" Name="Profit Percentage" VisibleIndex="15"> <PropertiesTextEdit DisplayFormatString="{0:P}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle BackColor="#FFCC99" Font-Bold="True" ForeColor="#000099" HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> </Columns> <TotalSummary> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_1" ShowInColumn="Jan" SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_2" ShowInColumn="February " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_3" ShowInColumn="March " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_4" ShowInColumn="April " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_5" ShowInColumn="May " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_6" ShowInColumn="June " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_7" ShowInColumn="July " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_8" ShowInColumn="August " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_9" ShowInColumn="September " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_10" ShowInColumn="October " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_11" ShowInColumn="November " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_12" ShowInColumn="December " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="total" ShowInColumn="NetProfit" SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:P}" FieldName="Pre" ShowInColumn="Pre" SummaryType="Average" /> </TotalSummary> </dx:ASPxGridView> </td> </tr> <tr> <td style="height: 20px" align="center"> <dx:ASPxGridViewExporter ID="ASPxGridViewExporter2" runat="server" GridViewID="grdSales0"> </dx:ASPxGridViewExporter> <asp:ImageButton runat="server" ImageUrl="~/assets/export/Ex.png" Height="40px" Width="40px" ID="exl" OnClick="exl_Click1"></asp:ImageButton> <asp:SqlDataSource ID="DSTotalSalesProfit" runat="server" ConnectionString="<%$ ConnectionStrings:ErpCS %>" OnSelecting="SqlDataSource1_Selecting" SelectCommand="SalesProfitAroundYear" SelectCommandType="StoredProcedure"> </asp:SqlDataSource> <asp:SqlDataSource ID="DSTotalSalesTypesprofit" runat="server" ConnectionString="<%$ ConnectionStrings:ErpCS %>" OnSelecting="SqlDataSource1_Selecting" SelectCommand="SalesProfitAroundYearByType" SelectCommandType="StoredProcedure"> <SelectParameters> <asp:SessionParameter Name="CompID" SessionField="CompID2" Type="Int32" /> </SelectParameters> </asp:SqlDataSource> </td> </tr> <%--<tr> <td style="height: 20px"> </td> </tr>--%> <tr> <td style="height: 20px" align="center"> </td> </tr> <tr> <td style="height: 20px" align="center"> <div align="center" ><font size="4" color="#2196f3">Total Purchases Report</font></div></td> </tr> <tr> <td style="height: 20px" align="center"> <dx:ASPxGridView ID="grdSales1" runat="server" Width="100%" AutoGenerateColumns="False" DataSourceID="DSTotalPurches" EnableTheming="True" Theme="Office2010Black" KeyFieldName="CompID"> <SettingsDetail ShowDetailRow="True" /> <Templates> <DetailRow> <dx:ASPxGridView ID="grdSalesType1" runat="server" AutoGenerateColumns="False" DataSourceID="DSTotalPurchesTypes" EnableTheming="True" Theme="DevEx" Width="100%" OnBeforePerformDataSelect="grdSalesType1_BeforePerformDataSelect"> <Settings ShowFooter="True" /> <SettingsDataSecurity AllowDelete="False" AllowEdit="False" AllowInsert="False" /> <Columns> <dx:GridViewDataTextColumn Caption="Invoice Type" FieldName="company" Name="company" VisibleIndex="0"> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle BackColor="#FFFFCC" Font-Bold="True" HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="January " FieldName="_1" Name="Jan" VisibleIndex="2"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="February " FieldName="_2" Name="February " VisibleIndex="3"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="March " FieldName="_3" Name="March " VisibleIndex="4"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="April " FieldName="_4" Name="April " VisibleIndex="5"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="May " FieldName="_5" Name="May " VisibleIndex="6"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="June " FieldName="_6" Name="June " VisibleIndex="7"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="July " FieldName="_7" Name="July " VisibleIndex="8"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="August " FieldName="_8" Name="August " VisibleIndex="9"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="September " FieldName="_9" Name="September " VisibleIndex="10"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="October " FieldName="_10" Name="October " VisibleIndex="11"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="November " FieldName="_11" Name="November " VisibleIndex="12"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="December " FieldName="_12" Name="December " VisibleIndex="13"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="NetPurchases" FieldName="total" Name="NetPurchases" VisibleIndex="14"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle BackColor="#CCFFFF" Font-Bold="True" ForeColor="#000066" HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> </Columns> <TotalSummary> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_1" ShowInColumn="Jan" SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_2" ShowInColumn="February " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_3" ShowInColumn="March " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_4" ShowInColumn="April " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_5" ShowInColumn="May " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_6" ShowInColumn="June " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_7" ShowInColumn="July " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_8" ShowInColumn="August " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_9" ShowInColumn="September " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_10" ShowInColumn="October " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_11" ShowInColumn="November " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_12" ShowInColumn="December " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="total" ShowInColumn="NetPurchases" SummaryType="Sum" /> </TotalSummary> </dx:ASPxGridView> </DetailRow> </Templates> <Settings ShowFooter="True" /> <SettingsDataSecurity AllowDelete="False" AllowEdit="False" AllowInsert="False" /> <Columns> <dx:GridViewDataTextColumn FieldName="CompID" Name="CompID" ShowInCustomizationForm="True" Visible="False" VisibleIndex="1"> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="BranchName" FieldName="company" Name="company" ShowInCustomizationForm="True" VisibleIndex="0"> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle BackColor="#CCFFFF" Font-Bold="True" HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="January " FieldName="_1" Name="Jan" ShowInCustomizationForm="True" VisibleIndex="2"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="February " FieldName="_2" Name="February " ShowInCustomizationForm="True" VisibleIndex="3"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="March " FieldName="_3" Name="March " ShowInCustomizationForm="True" VisibleIndex="4"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="April " FieldName="_4" Name="April " ShowInCustomizationForm="True" VisibleIndex="5"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="May " FieldName="_5" Name="May " ShowInCustomizationForm="True" VisibleIndex="6"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="June " FieldName="_6" Name="June " ShowInCustomizationForm="True" VisibleIndex="7"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="July " FieldName="_7" Name="July " ShowInCustomizationForm="True" VisibleIndex="8"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="August " FieldName="_8" Name="August " ShowInCustomizationForm="True" VisibleIndex="9"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="September " FieldName="_9" Name="September " ShowInCustomizationForm="True" VisibleIndex="10"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="October " FieldName="_10" Name="October " ShowInCustomizationForm="True" VisibleIndex="11"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="November " FieldName="_11" Name="November " ShowInCustomizationForm="True" VisibleIndex="12"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="December " FieldName="_12" Name="December " ShowInCustomizationForm="True" VisibleIndex="13"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="NetPurchases" FieldName="total" Name="NetPurchases" ShowInCustomizationForm="True" VisibleIndex="14"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle BackColor="#FFFFCC" Font-Bold="True" ForeColor="#000066" HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> </Columns> <TotalSummary> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_1" ShowInColumn="Jan" SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_2" ShowInColumn="February " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_3" ShowInColumn="March " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_4" ShowInColumn="April " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_5" ShowInColumn="May " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_6" ShowInColumn="June " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_7" ShowInColumn="July " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_8" ShowInColumn="August " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_9" ShowInColumn="September " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_10" ShowInColumn="October " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_11" ShowInColumn="November " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_12" ShowInColumn="December " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="total" ShowInColumn="NetPurchases" SummaryType="Sum" /> </TotalSummary> </dx:ASPxGridView> </td> </tr> <tr> <td style="height: 20px" align="center"> <dx:ASPxGridViewExporter ID="ASPxGridViewExporter3" runat="server" GridViewID="grdSales1"> </dx:ASPxGridViewExporter> <asp:ImageButton runat="server" ImageUrl="~/assets/export/Ex.png" Height="40px" Width="40px" ID="exl1" OnClick="exl1_Click"></asp:ImageButton> <asp:SqlDataSource ID="DSTotalPurches" runat="server" ConnectionString="<%$ ConnectionStrings:ErpCS %>" OnSelecting="SqlDataSource1_Selecting" SelectCommand="PurchasesAroundYear" SelectCommandType="StoredProcedure"> </asp:SqlDataSource> <asp:SqlDataSource ID="DSTotalPurchesTypes" runat="server" ConnectionString="<%$ ConnectionStrings:ErpCS %>" OnSelecting="SqlDataSource1_Selecting" SelectCommand="PurchasesAroundYearByType" SelectCommandType="StoredProcedure"> <SelectParameters> <asp:SessionParameter Name="CompID" SessionField="CompID3" Type="Int32" /> </SelectParameters> </asp:SqlDataSource> </td> </tr> <tr> <td style="height: 20px" align="center"> </td> </tr> <tr> <td style="height: 20px"><div align="center" ><font size="4" color="green">Suppliers Purchases Report</font></div></td> </tr> <tr> <td style="height: 20px" align="center"> <dx:ASPxGridView ID="grdSuppliresPurches" runat="server" Width="100%" AutoGenerateColumns="False" DataSourceID="DSTotalSuppliersPurches" EnableTheming="True" Theme="Office2010Black" KeyFieldName="CompID"> <SettingsPager Mode="ShowAllRecords"> </SettingsPager> <Settings ShowFooter="True" ShowFilterRow="True" ShowFilterRowMenu="True" ShowPreview="True" VerticalScrollBarMode="Visible" VerticalScrollBarStyle="Virtual" /> <SettingsDataSecurity AllowDelete="False" AllowEdit="False" AllowInsert="False" /> <SettingsSearchPanel Visible="True" /> <Columns> <dx:GridViewDataTextColumn FieldName="CompID" Name="CompID" ShowInCustomizationForm="True" Visible="False" VisibleIndex="2"> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="Supplier Name" FieldName="company" Name="company" ShowInCustomizationForm="True" VisibleIndex="1"> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle BackColor="#CCFFFF" Font-Bold="True" HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="January " FieldName="_1" Name="Jan" ShowInCustomizationForm="True" VisibleIndex="3"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="February " FieldName="_2" Name="February " ShowInCustomizationForm="True" VisibleIndex="4"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="March " FieldName="_3" Name="March " ShowInCustomizationForm="True" VisibleIndex="5"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="April " FieldName="_4" Name="April " ShowInCustomizationForm="True" VisibleIndex="6"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="May " FieldName="_5" Name="May " ShowInCustomizationForm="True" VisibleIndex="7"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="June " FieldName="_6" Name="June " ShowInCustomizationForm="True" VisibleIndex="8"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="July " FieldName="_7" Name="July " ShowInCustomizationForm="True" VisibleIndex="9"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="August " FieldName="_8" Name="August " ShowInCustomizationForm="True" VisibleIndex="10"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="September " FieldName="_9" Name="September " ShowInCustomizationForm="True" VisibleIndex="11"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="October " FieldName="_10" Name="October " ShowInCustomizationForm="True" VisibleIndex="12"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="November " FieldName="_11" Name="November " ShowInCustomizationForm="True" VisibleIndex="13"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="December " FieldName="_12" Name="December " ShowInCustomizationForm="True" VisibleIndex="14"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="NetPurchases" FieldName="total" Name="NetPurchases" ShowInCustomizationForm="True" VisibleIndex="15"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle BackColor="#FFFFCC" Font-Bold="True" ForeColor="#000066" HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="Supplier Balance" FieldName="Balance" Name="Balance" VisibleIndex="16"> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle BackColor="#CCFFCC" Font-Bold="True" Font-Overline="False" HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> </Columns> <TotalSummary> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_1" ShowInColumn="Jan" SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_2" ShowInColumn="February " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_3" ShowInColumn="March " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_4" ShowInColumn="April " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_5" ShowInColumn="May " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_6" ShowInColumn="June " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_7" ShowInColumn="July " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_8" ShowInColumn="August " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_9" ShowInColumn="September " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_10" ShowInColumn="October " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_11" ShowInColumn="November " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_12" ShowInColumn="December " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="total" ShowInColumn="NetPurchases" SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="Balance" ShowInColumn="Balance" SummaryType="Sum" /> </TotalSummary> </dx:ASPxGridView> </td> </tr> <tr> <td style="height: 20px" align="center"> <dx:ASPxGridViewExporter ID="ASPxGridViewExporter4" runat="server" GridViewID="grdSuppliresPurches"> </dx:ASPxGridViewExporter> <asp:ImageButton runat="server" ImageUrl="~/assets/export/Ex.png" Height="40px" Width="40px" ID="exl2" OnClick="exl2_Click"></asp:ImageButton> <asp:SqlDataSource ID="DSTotalSuppliersPurches" runat="server" ConnectionString="<%$ ConnectionStrings:ErpCS %>" OnSelecting="SqlDataSource1_Selecting" SelectCommand="SuppliersPurchasesAroundYear" SelectCommandType="StoredProcedure"> </asp:SqlDataSource> </td> </tr> <tr> <td style="height: 20px"> </td> </tr> <tr> <td style="height: 20px"><div align="center" ><font size="4" color="red">General & Administrative Expenses</font></div></td> </tr> <tr> <td style="height: 20px"> <dx:ASPxGridView ID="grdSales2" runat="server" Width="100%" AutoGenerateColumns="False" EnableTheming="True" Theme="Office2010Black" KeyFieldName="CompID" DataSourceID="DSTotalExpenses"> <SettingsDetail ShowDetailRow="True" /> <Templates> <DetailRow> <dx:ASPxGridView ID="grdSuppliresPurches" runat="server" AutoGenerateColumns="False" DataSourceID="DSTotalExpensesypes" EnableTheming="True" KeyFieldName="CompID" OnBeforePerformDataSelect="grdSuppliresPurches_BeforePerformDataSelect" Theme="Office2010Silver" Width="100%"> <SettingsPager Mode="ShowAllRecords"> </SettingsPager> <Settings ShowFilterRow="True" ShowFilterRowMenu="True" ShowFooter="True" ShowPreview="True" VerticalScrollBarMode="Visible" VerticalScrollBarStyle="Virtual" /> <SettingsDataSecurity AllowDelete="False" AllowEdit="False" AllowInsert="False" /> <SettingsSearchPanel Visible="True" /> <Columns> <dx:GridViewDataTextColumn Caption="Account No" FieldName="Account_No" Name="Account_No" ShowInCustomizationForm="True" VisibleIndex="2"> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="Account Name" FieldName="company" Name="company" ShowInCustomizationForm="True" VisibleIndex="1"> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle BackColor="#CCFFFF" Font-Bold="True" HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="January " FieldName="_1" Name="Jan" ShowInCustomizationForm="True" VisibleIndex="3"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="February " FieldName="_2" Name="February " ShowInCustomizationForm="True" VisibleIndex="4"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="March " FieldName="_3" Name="March " ShowInCustomizationForm="True" VisibleIndex="5"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="April " FieldName="_4" Name="April " ShowInCustomizationForm="True" VisibleIndex="6"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="May " FieldName="_5" Name="May " ShowInCustomizationForm="True" VisibleIndex="7"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="June " FieldName="_6" Name="June " ShowInCustomizationForm="True" VisibleIndex="8"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="July " FieldName="_7" Name="July " ShowInCustomizationForm="True" VisibleIndex="9"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="August " FieldName="_8" Name="August " ShowInCustomizationForm="True" VisibleIndex="10"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="September " FieldName="_9" Name="September " ShowInCustomizationForm="True" VisibleIndex="11"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="October " FieldName="_10" Name="October " ShowInCustomizationForm="True" VisibleIndex="12"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="November " FieldName="_11" Name="November " ShowInCustomizationForm="True" VisibleIndex="13"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="December " FieldName="_12" Name="December " ShowInCustomizationForm="True" VisibleIndex="14"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="Total Expenses" FieldName="total" Name="Total Expenses" ShowInCustomizationForm="True" VisibleIndex="15"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle BackColor="#FFFFCC" Font-Bold="True" ForeColor="#000066" HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> </Columns> <TotalSummary> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_1" ShowInColumn="Jan" SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_2" ShowInColumn="February " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_3" ShowInColumn="March " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_4" ShowInColumn="April " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_5" ShowInColumn="May " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_6" ShowInColumn="June " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_7" ShowInColumn="July " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_8" ShowInColumn="August " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_9" ShowInColumn="September " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_10" ShowInColumn="October " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_11" ShowInColumn="November " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_12" ShowInColumn="December " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="total" ShowInColumn="Total Expenses" SummaryType="Sum" /> </TotalSummary> </dx:ASPxGridView> </DetailRow> </Templates> <Settings ShowFooter="True" /> <SettingsDataSecurity AllowDelete="False" AllowEdit="False" AllowInsert="False" /> <Columns> <dx:GridViewDataTextColumn FieldName="CompID" Name="CompID" ShowInCustomizationForm="True" Visible="False" VisibleIndex="1"> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="BranchName" FieldName="company" Name="company" ShowInCustomizationForm="True" VisibleIndex="0"> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle BackColor="#CCFFFF" Font-Bold="True" HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="January " FieldName="_1" Name="Jan" ShowInCustomizationForm="True" VisibleIndex="2"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="February " FieldName="_2" Name="February " ShowInCustomizationForm="True" VisibleIndex="3"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="March " FieldName="_3" Name="March " ShowInCustomizationForm="True" VisibleIndex="4"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="April " FieldName="_4" Name="April " ShowInCustomizationForm="True" VisibleIndex="5"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="May " FieldName="_5" Name="May " ShowInCustomizationForm="True" VisibleIndex="6"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="June " FieldName="_6" Name="June " ShowInCustomizationForm="True" VisibleIndex="7"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="July " FieldName="_7" Name="July " ShowInCustomizationForm="True" VisibleIndex="8"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="August " FieldName="_8" Name="August " ShowInCustomizationForm="True" VisibleIndex="9"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="September " FieldName="_9" Name="September " ShowInCustomizationForm="True" VisibleIndex="10"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="October " FieldName="_10" Name="October " ShowInCustomizationForm="True" VisibleIndex="11"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="November " FieldName="_11" Name="November " ShowInCustomizationForm="True" VisibleIndex="12"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="December " FieldName="_12" Name="December " ShowInCustomizationForm="True" VisibleIndex="13"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="TotalExpenses" FieldName="total" Name="TotalExpenses" ShowInCustomizationForm="True" VisibleIndex="14"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle BackColor="#FFFFCC" Font-Bold="True" ForeColor="#000066" HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> </Columns> <TotalSummary> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_1" ShowInColumn="Jan" SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_2" ShowInColumn="February " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_3" ShowInColumn="March " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_4" ShowInColumn="April " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_5" ShowInColumn="May " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_6" ShowInColumn="June " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_7" ShowInColumn="July " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_8" ShowInColumn="August " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_9" ShowInColumn="September " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_10" ShowInColumn="October " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_11" ShowInColumn="November " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_12" ShowInColumn="December " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="total" ShowInColumn="TotalExpenses" SummaryType="Sum" /> </TotalSummary> </dx:ASPxGridView> </td> </tr> <tr> <td style="height: 20px" align="center"> <dx:ASPxGridViewExporter ID="ASPxGridViewExporter5" runat="server" GridViewID="grdSales2"> </dx:ASPxGridViewExporter> <asp:ImageButton runat="server" ImageUrl="~/assets/export/Ex.png" Height="40px" Width="40px" ID="exl3" OnClick="exl3_Click"></asp:ImageButton> <asp:SqlDataSource ID="DSTotalExpenses" runat="server" ConnectionString="<%$ ConnectionStrings:ErpCS %>" OnSelecting="SqlDataSource1_Selecting" SelectCommand="GenralAdministrativeExpenses" SelectCommandType="StoredProcedure"> </asp:SqlDataSource> </td> </tr> <tr> <td style="height: 20px"> <asp:SqlDataSource ID="DSTotalExpensesypes" runat="server" ConnectionString="<%$ ConnectionStrings:ErpCS %>" OnSelecting="SqlDataSource1_Selecting" SelectCommand="GenralAdministrativeExpensesByCompID" SelectCommandType="StoredProcedure"> <SelectParameters> <asp:SessionParameter Name="CompID" SessionField="CompID4" Type="Int32" /> </SelectParameters> </asp:SqlDataSource> </td> </tr> <tr> <td> </td> </tr> <tr> <td> </td> </tr> </table> </div> </div> </asp:Content>
| ver. 1.4 |
Github
|
.
| PHP 7.3.33 | Generation time: 0.09 |
proxy
|
phpinfo
|
Settings