<?xml version="1.0" encoding="utf-8" standalone="no"?>
<TfrxReport Version="6.7.9" DotMatrixReport="False" EngineOptions.SilentMode="True" EngineOptions.NewSilentMode="simSilent" EngineOptions.UseFileCache="True" IniFile="\Software\Fast Reports" PreviewOptions.AllowEdit="False" PreviewOptions.Buttons="167935" PreviewOptions.Zoom="1" PrintOptions.Printer="Padrão" PrintOptions.PrintOnSheet="0" ReportOptions.CreateDate="43487,3236286458" ReportOptions.Description.Text="" ReportOptions.LastChange="45103,4594525116" ScriptLanguage="PascalScript" ScriptText.Text="&#13;&#10;begin&#13;&#10;&#13;&#10;end." ShowProgress="False" StoreInDFM="False">
  <Datasets>
    <item DataSet="tbRelatorio" DataSetName="tbRelatorio"/>
    <item DataSet="QryEmpresa" DataSetName="QryEmpresa"/>
  </Datasets>
  <Variables>
    <item Name=" Sisplan"/>
    <item Name="Empresa" Value="'_001'"/>
    <item Name="Layout" Value="'RelAnaliseVendedorPadrao.FR3'"/>
    <item Name="PastaFotos" Value="'P:\Sisplan\projeto\Foto'"/>
    <item Name="Usuario" Value="'SISPLAN'"/>
    <item Name="emp_id" Value="'1'"/>
    <item Name="DEPOSITO" Value="''"/>
    <item Name="TIPOPRODUTO" Value="''"/>
    <item Name="EMITIDO" Value="'true'"/>
    <item Name="SUBGRUPO" Value="''"/>
    <item Name="ETIQUETA" Value="''"/>
    <item Name="COLECAO" Value="''"/>
    <item Name="ORDEM_ORDENACAO" Value="'0'"/>
    <item Name="TELA_ORDENACAO" Value="'RelAnaliseVendedor'"/>
    <item Name="DATAINI" Value="'2023-01-01'"/>
    <item Name="FORNECEDOR" Value="''"/>
    <item Name="USAMATERIAL" Value="'false'"/>
    <item Name="GUIA" Value="''"/>
    <item Name="CLIENTE" Value="''"/>
    <item Name="TABELA" Value="''"/>
    <item Name="DEVOLVIDO" Value="'true'"/>
    <item Name="USR_CAIXA" Value="''"/>
    <item Name="GRUPO" Value="''"/>
    <item Name="CODIGO" Value="''"/>
    <item Name="LINHA" Value="''"/>
    <item Name="TIPO_VENDA" Value="''"/>
    <item Name="MARCA" Value="''"/>
    <item Name="PENDENTE" Value="'false'"/>
    <item Name="VENDEDOR" Value="''"/>
    <item Name="DATAFIM" Value="'2023-06-26'"/>
  </Variables>
  <TfrxDataPage Name="Data" Height="1000" Left="0" Top="0" Width="1000">
    <TfrxFDDatabase Name="Conexao" DriverName="FB" DatabaseName="d:/dados/Bases/11554F.FDB" Params.Text="Protocol=TCPIP&#13;&#10;Database=d:/dados/Bases/11554F.FDB&#13;&#10;Server=172.20.10.204&#13;&#10;Port=3051&#13;&#10;user_name=SYSDBA&#13;&#10;password=masterkey&#13;&#10;MonitorBy=Remote&#13;&#10;DriverID=FB&#13;&#10;CharacterSet=UTF8" LoginPrompt="False" Connected="false" PropData="05704C65667402280470546F700214"/>
    <TfrxFDQuery Name="QryEmpresa" UserName="QryEmpresa" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="SELECT * FROM EMPRESA WHERE EMP_ID = :EMP_ID  " MacroCreate="True" MacroExpand="True" ReadOnly="False" Database="Conexao" Left="120" Top="156">
      <Parameters>
        <item Name="EMP_ID" DataType="ftInteger" Expression="&#60;emp_id&#62;"/>
      </Parameters>
    </TfrxFDQuery>
  </TfrxDataPage>
  <TfrxReportPage Name="Page1" PaperWidth="210" PaperHeight="297" PaperSize="9" LeftMargin="5" RightMargin="5" TopMargin="5" BottomMargin="5" ColumnWidth="0" ColumnPositions.Text="" Frame.Typ="0" MirrorMode="0" HGuides.Text="" VGuides.Text="">
    <TfrxMasterData Name="MasterData1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="15,11812" Left="0" Top="253,22851" Width="755,906" ColumnWidth="0" ColumnGap="0" DataSet="tbRelatorio" DataSetName="tbRelatorio" RowCount="0">
      <TfrxMemoView Name="Memo22" AllowVectorExport="True" Left="0" Top="0" Width="755,906" Height="15,11812" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Style="fsDot" Frame.Typ="8" Frame.Width="0,5" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text=""/>
      <TfrxMemoView Name="Memo7" AllowVectorExport="True" Left="351,49629" Top="0" Width="71,81107" Height="15,11812" DataField="QUANTIDADE" DataSet="tbRelatorio" DataSetName="tbRelatorio" DisplayFormat.FormatStr="%2.0n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[tbRelatorio.&#34;QUANTIDADE&#34;]"/>
      <TfrxMemoView Name="Memo8" AllowVectorExport="True" Left="423,30736" Top="0" Width="71,81107" Height="15,11812" DataField="VALOR" DataSet="tbRelatorio" DataSetName="tbRelatorio" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[tbRelatorio.&#34;VALOR&#34;]"/>
      <TfrxMemoView Name="Memo9" AllowVectorExport="True" Left="495,11843" Top="0" Width="83,14966" Height="15,11812" DataField="VENDAS" DataSet="tbRelatorio" DataSetName="tbRelatorio" DisplayFormat.FormatStr="%2.0n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[tbRelatorio.&#34;VENDAS&#34;]"/>
      <TfrxMemoView Name="Memo10" AllowVectorExport="True" Left="578,26809" Top="0" Width="64,25201" Height="15,11812" DataField="VM" DataSet="tbRelatorio" DataSetName="tbRelatorio" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[tbRelatorio.&#34;VM&#34;]"/>
      <TfrxMemoView Name="Memo11" AllowVectorExport="True" Left="642,5201" Top="0" Width="64,25201" Height="15,11812" DataField="PA" DataSet="tbRelatorio" DataSetName="tbRelatorio" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[tbRelatorio.&#34;PA&#34;]"/>
      <TfrxMemoView Name="Memo12" AllowVectorExport="True" Left="706,77211" Top="0" Width="49,13389" Height="15,11812" DataField="TICKET_MEDIO" DataSet="tbRelatorio" DataSetName="tbRelatorio" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[tbRelatorio.&#34;TICKET_MEDIO&#34;]"/>
      <TfrxMemoView Name="Memo14" AllowVectorExport="True" Left="0,77953" Top="0" Width="351,49629" Height="15,11812" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[tbRelatorio.&#34;CODREP&#34;] - [tbRelatorio.&#34;NOME_REPRESEN&#34;]"/>
    </TfrxMasterData>
    <TfrxPageFooter Name="PageFooter1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="15,11812" Left="0" Top="374,17347" Width="755,906">
      <TfrxMemoView Name="Memo1" AllowVectorExport="True" Left="0" Top="3,77953" Width="755,906" Height="11,33859" Font.Charset="1" Font.Color="-16777208" Font.Height="-8" Font.Name="Arial" Font.Style="0" Frame.Typ="4" HAlign="haRight" ParentFont="False" VAlign="vaCenter" Text="Sisplan Sistemas e Planejamento LTDA - (47) 3380-6100 - www.sisplansistemas.com.br"/>
    </TfrxPageFooter>
    <TfrxPageHeader Name="PageHeader1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="149,48825" Left="0" Top="18,89765" Width="755,906">
      <TfrxMemoView Name="Memo4" AllowVectorExport="True" Left="0" Top="39,45671" Width="755,906" Height="26,45671" DataSetName="tbEmpresa" Font.Charset="1" Font.Color="-16777208" Font.Height="-16" Font.Name="Arial" Font.Style="5" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="RELATÓRIO DE ANÁLISE DE VENDEDOR - PADRÃO"/>
      <TfrxMemoView Name="tbEmpresaEMP_NOME" AllowVectorExport="True" Left="0" Top="13,77953" Width="755,906" Height="26,45671" DataSetName="tbEmpresa" Font.Charset="1" Font.Color="-16777208" Font.Height="-15" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="[QryEmpresa.&#34;EMP_NOME&#34;]">
        <Formats>
          <item/>
          <item/>
        </Formats>
      </TfrxMemoView>
      <TfrxShapeView Name="Shape1" AllowVectorExport="True" Left="0" Top="133,94496" Width="755,906" Height="15,11812" Fill.BackColor="-16777201" Frame.Typ="0" Shape="skRoundRectangle"/>
      <TfrxPictureView Name="Picture1" AllowVectorExport="True" Left="0" Top="0" Width="139,84261" Height="94,48825" Center="True" DataField="EMP_LOGO" DataSet="QryEmpresa" DataSetName="QryEmpresa" Frame.Typ="0" HightQuality="True" Transparent="False" TransparentColor="16777215"/>
      <TfrxMemoView Name="Memo16" AllowVectorExport="True" Left="0,77953" Top="134,16543" Width="351,49629" Height="15,11812" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" VAlign="vaCenter" Text="Representante"/>
      <TfrxMemoView Name="Memo17" AllowVectorExport="True" Left="351,49629" Top="134,16543" Width="71,81107" Height="15,11812" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haRight" ParentFont="False" VAlign="vaCenter" Text="Qtde. Peças"/>
      <TfrxMemoView Name="Memo18" AllowVectorExport="True" Left="423,30736" Top="134,16543" Width="71,81107" Height="15,11812" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haRight" ParentFont="False" VAlign="vaCenter" Text="Valor"/>
      <TfrxMemoView Name="Memo19" AllowVectorExport="True" Left="495,11843" Top="134,16543" Width="83,14966" Height="15,11812" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haRight" ParentFont="False" VAlign="vaCenter" Text="Qtde. Vendas"/>
      <TfrxMemoView Name="Memo20" AllowVectorExport="True" Left="706,77211" Top="134,16543" Width="49,13389" Height="15,11812" Font.Charset="1" Font.Color="255" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haRight" ParentFont="False" VAlign="vaCenter" Text="T.M."/>
      <TfrxMemoView Name="Memo21" AllowVectorExport="True" Left="642,5201" Top="134,16543" Width="64,25201" Height="15,11812" Font.Charset="1" Font.Color="52376" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haRight" ParentFont="False" VAlign="vaCenter" Text="P.A."/>
      <TfrxMemoView Name="Memo13" AllowVectorExport="True" Left="578,26809" Top="134,16543" Width="64,25201" Height="15,11812" Font.Charset="1" Font.Color="16711680" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haRight" ParentFont="False" VAlign="vaCenter" Text="P.M. Peças"/>
      <TfrxMemoView Name="Memo23" AllowVectorExport="True" Left="569,60668" Top="75,5906" Width="185,19697" Height="18,89765" Font.Charset="1" Font.Color="16711680" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="P.M. Peças = Preço Médio de Peças"/>
      <TfrxMemoView Name="Memo24" AllowVectorExport="True" Left="569,60668" Top="94,48825" Width="185,19697" Height="18,89765" Font.Charset="1" Font.Color="52376" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="P.A = Peças por Atendimento"/>
      <TfrxMemoView Name="Memo25" AllowVectorExport="True" Left="569,60668" Top="113,3859" Width="185,19697" Height="18,89765" Font.Charset="1" Font.Color="255" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="T.M = Ticket Médio por Venda"/>
    </TfrxPageHeader>
    <TfrxHeader Name="Header1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="0" Left="0" Top="230,55133" Width="755,906"/>
    <TfrxFooter Name="Footer1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="22,67718" Left="0" Top="291,02381" Width="755,906">
      <TfrxMemoView Name="Memo26" AllowVectorExport="True" Left="0" Top="0" Width="351,49629" Height="15,11812" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="Totais:"/>
      <TfrxMemoView Name="Memo27" AllowVectorExport="True" Left="351,49629" Top="0" Width="71,81107" Height="15,11812" DataSet="tbRelatorio" DataSetName="tbRelatorio" DisplayFormat.FormatStr="%2.0n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[SUM(&#60;tbRelatorio.&#34;QUANTIDADE&#34;&#62;,MasterData1)]"/>
      <TfrxMemoView Name="Memo28" AllowVectorExport="True" Left="423,30736" Top="0" Width="71,81107" Height="15,11812" DataSet="tbRelatorio" DataSetName="tbRelatorio" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[SUM(&#60;tbRelatorio.&#34;VALOR&#34;&#62;,MasterData1,1)]"/>
      <TfrxMemoView Name="Memo29" AllowVectorExport="True" Left="495,11843" Top="0" Width="83,14966" Height="15,11812" DataSet="tbRelatorio" DataSetName="tbRelatorio" DisplayFormat.FormatStr="%2.0n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[SUM(&#60;tbRelatorio.&#34;VENDAS&#34;&#62;,MasterData1,1)]"/>
      <TfrxMemoView Name="Memo30" AllowVectorExport="True" Left="578,26809" Top="0" Width="64,25201" Height="15,11812" DataSet="tbRelatorio" DataSetName="tbRelatorio" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[(SUM(&#60;tbRelatorio.&#34;VALOR&#34;&#62;, MasterData1,1)/SUM(&#60;tbRelatorio.&#34;QUANTIDADE&#34;&#62;, MasterData1,1))]"/>
      <TfrxMemoView Name="Memo31" AllowVectorExport="True" Left="642,5201" Top="0" Width="64,25201" Height="15,11812" DataSet="tbRelatorio" DataSetName="tbRelatorio" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[(SUM(&#60;tbRelatorio.&#34;QUANTIDADE&#34;&#62;, MasterData1,1)/SUM(&#60;tbRelatorio.&#34;VENDAS&#34;&#62;, MasterData1,1))]"/>
      <TfrxMemoView Name="Memo32" AllowVectorExport="True" Left="706,77211" Top="0" Width="49,13389" Height="15,11812" DataSet="tbRelatorio" DataSetName="tbRelatorio" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[(SUM(&#60;tbRelatorio.&#34;VALOR&#34;&#62;, MasterData1,1)/SUM(&#60;tbRelatorio.&#34;VENDAS&#34;&#62;, MasterData1,1))]"/>
    </TfrxFooter>
  </TfrxReportPage>
</TfrxReport>
