<?xml version="1.0" encoding="utf-8" standalone="no"?>
<TfrxReport Version="4.13.1" DotMatrixReport="False" IniFile="\Software\Fast Reports" PreviewOptions.Buttons="4095" PreviewOptions.Zoom="1" PrintOptions.Printer="Varsayılan" PrintOptions.PrintOnSheet="0" ReportOptions.CreateDate="41415.9784123032" ReportOptions.Description.Text="" ReportOptions.LastChange="41416.0819208333" ScriptLanguage="PascalScript" ScriptText.Text="begin&#13;&#10;&#13;&#10;end." PropData="044C65667403900103546F700380010844617461736574730101142D00000020446174615365743D226B61726C696C696B512220446174615365744E616D653D224B61726CC4B16CC4B16B220000095661726961626C65730100055374796C650100">
  <TfrxDataPage Name="Data" Height="1000" Left="0" Top="0" Width="1000">
    <TFrxFDQuery Name="karlilikQ" UserName="Karlılık" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="Set DateFormat DMY&#13;&#10;  &#13;&#10;Declare @T1 DateTime, @T2 DateTime&#13;&#10;&#13;&#10;Set @T1 = :Tarih1            &#13;&#10;Set @T2 = :Tarih2  &#13;&#10;&#13;&#10;Select A.*, A.SATISTUTARI - A.MALIYETTUTARI AS KARTUTARI, &#13;&#10;  CASE WHEN ISNULL(MALIYET, 0) = 0 THEN 100 ELSE Round(100.00 * (A.FIYATI - A.MALIYET) / MALIYET, 2) END AS KARYUZDE from&#13;&#10;(&#13;&#10;Select&#13;&#10;  B.TARIH, B.BELGENO, S.STOKKODU, BC.BARKOD, S.CINSI, H.MIKTARI, BC.BIRIMADI, S.MALIYET,&#13;&#10;  S.MALIYET * H.MIKTARI AS MALIYETTUTARI, H.FIYATI, H.FIYATI * H.MIKTARI AS SATISTUTARI&#13;&#10;From&#13;&#10;TBLSATFATHAREKET H&#13;&#10;LEFT OUTER JOIN TBLSATFATBASLIK B ON B.KARTNO = H.FATURAID&#13;&#10;LEFT OUTER JOIN TBLSTOKLAR S ON H.STOKID = S.KARTNO&#13;&#10;LEFT OUTER JOIN TBLBIRIMLEREX BC ON B.KARTNO = H.BIRIMID&#13;&#10;WHERE B.TARIH &#62;= @T1 AND B.TARIH &#60;= @T2&#13;&#10;) AS A&#13;&#10;ORDER BY A.TARIH&#13;&#10;-- Select * from TBLSATFATHAREKET  " PropData="05704C65667402680470546F70025C0A506172616D657465727301010622204E616D653D22546172696831222044617461547970653D226674537472696E672200010622204E616D653D22546172696832222044617461547970653D226674537472696E67220000"/>
  </TfrxDataPage>
  <TfrxReportPage Name="Page1" Orientation="poLandscape" PaperWidth="297" PaperHeight="210" PaperSize="9" LeftMargin="5" RightMargin="5" TopMargin="10" BottomMargin="10" ColumnWidth="0" ColumnPositions.Text="" HGuides.Text="" VGuides.Text="">
    <TfrxReportTitle Name="ReportTitle1" Height="60.47248" Left="0" Top="18.89765" Width="1084.72511">
      <TfrxMemoView Name="Memo1" Left="226.7718" Top="0" Width="642.5201" Height="34.01577" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-16" Font.Name="Arial" Font.Style="1" Frame.Typ="15" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="21.05.2013 ile 22.05.2013 Arası Stok Bazlı Maliyet Karlılık Raporu"/>
      <TfrxPictureView Name="Picture1" Left="7.55906" Top="0" Width="211.65368" Height="60.47248" ShowHint="False" Picture.PropData="[encoded data, 200306 characters]" HightQuality="False" Transparent="False" TransparentColor="16777215"/>
    </TfrxReportTitle>
    <TfrxPageFooter Name="PageFooter1" Height="45.35436" Left="0" Top="298.58287" Width="1084.72511">
      <TfrxLineView Name="Line2" Left="7.55906" Top="7.55906" Width="1065.82746" Height="0" ShowHint="False" Frame.Typ="4"/>
      <TfrxMemoView Name="Memo3" Left="15.11812" Top="18.89765" Width="340.1577" Height="18.89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="ARDA POS Programı ile [Date] Tarihinde yazdırılmıştır."/>
      <TfrxMemoView Name="Memo4" Left="956.22109" Top="18.89765" Width="117.16543" Height="18.89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="Sayfa: [Page] / [TotalPages#]"/>
    </TfrxPageFooter>
    <TfrxMasterData Name="MasterData1" Height="15.11812" Left="0" Top="185.19697" Width="1084.72511" ColumnWidth="0" ColumnGap="0" DataSet="karlilikQ" DataSetName="Karlılık" RowCount="0">
      <TfrxMemoView Name="Memo20" Left="3.77953" Top="0" Width="1069.60699" Height="15.11812" ShowHint="False" Font.Charset="1" Font.Color="-2147483640" Font.Height="-13" Font.Name="Arial" Font.Style="0" Highlight.Font.Charset="1" Highlight.Font.Color="255" Highlight.Font.Height="-13" Highlight.Font.Name="Arial" Highlight.Font.Style="0" Highlight.Color="13750737" Highlight.Condition="&#60;Line&#62; Mod 2" ParentFont="False" Text=""/>
      <TfrxMemoView Name="Memo2" Left="3.77953" Top="0" Width="68.03154" Height="15.11812" ShowHint="False" DataField="TARIH" DataSet="karlilikQ" DataSetName="Karlılık" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[Karlılık.&#34;TARIH&#34;]"/>
      <TfrxMemoView Name="KarllkBELGENO" Left="75.5906" Top="0" Width="102.04731" Height="15.11812" ShowHint="False" DataField="BELGENO" DataSet="karlilikQ" DataSetName="Karlılık" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[Karlılık.&#34;BELGENO&#34;]"/>
      <TfrxMemoView Name="KarllkSTOKKODU" Left="181.41744" Top="0" Width="83.14966" Height="15.11812" ShowHint="False" DataField="STOKKODU" DataSet="karlilikQ" DataSetName="Karlılık" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[Karlılık.&#34;STOKKODU&#34;]"/>
      <TfrxMemoView Name="Memo5" Left="355.27582" Top="0" Width="245.66945" Height="15.11812" ShowHint="False" DataField="CINSI" DataSet="karlilikQ" DataSetName="Karlılık" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[Karlılık.&#34;CINSI&#34;]"/>
      <TfrxMemoView Name="KarllkBIRIMADI" Left="653.85869" Top="0" Width="45.35436" Height="15.11812" ShowHint="False" DataField="BIRIMADI" DataSet="karlilikQ" DataSetName="Karlılık" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Karlılık.&#34;BIRIMADI&#34;]"/>
      <TfrxMemoView Name="KarllkMALIYET" Left="702.99258" Top="0" Width="49.13389" Height="15.11812" ShowHint="False" DataSet="karlilikQ" DataSetName="Karlılık" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Karlılık.&#34;MALIYET&#34;]"/>
      <TfrxMemoView Name="KarllkMALIYETTUTARI" Left="755.906" Top="0" Width="71.81107" Height="15.11812" ShowHint="False" DataField="MALIYETTUTARI" DataSet="karlilikQ" DataSetName="Karlılık" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Karlılık.&#34;MALIYETTUTARI&#34;]"/>
      <TfrxMemoView Name="KarllkFIYATI" Left="832.71707" Top="0" Width="60.47248" Height="15.11812" ShowHint="False" DataField="FIYATI" DataSet="karlilikQ" DataSetName="Karlılık" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Karlılık.&#34;FIYATI&#34;]"/>
      <TfrxMemoView Name="KarllkSATISTUTARI" Left="898.96908" Top="0" Width="64.25201" Height="15.11812" ShowHint="False" DataField="SATISTUTARI" DataSet="karlilikQ" DataSetName="Karlılık" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Karlılık.&#34;SATISTUTARI&#34;]"/>
      <TfrxMemoView Name="KarllkMIKTARI" Left="604.7248" Top="0" Width="45.35436" Height="15.11812" ShowHint="False" DataField="MIKTARI" DataSet="karlilikQ" DataSetName="Karlılık" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Karlılık.&#34;MIKTARI&#34;]"/>
      <TfrxMemoView Name="KarllkKARTUTARI" Left="968.66203" Top="0" Width="68.03154" Height="15.11812" ShowHint="False" DataField="KARTUTARI" DataSet="karlilikQ" DataSetName="Karlılık" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Karlılık.&#34;KARTUTARI&#34;]"/>
      <TfrxMemoView Name="KarllkKARYUZDE" Left="1039.59122" Top="0" Width="34.01577" Height="15.11812" ShowHint="False" DataField="KARYUZDE" DataSet="karlilikQ" DataSetName="Karlılık" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Karlılık.&#34;KARYUZDE&#34;]"/>
      <TfrxMemoView Name="Memo10" Left="268.34663" Top="0" Width="83.14966" Height="15.11812" ShowHint="False" DataSet="karlilikQ" DataSetName="Karlılık" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[Karlılık.&#34;BARKOD&#34;]"/>
    </TfrxMasterData>
    <TfrxPageHeader Name="PageHeader1" Height="22.67716291" Left="0" Top="102.04731" Width="1084.72511">
      <TfrxMemoView Name="Memo6" Left="3.77953" Top="0" Width="60.47248" Height="18.89763291" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="8" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="Tarih"/>
      <TfrxMemoView Name="Memo7" Left="68.03154" Top="0" Width="109.60637" Height="18.89763291" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="8" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="Belge No"/>
      <TfrxMemoView Name="Memo8" Left="181.41744" Top="0" Width="83.14966" Height="18.89763291" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="8" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="Stok Kodu"/>
      <TfrxMemoView Name="Memo9" Left="355.27582" Top="0" Width="245.66945" Height="18.89763291" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="8" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="Ürün Adı"/>
      <TfrxMemoView Name="Memo11" Left="653.85869" Top="0" Width="45.35436" Height="18.89763291" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="8" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="Birim"/>
      <TfrxMemoView Name="Memo12" Left="604.7248" Top="0" Width="45.35436" Height="18.89763291" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="8" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="Miktar"/>
      <TfrxMemoView Name="Memo13" Left="702.99258" Top="0" Width="49.13389" Height="18.89763291" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="8" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="Maliyet"/>
      <TfrxMemoView Name="Memo15" Left="832.71707" Top="0" Width="60.47248" Height="18.89763291" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="8" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="Satış Fiyatı"/>
      <TfrxMemoView Name="Memo16" Left="898.96908" Top="0" Width="64.25201" Height="18.89763291" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="8" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="Satış Tutarı"/>
      <TfrxMemoView Name="Memo17" Left="968.66203" Top="0" Width="68.03154" Height="18.89763291" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="8" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="Kar Tutarı"/>
      <TfrxMemoView Name="Memo18" Left="1039.59122" Top="0" Width="34.01577" Height="18.89763291" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="8" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="Kar %"/>
      <TfrxMemoView Name="Memo14" Left="755.906" Top="0" Width="71.81107" Height="18.89763291" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="8" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="Maliyet Tutarı"/>
      <TfrxMemoView Name="Memo19" Left="268.34663" Top="0" Width="83.14966" Height="18.89763291" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="8" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="Barkod"/>
    </TfrxPageHeader>
    <TfrxReportSummary Name="ReportSummary1" Height="15.11812" Left="0" Top="260.78757" Width="1084.72511">
      <TfrxMemoView Name="Memo21" Left="3.77953" Top="0" Width="102.04731" Height="15.11812" ShowHint="False" DataSet="karlilikQ" DataSetName="Karlılık" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Satır Sayısı : [COUNT(MasterData1)]"/>
      <TfrxLineView Name="Line1" Left="3.77953" Top="0" Width="1069.60699" Height="0" ShowHint="False" Frame.Typ="4"/>
      <TfrxMemoView Name="Memo22" Left="544.25232" Top="0" Width="56.69295" Height="15.11812" ShowHint="False" DataSet="karlilikQ" DataSetName="Karlılık" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="TOPLAM :"/>
      <TfrxMemoView Name="Memo23" Left="604.7248" Top="0" Width="45.35436" Height="15.11812" ShowHint="False" DataSet="karlilikQ" DataSetName="Karlılık" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="8" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;Karlılık.&#34;MIKTARI&#34;&#62;,MasterData1)]"/>
      <TfrxMemoView Name="Memo24" Left="755.906" Top="0" Width="71.81107" Height="15.11812" ShowHint="False" DataSet="karlilikQ" DataSetName="Karlılık" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="8" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;Karlılık.&#34;MALIYETTUTARI&#34;&#62;,MasterData1)]"/>
      <TfrxMemoView Name="Memo25" Left="899.52814" Top="0" Width="64.25201" Height="15.11812" ShowHint="False" DataSet="karlilikQ" DataSetName="Karlılık" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="8" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;Karlılık.&#34;SATISTUTARI&#34;&#62;,MasterData1)]"/>
      <TfrxMemoView Name="Memo26" Left="967.55968" Top="0" Width="68.03154" Height="15.11812" ShowHint="False" DataSet="karlilikQ" DataSetName="Karlılık" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="8" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;Karlılık.&#34;KARTUTARI&#34;&#62;,MasterData1)]"/>
      <TfrxMemoView Name="Memo27" Left="1039.37075" Top="0" Width="34.01577" Height="15.11812" ShowHint="False" DataSet="karlilikQ" DataSetName="Karlılık" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="8" HAlign="haRight" ParentFont="False" Text="[AVG(&#60;Karlılık.&#34;KARYUZDE&#34;&#62;,MasterData1)]"/>
    </TfrxReportSummary>
  </TfrxReportPage>
</TfrxReport>
