0 SQL 5ab246e2-24f8-46ad-86b7-f292e4a9131a DummyDataSource true CodCentrosCusto System.String CentrosCusto System.String CodFuncionarios System.String Funcionario System.String CodGrupo System.String Grupo System.String MesOrdem System.String MesAno System.String Valor System.String CustoMedio System.String Despesa System.String OutrasReceitas System.String DummyDataSource true CodNaturezas System.String Natureza System.String MesOrdem System.String MesAno System.String Valor System.String CustoMedio System.String DummyDataSource true Campo System.String Valor System.String 2.60586cm 9.23393cm 0.4cm true true Filtros: 0.3pt #e8e8e8 2pt 2pt 2pt 2 0.4cm true true =Fields!Campo.Value 0.3pt =IIf(((RowNumber(nothing) mod 2) =0), "White", "Gainsboro") 2pt 2pt 2pt true true =Fields!Valor.Value 0.3pt =IIf(((RowNumber(nothing) mod 2) =0), "White", "Gainsboro") 2pt 2pt 2pt After dsFiltros =Fields!Campo.Value 9.79881cm 0.07938cm 0.8cm 11.83979cm 0.3cm true true 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt 2.3cm 2.5cm 1.23cm 0.4cm true true Textbox19 0.3pt 2pt 2pt 0.5pt true true Textbox130 0.3pt 2pt 2pt 0.5pt true true Textbox24 0.3pt 2pt 2pt 0.5pt 0.4cm true true =Sum(Fields!Valor.Value) Valor2 0.3pt 2pt 2pt 0.5pt true true =Sum(Fields!Valor.Value) Valor2 0.3pt 2pt 2pt 0.5pt true true =Format((100 - (Sum(Fields!CustoMedio.Value) / Sum(Fields!Valor.Value) * 100)), "###,##0.00") Textbox26 0.3pt 2pt 2pt 0.5pt 0.4cm true true =Sum(Fields!CustoMedio.Value) CustoMedio1 0.3pt 2pt 2pt 0.5pt true true =Sum(Fields!CustoMedio.Value) CustoMedio1 0.3pt 2pt 2pt 0.5pt true true Textbox27 0.3pt 2pt 2pt 0.5pt 0.4cm true true =Fields!Valor.Value Valor1 0.3pt 2pt 2pt 0.5pt true true =Sum(Fields!Valor.Value) Valor2 0.3pt 2pt 2pt 0.5pt true true Textbox29 0.3pt 2pt 2pt 0.5pt 0.4cm true true =Fields!CustoMedio.Value CustoMedio 0.3pt 2pt 2pt 0.5pt true true =Sum(Fields!CustoMedio.Value) CustoMedio1 0.3pt 2pt 2pt 0.5pt true true Textbox31 0.3pt 2pt 2pt 0.5pt 0.17667cm true true Textbox14 0.3pt 2pt 2pt 0.5pt true true Textbox15 0.3pt 2pt 2pt 0.5pt true true Textbox36 0.3pt 2pt 2pt 0.5pt 0.4cm true true =Sum(Fields!Valor.Value) Valor2 0.3pt 2pt 2pt 0.5pt true true =Sum(Fields!Valor.Value) Valor2 0.3pt 2pt 2pt 0.5pt true true =iif(Sum(Fields!Valor.Value) > 0, "100 %", "") Textbox38 0.3pt 2pt 2pt 0.5pt 0.4cm true true =Sum(Fields!CustoMedio.Value) CustoMedio1 0.3pt 2pt 2pt 0.5pt true true =Sum(Fields!CustoMedio.Value) CustoMedio1 0.3pt 2pt 2pt 0.5pt true true =IIf(Sum(Fields!Valor.Value) > 0, (Sum(Fields!CustoMedio.Value) / (Sum(Fields!Valor.Value) + 0.001)) * 100, "") Textbox40 0.3pt 2pt 2pt 0.5pt 0.4cm true true =Sum(Fields!Valor.Value) - Sum(Fields!CustoMedio.Value) Textbox80 0.3pt 2pt 2pt 0.5pt true true =Sum(Fields!Valor.Value) - Sum(Fields!CustoMedio.Value) Textbox80 0.3pt 2pt 2pt 0.5pt true true =IIf(Sum(Fields!Valor.Value) > 0, (Sum(Sum(Fields!Valor.Value) - Sum(Fields!CustoMedio.Value)) / (Sum(Fields!Valor.Value) + 0.001)) * 100, "") Textbox45 0.3pt 2pt 2pt 0.5pt 0.4cm true true =Sum(Fields!Despesa.Value) Despesa1 0.3pt 2pt 2pt 0.5pt true true =Sum(Fields!Despesa.Value) Despesa1 0.3pt 2pt 2pt 0.5pt true true =IIf(Sum(Fields!Valor.Value) > 0, (Sum(Fields!Despesa.Value) / (Sum(Fields!Valor.Value) + 0.001)) * 100, "") Textbox46 0.3pt 2pt 2pt 0.5pt 0.4cm true true =(Sum(Fields!Valor.Value) - Sum(Fields!CustoMedio.Value)) - Sum(Fields!Despesa.Value) Textbox10 0.3pt 2pt 2pt 0.5pt true true =(Sum(Fields!Valor.Value) - Sum(Fields!CustoMedio.Value)) - Sum(Fields!Despesa.Value) Textbox10 0.3pt 2pt 2pt 0.5pt true true =IIf(Sum(Fields!Valor.Value) > 0, (Sum((Sum(Fields!Valor.Value) - Sum(Fields!CustoMedio.Value)) - Sum(Fields!Despesa.Value)) / (Sum(Fields!Valor.Value) + 0.001)) * 100, "") Textbox47 0.3pt 2pt 2pt 0.5pt 0.25604cm true true Textbox52 0.3pt 2pt 2pt 0.5pt true true Textbox137 0.3pt 2pt 2pt 0.5pt true true Textbox48 0.3pt 2pt 2pt 0.5pt 0.4cm true true Textbox66 0.3pt 2pt 2pt 0.5pt true true Textbox67 0.3pt LightGrey 2pt 2pt 0.5pt true true Textbox68 0.3pt Black LightGrey LightGrey Black 2pt 2pt 0.5pt 0.4cm true true =Sum(Fields!Valor.Value) Valor2 0.3pt 2pt 2pt 0.5pt true true =Sum(Fields!Valor.Value) Valor2 0.3pt LightGrey 2pt 2pt 0.5pt true true =iif(Sum(Fields!Valor.Value) > 0, "100 %", "") Textbox49 0.3pt LightGrey LightGrey Black 2pt 2pt 0.5pt 0.4cm true true =Sum(Fields!CustoMedio.Value) CustoMedio1 0.3pt 2pt 2pt 0.5pt true true =Sum(Fields!CustoMedio.Value) CustoMedio1 0.3pt LightGrey 2pt 2pt 0.5pt true true =IIf(Sum(Fields!Valor.Value) > 0, (Sum(Fields!CustoMedio.Value) / (Sum(Fields!Valor.Value) + 0.001)) * 100, "") Textbox54 0.3pt LightGrey LightGrey Black 2pt 2pt 0.5pt 0.4cm true true =Sum(Fields!Valor.Value) - Sum(Fields!CustoMedio.Value) Textbox80 0.3pt 2pt 2pt 0.5pt true true =Sum(Fields!Valor.Value) - Sum(Fields!CustoMedio.Value) Textbox80 0.3pt LightGrey 2pt 2pt 0.5pt true true =Microsoft.VisualBasic.Interaction.IIf(Sum(Fields!Valor.Value) > 0, (Sum(Sum(Fields!Valor.Value) - Sum(Fields!CustoMedio.Value)) / (Sum(Fields!Valor.Value) + 0.001)) * 100, "") Textbox45 0.3pt Black 2pt 2pt 0.5pt 0.4cm true true =Sum(Fields!OutrasReceitas.Value) OutrasReceitas 0.3pt 2pt 2pt 0.5pt true true =Sum(Fields!OutrasReceitas.Value) OutrasReceitas 0.3pt LightGrey 2pt 2pt 0.5pt true true Textbox58 0.3pt LightGrey LightGrey Black 2pt 2pt 0.5pt 0.4cm true true =Sum(Fields!Despesa.Value) Despesa1 0.3pt 2pt 2pt 0.5pt true true =Sum(Fields!Despesa.Value) Despesa1 0.3pt LightGrey Black 2pt 2pt 0.5pt true true =Microsoft.VisualBasic.Interaction.IIf(Sum(Fields!Valor.Value) > 0, (Sum(Fields!Despesa.Value) / (Sum(Fields!Valor.Value) + 0.001)) * 100, "") Textbox46 0.3pt Black 2pt 2pt 0.5pt 0.4cm true true =(Sum(Fields!Valor.Value) - Sum(Fields!CustoMedio.Value) + Sum(Fields!OutrasReceitas.Value)) - Sum(Fields!Despesa.Value) Textbox10 0.3pt Black LightGrey 2pt 2pt 0.5pt true true =(Sum(Fields!Valor.Value) - Sum(Fields!CustoMedio.Value) + Sum(Fields!OutrasReceitas.Value)) - Sum(Fields!Despesa.Value) Textbox10 0.3pt LightGrey Black 2pt 2pt 0.5pt true true =Microsoft.VisualBasic.Interaction.IIf(Sum(Fields!Valor.Value) > 0, (Sum(Sum(Fields!Valor.Value) - Sum(Fields!CustoMedio.Value) + Sum(Fields!OutrasReceitas.Value) - Sum(Fields!Despesa.Value)) / (Sum(Fields!Valor.Value) + 0.001)) * 100, "") Textbox47 0.3pt Black Black 2pt 2pt 0.5pt =Fields!MesAno.Value =Fields!MesOrdem.Value 0.6cm true true =Fields!MesAno.Value MesAno 2pt 2pt 2pt 2pt 0.6cm true true Total Textbox129 2pt 2pt 2pt 2pt 0.6cm true true MC % Textbox23 2pt 2pt 2pt 2pt =Fields!CodCentrosCusto.Value =Fields!CentrosCusto.Value 0.07938cm true true 2pt 2pt 2pt 2pt 7.06021cm true true =Fields!CentrosCusto.Value 0.3pt 2pt 2pt 0.5pt After =Fields!CodFuncionarios.Value =Fields!Funcionario.Value 0.86021cm true true 0.3pt 2pt 2pt 0.5pt true 6.2cm true true =Fields!Funcionario.Value 0.3pt 2pt 2pt 0.5pt After 6.2cm true true 0.3pt 2pt 2pt 0.5pt =Parameters!OcultarCustosVendas.Value = True After =Fields!CodGrupo.Value =Fields!Grupo.Value 0.86021cm true true 0.3pt 2pt 2pt 0.5pt 5.33979cm true true =Fields!Grupo.Value 0.3pt 2pt 2pt 0.5pt =Ucase(Parameters!MostrarGrupos.Value) = "FALSE" =Ucase(Parameters!MostrarGrupos.Value) = "FALSE" 0.86021cm true true 0.3pt 2pt 2pt 0.5pt 5.33979cm true true 0.3pt 2pt 2pt 0.5pt =Ucase(Parameters!MostrarGrupos.Value) = "FALSE" Before =Ucase(Parameters!OcultarVendedores.Value) = "TRUE" Or Sum(Fields!Valor.Value) = 0 0.86021cm true true 0.3pt 2pt 2pt 0.5pt 6.2cm true true Total Vendas: 0.3pt 2pt 2pt 0.5pt Before 0.86021cm true true 0.3pt 2pt 2pt 0.5pt 6.2cm true true Total Custo Vendas: 0.3pt 2pt 2pt 0.5pt =Parameters!OcultarCustosVendas.Value = True Before 0.86021cm true true 0.3pt 2pt 2pt 0.5pt 6.2cm true true Resultado Bruto Vendas: 0.3pt 2pt 2pt 0.5pt =Parameters!OcultarCustosVendas.Value = True Before 0.86021cm true true 0.3pt 2pt 2pt 0.5pt 6.2cm true true Despesas Operacional 0.3pt 2pt 2pt 0.5pt =Parameters!OcultarDespesas.Value = true Before 0.86021cm true true 0.3pt 2pt 2pt 0.5pt 6.2cm true true Resultado Líquido: 0.3pt 2pt 2pt 0.5pt =Parameters!OcultarDespesas.Value = true Before 0.86021cm true true 0.3pt 2pt 2pt 0.5pt 0.86021cm true true 0.3pt 2pt 2pt 0.5pt 5.33979cm true true Textbox65 0.3pt 2pt 2pt 0.5pt Before 0.07938cm true true 2pt 2pt 2pt 2pt 7.06021cm true true TOTAL GERAL 0.3pt 2pt 2pt 0.5pt Before 0.07938cm true true 2pt 2pt 2pt 2pt 0.86021cm true true 0.3pt 2pt 2pt 0.5pt 6.2cm true true Total Geral Vendas: 0.3pt 2pt 2pt 0.5pt Before 0.07938cm true true 2pt 2pt 2pt 2pt 0.86021cm true true 0.3pt 2pt 2pt 0.5pt 6.2cm true true Total Geral CustoVendas: 0.3pt 2pt 2pt 0.5pt =Parameters!OcultarCustosVendas.Value = True Before 0.07938cm true true 2pt 2pt 2pt 2pt 0.86021cm true true 0.3pt 2pt 2pt 0.5pt 6.2cm true true Total Geral Resultado: 0.3pt 2pt 2pt 0.5pt =Parameters!OcultarCustosVendas.Value = True Before 0.07938cm true true 2pt 2pt 2pt 2pt 0.86021cm true true 0.3pt 2pt 2pt 0.5pt 6.2cm true true Total Geral Outras Receitas: 0.3pt 2pt 2pt 0.5pt =Parameters!OcultarOutrasReceitas.Value = true Before 0.07938cm true true 2pt 2pt 2pt 2pt 0.86021cm true true 0.3pt 2pt 2pt 0.5pt 6.2cm true true Total Geral Despesas Operacionais: 0.3pt 2pt 2pt 0.5pt =Parameters!OcultarDespesas.Value = true Before 0.07938cm true true 2pt 2pt 2pt 2pt 0.86021cm true true 0.3pt 2pt 2pt 0.5pt 6.2cm true true Total Geral Resultado Líquido: 0.3pt 2pt 2pt 0.5pt =Parameters!OcultarDespesas.Value = true Before dtAnaliseVendas 0.127cm 7.83271cm 13.16959cm 1 true true Resumo de Naturezas de Operação Textbox9 0.3pt 2pt 2pt 0.5pt 2 2.3cm 2.5cm 0.4cm true true =Sum(Fields!Valor.Value) Valor2 0.3pt 2pt 2pt 0.5pt true true =Sum(Fields!Valor.Value) Valor2 0.3pt 2pt 2pt 0.5pt 0.4cm true true =Sum(Fields!CustoMedio.Value) CustoMedio1 0.3pt 2pt 2pt 0.5pt true true =Sum(Fields!CustoMedio.Value) CustoMedio1 0.3pt 2pt 2pt 0.5pt =Fields!MesAno.Value =Fields!MesOrdem.Value 0.6cm true true =Fields!MesAno.Value MesAno1 0.3pt 2pt 2pt 0.5pt 0.6cm true true Total Textbox25 0.3pt 2pt 2pt 0.5pt =Fields!CodNaturezas.Value =Fields!Natureza.Value 1.28292cm true true =Fields!CodNaturezas.Value 0.3pt 2pt 2pt 0.5pt 5.82146cm true true =Fields!Natureza.Value 0.3pt 2pt 2pt 0.5pt 5.82146cm true true 0.3pt 2pt 2pt 0.5pt dtAnaliseVendasNaturezas 8.18737cm 0.07938cm 1.4cm 11.90438cm 2 =Parameters!OcultarResumoNaturezas.Value = True 4.17276in =Parameters!Periodo.Value Textbox1 1.62698cm 0.49417cm 13.16959cm External =Parameters!LogoMenor.Value FitProportional 0.07938cm 1.52672cm 5.14717cm 1 0.30896cm true true true true =Now() & " Pag: " & Globals!PageNumber & " de " & Globals!TotalPages Textbox4 0.30896cm 6.6275cm 29.7cm 21cm 0.5cm 0.5cm 0.5cm 0.5cm 0.13cm