<?xml version="1.0" encoding="utf-8" standalone="no"?>
<TfrxReport Version="5.1.9" DotMatrixReport="False" IniFile="\Software\Fast Reports" PreviewOptions.Buttons="4095" PreviewOptions.Zoom="1" PrintOptions.Printer="Varsayılan" PrintOptions.PrintOnSheet="0" ReportOptions.CreateDate="42008,8583580556" ReportOptions.Description.Text="" ReportOptions.LastChange="42008,8699741319" ScriptLanguage="PascalScript" ScriptText.Text="begin&#13;&#10;&#13;&#10;end.">
  <Datasets>
    <item DataSet="depoQ" DataSetName="Depo Durumu"/>
    <item DataSet="masterQ" DataSetName="Kalite"/>
  </Datasets>
  <Variables>
    <item Name="KARTNO" Value="9"/>
    <item Name="CARIID"/>
    <item Name="TARIH"/>
    <item Name="DETAYKARTNO"/>
  </Variables>
  <TfrxDataPage Name="Data" Height="1000" Left="0" Top="0" Width="1000">
    <TfrxFDQuery Name="depoQ" UserName="Depo Durumu" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="Select * from(                              &#13;&#10;SELECT&#13;&#10;  SUM(G.GIREN) - SUM(G.CIKAN) AS MIKTAR,&#13;&#10;  K.KOD AS KALITEKOD, K.ACIKLAMA AS KALITEACIKLAMA,&#13;&#10;  E.KOD AS EBATKOD, E.ACIKLAMA AS EBATACIKLAMA,&#13;&#10;  D.KOD AS DESENKOD, D.ACIKLAMA AS DESENACIKLAMA,&#13;&#10;  R.KOD AS RENKKOD, R.ACIKLAMA AS RENKACIKLAMA,&#13;&#10;  ISNULL(E.RULO, 0) AS RULO, M2 AS UZUNLUK,&#13;&#10;  CASE E.RULO&#13;&#10;    WHEN 1 THEN (SUM(G.GIREN) - SUM(G.CIKAN)) * M2 * (E.EN / 100.0)&#13;&#10;  ELSE&#13;&#10;    (E.EN / 100.0) * (E.BOY / 100.0) * (SUM(G.GIREN) - SUM(G.CIKAN))&#13;&#10;  END AS M2&#13;&#10;from URETIMDEPODURUMU G&#13;&#10;LEFT OUTER JOIN TBLKALITELER K ON G.KALITEID = K.ID&#13;&#10;LEFT OUTER JOIN TBLEBATLAR E ON G.EBATID = E.ID&#13;&#10;LEFT OUTER JOIN TBLDESENLER D ON G.DESENID = D.ID&#13;&#10;LEFT OUTER JOIN TBLRENKLER R ON G.RENKID = R.ID&#13;&#10;WHERE KALITEID = :KALITEID                &#13;&#10;GROUP BY &#13;&#10;  K.KOD, K.ACIKLAMA, E.KOD, E.ACIKLAMA, E.EN, E.BOY,&#13;&#10;  D.KOD, D.ACIKLAMA, R.KOD, R.ACIKLAMA, E.RULO, M2&#13;&#10;) AS A&#13;&#10;WHERE MIKTAR &#62; 0                                     " PropData="05704C656674025C0470546F70026C0A506172616D657465727301010643204E616D653D224B414C4954454944222044617461547970653D226674496E7465676572222045787072657373696F6E3D22262336303B4B4152544E4F262336323B220000"/>
    <TfrxFDQuery Name="masterQ" UserName="Kalite" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="Select&#13;&#10;  KOD, ACIKLAMA&#13;&#10;FROM TBLKALITELER&#13;&#10;WHERE ID = :KALITEID                                             " PropData="05704C656674025C0470546F7002280A506172616D657465727301010643204E616D653D224B414C4954454944222044617461547970653D226674496E7465676572222045787072657373696F6E3D22262336303B4B4152544E4F262336323B220000"/>
  </TfrxDataPage>
  <TfrxReportPage Name="Page1" Orientation="poLandscape" PaperWidth="297" PaperHeight="210" PaperSize="9" LeftMargin="10" RightMargin="10" TopMargin="10" BottomMargin="10" ColumnWidth="0" ColumnPositions.Text="" HGuides.Text="" VGuides.Text="">
    <TfrxReportTitle Name="ReportTitle1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="64,25201" Left="0" Top="18,89765" Width="1046,92981">
      <TfrxMemoView Name="Memo1" Left="60,47248" Top="0" Width="646,29963" Height="30,23624" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="[Kalite.&#34;KOD&#34;] Depo Durumu"/>
      <TfrxLineView Name="Line1" Left="7,55906" Top="45,35436" Width="1035,59122" Height="0" Color="0" Frame.Typ="4"/>
    </TfrxReportTitle>
    <TfrxMasterData Name="MasterData1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="184,01577" Left="0" Top="143,62214" Width="1046,92981" ColumnWidth="0" ColumnGap="0" DataSet="depoQ" DataSetName="Depo Durumu" RowCount="0">
      <TfrxDBCrossView Name="DBCross1" Left="79,37013" Top="11,33859" Width="384" Height="128" AddHeight="0" AddWidth="0" DownThenAcross="False" NextCrossGap="0" RowLevels="2" ShowCorner="False" ShowTitle="False" CellFields.Text="MIKTAR" ColumnFields.Text="EBATKOD" DataSet="depoQ" DataSetName="Depo Durumu" RowFields.Text="DESENKOD&#13;&#10;RENKKOD" PropData="[encoded data, 13482 characters]"/>
    </TfrxMasterData>
    <TfrxPageFooter Name="PageFooter1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="56,69295" Left="0" Top="389,29159" Width="1046,92981">
      <TfrxLineView Name="Line2" Left="7,55906" Top="7,55906" Width="1035,59122" Height="0" Color="0" Frame.Typ="4"/>
      <TfrxMemoView Name="Memo2" Left="15,11812" Top="18,89765" Width="510,23655" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="PARADOX ile [Date] Tarihinde yazdırılmıştır"/>
      <TfrxMemoView Name="Memo14" Left="918,42579" Top="18,89765" Width="117,16543" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="Sayfa: [Page] / [TotalPages#]"/>
    </TfrxPageFooter>
  </TfrxReportPage>
</TfrxReport>
