<?xml version="1.0" encoding="utf-8"?>
<TfrxReport Version="4.7.184" DotMatrixReport="False" EngineOptions.MaxMemSize="10000000" IniFile="\Software\Fast Reports" PreviewOptions.Buttons="2047" PreviewOptions.Zoom="1" PrintOptions.Printer="HP LaserJet 1022" PrintOptions.PrintOnSheet="0" ReportOptions.Compressed="True" ReportOptions.CreateDate="39973,6382602778" ReportOptions.Description.Text="" ReportOptions.LastChange="40260,704212419" ScriptLanguage="PascalScript" ScriptText.Text="procedure FrReportOnStartReport(Sender: TfrxComponent);&#13;&#10;var DS :TfrxdbDataset;&#13;&#10;    TAble :TTable;&#13;&#10;    FR1:string;                                    &#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;  MyCDS.Indexfieldnames := 'isbadseria;name';                                                                                  &#13;&#10;end;&#13;&#10;&#13;&#10;&#13;&#10;begin&#13;&#10;end." OnStartReport="FrReportOnStartReport" PropData="044C65667403C00003546F70024008446174617365747301010C2200000020446174615365743D22667244532220446174615365744E616D653D2266724453220000095661726961626C657301010C1A000000204E616D653D22564152534B4C4144222056616C75653D22332200010C3A000000204E616D653D22566172536B6C61644E616D65222056616C75653D2227CECECE20262333343BDDEAEEEDEEEC262333343B20E02FEF20B932272200010C20000000204E616D653D22564152534B4C41444C697374222056616C75653D222733272200010C3E000000204E616D653D22564152534B4C41444E616D654C697374222056616C75653D2227CECECE20262333343BDDEAEEEDEEEC262333343B20E02FEF20B932272200010C2C000000204E616D653D2256417246696C7465724F73746174222056616C75653D2227CDE5EFF0EEE4E0EDEDFBE5272200010C26000000204E616D653D22564152536F7274222056616C75653D2227CDE0E8ECE5EDEEE2E0EDE8E5272200010C1E000000204E616D653D2256415246696C7465724E4E222056616C75653D2227272200010C1A000000204E616D653D225641524167656E74222056616C75653D22302200010C1F000000204E616D653D225641524167656E744E616D65222056616C75653D2227272200010C23000000204E616D653D227661724167656E74416C6C4E616D6573222056616C75653D2227272200010C1C000000204E616D653D2256415246696E616E6365222056616C75653D22302200010C21000000204E616D653D2256415246696E616E63654E616D65222056616C75653D2227272200010C20000000204E616D653D2256415246696C7465724B617274222056616C75653D2227272200010C21000000204E616D653D2256415246696C7465725365726961222056616C75653D2227272200010C2A000000204E616D653D2256415246696C74657253726F6B546F222056616C75653D222720202E20202E2020272200010C2C000000204E616D653D2256415246696C74657253726F6B46726F6D222056616C75653D222720202E20202E2020272200010C27000000204E616D653D2256415246696C7465724E756C6C53726F6B222056616C75653D2246616C73652200010C2E000000204E616D653D2256415246696C74657253726F6B536572746966222056616C75653D222720202E20202E2020272200010C2D000000204E616D653D2256415246696C7465724E756C6C53726F6B536572746966222056616C75653D2246616C73652200010C19000000204E616D653D225641524B555253222056616C75653D2231220000055374796C650100">
  <TfrxDataPage Name="Data" Height="1000" Left="0" Top="0" Width="1000"/>
  <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" Height="98,26778" Left="0" Top="18,89765" Width="1046,92981">
      <TfrxMemoView Name="VarSkladName" Left="71,81107" Top="41,47248" Width="332,59864" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[VarSkladName]"/>
      <TfrxMemoView Name="Memo1" Left="11,33859" Top="41,47248" Width="56,69295" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Склад:"/>
      <TfrxMemoView Name="Memo2" Left="11,33859" Top="3,77953" Width="419,52783" Height="37,7953" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-24" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Отчет по забракованным сериям"/>
      <TfrxMemoView Name="Memo14" Left="805,03989" Top="3,77953" Width="222,99227" Height="26,45671" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-9" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="Последнюю версию отчета вы можете скачать с сайта: http://LazyAdmin.ru"/>
      <TfrxMemoView Name="Memo15" Left="876,85096" Top="30,67718" Width="151,1812" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-8" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="версия отчета:  2009.06.23"/>
    </TfrxReportTitle>
    <TfrxMasterData Name="MasterData1" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="0" Height="68,03154" Left="0" ParentFont="False" Top="343,93723" Width="1046,92981" OnBeforePrint="MasterData1OnBeforePrint" ColumnWidth="0" ColumnGap="0" DataSet="frDS" DataSetName="frDS" RowCount="0">
      <TfrxMemoView Name="Memo18" Left="0" Top="0" Width="60,47248" Height="68,03154" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="1" ParentFont="False" VAlign="vaCenter" Text=""/>
      <TfrxMemoView Name="frDSProducerName" Left="438,42548" Top="0" Width="132,28355" Height="34,01577" ShowHint="False" DataSet="frDS" DataSetName="frDS" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Color="15000804" Frame.Typ="10" GapX="4" GapY="4" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="[frDS.&#34;ProducerName&#34;]"/>
      <TfrxMemoView Name="frDSBadSEriaparamName" Left="139,84261" Top="34,01577" Width="219,21274" Height="34,01577" ShowHint="False" StretchMode="smMaxHeight" DataField="BadSeria_Name" DataSet="frDS" DataSetName="frDS" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Color="15000804" Frame.Typ="2" GapX="4" GapY="4" ParentFont="False" VAlign="vaCenter" Text="[frDS.&#34;BadSeria_Name&#34;]"/>
      <TfrxMemoView Name="frDSBadSeria" Left="359,05535" Top="34,01577" Width="79,37013" Height="34,01577" ShowHint="False" DataField="BadSeria" DataSet="frDS" DataSetName="frDS" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Color="15000804" Frame.Typ="2" GapX="4" GapY="4" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="[frDS.&#34;BadSeria&#34;]"/>
      <TfrxMemoView Name="frDSBadSeriaMess" Left="755,906" Top="0" Width="124,72449" Height="18,89765" ShowHint="False" DataField="BadSeriaMess" DataSet="frDS" DataSetName="frDS" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Color="15000804" Frame.Typ="10" GapX="4" GapY="4" ParentFont="False" VAlign="vaCenter" Text="[frDS.&#34;BadSeriaMess&#34;]"/>
      <TfrxMemoView Name="frDSBadSEriaparamName1" Left="699,21305" Top="18,89765" Width="347,71676" Height="49,13389" ShowHint="False" DataField="BadSEriaparamName" DataSet="frDS" DataSetName="frDS" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" GapX="4" GapY="4" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="[frDS.&#34;BadSEriaparamName&#34;]"/>
      <TfrxSysMemoView Name="SysMemo4" Left="15,33859" Top="17,33859" Width="30,23624" Height="34,01577" ShowHint="False" Font.Charset="1" Font.Color="15000804" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Color="15000804" Frame.Typ="15" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="[LINE#]"/>
      <TfrxMemoView Name="frDSName" Left="139,84261" Top="0" Width="219,21274" Height="34,01577" ShowHint="False" DataField="Name" DataSet="frDS" DataSetName="frDS" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Color="14211288" Frame.Typ="10" GapX="4" GapY="4" ParentFont="False" VAlign="vaCenter" Text="[frDS.&#34;Name&#34;]"/>
      <TfrxMemoView Name="frDSSeria" Left="359,05535" Top="0" Width="79,37013" Height="34,01577" ShowHint="False" DataField="Seria" DataSet="frDS" DataSetName="frDS" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Color="15000804" Frame.Typ="10" GapX="8" GapY="2" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="[frDS.&#34;Seria&#34;]"/>
      <TfrxMemoView Name="Memo10" Left="60,47248" Top="0" Width="79,37013" Height="34,01577" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Color="15000804" Frame.Typ="10" GapX="4" GapY="4" ParentFont="False" VAlign="vaCenter" Text="Наша база:"/>
      <TfrxMemoView Name="Memo11" Left="60,47248" Top="34,01577" Width="79,37013" Height="34,01577" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Color="15000804" Frame.Typ="2" GapX="4" GapY="4" ParentFont="False" VAlign="vaCenter" Text="Брак:"/>
      <TfrxLineView Name="Line1" Align="baBottom" Left="0" Top="68,03154" Width="1046,92981" Height="0" ShowHint="False" Frame.Typ="4"/>
      <TfrxMemoView Name="frDSBadSeriaBreakDate" Left="914,64626" Top="0" Width="132,28355" Height="18,89765" ShowHint="False" DataField="BadSeriaBreakDate" DataSet="frDS" DataSetName="frDS" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Color="14211288" Frame.Typ="10" GapX="4" GapY="4" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[frDS.&#34;BadSeriaBreakDate&#34;]"/>
      <TfrxMemoView Name="Memo5" Left="699,21305" Top="0" Width="56,69295" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Color="15000804" Frame.Typ="10" GapX="4" GapY="4" ParentFont="False" VAlign="vaCenter" Text="Письмо:"/>
      <TfrxMemoView Name="Memo13" Left="880,63049" Top="0" Width="34,01577" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Color="14211288" Frame.Typ="10" GapX="4" GapY="4" ParentFont="False" VAlign="vaCenter" Text="Дата:"/>
      <TfrxMemoView Name="Memo17" Left="438,42548" Top="34,01577" Width="132,28355" Height="34,01577" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Color="14211288" Frame.Typ="2" GapX="4" GapY="4" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="[BDEQueryValue('select producername from badseria where id =:id',[&#60;frDS.&#34;badseriaid&#34;&#62;])]"/>
      <TfrxLineView Name="Line2" Left="0" Top="0,47248" Width="1046,92981" Height="0" ShowHint="False" Frame.Typ="4"/>
      <TfrxMemoView Name="Memo19" Left="914,64626" Top="0" Width="132,28355" Height="68,03154" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="2" ParentFont="False" Text=""/>
      <TfrxMemoView Name="Memo24" Left="570,70903" Top="0" Width="64,25201" Height="34,01577" ShowHint="False" DataField="data" DataSet="frDS" DataSetName="frDS" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Color="15000804" Frame.Typ="10" GapX="4" GapY="4" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="[frDS.&#34;data&#34;]"/>
      <TfrxMemoView Name="Memo25" Left="634,96104" Top="0" Width="64,25201" Height="34,01577" ShowHint="False" DataField="ID_DOC" DataSet="frDS" DataSetName="frDS" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Color="15000804" Frame.Typ="10" GapX="4" GapY="4" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="[frDS.&#34;ID_DOC&#34;]"/>
      <TfrxMemoView Name="Memo26" Left="570,70903" Top="34,01577" Width="128,50402" Height="34,01577" ShowHint="False" DataField="AgentName" DataSet="frDS" DataSetName="frDS" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Color="15000804" Frame.Typ="10" GapX="4" GapY="4" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="[frDS.&#34;AgentName&#34;]"/>
    </TfrxMasterData>
    <TfrxHeader Name="Header1" Height="52,91342" Left="0" Top="177,63791" Width="1046,92981">
      <TfrxMemoView Name="Memo7" Left="140,26778" Top="0" Width="219,21274" Height="52,91342" ShowHint="False" Color="15790320" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="15" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="Наименование"/>
      <TfrxMemoView Name="Memo8" Left="359,48052" Top="0" Width="79,37013" Height="52,91342" ShowHint="False" Color="15790320" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="15" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="Серия"/>
      <TfrxMemoView Name="Memo9" Left="0" Top="0" Width="139,84261" Height="52,91342" ShowHint="False" Color="15790320" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="15" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="№"/>
      <TfrxMemoView Name="Memo6" Left="438,85065" Top="0" Width="132,28355" Height="52,91342" ShowHint="False" Color="15790320" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="15" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="Производитель"/>
      <TfrxMemoView Name="Memo12" Left="699,21305" Top="0" Width="347,71676" Height="52,91342" ShowHint="False" Color="15790320" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="15" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="Письмо | Дата забраковки | Основание забраковки"/>
      <TfrxMemoView Name="Memo21" Left="570,70903" Top="26,45671" Width="128,50402" Height="26,45671" ShowHint="False" Color="15790320" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="15" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="Поставщик"/>
      <TfrxMemoView Name="Memo22" Left="570,70903" Top="0" Width="64,25201" Height="26,45671" ShowHint="False" Color="15790320" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="15" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="Дата"/>
      <TfrxMemoView Name="Memo23" Left="634,96104" Top="0" Width="64,25201" Height="26,45671" ShowHint="False" Color="15790320" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="15" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="Номер"/>
    </TfrxHeader>
    <TfrxPageFooter Name="PageFooter1" Height="26,45671" Left="0" Top="608,50433" Width="1046,92981">
      <TfrxMemoView Name="Memo3" Left="189,16543" Top="3,77953" Width="102,04731" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" ParentFont="False" VAlign="vaCenter" Text="Отчет распечатан:"/>
      <TfrxSysMemoView Name="SysMemo1" Left="294,99227" Top="3,77953" Width="68,03154" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" ParentFont="False" VAlign="vaCenter" Text="[DATE]"/>
      <TfrxMemoView Name="Memo4" Left="366,80334" Top="3,77953" Width="60,47248" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" ParentFont="False" VAlign="vaCenter" Text="Страница:"/>
      <TfrxSysMemoView Name="SysMemo3" Left="427,27582" Top="3,77953" Width="162,51979" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" ParentFont="False" VAlign="vaCenter" Text="[PAGE#] из [TOTALPAGES#]"/>
      <TfrxMemoView Name="Memo16" Left="0" Top="3,77952756" Width="185,19697" Height="18,8976378" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" ParentFont="False" VAlign="vaCenter" Text="Отчет по забракованным сериям"/>
    </TfrxPageFooter>
    <TfrxGroupHeader Name="GroupHeader1" Height="68,03154" Left="0" Top="253,22851" Width="1046,92981" Condition="frDS.&#34;IsBadSEria&#34;">
      <TfrxSysMemoView Name="SysMemo2" Left="0" Top="26,23624" Width="1046,92981" Height="41,57483" ShowHint="False" Color="15790320" Font.Charset="1" Font.Color="-16777208" Font.Height="-19" Font.Name="Arial" Font.Style="1" Frame.Typ="7" Frame.Width="1,5" GapX="4" GapY="4" ParentFont="False" VAlign="vaCenter" Text="[(IIF(&#60;frDS.&#34;IsBadSEria&#34;&#62;=1,'Найдены забракованные серии. Обратите особое внимание',''))][(IIF(&#60;frDS.&#34;IsBadSEria&#34;&#62;=2,'Найдены у других производителей',''))][(IIF(&#60;frDS.&#34;IsBadSEria&#34;&#62;=3,'Найдены похожие серии',''))][(IIF(&#60;frDS.&#34;IsBadSEria&#34;&#62;=4,'Найдены похожие серии у других производителей',''))][(IIF(&#60;frDS.&#34;IsBadSEria&#34;&#62;=5,'Все серии данного производителя в браке',''))][(IIF(&#60;frDS.&#34;IsBadSEria&#34;&#62;=6,'Серия с похожим наименованием в браке',''))]"/>
    </TfrxGroupHeader>
    <TfrxGroupFooter Name="GroupFooter1" Height="30,23624" Left="0" Top="434,64595" Width="1046,92981">
      <TfrxSysMemoView Name="SysMemo5" Left="0" Top="0" Width="1028,03216" Height="22,67718" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[(IIF(&#60;frDS.&#34;IsBadSEria&#34;&#62;=1,'При проверке обратить особое внимание на данный раздел, так как в нем находятся данные по которым были полные совпадения информации',''))][(IIF(&#60;frDS.&#34;IsBadSEria&#34;&#62;=2,'Забракованные серии найдены у других производителей',''))][(IIF(&#60;frDS.&#34;IsBadSEria&#34;&#62;=3,'Найдены похожие серии. Обратите внимание на эти серии. Возможно при приеме накладных была не правильно введена серия',''))][(IIF(&#60;frDS.&#34;IsBadSEria&#34;&#62;=4,'Найдены серии похожие на серии, забракованные  у других производителей',''))][(IIF(&#60;frDS.&#34;IsBadSEria&#34;&#62;=5,'Все серии данного производителя в браке',''))][(IIF(&#60;frDS.&#34;IsBadSEria&#34;&#62;=6,'Серия с похожим наименованием в браке.',''))]"/>
    </TfrxGroupFooter>
    <TfrxReportSummary Name="ReportSummary1" Height="60,47248" Left="0" Top="525,35467" Width="1046,92981">
      <TfrxMemoView Name="Memo20" Left="529,1342" Top="18,89765" Width="495,11843" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="Забракованные серии проверены и изъяты __________________________________ "/>
    </TfrxReportSummary>
  </TfrxReportPage>
</TfrxReport>
