<?xml version="1.0" encoding="utf-8"?>
<TfrxReport Version="4.12.1" DotMatrixReport="False" EngineOptions.DoublePass="True" IniFile="\Software\Fast Reports" PreviewOptions.Buttons="4089" PreviewOptions.OutlineWidth="180" PreviewOptions.Zoom="2" PrintOptions.Printer="Default" PrintOptions.PrintOnSheet="0" ReportOptions.Author="EXATA Sistemas" ReportOptions.CreateDate="37871,9957952199" ReportOptions.Description.Text="Este relatório e parte integrante do SEAC - Sistema EXATA de Automação Comercial" ReportOptions.Name="Relatorios\Relacao_Produtos_Vendidos_Fita.estrelfr4" ReportOptions.LastChange="45449,5986160995" ReportOptions.VersionBuild="0" ReportOptions.VersionMajor="1" ReportOptions.VersionMinor="0" ReportOptions.VersionRelease="0" ScriptLanguage="PascalScript" ScriptText.Text="var&#13;&#10;cCampos:string;&#13;&#10;cIndex:string;&#13;&#10;cVazio:string;&#13;&#10;cSQL:string;&#13;&#10;  &#13;&#10;begin&#13;&#10;&#13;&#10;       Report.PreviewOptions.Zoom := 2;&#13;&#10;                                                           &#13;&#10;       //**********************************************************************//&#13;&#10;       // Montando o DataSet                                                            &#13;&#10;       //**********************************************************************//                                                                                                                                                          &#13;&#10;       cCampos := '[Produto_Nome][Produto_Codigo][Unidade_Abreviacao][Preco_Venda][Quantidade]';&#13;&#10;       cIndex := '[1][2][3][4][5]';&#13;&#10;       cVazio := '{{&#34;&#34;,0,&#34;&#34;,0,0}}';&#13;&#10;&#13;&#10;       CallHbFunc('Relatorio_DataSet',[cCampos,cIndex,cVazio]);&#13;&#10;       //**********************************************************************//                                                                                                                                                          &#13;&#10;    &#13;&#10;       //**********************************************************************//&#13;&#10;       // Populando o DataSet                                                            &#13;&#10;       //**********************************************************************//&#13;&#10;       cSQL := 'SELECT a.pd_nome, a.pd_codigo, a.un_abrev, a.pd_valor_venda, SUM(a.mp_qtd_movimentada) ';                                                                                                                                                           &#13;&#10;       cSQL := cSQL+'FROM cc_produtos a, caixa b ';&#13;&#10;       cSQL := cSQL+'WHERE a.sql_deleted = &#34;F&#34; ';&#13;&#10;       cSQL := cSQL+'AND b.sql_deleted = &#34;F&#34; ';&#13;&#10;       cSQL := cSQL+'AND a.op_codigo = b.op_codigo ';&#13;&#10;       cSQL := cSQL+'AND b.cx_valor_liquido &#62; &#34;0&#34; ';&#13;&#10;       cSQL := cSQL+'AND a.pd_valor_venda &#60;&#62; &#34;0&#34; ';&#13;&#10;       cSQL := cSQL+'AND a.pd_nome &#60;&#62; &#34;Vago&#34; ';&#13;&#10;       cSQL := cSQL+'AND a.mp_status = &#34;SM&#34; ';&#13;&#10;       cSQL := cSQL+'AND LEFT(a.mp_documento,3) &#60;&#62; &#34;ACT&#34; ';&#13;&#10;       cSQL := cSQL+'AND LEFT(a.mp_documento,3) &#60;&#62; &#34;RS-&#34; ';&#13;&#10;       cSQL := cSQL+&#60;cwhere&#62;+' ';                                                                                     &#13;&#10;       cSQL := cSQL+'GROUP BY a.pd_codigo ';                                                &#13;&#10;       cSQL := cSQL+'ORDER BY a.pd_nome ';&#13;&#10;       //cSQL := cSQL+'LIMIT 20 ';&#13;&#10;&#13;&#10;       CallHbFunc('Relatorio_PopulaDataSet',[cSQL,cVazio]);&#13;&#10;       //**********************************************************************//&#13;&#10;&#13;&#10;end." ShowProgress="False" StoreInDFM="False" PropData="044C656674025803546F70026808446174617365747301010C2400000020446174615365743D226F444D2E2220446174615365744E616D653D22546162656C61220000095661726961626C657301010C0F000000204E616D653D222056657273616F2200010C20000000204E616D653D2256657273616F5F53697374656D61222056616C75653D22372200010C10000000204E616D653D22205265746F726E6F2200010C1F000000204E616D653D225265746F726E6F222056616C75653D222766616C7365272200010C10000000204E616D653D2220456D70726573612200010C34000000204E616D653D2252617A616F5F536F6369616C222056616C75653D22274558415441205465636E6F6C6F676961204C746461272200010C2E000000204E616D653D224E6F6D655F46616E7461736961222056616C75653D222745584154412053697374656D6173272200010C1E000000204E616D653D224C6F6A61222056616C75653D22274E69746572F369272200010C3D000000204E616D653D22456E64657265636F222056616C75653D22275275612045757A6562696F2064652051756569726F7A2C20363030202D204C6F6A61272200010C1F000000204E616D653D224E756D65726F222056616C75653D2227202020363030272200010C22000000204E616D653D22436F6D706C656D656E746F222056616C75653D22274C6F6A61272200010C1F000000204E616D653D2242616972726F222056616C75653D222743656E74726F272200010C1E000000204E616D653D22436964616465222056616C75653D22274D616361E9272200010C17000000204E616D653D225546222056616C75653D2227524A272200010C1F000000204E616D653D22434550222056616C75653D222732373931302D323330272200010C2A000000204E616D653D2254656C65666F6E65222056616C75653D22272832322920323736322D3836373920272200010C25000000204E616D653D22466178222056616C75653D2227282020292020202020202D20202020272200010C29000000204E616D653D2243656C756C6172222056616C75653D2227282020292020202020202D20202020272200010C29000000204E616D653D22434E504A222056616C75653D222733362E3537372E3534322F303030312D3739272200010C2A000000204E616D653D22496E73635F457374616475616C222056616C75653D222738342E3636332E303138272200010C29000000204E616D653D22496E73635F4D756E69636970616C222056616C75653D22273030303030303030272200010C2C000000204E616D653D2253697465222056616C75653D22277777772E657861746173697374656D61732E636F6D272200010C33000000204E616D653D22456D61696C222056616C75653D2227636F6D65726369616C40657861746173697374656D61732E636F6D272200010C17000000204E616D653D224C6F676F222056616C75653D2227272200010C19000000204E616D653D22536C6F67616E222056616C75653D2227272200010C21000000204E616D653D22436F6469676F5F4C6F6A61222056616C75653D2227303031272200010C1E000000204E616D653D225465726D696E616C222056616C75653D2227303031272200010C0F000000204E616D653D2220546974756C6F2200010C36000000204E616D653D22546974756C6F31222056616C75653D222752656C61E7E36F2064652050726F6475746F732056656E6469646F73272200010C27000000204E616D653D22546974756C6F32222056616C75653D22274C6F6A613A204E69746572F369272200010C27000000204E616D653D22546974756C6F33222056616C75653D22275465726D696E616C3A20303031272200010C36000000204E616D653D22546974756C6F34222056616C75653D22274D6F76696D656E746F20646F204469613A2030362F30362F32303234272200010C1A000000204E616D653D22546974756C6F35222056616C75653D2227272200010C0E000000204E616D653D22204175746F722200010C2B000000204E616D653D224175746F725F4E6F6D65222056616C75653D222745584154412053697374656D6173272200010C32000000204E616D653D224175746F725F53697465222056616C75653D22277777772E657861746173697374656D61732E636F6D272200010C10000000204E616D653D2220436F6C756E61732200010C81000000204E616D653D22637768657265222056616C75653D222720414E4420622E63785F646174615F6661747572616D656E746F203D20262333343B323032342D30362D3036262333343B20414E4420622E6C6F5F636F6469676F203D203120414E4420622E63785F7465726D696E616C203D20262333343B303031262333343B2027220000055374796C650100">
  <TfrxDataPage Name="Data" Height="1000" Left="0" Top="0" Width="1000"/>
  <TfrxReportPage Name="Page1" PaperWidth="75" PaperHeight="100" PaperSize="256" LeftMargin="4" RightMargin="4" TopMargin="0,5" BottomMargin="0,5" Columns="1" ColumnWidth="210" ColumnPositions.Text="0" Duplex="dmSimplex" LargeDesignHeight="True" PrintOnPreviousPage="True" HGuides.Text="" VGuides.Text="876,85096&#13;&#10;158,74026">
    <TfrxMasterData Name="Band4" Height="14,36220424" Left="0" Top="200,31509" Width="253,22851" Columns="1" ColumnWidth="200" ColumnGap="20" DataSet="oDM." DataSetName="Tabela" RowCount="0" Stretched="True">
      <TfrxMemoView Name="Descricao" Left="2,04731" Top="0" Width="101,669357" Height="11,33858024" ShowHint="False" StretchMode="smActualHeight" DataSetName="Vendas_Periodo" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haBlock" ParentFont="False" WordWrap="False" Text="[Tabela.&#34;Produto_Nome&#34;]"/>
      <TfrxMemoView Name="Codigo" Left="103,3859" Top="0" Width="25,055195" Height="11,33858024" ShowHint="False" DataSetName="Vendas_Periodo" Font.Charset="1" Font.Color="0" Font.Height="-9" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" WordWrap="False" Text="[Tabela.&#34;Produto_Codigo&#34;]"/>
      <TfrxMemoView Name="Und" Left="181,03937008" Top="0" Width="18,519697" Height="11,33858024" ShowHint="False" StretchMode="smActualHeight" DataField="Unidade_Abreviacao" DataSet="oDM." DataSetName="Tabela" Font.Charset="1" Font.Color="-16777208" Font.Height="-9" Font.Name="Arial" Font.Style="0" ParentFont="False" WordWrap="False" Text="[Tabela.&#34;Unidade_Abreviacao&#34;]"/>
      <TfrxMemoView Name="Quantidade" Left="128,31509" Top="0" Width="49,511843" Height="11,33858024" ShowHint="False" DataField="Quantidade" DataSet="oDM." DataSetName="Tabela" DisplayFormat.FormatStr="%2.3f" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-9" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" WordWrap="False" Text="[Tabela.&#34;Quantidade&#34;]"/>
      <TfrxMemoView Name="TabelaPreco_Venda" Left="201,960761" Top="0" Width="43,464595" Height="11,33858024" ShowHint="False" DataSet="oDM." DataSetName="Tabela" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-9" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" WordWrap="False" Text="[&#60;Tabela.&#34;Preco_Venda&#34;&#62;*&#60;Tabela.&#34;Quantidade&#34;&#62;]"/>
    </TfrxMasterData>
    <TfrxFooter Name="Footer1" Height="41,196877" Left="0" Top="238,11039" Width="253,22851" Stretched="True">
      <TfrxSysMemoView Name="SysMemo1" Left="93,48825" Top="2" Width="151,937106" 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" Frame.Typ="4" HAlign="haRight" ParentFont="False" VAlign="vaCenter" WordWrap="False" Text="[SUM(&#60;Tabela.&#34;Preco_Venda&#34;&#62;*&#60;Tabela.&#34;Quantidade&#34;&#62;,Band4,2)]"/>
      <TfrxMemoView Name="Memo7" Left="0,04731" Top="2" Width="105,425201" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="4" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="Total (R$): "/>
      <TfrxMemoView Name="Memo4" Left="0,04731" Top="21,89765" Width="246,00804" Height="15,11812" ShowHint="False" URL="[Autor_Site]" Font.Charset="1" Font.Color="16711680" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="4" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[Autor_Site]"/>
    </TfrxFooter>
    <TfrxReportTitle Name="ReportTitle1" Height="122,09462" Left="0" Top="18,89765" Width="253,22851" Stretched="True">
      <TfrxMemoView Name="Memo1" Left="0,370037" Top="97,96073" Width="245,66897157" Height="15,11812" OnAfterData="Memo5OnAfterData" ShowHint="False" Font.Charset="1" Font.Color="128" Font.Height="-9" Font.Name="Arial" Font.Style="1" Frame.Typ="12" ParentFont="False" VAlign="vaCenter" Text=""/>
      <TfrxMemoView Name="Nome_Fantasia" Left="2,417347" Top="1,55906" Width="238,44898" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-15" Font.Name="Arial" Font.Style="1" ParentFont="False" VAlign="vaBottom" Text="[Nome_Fantasia]"/>
      <TfrxMemoView Name="Emissao" Left="2,417347" Top="81,716574" Width="238,44898" Height="14,716543" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-12" Font.Name="Arial" Font.Style="1" ParentFont="False" VAlign="vaCenter" Text="EmissÃ£o: [Date] -  [Time]"/>
      <TfrxMemoView Name="Memo5" Left="2,417347" Top="97,96073" Width="101,669357" Height="15,11812" ShowHint="False" Font.Charset="1" Font.Color="128" Font.Height="-9" Font.Name="Arial" Font.Style="1" ParentFont="False" VAlign="vaCenter" Text="DescriÃ§Ã£o do Produto"/>
      <TfrxMemoView Name="Memo6" Left="103,755937" Top="97,96073" Width="25,055195" Height="15,11812" ShowHint="False" Font.Charset="1" Font.Color="128" Font.Height="-9" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" VAlign="vaCenter" Text="CÃ³d"/>
      <TfrxMemoView Name="Titulo1" Left="2,417347" Top="23,55646267" Width="238,44898" Height="14,716543" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-12" Font.Name="Arial" Font.Style="1" ParentFont="False" VAlign="vaCenter" Text="[Titulo1]"/>
      <TfrxMemoView Name="Memo14" Left="181,519759" Top="97,96073" Width="18,89765" Height="15,11812" ShowHint="False" Font.Charset="1" Font.Color="128" Font.Height="-9" Font.Name="Arial" Font.Style="1" ParentFont="False" VAlign="vaCenter" Text="Un"/>
      <TfrxMemoView Name="Memo3" Left="128,685127" Top="97,96073" Width="49,511843" Height="15,11812" ShowHint="False" Font.Charset="1" Font.Color="128" Font.Height="-9" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="Qtd"/>
      <TfrxMemoView Name="Memo8" Left="200,818986" Top="97,96073" Width="44,976407" Height="15,11812" ShowHint="False" Font.Charset="1" Font.Color="128" Font.Height="-9" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="Valor(R$)"/>
      <TfrxMemoView Name="Memo9" Left="2,417347" Top="37,8464905" Width="238,44898" Height="14,716543" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-12" Font.Name="Arial" Font.Style="1" ParentFont="False" VAlign="vaCenter" Text="[Titulo2]"/>
      <TfrxMemoView Name="Memo10" Left="2,417347" Top="52,13651834" Width="238,44898" Height="14,716543" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-12" Font.Name="Arial" Font.Style="1" ParentFont="False" VAlign="vaCenter" Text="[Titulo3]"/>
      <TfrxMemoView Name="Memo11" Left="2,417347" Top="66,42654617" Width="238,44898" Height="14,716543" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-12" Font.Name="Arial" Font.Style="1" ParentFont="False" VAlign="vaCenter" Text="[Titulo4]"/>
    </TfrxReportTitle>
  </TfrxReportPage>
</TfrxReport>
