<?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="По умолчанию" PrintOptions.PrintOnSheet="0" ReportOptions.Compressed="True" ReportOptions.CreateDate="38637,9142053588" ReportOptions.Description.Text="" ReportOptions.LastChange="41344,5854114352" ScriptLanguage="PascalScript" ScriptText.Text="procedure FrReportOnStartReport(Sender: TfrxComponent);&#13;&#10;var DS :TfrxdbDataset;&#13;&#10;//var MyCDS :TClientDataset;&#13;&#10;begin&#13;&#10;  //MyCDS := TClientDataset.create(sender);                                &#13;&#10;  ds := tfrxdbdataset(tfrxreport(sender).getdataset('frds'));&#13;&#10;  //readdataset(MyCDS, ds.dataset);&#13;&#10;  //ds.dataset := mycds;&#13;&#10;  if ds.dataset is tclientdataset&#13;&#10;  then begin                         &#13;&#10;    tclientdataset(DS.dataset).Indexfieldnames := 'id_branch;name_org;name';&#13;&#10;    tclientdataset(DS.dataset).filter := 'preq_fld&#62;0';&#13;&#10;    tclientdataset(DS.dataset).filtered := true;&#13;&#10;  end                &#13;&#10;end;&#13;&#10;&#13;&#10;begin&#13;&#10;&#13;&#10;end." ShowProgress="False" StoreInDFM="False" OnStartReport="FrReportOnStartReport" PropData="0844617461736574730101062220446174615365743D22667244532220446174615365744E616D653D2266724453220001063420446174615365743D22667253756244657461696C44532220446174615365744E616D653D22667253756244657461696C4453220000095661726961626C657301011435000000204E616D653D22566172536F7274222056616C75653D2227D091D0B5D0B720D181D0BED180D182D0B8D180D0BED0B2D0BAD0B8272200010623204E616D653D2256617246696C74657243616E557365222056616C75653D22273027220001062E204E616D653D2256617246696C7465724461746546726F6D222056616C75653D222730312E30392E32303035272200010622204E616D653D2276617246696C74657244617465546F222056616C75653D222727220001061F204E616D653D2256617246696C7465724F7267222056616C75653D2227272200010623204E616D653D2256415246696C7465724F52474E616D65222056616C75653D2227272200010623204E616D653D2276617246696C74657253746F726E6F222056616C75653D222730272200010626204E616D653D2256617246696C746572555345445452414445222056616C75653D22273027220000055374796C650100">
  <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="34,01577" Left="0" Top="18,89765" Width="718,1107">
      <TfrxMemoView Name="Memo1" Left="30,23624" Top="3" Width="423,30736" Height="24,23098333" ShowHint="False" AutoWidth="True" Font.Charset="1" Font.Color="-16777208" Font.Height="-19" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Предварительная заявка (сводный лист)"/>
      <TfrxLineView Name="Line6" Left="0" Top="34,01577" Width="718,1107" Height="0" ShowHint="False" Frame.Typ="4"/>
    </TfrxReportTitle>
    <TfrxReportSummary Name="ReportSummary1" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Height="26,45671" Left="0" ParentFont="False" Top="457,32313" Width="718,1107">
      <TfrxMemoView Name="Memo16" Left="18,89765" Top="3,77953" Width="94,48825" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="0" Font.Height="-16" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Итого:"/>
      <TfrxLineView Name="Line4" Align="baClient" Left="0" Top="0" Width="718,1107" Height="0" ShowHint="False" Frame.Typ="4"/>
      <TfrxMemoView Name="Memo13" Left="566,9295" Top="3,77953" Width="143,62214" Height="18,89765" ShowHint="False" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-16" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;frDS.&#34;PRICE_DISCOUNT&#34;&#62; * &#60;frDS.&#34;preq_fld&#34;&#62;)]"/>
    </TfrxReportSummary>
    <TfrxGroupHeader Name="GroupHeader1" Height="30,23624" Left="0" Top="204,09462" Width="718,1107" Condition="frDS.&#34;ID_ORG&#34;" KeepTogether="True">
      <TfrxMemoView Name="Memo2" Left="15,11812" Top="3" Width="680,3154" Height="18,89765" ShowHint="False" AutoWidth="True" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="8" ParentFont="False" Text="[frDS.&#34;NAME_ORG&#34;][iif(asstring(DBQueryValue('select telephone from orgs where id =:id',[&#60;frDS.&#34;ID_ORG&#34;&#62;]))='','','  (тел.: '+asstring(DBQueryValue('select telephone from orgs where id =:id',[&#60;frDS.&#34;ID_ORG&#34;&#62;]))+')' )]"/>
    </TfrxGroupHeader>
    <TfrxMasterData Name="MasterData1" Height="22,67718" Left="0" Top="257,00804" Width="718,1107" ColumnWidth="0" ColumnGap="0" DataSet="frDS" DataSetName="frDS" RowCount="0" Stretched="True">
      <TfrxMemoView Name="Memo3" Left="15,11812" Top="0" Width="419,52783" Height="18,89765" ShowHint="False" StretchMode="smActualHeight" DataSet="frDS" DataSetName="frDS" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[&#60;frDS.&#34;NAME&#34;&#62; ] [ &#60;frDS.&#34;FORM&#34;&#62;] [IIF(&#60;frds.&#34;CODE_ORIGINAL&#34;&#62; &#62;'','('+&#60;frds.&#34;CODE_ORIGINAL&#34;&#62;+')','')] [IIF(&#60;frds.&#34;NAME_PRODUCER&#34;&#62; &#62;'','  /'+&#60;frds.&#34;NAME_PRODUCER&#34;&#62;,'')]"/>
      <TfrxMemoView Name="Memo4" Left="574,48856" Top="0" Width="68,03154" Height="18,89765" ShowHint="False" DataSet="frDS" DataSetName="frDS" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[frDS.&#34;PRICE_DISCOUNT&#34;]"/>
      <TfrxMemoView Name="Memo5" Left="498,89796" Top="0" Width="75,5906" Height="18,89765" ShowHint="False" DataSet="frDS" DataSetName="frDS" DisplayFormat.FormatStr="%g" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="[frDS.&#34;preq_fld&#34;]"/>
      <TfrxMemoView Name="Memo9" Left="642,5201" Top="0" Width="68,03154" Height="18,89765" ShowHint="False" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[&#60;frDS.&#34;PRICE_DISCOUNT&#34;&#62; * &#60;frDS.&#34;PREQ_FLD&#34;&#62;]"/>
      <TfrxMemoView Name="Memo14" Left="442,20501" Top="0" Width="56,69295" Height="18,89765" ShowHint="False" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[DBQueryValue('select price from get_registry_price(:id_goods,:id_producer,NULL)',[ &#60;frDS.&#34;ID_GOODS&#34;&#62;, &#60;frDS.&#34;ID_PRODUCERS&#34;&#62;])]"/>
    </TfrxMasterData>
    <TfrxGroupFooter Name="GroupFooter1" Height="34,01577" Left="0" Top="302,3624" Width="718,1107">
      <TfrxMemoView Name="Memo11" Left="18,89765" Top="0" Width="173,85838" Height="18,89765" ShowHint="False" AutoWidth="True" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="Итого по поставщику:"/>
      <TfrxMemoView Name="Memo12" Left="566,9295" Top="0" Width="143,62214" Height="18,89765" ShowHint="False" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;frDS.&#34;PRICE_DISCOUNT&#34;&#62; * &#60;frDS.&#34;preq_fld&#34;&#62;)]"/>
      <TfrxLineView Name="Line3" Left="0" Top="0" Width="718,1107" Height="0" ShowHint="False" Frame.Typ="4"/>
    </TfrxGroupFooter>
    <TfrxHeader Name="Header1" Height="22,67718" Left="0" Top="113,3859" Width="718,1107">
      <TfrxMemoView Name="Memo6" Left="15,11812" 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" HAlign="haRight" ParentFont="False" Text="Наименование"/>
      <TfrxMemoView Name="Memo7" Left="574,48856" Top="0" Width="68,03154" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="Цена"/>
      <TfrxMemoView Name="Memo8" Left="498,89796" Top="0" Width="75,5906" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="Заказ"/>
      <TfrxMemoView Name="Memo10" Left="642,5201" Top="0" Width="64,25201" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="На сумму"/>
      <TfrxMemoView Name="Memo15" Left="442,20501" Top="0" Width="56,69295" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="Реестр"/>
    </TfrxHeader>
    <TfrxGroupHeader Name="GroupHeader2" Height="22,67718" Left="0" Top="158,74026" Width="718,1107" Condition="frDS.&#34;ID_BRANCH&#34;">
      <TfrxMemoView Name="Memo20" Left="15,11812" Top="0" Width="646,29963" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-16" Font.Name="Arial" Font.Style="3" ParentFont="False" Text="Филиал: [iif(asinteger(&#60;frds.&#34;ID_BRANCH&#34;&#62;)=0,'Не указан', asstring(DBQueryValue('select name from orgs where id =:id',[&#60;frDS.&#34;ID_BRANCH&#34;&#62;])))]"/>
    </TfrxGroupHeader>
    <TfrxGroupFooter Name="GroupFooter2" Height="37,7953" Left="0" Top="359,05535" Width="718,1107">
      <TfrxMemoView Name="Memo17" Left="18,89765" Top="0" Width="173,85838" Height="18,89765" ShowHint="False" AutoWidth="True" Font.Charset="1" Font.Color="-16777208" Font.Height="-16" Font.Name="Arial" Font.Style="3" ParentFont="False" Text="Итого по филиалу:"/>
      <TfrxMemoView Name="Memo18" Left="566,9295" Top="0" Width="143,62214" Height="18,89765" ShowHint="False" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-16" Font.Name="Arial" Font.Style="3" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;frDS.&#34;PRICE_DISCOUNT&#34;&#62; * &#60;frDS.&#34;preq_fld&#34;&#62;)]"/>
      <TfrxLineView Name="Line1" Left="0" Top="0" Width="718,1107" Height="0" ShowHint="False" Frame.Typ="4"/>
    </TfrxGroupFooter>
  </TfrxReportPage>
</TfrxReport>
