﻿<?xml version="1.0" encoding="utf-8"?>
<inherited BaseReport="..\..\Reports\Base.frx" ScriptLanguage="CSharp" DoublePass="true" ReportInfo.Created="05/15/2013 14:45:40" ReportInfo.Modified="04/07/2015 14:55:48" ReportInfo.CreatorVersion="1.6.57.0">
  <ScriptText>using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Windows.Forms;
using System.Drawing;
using System.Data;
using FastReport;
using FastReport.Data;
using FastReport.Dialog;
using FastReport.Barcode;
using FastReport.Table;
using FastReport.Utils;

namespace FastReport
{
  public class ReportScript
  {

    
    
    private void Data1_AfterData(object sender, EventArgs e)
    {
      txtHeader.Text = &quot;Item Summary for - &quot; + Report.GetColumnValue(&quot;products.ProductCode&quot;);
      
      
      
    }

    private void Data2_AfterData(object sender, EventArgs e)
    {
      //Qty format         
      int decimalValue = Convert.ToInt32(Report.GetColumnValue(&quot;programs_config.QtyDecimalValue&quot;));
      decimal qtyVal = 0; 
      if (Decimal.TryParse(txtQtyPurchased.Text, out qtyVal))
      {
        txtQtyPurchased.Text = String.Format(&quot;{0:F&quot; + decimalValue + &quot;}&quot;, qtyVal);
        //MSChart1.Chart.ChartAreas.Item(&quot;Y VAL&quot;).AxisY.f
      }
    }
    

    private void Child2_AfterData(object sender, EventArgs e)
    {
      //Qty format         
      int decimalValue = Convert.ToInt32(Report.GetColumnValue(&quot;programs_config.QtyDecimalValue&quot;));
      decimal qtyVal = 0; 
      if (Decimal.TryParse(txtQtyAvailable.Text, out qtyVal))
      {
        txtQtyAvailable.Text = String.Format(&quot;{0:F&quot; + decimalValue + &quot;}&quot;, qtyVal);
      }
    }
  }
}
</ScriptText>
  <Dictionary>
    <MySqlDataConnection Name="Connection" ConnectionString="rijcmlqomabmqtwD7y3BaVO988XrjoBefSoHBX+xGSDpo0d+ot8yrzL17EhRvx7tW87ZuxDTsXprPmiOj80ATh2Aow+2w==">
      <TableDataSource Name="companies" DataType="System.Int32" Enabled="true" TableName="companies" SelectCommand="SELECT * FROM companies WHERE ID = @CompanyID">
        <Column Name="ID" DataType="System.UInt32"/>
        <Column Name="Name" DataType="System.String"/>
        <Column Name="Email" DataType="System.String"/>
        <Column Name="Address" DataType="System.String"/>
        <Column Name="RegNo" DataType="System.String"/>
        <Column Name="VATno" DataType="System.String"/>
        <Column Name="ContactNo" DataType="System.String"/>
        <Column Name="AltNo" DataType="System.String"/>
        <Column Name="FaxNo" DataType="System.String"/>
        <Column Name="CellNo" DataType="System.String"/>
        <Column Name="LogoPath" DataType="System.String"/>
        <Column Name="VATrate" DataType="System.String"/>
        <Column Name="InvoiceStylePath" DataType="System.String"/>
        <Column Name="InvoiceSize" DataType="System.String"/>
        <Column Name="BankingDetails" DataType="System.String"/>
        <Column Name="FinYearStartMonth" DataType="System.String"/>
        <Column Name="Scheme" DataType="System.String"/>
        <CommandParameter Name="CompanyID" DataType="254" Expression="[CompanyID]"/>
      </TableDataSource>
      <TableDataSource Name="items_sold" DataType="System.Int32" Enabled="true" TableName="items_sold" SelectCommand="DROP TABLE IF EXISTS item_sales; &#13;&#10;CREATE TABLE item_sales (&#13;&#10;TransType VARCHAR(45) NOT NULL,&#13;&#10;TransDate DATETIME NOT NULL default '2000-01-01 00:00',&#13;&#10;TransID INT(10) UNSIGNED NOT NULL DEFAULT 0,&#13;&#10;ClientID INT(10) UNSIGNED NOT NULL DEFAULT 0,&#13;&#10;ClientName VARCHAR(245) NOT NULL,&#13;&#10;CompanyID INT(10) UNSIGNED NOT NULL DEFAULT 0,&#13;&#10;TransTotalCost DECIMAL(10,2) NOT NULL DEFAULT 0.00,&#13;&#10;TransTotalExcl DECIMAL(10,2) NOT NULL DEFAULT 0.00,&#13;&#10;TransTotalIncl DECIMAL(10,2) NOT NULL DEFAULT 0.00,&#13;&#10;ProductID INT(10) UNSIGNED NOT NULL DEFAULT 0,&#13;&#10;ProductCode VARCHAR(45) NOT NULL,&#13;&#10;Description VARCHAR(450) NOT NULL,&#13;&#10;Qty DECIMAL(14,2) NOT NULL DEFAULT 0.00,&#13;&#10;IsProduct TINYINT(3) UNSIGNED NOT NULL DEFAULT 0,&#13;&#10;SalesRep VARCHAR(45) NOT NULL);&#13;&#10;INSERT INTO item_sales (TransType, TransDate, TransID, ClientID, ClientName, CompanyID, TransTotalCost, TransTotalExcl, TransTotalIncl, ProductID, ProductCode, Description, Qty, IsProduct, SalesRep) &#13;&#10;SELECT 'Cash Sale' AS TransType, `Date`, RelatedID, ClientID, '' AS ClientName, CompanyID, TotalCost, TotalSellingExcl, TotalSellingIncl, ProductID, ProductCode, Description, Qty, IsProduct, SalesRep FROM cash_sales_items &#13;&#10;WHERE CompanyID = @CompanyID AND ProductID  = @ProductID AND DATE_FORMAT(`Date`, '%Y%m') BETWEEN &#13;&#10;DATE_FORMAT(DATE_ADD(CONCAT(YEAR(CURDATE()), @StartMonth, '01'), INTERVAL -12 MONTH), '%Y%m') AND DATE_FORMAT(DATE_ADD(CONCAT(YEAR(CURDATE()), @StartMonth, '01'), INTERVAL 11 MONTH), '%Y%m');&#13;&#10;INSERT INTO item_sales (TransType,TransDate, TransID, ClientID, ClientName, CompanyID, TransTotalCost, TransTotalExcl, TransTotalIncl, ProductID, ProductCode, Description, Qty, IsProduct, SalesRep) &#13;&#10;SELECT 'Cash Refund' AS TransType, `Date`, RelatedID, ClientID, '' AS ClientName, CompanyID, TotalCost*-1, TotalSellingExcl*-1, TotalSellingIncl*-1, ProductID, ProductCode, Description, Qty*-1, IsProduct, SalesRep FROM cash_refunds_items &#13;&#10;WHERE CompanyID = @CompanyID AND ProductID  = @ProductID AND DATE_FORMAT(`Date`, '%Y%m') BETWEEN &#13;&#10;DATE_FORMAT(DATE_ADD(CONCAT(YEAR(CURDATE()), @StartMonth, '01'), INTERVAL -12 MONTH), '%Y%m') AND DATE_FORMAT(DATE_ADD(CONCAT(YEAR(CURDATE()), @StartMonth, '01'), INTERVAL 11 MONTH), '%Y%m');&#13;&#10;INSERT INTO item_sales (TransType,TransDate, TransID, ClientID, ClientName, CompanyID, TransTotalCost, TransTotalExcl, TransTotalIncl, ProductID, ProductCode, Description, Qty, IsProduct, SalesRep) &#13;&#10;SELECT 'Credit Sale' AS TransType, `Date`, RelatedID, ClientID, '' AS ClientName, CompanyID, TotalCost, TotalSellingExcl, TotalSellingIncl, ProductID, ProductCode, Description, Qty, IsProduct, SalesRep FROM credit_sales_items &#13;&#10;WHERE CompanyID = @CompanyID AND ProductID  = @ProductID AND DATE_FORMAT(`Date`, '%Y%m') BETWEEN &#13;&#10;DATE_FORMAT(DATE_ADD(CONCAT(YEAR(CURDATE()), @StartMonth, '01'), INTERVAL -12 MONTH), '%Y%m') AND DATE_FORMAT(DATE_ADD(CONCAT(YEAR(CURDATE()), @StartMonth, '01'), INTERVAL 11 MONTH), '%Y%m');&#13;&#10;INSERT INTO item_sales (TransType,TransDate, TransID, ClientID, ClientName, CompanyID, TransTotalCost, TransTotalExcl, TransTotalIncl, ProductID, ProductCode, Description, Qty, IsProduct, SalesRep) &#13;&#10;SELECT 'Credit Note' AS TransType, `Date`, RelatedID, ClientID, '' AS ClientName, CompanyID, TotalCost*-1, TotalSellingExcl*-1, TotalSellingIncl*-1, ProductID, ProductCode, Description, Qty*-1, IsProduct, SalesRep FROM credit_notes_items &#13;&#10;WHERE CompanyID = @CompanyID AND ProductID  = @ProductID AND DATE_FORMAT(`Date`, '%Y%m') BETWEEN &#13;&#10;DATE_FORMAT(DATE_ADD(CONCAT(YEAR(CURDATE()), @StartMonth, '01'), INTERVAL -12 MONTH), '%Y%m') AND DATE_FORMAT(DATE_ADD(CONCAT(YEAR(CURDATE()), @StartMonth, '01'), INTERVAL 11 MONTH), '%Y%m');&#13;&#10;UPDATE item_sales i, clients c SET i.ClientName = c.Name WHERE i.ClientID = c.ClientID AND (c.CompanyID = @CompanyID);&#13;&#10;SELECT DATE_FORMAT(TransDate,'%Y-%b') AS Period, SUM(Qty) AS QtySold FROM item_sales GROUP BY DATE_FORMAT(TransDate,'%Y-%m');&#13;&#10;&#13;&#10;">
        <Column Name="Period" DataType="System.String"/>
        <Column Name="QtySold" DataType="System.Decimal"/>
        <CommandParameter Name="ProductID" DataType="254" Expression="[ProductID]"/>
        <CommandParameter Name="CompanyID" DataType="254" Expression="[CompanyID]"/>
        <CommandParameter Name="StartMonth" DataType="254" Expression="[StartMonth]"/>
      </TableDataSource>
      <TableDataSource Name="programs_config" DataType="System.Int32" Enabled="true" TableName="programs_config" SelectCommand="SELECT QtyDecimalValue FROM programs_config WHERE CompanyID = @CompanyID">
        <Column Name="QtyDecimalValue" DataType="System.UInt32"/>
        <CommandParameter Name="CompanyID" DataType="254" Expression="[CompanyID]"/>
      </TableDataSource>
      <TableDataSource Name="products" DataType="System.Int32" Enabled="true" TableName="products" SelectCommand="SELECT * FROM products WHERE ProductID = @ProductID">
        <Column Name="ID" Enabled="false" DataType="System.UInt32"/>
        <Column Name="ProductCode" DataType="System.String"/>
        <Column Name="Description" DataType="System.String"/>
        <Column Name="CostPrice" DataType="System.Decimal"/>
        <Column Name="SellingPrice" DataType="System.Decimal"/>
        <Column Name="VatRate" Enabled="false" DataType="System.Decimal"/>
        <Column Name="SellingPriceIncl" DataType="System.Decimal"/>
        <Column Name="QtyAvailable" DataType="System.Decimal"/>
        <Column Name="IsProduct" DataType="System.Byte"/>
        <Column Name="CompanyID" Enabled="false" DataType="System.UInt32"/>
        <Column Name="ProductID" DataType="System.UInt32"/>
        <Column Name="Category" DataType="System.String"/>
        <Column Name="SubCategory" DataType="System.String"/>
        <Column Name="MinQty" DataType="System.Decimal"/>
        <Column Name="MaxQty" DataType="System.Decimal"/>
        <Column Name="CaseQty" DataType="System.Decimal"/>
        <Column Name="PromotionFromDate" DataType="System.DateTime"/>
        <Column Name="PromotionToDate" DataType="System.DateTime"/>
        <Column Name="MainSupplierID" DataType="System.UInt32"/>
        <CommandParameter Name="ProductID" DataType="254" Expression="[ProductID]"/>
      </TableDataSource>
      <TableDataSource Name="item_purchases" DataType="System.Int32" Enabled="true" TableName="item_purchases" SelectCommand="DROP TABLE IF EXISTS item_purchases; &#13;&#10;CREATE TABLE item_purchases&#13;&#10;(TransType VARCHAR(45) NOT NULL,&#13;&#10;TransDate DATETIME NOT NULL default '2000-01-01 00:00',&#13;&#10;TransID INT(10) UNSIGNED NOT NULL DEFAULT 0,&#13;&#10;SupplierID INT(10) UNSIGNED NOT NULL DEFAULT 0,&#13;&#10;SupplierName VARCHAR(245) NOT NULL,&#13;&#10;CompanyID INT(10) UNSIGNED NOT NULL DEFAULT 0,&#13;&#10;TransTotalExcl DECIMAL(10,2) NOT NULL DEFAULT 0.00,&#13;&#10;TransTotalIncl DECIMAL(10,2) NOT NULL DEFAULT 0.00,&#13;&#10;ProductID INT(10) UNSIGNED NOT NULL DEFAULT 0,&#13;&#10;ProductCode VARCHAR(45) NOT NULL,&#13;&#10;Description VARCHAR(450) NOT NULL,&#13;&#10;Qty DECIMAL(14,2) NOT NULL DEFAULT 0.00,&#13;&#10;IsProduct TINYINT(3) UNSIGNED NOT NULL DEFAULT 0,&#13;&#10;User VARCHAR(45) NOT NULL,&#13;&#10;InvoiceNo VARCHAR(45) NOT NULL);&#13;&#10;INSERT INTO item_purchases (TransType, TransDate, TransID, SupplierID, SupplierName, CompanyID, TransTotalExcl, TransTotalIncl, ProductID, ProductCode, Description, Qty, IsProduct, User) &#13;&#10;SELECT 'Cash Purchase' AS TransType, `Date`, RelatedID, SupplierID, '' AS SupplierName, CompanyID, TotalExcl, TotalIncl, ProductID, ProductCode, Description, Qty, IsProduct, User FROM cash_purchases_items &#13;&#10;WHERE CompanyID = @CompanyID AND ProductID  = @ProductID AND DATE_FORMAT(`Date`, '%Y%m') BETWEEN &#13;&#10;DATE_FORMAT(DATE_ADD(CONCAT(YEAR(CURDATE()), @StartMonth, '01'), INTERVAL -12 MONTH), '%Y%m') AND DATE_FORMAT(DATE_ADD(CONCAT(YEAR(CURDATE()), @StartMonth, '01'), INTERVAL 11 MONTH), '%Y%m');&#13;&#10;UPDATE item_purchases i, cash_purchases c SET i.InvoiceNo = c.InvoiceNo WHERE i.TransID = c.TransID AND (c.CompanyID = @CompanyID);&#13;&#10;INSERT INTO item_purchases (TransType,TransDate, TransID, SupplierID, SupplierName, CompanyID, TransTotalExcl, TransTotalIncl, ProductID, ProductCode, Description, Qty, IsProduct, User) &#13;&#10;SELECT 'Cash Return' AS TransType, `Date`, RelatedID, SupplierID, '' AS SupplierName, CompanyID, TotalExcl*-1, TotalIncl*-1, ProductID, ProductCode, Description, Qty*-1, IsProduct, User FROM cash_purchases_returns_items &#13;&#10;WHERE CompanyID = @CompanyID AND ProductID  = @ProductID AND DATE_FORMAT(`Date`, '%Y%m') BETWEEN &#13;&#10;DATE_FORMAT(DATE_ADD(CONCAT(YEAR(CURDATE()), @StartMonth, '01'), INTERVAL -12 MONTH), '%Y%m') AND DATE_FORMAT(DATE_ADD(CONCAT(YEAR(CURDATE()), @StartMonth, '01'), INTERVAL 11 MONTH), '%Y%m');&#13;&#10;INSERT INTO item_purchases (TransType,TransDate, TransID, SupplierID, SupplierName, CompanyID, TransTotalExcl, TransTotalIncl, ProductID, ProductCode, Description, Qty, IsProduct, User) &#13;&#10;SELECT 'Credit Purchase' AS TransType, `Date`, RelatedID, SupplierID, '' AS SupplierName, CompanyID, TotalExcl, TotalIncl, ProductID, ProductCode, Description, Qty, IsProduct, User FROM credit_purchases_items &#13;&#10;WHERE CompanyID = @CompanyID AND ProductID  = @ProductID AND DATE_FORMAT(`Date`, '%Y%m') BETWEEN &#13;&#10;DATE_FORMAT(DATE_ADD(CONCAT(YEAR(CURDATE()), @StartMonth, '01'), INTERVAL -12 MONTH), '%Y%m') AND DATE_FORMAT(DATE_ADD(CONCAT(YEAR(CURDATE()), @StartMonth, '01'), INTERVAL 11 MONTH), '%Y%m');&#13;&#10;UPDATE item_purchases i, credit_purchases c SET i.InvoiceNo = c.InvoiceNo WHERE i.TransID = c.TransID AND (c.CompanyID = @CompanyID);&#13;&#10;INSERT INTO item_purchases (TransType,TransDate, TransID, SupplierID, SupplierName, CompanyID, TransTotalExcl, TransTotalIncl, ProductID, ProductCode, Description, Qty, IsProduct, User) &#13;&#10;SELECT 'Debit Note' AS TransType, `Date`, RelatedID, SupplierID, '' AS SupplierName, CompanyID, TotalExcl*-1, TotalIncl*-1, ProductID, ProductCode, Description, Qty*-1, IsProduct, User FROM debit_notes_items &#13;&#10;WHERE CompanyID = @CompanyID AND ProductID  = @ProductID AND DATE_FORMAT(`Date`, '%Y%m') BETWEEN &#13;&#10;DATE_FORMAT(DATE_ADD(CONCAT(YEAR(CURDATE()), @StartMonth, '01'), INTERVAL -12 MONTH), '%Y%m') AND DATE_FORMAT(DATE_ADD(CONCAT(YEAR(CURDATE()), @StartMonth, '01'), INTERVAL 11 MONTH), '%Y%m');&#13;&#10;UPDATE item_purchases i, suppliers c SET i.SupplierName = c.Name WHERE i.SupplierID = c.SupplierID AND (c.CompanyID = @CompanyID);&#13;&#10;SELECT *, TransTotalExcl/Qty AS UnitExcl FROM item_purchases GROUP BY DATE_FORMAT(TransDate,'%Y-%m') ORDER BY TransDate DESC LIMIT 30;">
        <Column Name="TransType" DataType="System.String"/>
        <Column Name="TransDate" DataType="System.DateTime"/>
        <Column Name="TransID" DataType="System.UInt32"/>
        <Column Name="SupplierID" DataType="System.UInt32"/>
        <Column Name="SupplierName" DataType="System.String"/>
        <Column Name="CompanyID" DataType="System.UInt32"/>
        <Column Name="TransTotalExcl" DataType="System.Decimal"/>
        <Column Name="TransTotalIncl" DataType="System.Decimal"/>
        <Column Name="ProductID" DataType="System.UInt32"/>
        <Column Name="ProductCode" DataType="System.String"/>
        <Column Name="Description" DataType="System.String"/>
        <Column Name="Qty" DataType="System.Decimal"/>
        <Column Name="IsProduct" DataType="System.Byte"/>
        <Column Name="User" DataType="System.String"/>
        <Column Name="UnitExcl" DataType="System.Decimal"/>
        <Column Name="InvoiceNo" DataType="System.String"/>
        <CommandParameter Name="CompanyID" DataType="254" Expression="[CompanyID]"/>
        <CommandParameter Name="ProductID" DataType="254" Expression="[ProductID]"/>
        <CommandParameter Name="StartMonth" DataType="254" Expression="[StartMonth]"/>
      </TableDataSource>
    </MySqlDataConnection>
    <Parameter Name="CompanyID" DataType="System.Int32"/>
    <Parameter Name="StartMonth" DataType="System.String" Expression="&quot;'&quot; + [companies.FinYearStartMonth] + &quot;'&quot;"/>
    <Parameter Name="ProductID" DataType="System.String"/>
  </Dictionary>
  <inherited Name="Page1" Landscape="true" PaperWidth="297" PaperHeight="210" RawPaperSize="9" FirstPageSource="15" OtherPagesSource="15">
    <inherited Name="PageHeader1" Width="1047.06" Height="56.7">
      <inherited Name="_CompanyName"/>
      <ChildBand Name="Child1" ZOrder="-1" Top="60.7" Width="1047.06" Height="56.7">
        <TextObject Name="txtHeader" Left="37.8" Top="9.45" Width="689.85" Height="47.25" Text="Item Summary" Font="Segoe UI Light, 22pt" TextFill.Color="OliveDrab"/>
        <ChildBand Name="Child2" Top="121.4" Width="1047.06" Height="37.8" AfterDataEvent="Child2_AfterData">
          <TextObject Name="Text4" Left="283.5" Width="444.15" Height="37.8" Text="[products.Description]" Font="Segoe UI Light, 16pt" TextFill.Color="OliveDrab"/>
          <TextObject Name="txtQtyAvailable" Left="859.95" Top="9.45" Width="113.4" Height="18.9" Text="[products.QtyAvailable]" WordWrap="false" Trimming="EllipsisCharacter"/>
          <TextObject Name="Text81" Left="756" Top="9.45" Width="94.5" Height="18.9" Text="Qty Available" TextFill.Color="DimGray"/>
        </ChildBand>
      </ChildBand>
    </inherited>
    <DataBand Name="Data1" ZOrder="0" Top="163.2" Width="1047.06" Height="491.4" AfterDataEvent="Data1_AfterData">
      <MSChartObject Name="MSChart1" Left="37.8" Top="47.25" Width="1001.7" Height="444.15" DataSource="items_sold" ChartData="PENoYXJ0IFBhbGV0dGU9IlNlbWlUcmFuc3BhcmVudCIgU2l6ZT0iMjg4LCAyMzIiIEJhY2tHcmFkaWVudFN0eWxlPSJEaWFnb25hbExlZnQiIEJhY2tTZWNvbmRhcnlDb2xvcj0iV2hpdGUiIEJvcmRlcmxpbmVDb2xvcj0iU2lsdmVyIiBCb3JkZXJsaW5lRGFzaFN0eWxlPSJTb2xpZCI+DQogIDxTZXJpZXM+DQogICAgPFNlcmllcyBOYW1lPSJTZXJpZXMxIiBMZWdlbmQ9IkRlZmF1bHQiIFhWYWx1ZVR5cGU9IlN0cmluZyIgWVZhbHVlVHlwZT0iRG91YmxlIiBTaGFkb3dPZmZzZXQ9IjQiIFNoYWRvd0NvbG9yPSIxMjgsIDE5MiwgMTkyLCAxOTIiIENoYXJ0QXJlYT0iRGVmYXVsdCIgTGFiZWw9IiNWQUxZIiBDb2xvcj0iMTQyLCAzMCwgMTQ0LCAyNTUiIEJvcmRlckNvbG9yPSJUcmFuc3BhcmVudCIgQmFja1NlY29uZGFyeUNvbG9yPSJXaGl0ZSIgTGFiZWxGb3JlQ29sb3I9IkdyYXkiIEN1c3RvbVByb3BlcnRpZXM9IkRyYXdpbmdTdHlsZT1DeWxpbmRlciI+DQogICAgICA8UG9pbnRzPg0KICAgICAgICA8RGF0YVBvaW50IFlWYWx1ZXM9IjEiIEF4aXNMYWJlbD0iQSIgLz4NCiAgICAgICAgPERhdGFQb2ludCBZVmFsdWVzPSIyIiBBeGlzTGFiZWw9IkIiIC8+DQogICAgICA8L1BvaW50cz4NCiAgICA8L1Nlcmllcz4NCiAgPC9TZXJpZXM+DQogIDxMZWdlbmRzPg0KICAgIDxMZWdlbmQgTmFtZT0iRGVmYXVsdCIgRW5hYmxlZD0iRmFsc2UiPg0KICAgIDwvTGVnZW5kPg0KICA8L0xlZ2VuZHM+DQogIDxUaXRsZXM+DQogICAgPFRpdGxlIE5hbWU9IlRpdGxlMSIgVmlzaWJsZT0iRmFsc2UiPg0KICAgIDwvVGl0bGU+DQogIDwvVGl0bGVzPg0KICA8Q2hhcnRBcmVhcz4NCiAgICA8Q2hhcnRBcmVhIE5hbWU9IkRlZmF1bHQiIFNoYWRvd0NvbG9yPSIxMjgsIDEwNSwgMTA1LCAxMDUiPg0KICAgICAgPEF4aXNZPg0KICAgICAgICA8TWFqb3JHcmlkIExpbmVDb2xvcj0iNjQsIDIyMCwgMjIwLCAyMjAiIC8+DQogICAgICAgIDxNaW5vckdyaWQgTGluZUNvbG9yPSJXaGl0ZVNtb2tlIiBMaW5lRGFzaFN0eWxlPSJEb3QiIEVuYWJsZWQ9IlRydWUiIC8+DQogICAgICAgIDxMYWJlbFN0eWxlIEZvcm1hdD0iIyAjIyMgIyMwLjAwIiAvPg0KICAgICAgPC9BeGlzWT4NCiAgICAgIDxBeGlzWCBJbnRlcnZhbD0iMSI+DQogICAgICAgIDxNYWpvckdyaWQgTGluZUNvbG9yPSI2NCwgMjExLCAyMTEsIDIxMSIgRW5hYmxlZD0iRmFsc2UiIC8+DQogICAgICAgIDxNaW5vckdyaWQgTGluZUNvbG9yPSJXaGl0ZVNtb2tlIiBMaW5lRGFzaFN0eWxlPSJEb3QiIC8+DQogICAgICA8L0F4aXNYPg0KICAgICAgPEF4aXNYMj4NCiAgICAgICAgPE1ham9yR3JpZCBMaW5lQ29sb3I9IjY0LCA2NCwgNjQsIDY0IiAvPg0KICAgICAgPC9BeGlzWDI+DQogICAgICA8QXhpc1kyPg0KICAgICAgICA8TWFqb3JHcmlkIExpbmVDb2xvcj0iNjQsIDY0LCA2NCwgNjQiIC8+DQogICAgICA8L0F4aXNZMj4NCiAgICA8L0NoYXJ0QXJlYT4NCiAgPC9DaGFydEFyZWFzPg0KPC9DaGFydD4=">
        <MSChartSeries Name="Series1" XValue="[items_sold.Period]" YValue1="[items_sold.QtySold]"/>
      </MSChartObject>
      <TextObject Name="Text83" Left="28.35" Width="689.85" Height="56.7" Text="Sales (Qty's)" Font="Segoe UI Light, 22pt" TextFill.Color="DarkGoldenrod"/>
      <ChildBand Name="Child3" Top="658.6" Width="1047.06" Height="37.8" StartNewPage="true" FirstRowStartsNewPage="true">
        <SubreportObject Name="Subreport1" Left="18.9" Top="9.45" Width="94.5" Height="18.9" ReportPage="Page2"/>
      </ChildBand>
    </DataBand>
    <ReportSummaryBand Name="ReportSummary1" ZOrder="-1" Top="700.4" Width="1047.06" Height="37.8"/>
    <PageFooterBand Name="PageFooter1" ZOrder="-1" Top="742.2" Width="1047.06" Height="18.9">
      <TextObject Name="Text36" Left="9.45" Width="94.5" Height="18.9" Text="[PageNofM]" Font="Arial, 9pt" TextFill.Color="DimGray"/>
      <TextObject Name="Text79" Left="765.45" Width="94.5" Height="18.9" Text="Print Date:" HorzAlign="Right" TextFill.Color="DimGray"/>
      <TextObject Name="Text78" Left="869.4" Width="160.65" Height="18.9" Text="[Date]" TextFill.Color="DimGray"/>
    </PageFooterBand>
  </inherited>
  <ReportPage Name="Page2" ZOrder="1" Landscape="true" PaperWidth="297" PaperHeight="210" RawPaperSize="9" FirstPageSource="15" OtherPagesSource="15">
    <DataBand Name="Data2" Top="98.5" Width="1047.06" Height="18.9" AfterDataEvent="Data2_AfterData" DataSource="item_purchases">
      <TextObject Name="Text1" Left="37.8" Width="170.1" Height="18.9" Text="[item_purchases.TransType]"/>
      <TextObject Name="Text3" Left="217.35" Width="94.5" Height="18.9" Text="[item_purchases.TransDate]" Format="Custom" Format.Format="yyyy-MM-dd"/>
      <TextObject Name="Text6" Left="425.25" Width="283.5" Height="18.9" Text="[item_purchases.SupplierName]"/>
      <TextObject Name="txtQtyPurchased" Left="718.2" Width="94.5" Height="18.9" Text="[item_purchases.Qty]" HorzAlign="Right" WordWrap="false" Trimming="EllipsisCharacter"/>
      <TextObject Name="Text8" Left="926.1" Width="94.5" Height="18.9" Text="[item_purchases.UnitExcl]" Format="Number" Format.UseLocale="false" Format.DecimalDigits="2" Format.DecimalSeparator="." Format.GroupSeparator=" " Format.NegativePattern="1" HorzAlign="Right" WordWrap="false" Trimming="EllipsisCharacter"/>
      <TextObject Name="Text10" Left="321.3" Width="94.5" Height="18.9" Text="[item_purchases.TransID]"/>
      <TextObject Name="Text12" Left="822.15" Width="94.5" Height="18.9" Text="[item_purchases.InvoiceNo]"/>
      <DataHeaderBand Name="DataHeader1" Width="1047.06" Height="94.5">
        <ShapeObject Name="Shape5" Left="28.35" Top="56.7" Width="1001.7" Height="37.8" Border.Color="Transparent" Fill.Color="WhiteSmoke" Shape="RoundRectangle"/>
        <TextObject Name="Text2" Left="37.8" Top="66.15" Width="94.5" Height="18.9" Text="Trans Type"/>
        <TextObject Name="Text5" Left="217.35" Top="66.15" Width="94.5" Height="18.9" Text="Trans Date"/>
        <TextObject Name="Text7" Left="425.25" Top="66.15" Width="179.55" Height="18.9" Text="From Supplier"/>
        <TextObject Name="Text9" Left="708.75" Top="66.15" Width="103.95" Height="18.9" Text="Qty purchased" HorzAlign="Right"/>
        <TextObject Name="Text11" Left="926.1" Top="66.15" Width="94.5" Height="18.9" Text="Unit Excl." HorzAlign="Right"/>
        <TextObject Name="Text82" Left="28.35" Top="9.45" Width="689.85" Height="56.7" Text="Purchases" Font="Segoe UI Light, 22pt" TextFill.Color="DarkGoldenrod"/>
        <TextObject Name="Text84" Left="321.3" Top="66.15" Width="94.5" Height="18.9" Text="Document #"/>
        <TextObject Name="Text85" Left="822.15" Top="66.15" Width="94.5" Height="18.9" Text="Invoice #"/>
      </DataHeaderBand>
      <DataFooterBand Name="DataFooter1" Top="121.4" Width="1047.06" Height="37.8"/>
    </DataBand>
  </ReportPage>
</inherited>
