0 SQL 5ab246e2-24f8-46ad-86b7-f292e4a9131a DummyDataSource true CodNotas System.String NumeroNota System.String DataEmissaoNota System.String CodClientes System.Int Cliente System.String Funcionario System.String Natureza System.String CodProdutos System.String Referencia System.String Produto System.String CodGrupo System.String Grupo System.String EstoqueAtual System.Decimal QuantidadeVendida System.Decimal QuantidadeDevolvida System.Decimal Custo System.Decimal PrecoMedio System.Decimal ValorST System.Decimal ValorTotalCusto System.Decimal ValorTotalVenda System.Decimal CustoDevolucao System.Decimal ValorDevolucao System.Decimal ValorLiquido System.Decimal MRK System.Decimal MC System.Decimal PrazoMedio System.Decimal PrazoMedioCompra System.Decimal CodPagamento System.Decimal TipoPagamento System.Decimal DataPagamento System.Decimal ValorPagamento System.Decimal CodBC System.Decimal DataBC System.Decimal ValorBC System.Decimal ValorICM System.Decimal ValorICMSSN System.Decimal ValorPis System.Decimal ValorCofins System.Decimal ValorISSQN System.Decimal ValorIRRF System.Decimal ValorINSS System.Decimal ValorCSLL System.Decimal ValorDiferencialAliquota System.Decimal ValorFCP System.Decimal ValorFCPICMS System.Decimal TotalMRK System.Decimal TotalMC System.Decimal ValorComplemento System.Decimal DummyDataSource true CodNatureza System.String Natureza System.String ValorTotal System.Decimal Custo System.Decimal valorDevolucao System.Decimal QuantidadeNotas System.Decimal ValorCustoDevolucao System.Decimal ValorImpostos System.Decimal ValorLiquido System.Decimal ValorComplemento System.Decimal DummyDataSource true CodVendedores System.String Vendedor System.String ValorTotal System.Decimal Custo System.Decimal valorDevolucao System.Decimal QuantidadeNotas System.Decimal ValorCustoDevolucao System.Decimal MRKVendedor System.Decimal MCVendedor System.Decimal TotalMRKVendedor System.Decimal TotalMCVendedor System.Decimal ValorImpostos System.Decimal ValorLiquido System.Decimal ValorComplemento System.Decimal DummyDataSource true Cod System.String Conta System.String Valor System.Decimal DummyDataSource true Filtro System.String DescricaoFiltro System.String 1.14206cm 1.90358cm 4.82237cm 1.6cm 1.6cm 0.93359cm 1.44cm 1.44cm 1.94cm 1.94cm 1.44cm 1.94cm 1.9cm 1.9cm 1.9cm 1.5cm 1.5cm 1.5cm 1.5cm 1.5cm 1.5cm 1.5cm 1.5cm 1.5cm 1.5cm 1.5cm 2.3cm 1.1cm 1.81476cm 1.15685cm 1.02456cm 0.4cm true true Grupo Textbox258 0.3pt #caebfc 2pt 2pt 2pt 6 true true =Parameters!Custo.Value Textbox12 0.3pt #caebfc 2pt 2pt 2pt true true Preco Med Textbox16 0.3pt #caebfc 2pt 2pt 2pt true true =Parameters!ValorTotalCusto.Value Textbox22 0.3pt #caebfc 2pt 2pt 2pt true true Tot Venda Textbox20 0.3pt #caebfc 2pt 2pt 2pt true true Custo Dev Textbox30 0.3pt #caebfc 2pt 2pt 2pt true true Vlr Devol Textbox26 0.3pt #caebfc 2pt 2pt 2pt true true Vlr Compl. Textbox17 0.3pt #caebfc 2pt 2pt 2pt true true Venda Líquida Textbox1 0.3pt #caebfc 2pt 2pt 2pt true true Custo Líquido Textbox10 0.3pt #caebfc 2pt 2pt 2pt true true ICMS Textbox87 0.3pt #caebfc 2pt 2pt 2pt true true ICMS SN Textbox121 0.3pt #caebfc 2pt 2pt 2pt true true Pis Textbox105 0.3pt #caebfc 2pt 2pt 2pt true true Cofins Textbox118 0.3pt #caebfc 2pt 2pt 2pt true true ISSQN Textbox114 0.3pt #caebfc 2pt 2pt 2pt true true IRRF Textbox109 0.3pt #caebfc 2pt 2pt 2pt true true INSS Textbox99 0.3pt #caebfc 2pt 2pt 2pt true true CSLL Textbox96 0.3pt #caebfc 2pt 2pt 2pt true true Difal Textbox93 0.3pt #caebfc 2pt 2pt 2pt true true FCP Textbox90 0.3pt #caebfc 2pt 2pt 2pt true true FCP ICMS Textbox82 0.3pt #caebfc 2pt 2pt 2pt true true Rent.Líquida Textbox24 0.3pt #caebfc 2pt 2pt 2pt true true Prazo Med. Textbox104 0.3pt #caebfc 2pt 2pt 2pt true true Prazo Med Compra Textbox200 0.3pt #caebfc 2pt 2pt 2pt true true MRK% Textbox18 0.3pt #caebfc 2pt 2pt 2pt true true MC% Textbox14 0.3pt #caebfc 2pt 2pt 2pt 0.4cm true true =Fields!Grupo.Value Grupo 0.3pt 2pt 2pt 2pt 6 true true =Sum(Fields!Custo.Value) Custo 0.3pt 2pt 2pt 2pt true true =Sum(Fields!PrecoMedio.Value) PrecoMedio 0.3pt 2pt 2pt 2pt true true =Sum(Fields!ValorTotalCusto.Value) ValorTotalCusto 0.3pt 2pt 2pt 2pt true true =Sum(Fields!ValorTotalVenda.Value) ValorTotalVenda 0.3pt 2pt 2pt 2pt true true =Sum(Fields!CustoDevolucao.Value) CustoDevolucao 0.3pt 2pt 2pt 2pt true true =Sum(Fields!ValorDevolucao.Value) ValorDevolucao 0.3pt 2pt 2pt 2pt true true =Sum(Fields!ValorComplemento.Value) ValorComplemento 0.3pt 2pt 2pt 2pt true true =Sum(Fields!ValorTotalVenda.Value) + Sum(Fields!ValorComplemento.Value) - Sum(Fields!ValorDevolucao.Value) Textbox2 0.3pt 2pt 2pt 2pt true true =Sum(Fields!ValorTotalCusto.Value) - Sum(Fields!CustoDevolucao.Value) Textbox11 0.3pt 2pt 2pt 2pt true true =Sum(Fields!ValorICM.Value) Textbox89 0.3pt 2pt 2pt 2pt true true =Sum(Fields!ValorICMSSN.Value) Textbox123 0.3pt 2pt 2pt 2pt true true =Sum(Fields!ValorPis.Value) Textbox107 0.3pt 2pt 2pt 2pt true true =Sum(Fields!ValorCofins.Value) Textbox120 0.3pt 2pt 2pt 2pt true true =Sum(Fields!ValorISSQN.Value) Textbox117 0.3pt 2pt 2pt 2pt true true =Sum(Fields!ValorIRRF.Value) Textbox112 0.3pt 2pt 2pt 2pt true true =Sum(Fields!ValorINSS.Value) Textbox104 0.3pt 2pt 2pt 2pt true true =Sum(Fields!ValorCSLL.Value) Textbox98 0.3pt 2pt 2pt 2pt true true =Sum(Fields!ValorDiferencialAliquota.Value) Textbox95 0.3pt 2pt 2pt 2pt true true =Sum(Fields!ValorFCP.Value) Textbox92 0.3pt 2pt 2pt 2pt true true =Sum(Fields!ValorFCPICMS.Value) Textbox86 0.3pt 2pt 2pt 2pt true true =Sum(Fields!ValorLiquido.Value) ValorLiquido 0.3pt 2pt 2pt 2pt true true =Sum(Fields!PrazoMedio.Value * Fields!ValorTotalVenda.Value) / Sum(Fields!ValorTotalVenda.Value) Textbox105 0.3pt 2pt 2pt 2pt true true Textbox184 0.3pt 2pt 2pt 2pt true true =iif(Sum(Fields!ValorTotalCusto.Value) - Sum(Fields!CustoDevolucao.Value) <> 0, ((Sum(Fields!ValorTotalVenda.Value) + Sum(Fields!ValorComplemento.Value) - Sum(Fields!ValorDevolucao.Value)) - ((Sum(Fields!ValorTotalCusto.Value) - Sum(Fields!CustoDevolucao.Value)))) / ((Sum(Fields!ValorTotalCusto.Value) - Sum(Fields!CustoDevolucao.Value))) * 100,100) Textbox23 0.3pt 2pt 2pt 2pt true true = IIF((Sum(Fields!ValorTotalVenda.Value) + Sum(Fields!ValorComplemento.Value) - Sum(Fields!ValorDevolucao.Value)) <> 0, 100 - (((Sum(Fields!ValorTotalCusto.Value) - Sum(Fields!CustoDevolucao.Value)) + Sum(CDec(Fields!ValorICM.Value) + CDec(Fields!ValorICMSSN.Value) + CDec(Fields!ValorPis.Value) + CDec(Fields!ValorCofins.Value) + CDec(Fields!ValorISSQN.Value) + CDec(Fields!ValorIRRF.Value) + CDec(Fields!ValorINSS.Value) + CDec(Fields!ValorCSLL.Value) + CDec(Fields!ValorDiferencialAliquota.Value) + CDec(Fields!ValorFCP.Value) + CDec(Fields!ValorFCPICMS.Value))) / (Sum(Fields!ValorTotalVenda.Value) + Sum(Fields!ValorComplemento.Value) - Sum(Fields!ValorDevolucao.Value)) * 100), 0) Textbox25 0.3pt 2pt 2pt 2pt true 0.15001cm true true Textbox359 0.3pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt true true Textbox362 0.3pt 2pt 2pt 2pt true true Textbox363 0.3pt 2pt 2pt 2pt true true Textbox364 0.3pt 2pt 2pt 2pt true true Textbox365 0.3pt 2pt 2pt 2pt true true Textbox366 0.3pt 2pt 2pt 2pt true true Textbox367 0.3pt 2pt 2pt 2pt true true Textbox368 0.3pt 2pt 2pt 2pt true true Textbox369 0.3pt 2pt 2pt 2pt true true Textbox370 0.3pt 2pt 2pt 2pt true true Textbox19 0.3pt 2pt 2pt 2pt true true Textbox3 0.3pt 2pt 2pt 2pt true true Textbox12 0.3pt 2pt 2pt 2pt true true Textbox241 0.3pt 2pt 2pt 2pt true true Textbox248 0.3pt 2pt 2pt 2pt true true Textbox269 0.3pt 2pt 2pt 2pt true true Textbox280 0.3pt 2pt 2pt 2pt true true Textbox257 0.3pt 2pt 2pt 2pt true true Textbox234 0.3pt 2pt 2pt 2pt true true Textbox295 0.3pt 2pt 2pt 2pt true true Textbox288 0.3pt 2pt 2pt 2pt true true Textbox316 0.3pt 2pt 2pt 2pt true true Textbox309 0.3pt 2pt 2pt 2pt true true Textbox302 0.3pt 2pt 2pt 2pt true true Textbox371 0.3pt 2pt 2pt 2pt true true Textbox106 0.3pt 2pt 2pt 2pt true true Textbox202 0.3pt 2pt 2pt 2pt true true Textbox372 0.3pt 2pt 2pt 2pt true true Textbox373 0.3pt 2pt 2pt 2pt 0.4cm true true Cod Textbox2 0.3pt #e8e8e8 2pt 2pt 2pt true true Ref 0.3pt #e8e8e8 2pt 2pt 2pt true true Produto 0.3pt #e8e8e8 2pt 2pt 2pt true true Est.Atual Textbox52 0.3pt #e8e8e8 2pt 2pt 2pt true true Qtd Vend Textbox8 0.3pt #e8e8e8 2pt 2pt 2pt true true Qtd Dev Textbox10 0.3pt #e8e8e8 2pt 2pt 2pt true true =Parameters!Custo.Value Textbox12 0.3pt #e8e8e8 2pt 2pt 2pt true true Preco Med Textbox16 0.3pt #e8e8e8 2pt 2pt 2pt true true =Parameters!ValorTotalCusto.Value Textbox22 0.3pt #e8e8e8 2pt 2pt 2pt true true Tot Venda Textbox20 0.3pt #e8e8e8 2pt 2pt 2pt true true Custo Dev Textbox30 0.3pt #e8e8e8 2pt 2pt 2pt true true Vlr Devol Textbox26 0.3pt #e8e8e8 2pt 2pt 2pt true true Vlr Compl. Textbox20 0.3pt #e8e8e8 2pt 2pt 2pt true true Venda Líquida Textbox4 0.3pt #e8e8e8 2pt 2pt 2pt true true Custo Líquido Textbox13 0.3pt #e8e8e8 2pt 2pt 2pt true true ICMS Textbox87 0.3pt #e8e8e8 2pt 2pt 2pt true true ICMS SN Textbox121 0.3pt #e8e8e8 2pt 2pt 2pt true true Pis Textbox105 0.3pt #e8e8e8 2pt 2pt 2pt true true Cofins Textbox118 0.3pt #e8e8e8 2pt 2pt 2pt true true ISSQN Textbox114 0.3pt #e8e8e8 2pt 2pt 2pt true true IRRF Textbox109 0.3pt #e8e8e8 2pt 2pt 2pt true true INSS Textbox99 0.3pt #e8e8e8 2pt 2pt 2pt true true CSLL Textbox96 0.3pt #e8e8e8 2pt 2pt 2pt true true Difal Textbox93 0.3pt #e8e8e8 2pt 2pt 2pt true true FCP Textbox90 0.3pt #e8e8e8 2pt 2pt 2pt true true FCP ICMS Textbox82 0.3pt #e8e8e8 2pt 2pt 2pt true true Rent.Líquida Textbox24 0.3pt #e8e8e8 2pt 2pt 2pt true true Prazo Med. Textbox107 0.3pt #e8e8e8 2pt 2pt 2pt true true Prazo Med Compra Textbox203 0.3pt #e8e8e8 2pt 2pt 2pt true true MRK% Textbox18 0.3pt #e8e8e8 2pt 2pt 2pt true true MC% Textbox14 0.3pt #e8e8e8 2pt 2pt 2pt 0.3cm true true =Fields!CodProdutos.Value CodProdutos 0.3pt 2pt 2pt 2pt true true =Fields!Referencia.Value 0.3pt 2pt 2pt 2pt true true =Fields!Produto.Value 0.3pt 2pt 2pt 2pt true true =Fields!EstoqueAtual.Value EstoqueAtual 0.3pt 2pt 2pt 2pt true true =Fields!QuantidadeVendida.Value QuantidadeVendida 0.3pt 2pt 2pt 2pt true true =Fields!QuantidadeDevolvida.Value QuantidadeDevolvida 0.3pt 2pt 2pt 2pt true true =Fields!Custo.Value Custo 0.3pt 2pt 2pt 2pt true true =Fields!PrecoMedio.Value PrecoMedio 0.3pt 2pt 2pt 2pt true true =Fields!ValorTotalCusto.Value ValorTotalCusto 0.3pt 2pt 2pt 2pt true true =Fields!ValorTotalVenda.Value ValorTotalVenda 0.3pt 2pt 2pt 2pt true true =Fields!CustoDevolucao.Value CustoDevolucao 0.3pt 2pt 2pt 2pt true true =Fields!ValorDevolucao.Value ValorDevolucao 0.3pt 2pt 2pt 2pt true true =Fields!ValorComplemento.Value ValorComplemento1 0.3pt 2pt 2pt 2pt true true =Fields!ValorTotalVenda.Value + Fields!ValorComplemento.Value - Fields!ValorDevolucao.Value Textbox5 0.3pt 2pt 2pt 2pt true true =Fields!ValorTotalCusto.Value - Fields!CustoDevolucao.Value Textbox14 0.3pt 2pt 2pt 2pt true true =Fields!ValorICM.Value ValorICM1 0.3pt 2pt 2pt 2pt true true =Fields!ValorICMSSN.Value ValorICMSSN1 0.3pt 2pt 2pt 2pt true true =Fields!ValorPis.Value ValorPis1 0.3pt 2pt 2pt 2pt true true =Fields!ValorCofins.Value ValorCofins1 0.3pt 2pt 2pt 2pt true true =Fields!ValorISSQN.Value ValorISSQN1 0.3pt 2pt 2pt 2pt true true =Fields!ValorIRRF.Value ValorIRRF1 0.3pt 2pt 2pt 2pt true true =Fields!ValorINSS.Value ValorINSS1 0.3pt 2pt 2pt 2pt true true =Fields!ValorCSLL.Value ValorCSLL1 0.3pt 2pt 2pt 2pt true true =Fields!ValorDiferencialAliquota.Value ValorDiferencialAliquota1 0.3pt 2pt 2pt 2pt true true =Fields!ValorFCP.Value ValorFCP1 0.3pt 2pt 2pt 2pt true true =Fields!ValorFCPICMS.Value ValorFCPICMS1 0.3pt 2pt 2pt 2pt true true =Fields!ValorLiquido.Value ValorLiquido 0.3pt 2pt 2pt 2pt true true =Fields!PrazoMedio.Value PrazoMedio1 0.3pt 2pt 2pt 2pt true true =Fields!PrazoMedioCompra.Value PrazoMedioCompra2 0.3pt 2pt 2pt 2pt true true =Fields!MRK.Value MRK 0.3pt 2pt 2pt 2pt true true =Fields!MC.Value MC 0.3pt 2pt 2pt 2pt 0.15001cm true true Textbox391 0.3pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt true true Textbox394 0.3pt 2pt 2pt 2pt true true Textbox395 0.3pt 2pt 2pt 2pt true true Textbox396 0.3pt 2pt 2pt 2pt true true Textbox397 0.3pt 2pt 2pt 2pt true true Textbox398 0.3pt 2pt 2pt 2pt true true Textbox399 0.3pt 2pt 2pt 2pt true true Textbox400 0.3pt 2pt 2pt 2pt true true Textbox401 0.3pt 2pt 2pt 2pt true true Textbox402 0.3pt 2pt 2pt 2pt true true Textbox22 0.3pt 2pt 2pt 2pt true true Textbox6 0.3pt 2pt 2pt 2pt true true Textbox15 0.3pt 2pt 2pt 2pt true true Textbox244 0.3pt 2pt 2pt 2pt true true Textbox251 0.3pt 2pt 2pt 2pt true true Textbox274 0.3pt 2pt 2pt 2pt true true Textbox284 0.3pt 2pt 2pt 2pt true true Textbox263 0.3pt 2pt 2pt 2pt true true Textbox237 0.3pt 2pt 2pt 2pt true true Textbox298 0.3pt 2pt 2pt 2pt true true Textbox291 0.3pt 2pt 2pt 2pt true true Textbox319 0.3pt 2pt 2pt 2pt true true Textbox312 0.3pt 2pt 2pt 2pt true true Textbox305 0.3pt 2pt 2pt 2pt true true Textbox403 0.3pt 2pt 2pt 2pt true true Textbox109 0.3pt 2pt 2pt 2pt true true Textbox207 0.3pt 2pt 2pt 2pt true true Textbox404 0.3pt 2pt 2pt 2pt true true Textbox405 0.3pt 2pt 2pt 2pt 0.4cm true true Textbox1 0.3pt #caebfc 2pt 2pt 2pt true true 0.3pt #caebfc 2pt 2pt 2pt true true TOTAL GERAL: 0.3pt #caebfc 2pt 2pt 2pt 4 true true =Sum(Fields!Custo.Value) Textbox11 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!PrecoMedio.Value) Textbox13 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!ValorTotalCusto.Value) Textbox15 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!ValorTotalVenda.Value) Textbox17 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!CustoDevolucao.Value) Textbox36 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!ValorDevolucao.Value) Textbox19 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!ValorComplemento.Value) Textbox23 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!ValorTotalVenda.Value) + Sum(Fields!ValorComplemento.Value) - Sum(Fields!ValorDevolucao.Value) Textbox8 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!ValorTotalCusto.Value) - Sum(Fields!CustoDevolucao.Value) Textbox16 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!ValorICM.Value) Textbox89 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!ValorICMSSN.Value) Textbox123 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!ValorPis.Value) Textbox107 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!ValorCofins.Value) Textbox120 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!ValorISSQN.Value) Textbox117 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!ValorIRRF.Value) Textbox112 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!ValorINSS.Value) Textbox104 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!ValorCSLL.Value) Textbox98 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!ValorDiferencialAliquota.Value) Textbox95 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!ValorFCP.Value) Textbox92 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!ValorFCPICMS.Value) Textbox86 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!ValorLiquido.Value) Textbox21 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!PrazoMedio.Value * Fields!ValorTotalVenda.Value) / Sum(Fields!ValorTotalVenda.Value) Textbox110 0.3pt #caebfc 2pt 2pt 2pt true true Textbox185 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!TotalMRK.Value) Textbox23 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!TotalMC.Value) Textbox25 0.3pt #caebfc 2pt 2pt 2pt =Parameters!MostrarValorComplemento.Value = False =Parameters!ValorICM.Value =Not Parameters!ValorICMSSN.Value =Not Parameters!ValorPis.Value =Not Parameters!ValorCofins.Value =Not Parameters!ValorISSQN.Value =Not Parameters!ValorIRRF.Value =Not Parameters!ValorINSS.Value =Not Parameters!ValorCSLL.Value =Not Parameters!ValorDiferencialAliquota.Value =Not Parameters!ValorFCP.Value =Not Parameters!ValorFCPICMS.Value =Parameters!MostrarPrazoMedioVendas.Value = false =Parameters!MostrarPrazoMedioCompras.Value = false true =Fields!CodGrupo.Value =Fields!Grupo.Value After After After Before true true dsRentabilidade =Switch(Parameters!Ordem.Value = "0", Fields!CodProdutos.Value, Parameters!Ordem.Value = "1", Fields!Produto.Value) =Switch(Parameters!Ordem.Value = "2", Fields!QuantidadeVendida.Value, Parameters!Ordem.Value = "3", Fields!ValorLiquido.Value) Descending 0.41417cm 2.20002cm 51.73777cm 0.3pt 1.14544cm 9.8664cm 2.49999cm 0.4cm true true RESUMO DESPESAS VENDEDOR Textbox38 0.3pt 2pt 2pt 3 0.4cm true true Cod Textbox61 0.3pt #caebfc 2pt 2pt true true Conta Textbox62 0.3pt #caebfc 2pt 2pt true true Valor Textbox63 0.3pt #caebfc 2pt 2pt 0.4cm true true =Fields!Cod.Value 2pt 2pt 2pt 2pt true true =Fields!Conta.Value 2pt 2pt 2pt 2pt true true =Fields!Valor.Value Valor 2pt 2pt 2pt 2pt 0.4cm true true #caebfc 2pt 2pt 2pt 2pt true true TOTAL: Textbox5 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!Valor.Value) Textbox57 #caebfc 2pt 2pt 2pt 2pt After After Before dsResumoDespesasVendedores 6.14336cm 1.6cm 13.51183cm 1 =IIf(Sum(Fields!Valor.Value, "dsResumoDespesasVendedores") > 0, false , true) 2.60586cm 10.55705cm 0.4cm true true Filtros: 0.3pt #e8e8e8 2pt 2pt 2pt 2 0.4cm true true =Fields!Filtro.Value 0.3pt 2pt 2pt 2pt true true =Fields!DescricaoFiltro.Value 0.3pt 2pt 2pt 2pt After dsFiltros =Fields!Filtro.Value 7.91975cm 0.00131cm 0.8cm 13.16291cm 2 =Parameters!ImprimirFiltrosUtilizados.Value = false 0.3cm 1.11785cm 7.5cm 2.3cm 2.3cm 2.3cm 2.3cm 2.49999cm 2.3cm 1.9cm 1.9cm 1.9cm 1.8cm 2.3cm 2cm 0.4cm true true RESUMO POR NATUREZA Textbox38 0.3pt 2pt 2pt 14 0.4cm true true Cod Textbox27 0.3pt #caebfc 2pt 2pt 2pt true true Natureza 0.3pt #caebfc 2pt 2pt 2pt true true Tot.Vendas Textbox31 0.3pt #caebfc 2pt 2pt 2pt true true =Parameters!Custo.Value Textbox35 0.3pt #caebfc 2pt 2pt 2pt true true Rent.Bruta Textbox39 0.3pt #caebfc 2pt 2pt 2pt true true Vlr Devol Textbox7 0.3pt #caebfc 2pt 2pt 2pt true true Custo Dev. Textbox34 0.3pt #caebfc 2pt 2pt 2pt true true Liquido Devol Textbox44 0.3pt #caebfc 2pt 2pt 2pt true true Vlr Compl. Textbox18 0.3pt #caebfc 2pt 2pt 2pt true true Venda Líquida Textbox68 0.3pt #caebfc 2pt 2pt 2pt true true Custo Líquido Textbox71 0.3pt #caebfc 2pt 2pt 2pt true true Impostos Textbox87 0.3pt #caebfc 2pt 2pt 2pt true true Rent.Líquida Textbox9 0.3pt #caebfc 2pt 2pt 2pt true true Qtd.Notas Textbox33 0.3pt #caebfc 2pt 2pt 2pt 0.3cm true true =Fields!Cod.Value Cod 0.3pt 2pt 2pt 2pt true true =Fields!Natureza.Value 0.3pt 2pt 2pt 2pt true true =Fields!ValorTotal.Value ValorTotal 0.3pt 2pt 2pt 2pt true true =Fields!Custo.Value Custo1 0.3pt 2pt 2pt 2pt true true =Fields!ValorTotal.Value - Fields!Custo.Value Textbox41 0.3pt 2pt 2pt 2pt true true =Fields!ValorDevolucao.Value ValorDevolucao1 0.3pt 2pt 2pt 2pt true true =Fields!ValorCustoDevolucao.Value ValorCustoDevolucao 0.3pt 2pt 2pt 2pt true true =Fields!ValorDevolucao.Value - Fields!ValorCustoDevolucao.Value Textbox48 0.3pt 2pt 2pt 2pt true true =Fields!ValorComplemento.Value ValorComplemento2 0.3pt 2pt 2pt 2pt true true =Fields!ValorTotal.Value + Fields!ValorComplemento.Value - Fields!ValorDevolucao.Value Textbox69 0.3pt 2pt 2pt 2pt true true =Fields!Custo.Value - Fields!ValorCustoDevolucao.Value Textbox72 0.3pt 2pt 2pt 2pt true true =Fields!ValorImpostos.Value ValorImpostos 0.3pt 2pt 2pt 2pt true true =Fields!ValorLiquido.Value ValorLiquido1 0.3pt 2pt 2pt 2pt true true =Fields!QtdNotas.Value QtdNotas 0.3pt 2pt 2pt 2pt 0.4cm true true TOTAL GERAL: Textbox43 0.3pt #caebfc 2pt 2pt 2pt 2 true true =Sum(Fields!ValorTotal.Value) Textbox45 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!Custo.Value) Textbox46 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!ValorTotal.Value - Fields!Custo.Value) Textbox42 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!ValorDevolucao.Value) Textbox32 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!ValorCustoDevolucao.Value) Textbox40 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!ValorDevolucao.Value - Fields!ValorCustoDevolucao.Value) Textbox49 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!ValorComplemento.Value) Textbox24 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!ValorTotal.Value) + Sum(Fields!ValorComplemento.Value) - Sum(Fields!ValorDevolucao.Value) Textbox70 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!Custo.Value) - Sum(Fields!ValorCustoDevolucao.Value) Textbox73 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!ValorImpostos.Value) ValorImpostos1 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!ValorLiquido.Value) Textbox28 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!QtdNotas.Value) Textbox47 0.3pt #caebfc 2pt 2pt 2pt =Parameters!MostrarValorComplemento.Value = False =Not Parameters!ValorICM.Value And Not Parameters!ValorICMSSN.Value And Not Parameters!ValorPis.Value And Not Parameters!ValorCofins.Value And Not Parameters!ValorISSQN.Value And Not Parameters!ValorIRRF.Value And Not Parameters!ValorINSS.Value And Not Parameters!ValorCSLL.Value And Not Parameters!ValorDiferencialAliquota.Value And Not Parameters!ValorFCP.Value And Not Parameters!ValorFCPICMS.Value After true true After true true Before dsResumoNaturezas 2.77168cm 1.5cm 34.41784cm 3 =IIf(Sum(Fields!ValorTotal.Value, "dsResumoNaturezas") > 0, False, True) 0.3pt 1.11785cm 7.5cm 2.3cm 2.3cm 2.3cm 2.3cm 2.49999cm 2.3cm 1.9cm 1.9cm 1.9cm 1.8cm 2.3cm 2cm 2cm 0.4cm true true RESUMO POR VENDEDORES Textbox38 0.3pt 2pt 2pt 13 true true Textbox80 0.3pt 2pt 2pt true true Textbox84 0.3pt 2pt 2pt 0.4cm true true Cod Textbox27 0.3pt #caebfc 2pt 2pt 2pt true true Vendedor 0.3pt #caebfc 2pt 2pt 2pt true true Tot.Vendas Textbox31 0.3pt #caebfc 2pt 2pt 2pt true true =Parameters!Custo.Value Textbox35 0.3pt #caebfc 2pt 2pt 2pt true true Rent.Bruta Textbox39 0.3pt #caebfc 2pt 2pt 2pt true true Vlr Devol Textbox7 0.3pt #caebfc 2pt 2pt 2pt true true Custo Dev. Textbox34 0.3pt #caebfc 2pt 2pt 2pt true true Liquido Devol Textbox44 0.3pt #caebfc 2pt 2pt 2pt true true Vlr Compl. Textbox25 0.3pt #caebfc 2pt 2pt 2pt true true Venda Líquida Textbox74 0.3pt #caebfc 2pt 2pt 2pt true true Custo Líquido Textbox77 0.3pt #caebfc 2pt 2pt 2pt true true Impostos Textbox87 0.3pt #caebfc 2pt 2pt 2pt true true Rent.Líquida Textbox9 0.3pt #caebfc 2pt 2pt 2pt true true MRK% Textbox81 0.3pt #caebfc 2pt 2pt 2pt true true MC% Textbox85 0.3pt #caebfc 2pt 2pt 2pt 0.3cm true true =Fields!CodVendedores.Value Cod 0.3pt 2pt 2pt 2pt true true =Fields!Vendedor.Value 0.3pt 2pt 2pt 2pt true true =Fields!ValorTotal.Value ValorTotal 0.3pt 2pt 2pt 2pt true true =Fields!Custo.Value Custo1 0.3pt 2pt 2pt 2pt true true =Fields!ValorTotal.Value - Fields!Custo.Value Textbox41 0.3pt 2pt 2pt 2pt true true =Fields!ValorDevolucao.Value ValorDevolucao1 0.3pt 2pt 2pt 2pt true true =Fields!ValorCustoDevolucao.Value ValorCustoDevolucao 0.3pt 2pt 2pt 2pt true true =Fields!ValorDevolucao.Value - Fields!ValorCustoDevolucao.Value Textbox48 0.3pt 2pt 2pt 2pt true true =Fields!ValorComplemento.Value ValorComplemento3 0.3pt 2pt 2pt 2pt true true =Fields!ValorTotal.Value + Fields!ValorComplemento.Value - Fields!ValorDevolucao.Value Textbox75 0.3pt 2pt 2pt 2pt true true =Fields!Custo.Value - Fields!ValorCustoDevolucao.Value Textbox78 0.3pt 2pt 2pt 2pt true true =Fields!ValorImpostos.Value ValorImpostos2 0.3pt 2pt 2pt 2pt true true =Fields!ValorLiquido.Value Textbox28 0.3pt 2pt 2pt 2pt true true =Fields!MRKVendedor.Value MRKVendedor 0.3pt 2pt 2pt 2pt true true =Fields!MCVendedor.Value MCVendedor 0.3pt 2pt 2pt 2pt 0.4cm true true TOTAL GERAL: Textbox43 0.3pt #caebfc 2pt 2pt 2pt 2 true true =Sum(Fields!ValorTotal.Value) Textbox45 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!Custo.Value) Textbox46 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!ValorTotal.Value - Fields!Custo.Value) Textbox42 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!ValorDevolucao.Value) Textbox32 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!ValorCustoDevolucao.Value) Textbox40 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!ValorDevolucao.Value - Fields!ValorCustoDevolucao.Value) Textbox49 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!ValorComplemento.Value) Textbox29 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!ValorTotal.Value) + Sum(Fields!ValorComplemento.Value) - Sum(Fields!ValorDevolucao.Value) Textbox76 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!Custo.Value) - Sum(Fields!ValorCustoDevolucao.Value) Textbox79 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!ValorImpostos.Value) ValorImpostos3 0.3pt #caebfc 2pt 2pt 2pt true true =Sum(Fields!ValorLiquido.Value) Textbox29 0.3pt #caebfc 2pt 2pt 2pt true true =First(Fields!TotalMRKVendedor.Value) TotalMRKVendedor 0.3pt #caebfc 2pt 2pt 2pt true true =First(Fields!TotalMCVendedor.Value) TotalMCVendedor 0.3pt #caebfc 2pt 2pt 2pt =Parameters!MostrarValorComplemento.Value = False =Not Parameters!ValorICM.Value And Not Parameters!ValorICMSSN.Value And Not Parameters!ValorPis.Value And Not Parameters!ValorCofins.Value And Not Parameters!ValorISSQN.Value And Not Parameters!ValorIRRF.Value And Not Parameters!ValorINSS.Value And Not Parameters!ValorCSLL.Value And Not Parameters!ValorDiferencialAliquota.Value And Not Parameters!ValorFCP.Value And Not Parameters!ValorFCPICMS.Value After true true After true true Before dsResumoVendedores 4.44807cm 1.5cm 36.41784cm 4 =IIf(Sum(Fields!ValorTotal.Value, "dsResumoVendedores") > 0, False, True) 0.3pt 3.43297in 1.20582cm 0.50299cm 33.23617cm External =Parameters!LogoMenor.Value FitProportional 0.0057cm 1.52672cm 5.14717cm 1 0.30907cm true true true true =Now() Textbox4 0.00001cm 0.30896cm 4.27271cm true true ="Pag: " & Globals!PageNumber & " de " & Globals!TotalPages Textbox4 23.16554cm 0.30896cm 4.67313cm 1 21cm 29.7cm 0.2cm 0.2cm 0.2cm 0.2cm 0.13cm