<?xml version="1.0" encoding="utf-8" standalone="no"?>
<TfrxReport Version="4.11.7" DotMatrixReport="False" EngineOptions.MaxMemSize="10000000" IniFile="\Software\Fast Reports" PreviewOptions.Buttons="4095" PreviewOptions.Zoom="1" PrintOptions.Printer="По умолчанию" PrintOptions.PrintOnSheet="0" ReportOptions.Compressed="True" ReportOptions.CreateDate="40815,47147875" ReportOptions.Description.Text="" ReportOptions.LastChange="40815,6745048148" ScriptLanguage="PascalScript" ScriptText.Text="begin&#13;&#10;&#13;&#10;end." PropData="044C656674027003546F7002400844617461736574730101062220446174615365743D22667244532220446174615365744E616D653D2266724453220001063420446174615365743D22667253756244657461696C44532220446174615365744E616D653D22667253756244657461696C4453220000095661726961626C657301010625204E616D653D225661724D696E44417465222056616C75653D2230312E30372E323031312200010625204E616D653D225661724D617844417465222056616C75653D2232392E30392E32303131220001061C204E616D653D22566172537461747573222056616C75653D222727220001061D204E616D653D22566172537570706C696572222056616C75653D22302200010622204E616D653D22566172537570706C6965724E616D65222056616C75653D2227272200010621204E616D653D2256617253746F726167654C697374222056616C75653D2227272200010620204E616D653D22566172526561736F6E4C697374222056616C75653D222727220001143C000000204E616D653D2256617255736572446F63222056616C75653D2227D092D181D0B520D0BFD0BED0BBD18CD0B7D0BED0B2D0B0D182D0B5D0BBD0B8272200011424000000204E616D653D22566172536F7274222056616C75653D2227D09DD0BED0BCD0B5D18027220000055374796C650100">
  <TfrxDataPage Name="Data" Height="1000" Left="0" Top="0" Width="1000"/>
  <TfrxReportPage Name="Page1" PaperWidth="210" PaperHeight="297" PaperSize="9" LeftMargin="10" RightMargin="10" TopMargin="10" BottomMargin="10" ColumnWidth="0" ColumnPositions.Text="" HGuides.Text="" VGuides.Text="">
    <TfrxReportTitle Name="ReportTitle1" Height="71,81107" Left="0" Top="18,89765" Width="718,1107">
      <TfrxMemoView Name="Memo1" Left="7,55906" Top="18,89765" Width="536,69326" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-16" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Суммарная ведомость приходов от поставщиков"/>
      <TfrxSysMemoView Name="SysMemo1" Left="570,70903" Top="0" Width="143,62214" Height="18,89765" ShowHint="False" AutoWidth="True" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[DATE] [TIME]"/>
      <TfrxMemoView Name="Memo19" Left="7,55906" Top="45,35436" Width="536,69326" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="За период с: [VARMINDATE] по: [VARMAXDATe] "/>
    </TfrxReportTitle>
    <TfrxHeader Name="Header1" Height="37,7953" Left="0" Top="151,1812" Width="718,1107">
      <TfrxMemoView Name="Memo2" Left="0" Top="0" Width="49,13389" Height="37,7953" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="15" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="N п/п"/>
      <TfrxMemoView Name="Memo3" Left="49,13389" Top="0" Width="162,51979" Height="37,7953" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="15" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="Контрагент"/>
      <TfrxMemoView Name="Memo4" Left="211,65368" Top="0" Width="86,92919" Height="37,7953" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="15" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="Сумма по себест"/>
      <TfrxMemoView Name="Memo5" Left="298,58287" Top="0" Width="86,92919" Height="37,7953" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="15" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="Сумма в рознице"/>
      <TfrxMemoView Name="Memo6" Left="385,51206" Top="0" Width="41,57483" Height="37,7953" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="15" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="Нацен-&#13;&#10;ка %"/>
      <TfrxMemoView Name="Memo7" Left="427,08689" Top="0" Width="71,81107" Height="37,7953" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="15" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="Наценка сумма"/>
      <TfrxMemoView Name="Memo8" Left="498,89796" Top="0" Width="71,81107" Height="37,7953" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="15" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="НДС&#13;&#10;закуп"/>
      <TfrxMemoView Name="Memo9" Left="570,70903" Top="0" Width="71,81107" Height="37,7953" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="15" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="НДС &#13;&#10;прод"/>
      <TfrxMemoView Name="Memo10" Left="642,5201" Top="0" Width="75,5906" Height="37,7953" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="15" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="Сумма возвратов"/>
    </TfrxHeader>
    <TfrxMasterData Name="MasterData1" Height="18,89765" Left="0" Top="211,65368" Width="718,1107" ColumnWidth="0" ColumnGap="0" DataSet="frDS" DataSetName="frDS" RowCount="0" Stretched="True">
      <TfrxMemoView Name="Memo11" Left="49,13389" Top="0" Width="162,51979" Height="18,89765" ShowHint="False" StretchMode="smMaxHeight" DataField="Name" DataSet="frDS" DataSetName="frDS" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="15" ParentFont="False" Text="[frDS.&#34;Name&#34;]"/>
      <TfrxSysMemoView Name="SysMemo2" Left="0" Top="0" Width="49,13389" Height="18,89765" ShowHint="False" StretchMode="smMaxHeight" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="15" HAlign="haCenter" ParentFont="False" Text="[LINE#]"/>
      <TfrxMemoView Name="Memo12" Left="211,65368" Top="0" Width="86,92919" Height="18,89765" ShowHint="False" StretchMode="smMaxHeight" DataField="InpSumma" DataSet="frDS" DataSetName="frDS" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="15" HAlign="haRight" ParentFont="False" Text="[frDS.&#34;InpSumma&#34;]"/>
      <TfrxMemoView Name="Memo13" Left="298,58287" Top="0" Width="86,92919" Height="18,89765" ShowHint="False" StretchMode="smMaxHeight" DataField="OutSumma" DataSet="frDS" DataSetName="frDS" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="15" HAlign="haRight" ParentFont="False" Text="[frDS.&#34;OutSumma&#34;]"/>
      <TfrxMemoView Name="Memo14" Left="385,51206" Top="0" Width="41,57483" Height="18,89765" ShowHint="False" StretchMode="smMaxHeight" DataSet="frDS" DataSetName="frDS" DisplayFormat.FormatStr="####.#" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="15" HAlign="haRight" ParentFont="False" Text="[(&#60;frDS.&#34;OutSumma&#34;&#62; / iif(&#60;frDS.&#34;InpSumma&#34;&#62;=0,iif(&#60;frDS.&#34;OutSumma&#34;&#62;=0,1,&#60;frDS.&#34;outSumma&#34;&#62;), &#60;frDS.&#34;InpSumma&#34;&#62;) - 1) * 100]"/>
      <TfrxMemoView Name="Memo15" Left="427,08689" Top="0" Width="71,81107" Height="18,89765" ShowHint="False" StretchMode="smMaxHeight" DataField="NacenSumma" DataSet="frDS" DataSetName="frDS" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="15" HAlign="haRight" ParentFont="False" Text="[frDS.&#34;NacenSumma&#34;]"/>
      <TfrxMemoView Name="Memo16" Left="498,89796" Top="0" Width="71,81107" Height="18,89765" ShowHint="False" StretchMode="smMaxHeight" DataField="ZNDSSumma" DataSet="frDS" DataSetName="frDS" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="15" HAlign="haRight" ParentFont="False" Text="[frDS.&#34;ZNDSSumma&#34;]"/>
      <TfrxMemoView Name="Memo17" Left="570,70903" Top="0" Width="71,81107" Height="18,89765" ShowHint="False" StretchMode="smMaxHeight" DataField="NDSSumma" DataSet="frDS" DataSetName="frDS" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="15" HAlign="haRight" ParentFont="False" Text="[frDS.&#34;NDSSumma&#34;]"/>
      <TfrxMemoView Name="Memo18" Left="642,5201" Top="0" Width="75,5906" Height="18,89765" ShowHint="False" StretchMode="smMaxHeight" DataSet="frDS" DataSetName="frDS" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="15" HAlign="haRight" ParentFont="False" Text="[BDEQueryValue('select sum(kol * cena)  from  rs_nakl a join rs_tovar b on a.id = b.id_nakl where a.agent = :id and a.data &#62;= :dt1 and a.data &#60;= :dt2 and a.osnov like ''В%''',&#13;&#10;[&#60;frDS.&#34;Agent&#34;&#62;,&#60;VarMinDAte&#62;,iif(&#60;VarMaxDate&#62;=0,date,&#60;VarMaxDAte&#62;)],'dbkassa')]"/>
    </TfrxMasterData>
    <TfrxReportSummary Name="ReportSummary1" Height="26,45671" Left="0" Top="291,02381" Width="718,1107">
      <TfrxMemoView Name="Memo20" Left="211,65368" Top="0" Width="86,92919" Height="18,89765" ShowHint="False" StretchMode="smMaxHeight" DataSet="frDS" DataSetName="frDS" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[sum(&#60;frDS.&#34;InpSumma&#34;&#62;)]"/>
      <TfrxMemoView Name="Memo21" Left="298,58287" Top="0" Width="86,92919" Height="18,89765" ShowHint="False" StretchMode="smMaxHeight" DataSet="frDS" DataSetName="frDS" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[sum(&#60;frDS.&#34;OutSumma&#34;&#62;)]"/>
      <TfrxMemoView Name="Memo22" Left="498,89796" Top="0" Width="71,81107" Height="18,89765" ShowHint="False" StretchMode="smMaxHeight" DataSet="frDS" DataSetName="frDS" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[sum(&#60;frDS.&#34;ZNDSSumma&#34;&#62;)]"/>
      <TfrxMemoView Name="Memo23" Left="570,70903" Top="0" Width="71,81107" Height="18,89765" ShowHint="False" StretchMode="smMaxHeight" DataSet="frDS" DataSetName="frDS" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[sum(&#60;frDS.&#34;NDSSumma&#34;&#62;)]"/>
      <TfrxMemoView Name="Memo24" Left="642,5201" Top="0" Width="75,5906" Height="18,89765" ShowHint="False" StretchMode="smMaxHeight" DataSet="frDS" DataSetName="frDS" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[sum(BDEQueryValue('select sum(kol * cena)  from  rs_nakl a join rs_tovar b on a.id = b.id_nakl where a.agent = :id and a.data &#62;= :dt1 and a.data &#60;= :dt2 and a.osnov like ''В%''',&#13;&#10;[&#60;frDS.&#34;Agent&#34;&#62;,&#60;VarMinDAte&#62;,iif(&#60;VarMaxDate&#62;=0,date,&#60;VarMaxDAte&#62;)],'dbkassa'))]"/>
      <TfrxMemoView Name="Memo25" Left="0" Top="0" Width="94,48825" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="Итого:"/>
      <TfrxMemoView Name="Memo26" Left="427,08689" Top="0" Width="71,81107" Height="18,89765" ShowHint="False" StretchMode="smMaxHeight" DataSet="frDS" DataSetName="frDS" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[sum(&#60;frDS.&#34;NacenSumma&#34;&#62;)]"/>
    </TfrxReportSummary>
  </TfrxReportPage>
</TfrxReport>
