<?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="41474,0111470718" ReportOptions.Description.Text="" ReportOptions.LastChange="41487,5594134607" ScriptLanguage="PascalScript" ScriptText.Text="begin&#13;&#10;&#13;&#10;end." PropData="044C65667403900103546F700380010844617461736574730101062A20446174615365743D226465706F512220446174615365744E616D653D224465706F20447572756D75220000095661726961626C65730100055374796C650100">
  <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&#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;  CAST(E.EN AS VARCHAR) + ' ' + CAST(E.BOY AS VARCHAR) AS ENBOY,&#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;  Round(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, 2) 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 &#62; 0&#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;ORDER BY E.EN, E.BOY  " PropData="05704C6566740394000470546F7002500A506172616D65746572730100"/>
  </TfrxDataPage>
  <TfrxReportPage Name="Page1" Orientation="poLandscape" PaperWidth="297" PaperHeight="210" PaperSize="256" LeftMargin="10" RightMargin="10" TopMargin="10" BottomMargin="10" ColumnWidth="0" ColumnPositions.Text="" HGuides.Text="" VGuides.Text="">
    <TfrxMasterData Name="MasterData1" Height="211,65368" Left="0" Top="18,89765" Width="1046,92981" ColumnWidth="0" ColumnGap="0" DataSet="depoQ" DataSetName="Depo Durumu" RowCount="0">
      <TfrxDBCrossView Name="DBCross1" Left="64,25201" Top="15,11812" Width="620" Height="172" ShowHint="False" AddHeight="0" AddWidth="0" CellLevels="2" DownThenAcross="True" NextCrossGap="0" PlainCells="True" RowLevels="3" ShowTitle="False" CellFields.Text="MIKTAR&#13;&#10;M2" ColumnFields.Text="EBATACIKLAMA" DataSet="depoQ" DataSetName="Depo Durumu" RowFields.Text="KALITEACIKLAMA&#13;&#10;DESENACIKLAMA&#13;&#10;RENKACIKLAMA" PropData="[encoded data, 27878 characters]"/>
    </TfrxMasterData>
  </TfrxReportPage>
</TfrxReport>
