0 SQL 5ab246e2-24f8-46ad-86b7-f292e4a9131a DummyDataSource true Natureza System.String DataEmissao System.String DataLancamento System.String Nota System.String NFSE System.String CodCliente System.String Cliente System.String NomeFantasiaCliente System.String Desconto System.Decimal PercentualDesc System.Decimal PercentualDescItem System.Decimal Acrescimo System.Decimal FRETE System.Decimal Despesas System.Decimal IPI System.Decimal ICMS System.Decimal ICMSST System.Decimal ValorDepositoFundoReformaRS System.Decimal ValorContabil System.Decimal ValorTotalProdutos System.Decimal CodProdutos System.Decimal Descricao System.Decimal CategoriaFiscalProduto System.String GrupoSimilaridade System.String QuantidadeEntrada System.Decimal QuantidadeSaida System.Decimal ValorEntrada System.Decimal ValorSaida System.Decimal NCM System.String Quantidade System.Decimal ValorTotalItem System.Decimal ValorUnitario System.Decimal CodNota System.Decimal ValorRetISSQN System.Decimal ValorINSS System.Decimal ValorIRRF System.Decimal ValorCSLL System.Decimal ValorPISRetencao System.Decimal ValorCOFINSRetencao System.Decimal ValorFCPICMS System.Decimal ValorFCPST System.Decimal ValorFCP System.Decimal ValorDiferencialAliquota System.Decimal PesoLiquido System.Decimal MensagemNF System.string CPFCNPJ System.String RowNumber System.Int32 DummyDataSource true Cod System.String Natureza System.String IPI System.String ICMS System.String ICMSST System.String ValorTotalDepositoFundoReformaRS System.Decimal FCPICMS System.String FCPST System.String FCP System.Decimal DIFAL System.Decimal ValorTotal System.String ValorTotalProduto System.Decimal PesoLiquidoTotal System.Decimal DummyDataSource true CodCentrosCusto System.String CentrosCusto System.String CodSubCentrosCusto System.String SubCentrosCusto System.String IPI System.String ICMS System.String ICMSST System.String ValorTotal System.String ValorTotalProduto System.Decimal DummyDataSource true CodProdutosGrupos System.Integer DescricaoProdutosGrupos System.String Quantidade System.Decimal ValorTotalProdutosGrupos System.Decimal Desconto System.Decimal Acrescimo System.Decimal Frete System.Decimal IPI System.Decimal ICMS System.Decimal ICMSST System.Decimal ValorLiquido System.Decimal DummyDataSource true Campo System.String Valor System.String 1.2cm 8.19758cm 2.84626cm 2.61601cm 2.01703cm 2.76458cm 2.89119cm 2.69706cm 1.9cm 2.01398cm 2.2cm 2.46458cm 2.2cm 3.4525cm 0.52062cm true true Cod Textbox2 #caebfc 2pt 2pt 2pt 2pt true true Produto Textbox2 #caebfc 2pt 2pt 2pt 2pt true true Categoria Fiscal Textbox331 #caebfc 2pt 2pt 2pt 2pt true true Grupo Similaridade Textbox287 #caebfc 2pt 2pt 2pt 2pt true true NCM Textbox111 #caebfc 2pt 2pt 2pt 2pt true true Quantidade Textbox18 #caebfc 2pt 2pt 2pt 2pt true true Total Prod. Textbox18 #caebfc 2pt 2pt 2pt 2pt true true DES. Textbox48 #caebfc 2pt 2pt 2pt 2pt true true ACRÉSC. Textbox12 #caebfc 2pt 2pt 2pt 2pt true true FRETE Textbox47 #caebfc 2pt 2pt 2pt 2pt true true IPI Textbox6 #caebfc 2pt 2pt 2pt 2pt true true ICMS Textbox12 #caebfc 2pt 2pt 2pt 2pt true true ICMSST Textbox40 #caebfc 2pt 2pt 2pt 2pt true true Fundo Reforma RS Textbox294 #caebfc 2pt 2pt 2pt 2pt 0.44125cm true true =Fields!CodProdutos.Value =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 2pt 2pt true true =Fields!Descricao.Value =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 2pt 2pt true true =Fields!CategoriaFiscalProduto.Value CategoriaFiscalProduto =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 2pt 2pt true true =Fields!GrupoSimilaridade.Value GrupoSimilaridade1 =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 2pt 2pt true true =Fields!NCM.Value NCM =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 2pt 2pt true true =Sum(Fields!Quantidade.Value) =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 2pt 2pt true true =Sum(Fields!ValorTotalItem.Value) ValorTotalItem1 =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 2pt 2pt true true =Format(Sum(Fields!DESCONTO.Value), "###,##0.00") & " (" & Format(((Sum(Fields!DESCONTO.Value) / Sum(Fields!ValorTotalItem.Value)) * 100), "###,##0.00") & ")" DESCONTO =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 2pt 2pt true true =Sum(Fields!ACRESCIMO.Value) Textbox15 =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 2pt 2pt true true =Sum(Fields!FRETE.Value) FRETE =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 2pt 2pt true true =Sum(Fields!IPI.Value) IPI =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 2pt 2pt true true =Sum(Fields!ICMS.Value) ICMS =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 2pt 2pt true true =Sum(Fields!ICMSST.Value) ICMSST =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 2pt 2pt true true =Sum(Fields!ValorDepositoFundoReformaRS.Value) ValorDepositoFundoReformaRS6 =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 2pt 2pt 0.52062cm true true Textbox147 #caebfc 2pt 2pt 2pt 2pt true true Total: Textbox14 #caebfc 2pt 2pt 2pt 2pt 4 true true =Sum(Fields!Quantidade.Value) Textbox139 #caebfc 2pt 2pt 2pt 2pt true true =Sum(Fields!ValorTotalItem.Value) ValorTotalItem2 #caebfc 2pt 2pt 2pt 2pt true true =Format(Sum(Fields!DESCONTO.Value), "###,##0.00") Textbox51 #caebfc 2pt 2pt 2pt 2pt true true =Sum(Fields!ACRESCIMO.Value) Textbox16 #caebfc 2pt 2pt 2pt 2pt true true =Sum(Fields!FRETE.Value) Textbox49 #caebfc 2pt 2pt 2pt 2pt true true =Sum(Fields!IPI.Value) Textbox18 #caebfc 2pt 2pt 2pt 2pt true true =Sum(Fields!ICMS.Value) Textbox19 #caebfc 2pt 2pt 2pt true true =Sum(Fields!ICMSST.Value) Textbox46 #caebfc 2pt 2pt 2pt 2pt true true =Sum(Fields!ValorDepositoFundoReformaRS.Value) Textbox304 #caebfc 2pt 2pt 2pt 2pt =Parameters!MostrarCategoriaFiscalProduto.Value = false =Parameters!MostrarGrupoSimilaridade.Value = False =Parameters!MostrarValorDepositoFundoReformaRS.Value = False After true true =Fields!CodProdutos.Value Before true dsNotas =Fields!Descricao.Value 0.00002cm 1.48249cm 39.46077cm =Parameters!Analise.Value = 0 Or Parameters!Analise.Value = 1 Or Parameters!Analise.Value = 2 0.84163cm 1.2cm 0.6cm 1.8cm 1.5cm 1.5cm 1.2cm 2.79599cm 1.9325cm 3.14849cm 1.9cm 2cm 1.7587cm 1.3cm 1.3cm 1.3cm 1.3cm 1.5cm 1.78563cm 2.28833cm 1.6cm 1.6cm 2.12958cm 1.2077cm 1.35856cm 1.29381cm 1.93138cm 2cm 2cm 2.14507cm 1.8cm 4.88125cm 0.9cm true true Nat. Textbox13 0.3pt #caebfc 2pt 2pt 2pt 2pt true true DataEmis Textbox2 0.3pt #caebfc 2pt 2pt 2pt 2pt 2 true true DataLanc Textbox11 0.3pt #caebfc 2pt 2pt 2pt 2pt true true Nota Textbox10 0.3pt #caebfc 2pt 2pt 2pt 2pt true true NFSe Textbox10 0.3pt #caebfc 2pt 2pt 2pt 2pt true true Cod Textbox8 0.3pt #caebfc 2pt 2pt 2pt 2pt true true Cliente Textbox4 0.3pt #caebfc 2pt 2pt 2pt 2pt 2 true true CPF/CNPJ Textbox372 0.3pt #caebfc 2pt 2pt 2pt 2pt true true Tot Prod./ Serv. Textbox47 0.3pt #caebfc 2pt 2pt 2pt 2pt true true DESC. Textbox48 0.3pt #caebfc 2pt 2pt 2pt 2pt true true ACRÉSC. Textbox8 0.3pt #caebfc 2pt 2pt 2pt 2pt true true FRETE Textbox47 0.3pt #caebfc 2pt 2pt 2pt 2pt true true DESP. Textbox1 0.3pt #caebfc 2pt 2pt 2pt 2pt true true IPI Textbox6 0.3pt #caebfc 2pt 2pt 2pt 2pt true true ICMS Textbox12 0.3pt #caebfc 2pt 2pt 2pt 2pt true true ICMSST Textbox40 0.3pt #caebfc 2pt 2pt 2pt 2pt true true DIFAL Textbox369 0.3pt #caebfc 2pt 2pt 2pt 2pt true true Fundo Reforma RS Textbox286 0.3pt #caebfc 2pt 2pt 2pt 2pt true true FCP Textbox19 0.3pt #caebfc 2pt 2pt 2pt 2pt true true FCP ST Textbox76 0.3pt #caebfc 2pt 2pt 2pt 2pt true true FCP DIFAL Textbox382 0.3pt #caebfc 2pt 2pt 2pt 2pt true true ISSQN Retido Textbox307 0.3pt #caebfc 2pt 2pt 2pt 2pt true true INSS Retido Textbox313 0.3pt #caebfc 2pt 2pt 2pt 2pt true true IRRF Retido Textbox319 0.3pt #caebfc 2pt 2pt 2pt 2pt true true CSLL Ret Textbox325 0.3pt #caebfc 2pt 2pt 2pt 2pt true true PIS Ret Textbox118 0.3pt #caebfc 2pt 2pt 2pt 2pt true true COFINS Ret Textbox124 0.3pt #caebfc 2pt 2pt 2pt 2pt true true Valor Textbox50 0.3pt #caebfc 2pt 2pt 2pt 2pt true true Peso Textbox47 0.3pt #caebfc 2pt 2pt 2pt 2pt true true Mensagem da Nota Textbox53 0.3pt #caebfc 2pt 2pt 2pt 2pt 0.4cm true true =Fields!Natureza.Value DataEmissao 0.3pt 2pt 2pt 1pt true true =Format(Fields!DataEmissao.Value, "dd/MM/yyyy") DataEmissao 0.3pt 2pt 2pt 1pt 2 true true =Fields!DataLancamento.Value DataLancamento 0.3pt 2pt 2pt 1pt true true =Fields!Nota.Value Nota 0.3pt 2pt 2pt 1pt true true =iif(Fields!NFSE.Value = 0,"",Fields!NFSE.Value) NFSE 0.3pt 2pt 2pt 1pt true true =Fields!CodCliente.Value 0.3pt 2pt 2pt 1pt true true =Fields!Cliente.Value 0.3pt 2pt 2pt 1pt 2 true true =Fields!CPFCNPJ.Value 0.3pt 2pt 2pt 1pt true true =Sum(Fields!ValorTotalItem.Value) ValorTotalProdutos 0.3pt 2pt 2pt 1pt true true =Format(Sum(Fields!DESCONTO.Value), "###,##0.00") & " (" & Format(Fields!PercentualDesc.Value, "###,##0.00") & ")" DESCONTO 0.3pt 2pt 2pt 1pt true true =Sum(Fields!ACRESCIMO.Value) Textbox10 0.3pt 2pt 2pt 1pt true true =Sum(Fields!FRETE.Value) FRETE 0.3pt 2pt 2pt 1pt true true =Sum(Fields!Despesas.Value) Textbox2 0.3pt 2pt 2pt 1pt true true =Sum(Fields!IPI.Value) IPI 0.3pt 2pt 2pt 1pt true true =Sum(Fields!ICMS.Value) ICMS 0.3pt 2pt 2pt 1pt true true =Sum(Fields!ICMSST.Value) ICMSST 0.3pt 2pt 2pt 1pt true true =Sum(Fields!ValorDiferencialAliquota.Value) ValorDiferencialAliquota2 0.3pt 2pt 2pt 1pt true true =Sum(Fields!ValorDepositoFundoReformaRS.Value) ValorDepositoFundoReformaRS 0.3pt 2pt 2pt 1pt true true =Sum(Fields!ValorFCPICMS.Value) ValorFCPICMS1 0.3pt 2pt 2pt 1pt true true =Sum(Fields!ValorFCPST.Value) ValorFCPST1 0.3pt 2pt 2pt 1pt true true =Sum(Fields!ValorFCP.Value) ValorFCP2 0.3pt 2pt 2pt 1pt true true =Fields!ValorRetISSQN.Value ValorRetISSQN1 0.3pt 2pt 2pt 1pt true true =Fields!ValorINSS.Value ValorINSS1 0.3pt 2pt 2pt 1pt true true =Fields!ValorIRRF.Value ValorIRRF1 0.3pt 2pt 2pt 1pt true true =Fields!ValorCSLL.Value ValorCSLL1 0.3pt 2pt 2pt 1pt true true =Fields!ValorPISRetencao.Value ValorPISRetencao 0.3pt 2pt 2pt 1pt true true =Fields!ValorCOFINSRetencao.Value ValorCOFINSRetencao 0.3pt 2pt 2pt 1pt true true =Fields!ValorContabil.Value ValorContabil 0.3pt 2pt 2pt 1pt true true =Sum(Fields!PesoLiquido.Value) PesoLiquido 0.3pt 2pt 2pt 1pt true true =Fields!MensagemNF.Value MensagemNF1 0.3pt 2pt 2pt 1pt 0.4cm true true 0.3pt 2pt 2pt 2pt 2pt true true Cod Textbox31 0.3pt #e8e8e8 2pt 2pt 1pt true true Descrição Textbox31 0.3pt #e8e8e8 2pt 2pt 1pt 6 true true Quantidade Textbox31 0.3pt #e8e8e8 2pt 2pt 1pt 2 true true Tot. Prod. ValorUnitario 0.3pt #e8e8e8 2pt 2pt 1pt true true DESC. Textbox31 0.3pt #e8e8e8 2pt 2pt 1pt true true ACRÉSC. Textbox11 0.3pt #e8e8e8 2pt 2pt 1pt true true FRETE Textbox31 0.3pt #e8e8e8 2pt 2pt 1pt true true DESP. Textbox4 0.3pt #e8e8e8 2pt 2pt 1pt true true IPI Textbox168 0.3pt #e8e8e8 2pt 2pt 1pt true true ICMS Textbox170 0.3pt #e8e8e8 2pt 2pt 1pt true true ICMSST Textbox172 0.3pt #e8e8e8 2pt 2pt 1pt true true DIFAL Textbox371 0.3pt #e8e8e8 2pt 2pt 1pt true true =Sum(Fields!ValorDepositoFundoReformaRS.Value) ValorDepositoFundoReformaRS1 0.3pt #e8e8e8 2pt 2pt 1pt true true FCP ValorFCPICMS2 0.3pt #e8e8e8 2pt 2pt 1pt true true FCP ST Textbox78 0.3pt #e8e8e8 2pt 2pt 1pt true true FCP DIFAL Textbox384 0.3pt #e8e8e8 2pt 2pt 1pt true true Vlr Unitário Textbox284 =Parameters!TipoAnalise.Value = 1 Or Parameters!Analise.Value = 0 Or Parameters!Analise.Value = 2 0.3pt #e8e8e8 2pt 2pt 1pt 2 true true Textbox2 0.3pt #e8e8e8 2pt 2pt 1pt 5 true true Textbox60 0.3pt #e8e8e8 2pt 2pt 1pt true true MensagemNF 0.3pt #e8e8e8 2pt 2pt 1pt 0.4cm true true 0.3pt 2pt 2pt 2pt 2pt true true =Fields!CodProdutos.Value CodProdutos 0.3pt =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!Descricao.Value 0.3pt =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt 6 true true =Fields!Quantidade.Value Quantidade 0.3pt =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt 2 true true =Fields!ValorTotalItem.Value ValorTotalItem 0.3pt =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Format(Fields!DESCONTO.Value, "###,##0.00") & " (" & Format(Fields!PercentualDescItem.Value, "###,##0.00") & ")" DESCONTO1 0.3pt =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!ACRESCIMO.Value ACRESCIMO 0.3pt =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!FRETE.Value FRETE1 0.3pt =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!Despesas.Value Despesas 0.3pt =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!IPI.Value IPI4 0.3pt =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!ICMS.Value ICMS5 0.3pt =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!ICMSST.Value ICMSST1 0.3pt =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!ValorDiferencialAliquota.Value ValorDiferencialAliquota3 0.3pt =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!ValorDepositoFundoReformaRS.Value ValorDepositoFundoReformaRS2 0.3pt =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!ValorFCPICMS.Value ValorFCPICMS3 0.3pt =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!ValorFCPST.Value ValorFCPST2 0.3pt =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!ValorFCP.Value ValorFCP3 0.3pt =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!ValorUnitario.Value ValorUnitario =Parameters!TipoAnalise.Value = 1 Or Parameters!Analise.Value = 0 Or Parameters!Analise.Value = 2 0.3pt =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt 2 true true Textbox6 0.3pt =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt 5 true true PesoLiquido1 0.3pt =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true Textbox93 0.3pt =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt 0.2825cm true true 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt 2 true true 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt true true =Sum(Fields!ACRESCIMO.Value) 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt true true =Sum(Fields!ValorDiferencialAliquota.Value) 0.3pt 2pt 2pt 2pt 2pt true true =Sum(Fields!ValorDepositoFundoReformaRS.Value) 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt true true =Sum(Fields!ValorFCP.Value) 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt 7 true true 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt 0.5cm true true Textbox149 0.3pt #caebfc 2pt 2pt 2pt 2pt true true Textbox149 0.3pt #caebfc 2pt 2pt 2pt 2pt true true Textbox149 0.3pt #caebfc 2pt 2pt 2pt 2pt true true Textbox149 0.3pt #caebfc 2pt 2pt 2pt 2pt true true Textbox149 0.3pt #caebfc 2pt 2pt 2pt 2pt true true Textbox121 0.3pt #caebfc 2pt 2pt 2pt 2pt true true Textbox149 0.3pt #caebfc 2pt 2pt 2pt 2pt true true Textbox149 0.3pt #caebfc 2pt 2pt 2pt 2pt true true Total Textbox226 0.3pt #caebfc 2pt 2pt 2pt 2pt 2 true true =Sum(Fields!ValorTotalItem.Value) 0.3pt #caebfc 2pt 2pt 2pt 2pt true true =Format(Sum(Fields!DESCONTO.Value), "###,##0.00") Textbox227 0.3pt #caebfc 2pt 2pt 2pt 2pt true true =Sum(Fields!ACRESCIMO.Value) 0.3pt #caebfc 2pt 2pt 2pt 2pt true true =Sum(Fields!FRETE.Value) 0.3pt #caebfc 2pt 2pt 2pt 2pt true true =Sum(Fields!Despesas.Value) 0.3pt #caebfc 2pt 2pt 2pt 2pt true true =Sum(Fields!IPI.Value) 0.3pt #caebfc 2pt 2pt 2pt 2pt true true =Sum(Fields!ICMS.Value) 0.3pt #caebfc 2pt 2pt 2pt 2pt true true =Sum(Fields!ICMSST.Value) 0.3pt #caebfc 2pt 2pt 2pt 2pt true true =Sum(Fields!ValorDiferencialAliquota.Value) 0.3pt #caebfc 2pt 2pt 2pt 2pt true true =Sum(Fields!ValorDepositoFundoReformaRS.Value) 0.3pt #caebfc 2pt 2pt 2pt 2pt true true =Sum(Fields!ValorFCPICMS.Value) 0.3pt #caebfc 2pt 2pt 2pt 2pt true true =Sum(Fields!ValorFCPST.Value) 0.3pt #caebfc 2pt 2pt 2pt 2pt true true =Sum(Fields!ValorFCP.Value) 0.3pt #caebfc 2pt 2pt 2pt 2pt true true =Sum(Iif(Fields!RowNumber.Value = 1, Fields!ValorRetISSQN.Value, 0.00D)) 0.3pt #caebfc 2pt 2pt 2pt 2pt true true =Sum(Iif(Fields!RowNumber.Value = 1, Fields!ValorINSS.Value, 0.00D)) 0.3pt #caebfc 2pt 2pt 2pt 2pt true true =Sum(Iif(Fields!RowNumber.Value = 1, Fields!ValorIRRF.Value, 0.00D)) 0.3pt #caebfc 2pt 2pt 2pt 2pt true true =Sum(Iif(Fields!RowNumber.Value = 1, Fields!ValorCSLL.Value, 0.00D)) 0.3pt #caebfc 2pt 2pt 2pt 2pt true true =Sum(Iif(Fields!RowNumber.Value = 1, Fields!ValorPISRetencao.Value, 0.00D)) 0.3pt #caebfc 2pt 2pt 2pt 2pt true true =Sum(Iif(Fields!RowNumber.Value = 1, Fields!ValorCOFINSRetencao.Value, 0.00D)) 0.3pt #caebfc 2pt 2pt 2pt 2pt true true =Sum(Fields!ValorContabil.Value) 0.3pt #caebfc 2pt 2pt 2pt 2pt true true =Sum(Fields!PesoLiquido.Value) 0.3pt #caebfc 2pt 2pt 2pt 2pt true true 0.3pt #caebfc 2pt 2pt 2pt 2pt =Parameters!MostrarNFSE.Value = False =Parameters!MostrarCPFCNPJClientes.Value = false =Parameters!MostrarDadosFCP.Value = false =Parameters!MostrarValorDepositoFundoReformaRS.Value = False =Parameters!MostrarDadosFCP.Value = false =Parameters!MostrarDadosFCP.Value = false =Parameters!MostrarDadosFCP.Value = false =Parameters!MostrarIRFServicos.Value = false =Parameters!MostrarIRFServicos.Value = false =Parameters!MostrarIRFServicos.Value = false =Parameters!MostrarIRFServicos.Value = false =Parameters!MostrarIRFServicos.Value = false =Parameters!MostrarIRFServicos.Value = false =Parameters!MostrarPeso.Value = false =Parameters!MostrarMensagemNf.Value = False =Fields!CodNota.Value =Fields!CodNota.Value =Parameters!TipoAnalise.Value = 1 Or Parameters!Analise.Value = 0 Or Parameters!Analise.Value = 2 =Parameters!TipoAnalise.Value = 1 Or Parameters!Analise.Value = 0 Or Parameters!Analise.Value = 2 =Parameters!TipoAnalise.Value = 1 Or Parameters!Analise.Value = 0 Or Parameters!Analise.Value = 2 Before true Before dsNotas 0cm 0.00002cm 2.8825cm 56.89862cm 1 =Parameters!Analise.Value <> 1 1.09771cm 8.40362cm 3.08292cm 1.9629cm 1.9629cm 1.9629cm 1.9629cm 3.49242cm 1.9629cm 1.9629cm 2.06873cm 2.82119cm 2.627cm 0.54709cm true true Cod Textbox30 #ffff99 2pt 2pt 2pt 2pt true true Natureza: #ffff99 2pt 2pt 2pt 2pt true true Total Prod. Textbox31 #ffff99 2pt 2pt 2pt 2pt true true IPI Textbox24 #ffff99 2pt 2pt 2pt 2pt true true ICMS Textbox26 #ffff99 2pt 2pt 2pt 2pt true true ICMS ST Textbox26 #ffff99 2pt 2pt 2pt 2pt true true DIFAL Textbox306 #ffff99 2pt 2pt 2pt 2pt true true Fundo Reforma RS Textbox17 #ffff99 2pt 2pt 2pt 2pt true true FCP Textbox285 #ffff99 2pt 2pt 2pt 2pt true true FCP ST Textbox293 #ffff99 2pt 2pt 2pt 2pt true true FCP DIFAL Textbox361 #ffff99 2pt 2pt 2pt 2pt true true Valor Textbox7 #ffff99 2pt 2pt 2pt 2pt true true Peso Textbox234 #ffff99 2pt 2pt 2pt 2pt 0.44125cm true true =Fields!Cod.Value Cod =IIf(((RowNumber(nothing) mod 2) =0), "White", "Silver") 2pt 2pt 2pt 2pt true true =Fields!Natureza.Value =IIf(((RowNumber(nothing) mod 2) =0), "White", "Silver") 2pt 2pt 2pt 2pt true true =Fields!ValorTotalProduto.Value ValorTotalProduto =IIf(((RowNumber(nothing) mod 2) =0), "White", "Silver") 2pt 2pt 2pt 2pt true true =Fields!IPI.Value IPI1 =IIf(((RowNumber(nothing) mod 2) =0), "White", "Silver") 2pt 2pt 2pt 2pt true true =Fields!ICMS.Value ICMS1 =IIf(((RowNumber(nothing) mod 2) =0), "White", "Silver") 2pt 2pt 2pt 2pt true true =Fields!ICMSST.Value ICMS1 =IIf(((RowNumber(nothing) mod 2) =0), "White", "Silver") 2pt 2pt 2pt 2pt true true =Fields!DIFAL.Value DIFAL =IIf(((RowNumber(nothing) mod 2) =0), "White", "Silver") 2pt 2pt 2pt 2pt true true =Fields!ValorTotalDepositoFundoReformaRS.Value ValorTotalDepositoFundoReformaRS =IIf(((RowNumber(nothing) mod 2) =0), "White", "Silver") 2pt 2pt 2pt 2pt true true =Fields!FCPICMS.Value FCPICMS =IIf(((RowNumber(nothing) mod 2) =0), "White", "Silver") 2pt 2pt 2pt 2pt true true =Fields!FCPST.Value FCPST =IIf(((RowNumber(nothing) mod 2) =0), "White", "Silver") 2pt 2pt 2pt 2pt true true =Fields!FCP.Value FCP =IIf(((RowNumber(nothing) mod 2) =0), "White", "Silver") 2pt 2pt 2pt 2pt true true =Fields!ValorTotal.Value ValorTotal =IIf(((RowNumber(nothing) mod 2) =0), "White", "Silver") 2pt 2pt 2pt 2pt true true =Fields!PesoLiquidoTotal.Value PesoLiquidoTotal =IIf(((RowNumber(nothing) mod 2) =0), "White", "Silver") 2pt 2pt 2pt 2pt 0.49416cm true true Total: Textbox33 #ffff99 2pt 2pt 2pt 2pt 2 true true =Sum(Fields!ValorTotalProduto.Value) Textbox46 #ffff99 2pt 2pt 2pt 2pt true true =Sum(Fields!IPI.Value) Textbox29 #ffff99 2pt 2pt 2pt 2pt true true =Sum(Fields!ICMS.Value) ICMS2 #ffff99 2pt 2pt 2pt 2pt true true =Sum(Fields!ICMSST.Value) ICMS2 #ffff99 2pt 2pt 2pt 2pt true true =Sum(Fields!DIFAL.Value) Textbox332 #ffff99 2pt 2pt 2pt 2pt true true =Sum(Fields!ValorTotalDepositoFundoReformaRS.Value) Textbox299 #ffff99 2pt 2pt 2pt 2pt true true =Sum(Fields!FCPICMS.Value) Textbox288 #ffff99 2pt 2pt 2pt 2pt true true =Sum(Fields!FCPST.Value) Textbox295 #ffff99 2pt 2pt 2pt 2pt true true =Sum(Fields!FCP.Value) Textbox364 #ffff99 2pt 2pt 2pt 2pt true true =Sum(Fields!ValorTotal.Value) Textbox21 #ffff99 2pt 2pt 2pt 2pt true true =Sum(Fields!PesoLiquidoTotal.Value) Textbox255 #ffff99 2pt 2pt 2pt 2pt 0.54709cm true true Total Entradas: Textbox34 2pt 2pt 2pt 2pt 2 true true =Parameters!TotalEntradaProduto.Value Textbox48 2pt 2pt 2pt 2pt true true =Parameters!TotalEntradasIPI.Value Textbox38 2pt 2pt 2pt 2pt true true =Parameters!TotalEntradasICMS.Value Textbox39 2pt 2pt 2pt 2pt true true =Parameters!TotalEntradasICMSST.Value Textbox39 2pt 2pt 2pt 2pt true true =Parameters!TotalEntradasDIFAL.Value Textbox333 2pt 2pt 2pt 2pt true true =Sum(Fields!ValorTotalDepositoFundoReformaRS.Value) ValorTotalDepositoFundoReformaRS1 2pt 2pt 2pt 2pt true true =Parameters!TotalEntradasFCPICMS.Value Textbox289 2pt 2pt 2pt 2pt true true =Parameters!TotalEntradasFCPST.Value Textbox296 2pt 2pt 2pt 2pt true true =Parameters!TotalEntradasFCP.Value Textbox365 2pt 2pt 2pt 2pt true true =Parameters!TotalEntradas.Value Textbox23 2pt 2pt 2pt 2pt true true =Parameters!TotalEntradasPesoLiquido.Value Textbox259 2pt 2pt 2pt 2pt 0.52062cm true true Total Saídas: Textbox35 2pt 2pt 2pt 2pt 2 true true =Parameters!TotalSaidasProduto.Value Textbox49 2pt 2pt 2pt 2pt true true =Parameters!TotalSaidasIPI.Value Textbox41 2pt 2pt 2pt 2pt true true =Parameters!TotalSaidasICMS.Value Textbox42 2pt 2pt 2pt 2pt true true =Parameters!TotalSaidasICMSST.Value Textbox42 2pt 2pt 2pt 2pt true true =Parameters!TotalSaidasDIFAL.Value Textbox334 2pt 2pt 2pt 2pt true true =Sum(Fields!ValorTotalDepositoFundoReformaRS.Value) ValorTotalDepositoFundoReformaRS2 2pt 2pt 2pt 2pt true true =Parameters!TotalSaidasFCPICMS.Value Textbox290 2pt 2pt 2pt 2pt true true =Parameters!TotalSaidasFCPST.Value Textbox297 2pt 2pt 2pt 2pt true true =Parameters!TotalSaidasFCP.Value Textbox366 2pt 2pt 2pt 2pt true true =Parameters!TotalSaidas.Value Textbox25 2pt 2pt 2pt 2pt true true =Parameters!TotalSaidasPesoLiquido.Value Textbox281 2pt 2pt 2pt 2pt 0.52062cm true true Saldo: Textbox36 #e8e8e8 2pt 2pt 2pt 2pt 2 true true =Parameters!TotalSaidasProduto.Value - Parameters!TotalEntradaProduto.Value Textbox51 #e8e8e8 2pt 2pt 2pt 2pt true true =Parameters!TotalSaidasIPI.Value-Parameters!TotalEntradasIPI.Value Textbox44 #e8e8e8 2pt 2pt 2pt 2pt true true =Parameters!TotalSaidasICMS.Value-Parameters!TotalEntradasICMS.Value Textbox45 #e8e8e8 2pt 2pt 2pt 2pt true true =Parameters!TotalSaidasICMSST.Value - Parameters!TotalEntradasICMSST.Value Textbox45 #e8e8e8 2pt 2pt 2pt 2pt true true =Parameters!TotalSaidasDIFAL.Value - Parameters!TotalEntradasDIFAL.Value Textbox335 #e8e8e8 2pt 2pt 2pt 2pt true true =Sum(Fields!ValorTotalDepositoFundoReformaRS.Value) ValorTotalDepositoFundoReformaRS3 #e8e8e8 2pt 2pt 2pt 2pt true true =Parameters!TotalSaidasFCPICMS.Value - Parameters!TotalEntradasFCPICMS.Value Textbox292 #e8e8e8 2pt 2pt 2pt 2pt true true =Parameters!TotalSaidasFCPST.Value - Parameters!TotalEntradasFCPST.Value Textbox298 #e8e8e8 2pt 2pt 2pt 2pt true true =Parameters!TotalSaidasFCP.Value - Parameters!TotalEntradasFCP.Value Textbox368 #e8e8e8 2pt 2pt 2pt 2pt true true =Parameters!TotalSaidas.Value-Parameters!TotalEntradas.Value Textbox27 #e8e8e8 2pt 2pt 2pt 2pt true true =Parameters!TotalSaidasPesoLiquido.Value - Parameters!TotalEntradasPesoLiquido.Value Textbox282 #e8e8e8 2pt 2pt 2pt 2pt =Parameters!MostrarDadosFCP.Value = false =Parameters!MostrarValorDepositoFundoReformaRS.Value = False =Parameters!MostrarDadosFCP.Value = False =Parameters!MostrarDadosFCP.Value = False =Parameters!MostrarDadosFCP.Value = false =Parameters!MostrarPeso.Value = false After true true Before Before Before Before dsNatureza =Fields!Natureza.Value 5.98548cm 0.00002cm 3.07083cm 35.37099cm 2 true true Resumo por Natureza de Operação 2pt 2pt 2pt 2pt 2.47249cm 2.5cm 3cm 3cm 3cm 3cm 3cm 3cm 4.27271cm 3cm 0.52062cm true true DataEmis Textbox2 #caebfc 2pt 2pt 2pt 2pt true true Total Prod. Textbox18 #caebfc 2pt 2pt 2pt 2pt true true DES. Textbox48 #caebfc 2pt 2pt 2pt 2pt true true ACRÉSC. Textbox12 #caebfc 2pt 2pt 2pt 2pt true true FRETE Textbox47 #caebfc 2pt 2pt 2pt 2pt true true IPI Textbox6 #caebfc 2pt 2pt 2pt 2pt true true ICMS Textbox12 #caebfc 2pt 2pt 2pt 2pt true true ICMSST Textbox40 #caebfc 2pt 2pt 2pt 2pt true true Fundo Reforma RS Textbox300 #caebfc 2pt 2pt 2pt 2pt true true Valor Textbox5 #caebfc 2pt 2pt 2pt 2pt 0.44125cm true true =Fields!DataEmissao.Value =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 2pt 2pt true true =Sum(Fields!ValorTotalItem.Value) ValorTotalItem1 =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 2pt 2pt true true =Format(Sum(Fields!DESCONTO.Value), "###,##0.00") & " (" & Format(((Sum(Fields!DESCONTO.Value)/Sum(Fields!ValorTotalItem.Value))*100), "###,##0.00") & ")" DESCONTO =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 2pt 2pt true true =Sum(Fields!ACRESCIMO.Value) Textbox15 =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 2pt 2pt true true =Sum(Fields!FRETE.Value) FRETE =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 2pt 2pt true true =Sum(Fields!IPI.Value) IPI =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 2pt 2pt true true =Sum(Fields!ICMS.Value) ICMS =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 2pt 2pt true true =Sum(Fields!ICMSST.Value) ICMSST =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 2pt 2pt true true =Sum(Fields!ValorDepositoFundoReformaRS.Value) ValorDepositoFundoReformaRS7 =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 2pt 2pt true true =Sum(Fields!ValorContabil.Value) ValorContabil =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 2pt 2pt 0.52062cm true true Total: Textbox14 #caebfc 2pt 2pt 2pt 2pt true true =Sum(Fields!ValorTotalItem.Value) ValorTotalItem2 #caebfc 2pt 2pt 2pt 2pt true true =Format(Sum(Fields!DESCONTO.Value), "###,##0.00") Textbox51 #caebfc 2pt 2pt 2pt 2pt true true =Sum(Fields!ACRESCIMO.Value) Textbox16 #caebfc 2pt 2pt 2pt 2pt true true =Sum(Fields!FRETE.Value) Textbox49 #caebfc 2pt 2pt 2pt 2pt true true =Sum(Fields!IPI.Value) Textbox18 #caebfc 2pt 2pt 2pt 2pt true true =Sum(Fields!ICMS.Value) Textbox19 #caebfc 2pt 2pt 2pt true true =Sum(Fields!ICMSST.Value) Textbox46 #caebfc 2pt 2pt 2pt 2pt true true =Sum(Fields!ValorDepositoFundoReformaRS.Value) Textbox329 #caebfc 2pt 2pt 2pt 2pt true true =Sum(Fields!ValorContabil.Value) Textbox9 #caebfc 2pt 2pt 2pt 2pt =Parameters!MostrarValorDepositoFundoReformaRS.Value = False After true true =Fields!DataEmissao.Value Before true dsNotas =Fields!DataEmissao.Value 0cm 0.00002cm 1.48249cm 30.2452cm 4 =Parameters!Analise.Value = 0 or Parameters!Analise.Value = 1 Or Parameters!Analise.Value = 3 2.60586cm 10.55705cm 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 19.51956cm 0.00002cm 0.8cm 13.16291cm 5 0.3cm true true Resumo por Grupo 2pt 2pt 2pt 2pt 1.09229cm 3.91171cm 2.42867cm 3.08577cm 2.10583cm 2.10583cm 1.78833cm 1.99289cm 2.01059cm 1.77647cm 2.93133cm 0.54709cm true true Cod Textbox30 #ffff99 2pt 2pt 2pt 2pt true true Grupo #ffff99 2pt 2pt 2pt 2pt true true Quantidade Textbox154 #ffff99 2pt 2pt 2pt 2pt true true Total Prod. Textbox31 #ffff99 2pt 2pt 2pt 2pt true true DES. Textbox159 #ffff99 2pt 2pt 2pt 2pt true true ACRÉSC. Textbox167 #ffff99 2pt 2pt 2pt 2pt true true FRETE Textbox178 #ffff99 2pt 2pt 2pt 2pt true true IPI Textbox24 #ffff99 2pt 2pt 2pt 2pt true true ICMS Textbox26 #ffff99 2pt 2pt 2pt 2pt true true ICMSST Textbox195 #ffff99 2pt 2pt 2pt 2pt true true Valor Líquido Textbox7 #ffff99 2pt 2pt 2pt 2pt 0.44125cm true true =Fields!CodProdutosGrupos.Value =IIf(((RowNumber(nothing) mod 2) =0), "White", "Silver") 2pt 2pt 2pt 2pt true true =Fields!DescricaoProdutosGrupos.Value =IIf(((RowNumber(nothing) mod 2) =0), "White", "Silver") 2pt 2pt 2pt 2pt true true =Fields!Quantidade.Value =IIf(((RowNumber(nothing) mod 2) =0), "White", "Silver") 2pt 2pt 2pt 2pt true true =Fields!ValorTotalProdutosGrupos.Value ValorTotalProdutosGrupos =IIf(((RowNumber(nothing) mod 2) =0), "White", "Silver") 2pt 2pt 2pt 2pt true true =Format(Fields!Desconto.Value, "###,##0.00") Desconto =IIf(((RowNumber(nothing) mod 2) =0), "White", "Silver") 2pt 2pt 2pt 2pt true true =Fields!Acrescimo.Value Acrescimo =IIf(((RowNumber(nothing) mod 2) =0), "White", "Silver") 2pt 2pt 2pt 2pt true true =Fields!Frete.Value Frete =IIf(((RowNumber(nothing) mod 2) =0), "White", "Silver") 2pt 2pt 2pt 2pt true true =Fields!IPI.Value IPI1 =IIf(((RowNumber(nothing) mod 2) =0), "White", "Silver") 2pt 2pt 2pt 2pt true true =Fields!ICMS.Value ICMS1 =IIf(((RowNumber(nothing) mod 2) =0), "White", "Silver") 2pt 2pt 2pt 2pt true true =Fields!ICMSST.Value ICMSST =IIf(((RowNumber(nothing) mod 2) =0), "White", "Silver") 2pt 2pt 2pt 2pt true true =Fields!ValorLiquido.Value ValorLiquido =IIf(((RowNumber(nothing) mod 2) =0), "White", "Silver") 2pt 2pt 2pt 2pt 0.49416cm true true Total: Textbox33 #ffff99 2pt 2pt 2pt 2pt 2 true true =Sum(Fields!Quantidade.Value) Textbox156 #ffff99 2pt 2pt 2pt 2pt true true =Sum(Fields!ValorTotalProdutosGrupos.Value) Textbox46 #ffff99 2pt 2pt 2pt 2pt true true =Format(Sum(Fields!Desconto.Value), "###,##0.00") Desconto1 #ffff99 2pt 2pt 2pt 2pt true true =Sum(Fields!Acrescimo.Value) Textbox170 #ffff99 2pt 2pt 2pt 2pt true true =Sum(Fields!Frete.Value) Textbox189 #ffff99 2pt 2pt 2pt 2pt true true =Sum(Fields!IPI.Value) Textbox29 #ffff99 2pt 2pt 2pt 2pt true true =Sum(Fields!ICMS.Value) Textbox174 #ffff99 2pt 2pt 2pt 2pt true true =Sum(Fields!ICMSST.Value) Textbox205 #ffff99 2pt 2pt 2pt 2pt true true =Sum(Fields!ValorLiquido.Value) Textbox21 #ffff99 2pt 2pt 2pt 2pt After true true Before dsProdutosGrupos =Fields!CodProdutosGrupos.Value 14.47114cm 0.00002cm 1.4825cm 25.22971cm 7 =Parameters!MostrarResumoPorGrupo.Value = False 1.09771cm 8.40362cm 3.08292cm 1.80415cm 1.80415cm 1.80415cm 3.08577cm 0.54709cm true true Cod Textbox30 #ffff99 2pt 2pt 2pt 2pt true true Centro de Custo: #ffff99 2pt 2pt 2pt 2pt true true Total Prod. Textbox31 #ffff99 2pt 2pt 2pt 2pt true true IPI Textbox24 #ffff99 2pt 2pt 2pt 2pt true true ICMS Textbox26 #ffff99 2pt 2pt 2pt 2pt true true ICMS ST Textbox26 #ffff99 2pt 2pt 2pt 2pt true true Valor Textbox7 #ffff99 2pt 2pt 2pt 2pt 0.44125cm true true =Fields!CodCentrosCusto.Value Cod =IIf(((RowNumber(nothing) mod 2) =0), "White", "Silver") 2pt 2pt 2pt 2pt true true =Fields!CentrosCusto.Value =IIf(((RowNumber(nothing) mod 2) =0), "White", "Silver") 2pt 2pt 2pt 2pt true true =Sum(Fields!ValorTotalProduto.Value) ValorTotalProduto =IIf(((RowNumber(nothing) mod 2) =0), "White", "Silver") 2pt 2pt 2pt 2pt true true =Sum(Fields!IPI.Value) IPI1 =IIf(((RowNumber(nothing) mod 2) =0), "White", "Silver") 2pt 2pt 2pt 2pt true true =Sum(Fields!ICMS.Value) ICMS1 =IIf(((RowNumber(nothing) mod 2) =0), "White", "Silver") 2pt 2pt 2pt 2pt true true =Sum(Fields!ICMSST.Value) ICMS1 =IIf(((RowNumber(nothing) mod 2) =0), "White", "Silver") 2pt 2pt 2pt 2pt true true =Sum(Fields!ValorTotal.Value) ValorTotal =IIf(((RowNumber(nothing) mod 2) =0), "White", "Silver") 2pt 2pt 2pt 2pt 0.49416cm true true Total: Textbox33 #ffff99 2pt 2pt 2pt 2pt 2 true true =Sum(Fields!ValorTotalProduto.Value) Textbox46 #ffff99 2pt 2pt 2pt 2pt true true =Sum(Fields!IPI.Value) Textbox29 #ffff99 2pt 2pt 2pt 2pt true true =Sum(Fields!ICMS.Value) ICMS2 #ffff99 2pt 2pt 2pt 2pt true true =Sum(Fields!ICMSST.Value) ICMS2 #ffff99 2pt 2pt 2pt 2pt true true =Sum(Fields!ValorTotal.Value) Textbox21 #ffff99 2pt 2pt 2pt 2pt 0.54709cm true true Total Entradas: Textbox34 2pt 2pt 2pt 2pt 2 true true =Parameters!TotalEntradaProduto.Value Textbox48 2pt 2pt 2pt 2pt true true =Parameters!TotalEntradasIPI.Value Textbox38 2pt 2pt 2pt 2pt true true =Parameters!TotalEntradasICMS.Value Textbox39 2pt 2pt 2pt 2pt true true =Parameters!TotalEntradasICMSST.Value Textbox39 2pt 2pt 2pt 2pt true true =Parameters!TotalEntradas.Value Textbox23 2pt 2pt 2pt 2pt 0.52062cm true true Total Saídas: Textbox35 2pt 2pt 2pt 2pt 2 true true =Parameters!TotalSaidasProduto.Value Textbox49 2pt 2pt 2pt 2pt true true =Parameters!TotalSaidasIPI.Value Textbox41 2pt 2pt 2pt 2pt true true =Parameters!TotalSaidasICMS.Value Textbox42 2pt 2pt 2pt 2pt true true =Parameters!TotalSaidasICMSST.Value Textbox42 2pt 2pt 2pt 2pt true true =Parameters!TotalSaidas.Value Textbox25 2pt 2pt 2pt 2pt 0.52062cm true true Saldo: Textbox36 #e8e8e8 2pt 2pt 2pt 2pt 2 true true =Parameters!TotalSaidasProduto.Value - Parameters!TotalEntradaProduto.Value Textbox51 #e8e8e8 2pt 2pt 2pt 2pt true true =Parameters!TotalSaidasIPI.Value - Parameters!TotalEntradasIPI.Value Textbox44 #e8e8e8 2pt 2pt 2pt 2pt true true =Parameters!TotalSaidasICMS.Value - Parameters!TotalEntradasICMS.Value Textbox45 #e8e8e8 2pt 2pt 2pt 2pt true true =Parameters!TotalSaidasICMSST.Value - Parameters!TotalEntradasICMSST.Value Textbox45 #e8e8e8 2pt 2pt 2pt 2pt true true =Parameters!TotalSaidas.Value - Parameters!TotalEntradas.Value Textbox27 #e8e8e8 2pt 2pt 2pt 2pt After true true =Fields!CodCentrosCusto.Value =Fields!CodSubCentrosCusto.Value =Fields!CodCentrosCusto.Value =Fields!CodSubCentrosCusto.Value Before Before Before Before true dsCentrosCusto 10.23524cm 0.00002cm 3.07083cm 21.08247cm 8 =Parameters!MostrarResumoCentrosCusto.Value = false true true Resumo por Centro de Custo 2pt 2pt 2pt 2pt 7.31134cm 2.8cm 2.8cm 2.8cm 2.8cm 0.6cm true true Resumo por Grupo de Similaridade de Produto 2pt 2pt 2pt 2pt 5 0.5cm true true Grupo Similaridade #ffff99 2pt 2pt 2pt 2pt true true Qtd Entrada Textbox315 #ffff99 2pt 2pt 2pt 2pt true true Valor Entrada Textbox317 #ffff99 2pt 2pt 2pt 2pt true true Qtd Saída Textbox323 #ffff99 2pt 2pt 2pt 2pt true true Valor Saída Textbox327 #ffff99 2pt 2pt 2pt 2pt 0.4cm true true =Fields!GrupoSimilaridade.Value 2pt 2pt 2pt 2pt true true =Fields!QuantidadeEntrada.Value QuantidadeEntrada 2pt 2pt 2pt 2pt true true =Fields!ValorEntrada.Value ValorEntrada1 2pt 2pt 2pt 2pt true true =Fields!QuantidadeSaida.Value QuantidadeSaida 2pt 2pt 2pt 2pt true true =Fields!ValorSaida.Value ValorSaida1 2pt 2pt 2pt 2pt 0.5cm true true Total: Textbox343 #ffff99 2pt 2pt 2pt 2pt true true =Sum(Fields!QuantidadeEntrada.Value) Textbox316 #ffff99 2pt 2pt 2pt 2pt true true =Sum(Fields!ValorEntrada.Value) Textbox342 #ffff99 2pt 2pt 2pt 2pt true true =Sum(Fields!QuantidadeSaida.Value) Textbox326 #ffff99 2pt 2pt 2pt 2pt true true =Sum(Fields!ValorSaida.Value) Textbox352 #ffff99 2pt 2pt 2pt 2pt 0.5cm true true Valor Saída - Entrada: Textbox348 #ffff99 2pt 2pt 2pt 2pt true true =Sum(Fields!ValorSaida.Value) - sum(Fields!ValorEntrada.Value) Textbox355 #ffff99 2pt 2pt 2pt 2pt true true #ffff99 2pt 2pt 2pt 2pt 3 After After =Fields!GrupoSimilaridade.Value Before Before dsNotas 16.61699cm 2.5cm 18.51134cm 10 =Parameters!MostrarResumoGrupoSimilaridade.Value = false 1.00767cm 0.6cm true true =Parameters!QuantidadeNotas.Value #e8e8e8 2pt 2pt 2pt 2pt 3.99635cm true true Quantidade de Notas: #e8e8e8 2pt 2pt 2pt 2pt dsNotas 4.19216cm 0.6cm 5.00402cm 11 1.6cm 2.1cm 2.1cm 1.5cm 1.6cm 2.6cm 2.5cm 1.57554cm 1.79273cm 2cm 1.6cm 1.6cm 1.6cm 1.91792cm 2.02375cm 1.6cm 1.6cm 2.02375cm 1.6cm 1.6cm 1.6cm 1.95425cm 2cm 2cm 2.74283cm 1.8cm 0.55cm true true Cliente Textbox493 0.3pt #caebfc 2pt 2pt 2pt 2pt 11 true true CPF/CNPJ: Textbox137 0.3pt #caebfc 2pt 2pt 2pt 2pt 15 0.5cm true true =Fields!CodCliente.Value CodCliente 0.3pt #caebfc 2pt 2pt 1pt true true =Fields!Cliente.Value & iif(System.String.IsNullOrEmpty(Fields!NomeFantasiaCliente.Value), "", " (" & Fields!NomeFantasiaCliente.Value & ")") Cliente 0.3pt #caebfc 2pt 2pt 1pt 10 true true =Fields!CPFCNPJ.Value CodCliente 0.3pt #caebfc 2pt 2pt 1pt 15 0.83cm true true Natureza Textbox13 0.3pt #e8e8e8 2pt 2pt 1pt true true Data Emissão Textbox2 0.3pt #e8e8e8 2pt 2pt 1pt true true Data Lançamento Textbox11 0.3pt #e8e8e8 2pt 2pt 1pt true true NFSe Textbox10 0.3pt #e8e8e8 2pt 2pt 1pt true true Nota Textbox10 0.3pt #e8e8e8 2pt 2pt 1pt true true Total Produtos/ Serviços Textbox47 0.3pt #e8e8e8 2pt 2pt 1pt true true DESCONTOS Textbox48 0.3pt #e8e8e8 2pt 2pt 1pt true true ACRÉSC. Textbox8 0.3pt #e8e8e8 2pt 2pt 1pt true true FRETE Textbox47 0.3pt #e8e8e8 2pt 2pt 1pt true true DESPESAS Textbox1 0.3pt #e8e8e8 2pt 2pt 1pt true true IPI Textbox6 0.3pt #e8e8e8 2pt 2pt 1pt true true ICMS Textbox12 0.3pt #e8e8e8 2pt 2pt 1pt true true ICMSST Textbox40 0.3pt #e8e8e8 2pt 2pt 1pt true true DIFAL Textbox347 0.3pt #e8e8e8 2pt 2pt 1pt true true Fundo Reforma RS Textbox305 0.3pt #e8e8e8 2pt 2pt 1pt true true FCP Textbox1 0.3pt #e8e8e8 2pt 2pt 1pt true true FCP ST Textbox10 0.3pt #e8e8e8 2pt 2pt 1pt true true FCP DIFAL Textbox353 0.3pt #e8e8e8 2pt 2pt 1pt true true ISSQN Retido Textbox219 0.3pt #e8e8e8 2pt 2pt 1pt true true INSS Retido Textbox226 0.3pt #e8e8e8 2pt 2pt 1pt true true IRRF Retido Textbox238 0.3pt #e8e8e8 2pt 2pt 1pt true true CSLL Ret Textbox266 0.3pt #e8e8e8 2pt 2pt 1pt true true PIS Ret Textbox122 0.3pt #e8e8e8 2pt 2pt 1pt true true COFINS Ret Textbox132 0.3pt #e8e8e8 2pt 2pt 1pt true true Valor Textbox86 0.3pt #e8e8e8 2pt 2pt 1pt true true Peso Textbox80 0.3pt #e8e8e8 2pt 2pt 1pt 0.5cm true true =Fields!Natureza.Value DataEmissao 0.3pt 2pt 2pt 2pt true true =Format(Fields!DataEmissao.Value, "dd/MM/yyyy") CodProdutos 0.3pt 2pt 2pt 2pt true true =Fields!DataLancamento.Value DataLancamento 0.3pt 2pt 2pt 2pt true true =iif(Fields!NFSE.Value = 0,"",Fields!NFSE.Value) NFSE1 0.3pt 2pt 2pt 2pt true true =Fields!Nota.Value Nota 0.3pt 2pt 2pt 2pt true true =Sum(Fields!ValorTotalItem.Value) ValorTotalItem 0.3pt 2pt 2pt 2pt true true =Format(Sum(Fields!DESCONTO.Value), "###,##0.00") & " (" & Format(Fields!PercentualDesc.Value, "###,##0.00") & ")" DESCONTO1 0.3pt 2pt 2pt 2pt true true =Sum(Fields!ACRESCIMO.Value) ACRESCIMO 0.3pt 2pt 2pt 2pt true true =Sum(Fields!FRETE.Value) FRETE1 0.3pt 2pt 2pt 2pt true true =Sum(Fields!Despesas.Value) Despesas 0.3pt 2pt 2pt 2pt true true =Sum(Fields!IPI.Value) IPI4 0.3pt 2pt 2pt 2pt true true =Sum(Fields!ICMS.Value) ICMS5 0.3pt 2pt 2pt 2pt true true =Sum(Fields!ICMSST.Value) ICMSST1 0.3pt 2pt 2pt 2pt true true =Sum(Fields!ValorDiferencialAliquota.Value) ValorDiferencialAliquota1 0.3pt 2pt 2pt 2pt true true =Sum(Fields!ValorDepositoFundoReformaRS.Value) ValorDepositoFundoReformaRS5 0.3pt 2pt 2pt 2pt true true =Sum(Fields!ValorFCPICMS.Value) ValorFCPICMS 0.3pt 2pt 2pt 2pt true true =Sum(Fields!ValorFCPST.Value) ValorFCPST 0.3pt 2pt 2pt 2pt true true =Sum(Fields!ValorFCP.Value) ValorFCP1 0.3pt 2pt 2pt 2pt true true =Fields!ValorRetISSQN.Value ValorRetISSQN 0.3pt 2pt 2pt 2pt true true =Fields!ValorINSS.Value ValorINSS 0.3pt 2pt 2pt 2pt true true =Fields!ValorIRRF.Value ValorIRRF 0.3pt 2pt 2pt 2pt true true =Fields!ValorCSLL.Value ValorCSLL 0.3pt 2pt 2pt 2pt true true =Fields!ValorPISRetencao.Value ValorPISRetencao1 0.3pt 2pt 2pt 2pt true true =Fields!ValorCOFINSRetencao.Value ValorCOFINSRetencao1 0.3pt 2pt 2pt 2pt true true =Sum(Fields!ValorContabil.Value) Textbox87 0.3pt 2pt 2pt 2pt true true =Sum(Fields!PesoLiquido.Value) Textbox81 0.3pt 2pt 2pt 2pt 0.5cm true true Total: Textbox502 0.3pt #e1e1e1 2pt 2pt 2pt 5 true true =Sum(Fields!ValorTotalItem.Value) ValorTotalProdutos 0.3pt #e1e1e1 2pt 2pt 2pt true true =Format(Sum(Fields!DESCONTO.Value), "###,##0.00") DESCONTO 0.3pt #e1e1e1 2pt 2pt 2pt true true =Sum(Fields!ACRESCIMO.Value) Textbox10 0.3pt #e1e1e1 2pt 2pt 2pt true true =Sum(Fields!FRETE.Value) FRETE 0.3pt #e1e1e1 2pt 2pt 2pt true true =Sum(Fields!Despesas.Value) Textbox2 0.3pt #e1e1e1 2pt 2pt 2pt true true =Sum(Fields!IPI.Value) IPI 0.3pt #e1e1e1 2pt 2pt 2pt true true =Sum(Fields!ICMS.Value) ICMS 0.3pt #e1e1e1 2pt 2pt 2pt true true =Sum(Fields!ICMSST.Value) ICMSST 0.3pt #e1e1e1 2pt 2pt 2pt true true =Sum(Fields!ValorDiferencialAliquota.Value) Textbox349 0.3pt #e1e1e1 2pt 2pt 2pt true true =Sum(Fields!ValorDepositoFundoReformaRS.Value) Textbox314 0.3pt #e1e1e1 2pt 2pt 2pt true true =Sum(Fields!ValorFCPICMS.Value) Textbox5 0.3pt #e1e1e1 2pt 2pt 2pt true true =Sum(Fields!ValorFCPST.Value) Textbox13 0.3pt #e1e1e1 2pt 2pt 2pt true true =Sum(Fields!ValorFCP.Value) Textbox358 0.3pt #e1e1e1 2pt 2pt 2pt true true =Sum(Iif(Fields!RowNumber.Value = 1, Fields!ValorRetISSQN.Value, 0.00D)) Textbox221 0.3pt #e1e1e1 2pt 2pt 2pt true true =Sum(Iif(Fields!RowNumber.Value = 1, Fields!ValorINSS.Value, 0.00D)) Textbox228 0.3pt #e1e1e1 2pt 2pt 2pt true true =Sum(Iif(Fields!RowNumber.Value = 1, Fields!ValorIRRF.Value, 0.00D)) Textbox242 0.3pt #e1e1e1 2pt 2pt 2pt true true =Sum(Iif(Fields!RowNumber.Value = 1, Fields!ValorCSLL.Value, 0.00D)) Textbox268 0.3pt #e1e1e1 2pt 2pt 2pt true true =Sum(Iif(Fields!RowNumber.Value = 1, Fields!ValorPISRetencao.Value, 0.00D)) Textbox128 0.3pt #e1e1e1 2pt 2pt 2pt true true =Sum(Iif(Fields!RowNumber.Value = 1, Fields!ValorCOFINSRetencao.Value, 0.00D)) Textbox141 0.3pt #e1e1e1 2pt 2pt 2pt true true =Sum(Fields!ValorContabil.Value) Textbox88 0.3pt #e1e1e1 2pt 2pt 2pt true true =Sum(Fields!PesoLiquido.Value) Textbox85 0.3pt #e1e1e1 2pt 2pt 2pt 0.25577cm true true 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt 0.54cm true true Total Geral: Textbox149 0.3pt #caebfc 2pt 2pt 2pt 2pt 5 true true =Sum(Fields!ValorTotalItem.Value) 0.3pt #caebfc 2pt 2pt 2pt 2pt true true =Format(Sum(Fields!DESCONTO.Value), "###,##0.00") Textbox227 0.3pt #caebfc 2pt 2pt 2pt 2pt true true =Sum(Fields!ACRESCIMO.Value) 0.3pt #caebfc 2pt 2pt 2pt 2pt true true =Sum(Fields!FRETE.Value) 0.3pt #caebfc 2pt 2pt 2pt 2pt true true =Sum(Fields!Despesas.Value) 0.3pt #caebfc 2pt 2pt 2pt 2pt true true =Sum(Fields!IPI.Value) 0.3pt #caebfc 2pt 2pt 2pt 2pt true true =Sum(Fields!QuantidadeEntrada.Value) 0.3pt #caebfc 2pt 2pt 2pt 2pt true true =Sum(Fields!ValorEntrada.Value) 0.3pt #caebfc 2pt 2pt 2pt 2pt true true =Sum(Fields!QuantidadeSaida.Value) 0.3pt #caebfc 2pt 2pt 2pt 2pt true true =Sum(Fields!ValorSaida.Value) 0.3pt #caebfc 2pt 2pt 2pt 2pt true true =Sum(Fields!ValorFCPICMS.Value) 0.3pt #caebfc 2pt 2pt 2pt 2pt true true =Sum(Fields!ValorDepositoFundoReformaRS.Value) 0.3pt #caebfc 2pt 2pt 2pt 2pt true true =Sum(Fields!ValorFCP.Value) 0.3pt #caebfc 2pt 2pt 2pt 2pt true true =Sum(Iif(Fields!RowNumber.Value = 1, Fields!ValorRetISSQN.Value, 0.00D)) 0.3pt #caebfc 2pt 2pt 2pt 2pt true true =Sum(Iif(Fields!RowNumber.Value = 1, Fields!ValorINSS.Value, 0.00D)) 0.3pt #caebfc 2pt 2pt 2pt 2pt true true =Sum(Iif(Fields!RowNumber.Value = 1, Fields!ValorIRRF.Value, 0.00D)) 0.3pt #caebfc 2pt 2pt 2pt 2pt true true =Sum(Iif(Fields!RowNumber.Value = 1, Fields!ValorCSLL.Value, 0.00D)) 0.3pt #caebfc 2pt 2pt 2pt 2pt true true =Sum(Iif(Fields!RowNumber.Value = 1, Fields!ValorPISRetencao.Value, 0.00D)) 0.3pt #caebfc 2pt 2pt 2pt 2pt true true =Sum(Iif(Fields!RowNumber.Value = 1, Fields!ValorCOFINSRetencao.Value, 0.00D)) 0.3pt #caebfc 2pt 2pt 2pt 2pt true true =Sum(Fields!ValorContabil.Value) 0.3pt #caebfc 2pt 2pt 2pt 2pt true true =Sum(Fields!PesoLiquido.Value) 0.3pt #caebfc 2pt 2pt 2pt 2pt =Parameters!MostrarNFSE.Value = False =Parameters!MostrarDadosFCP.Value = false =Parameters!MostrarValorDepositoFundoReformaRS.Value = False =Parameters!MostrarDadosFCP.Value = false = Parameters!MostrarDadosFCP.Value = false =Parameters!MostrarDadosFCP.Value = false =Parameters!MostrarIRFServicos.Value = false =Parameters!MostrarIRFServicos.Value = false =Parameters!MostrarIRFServicos.Value = false =Parameters!MostrarIRFServicos.Value = false =Parameters!MostrarIRFServicos.Value = false =Parameters!MostrarIRFServicos.Value = false =Parameters!MostrarPeso.Value=false =Fields!CodCliente.Value After =Fields!CodNota.Value =Fields!CodNota.Value Before Before Before dsNotas 0cm 0.00002cm 3.67577cm 48.63077cm 12 =Parameters!Analise.Value <> 0 7.99983in Textbox1 1.05901cm 0.00002cm 0.58942cm 26.12882cm External =Parameters!LogoMenor.Value FitProportional 0.05116cm 0.00002cm 1.52672cm 5.14717cm 1 0.30896cm true true true true =Now() Textbox4 0cm 0.31752cm 0.30896cm 4.27271cm true true = "Pag: " & Globals!PageNumber & " de " & Globals!TotalPages PageNumber 0cm 23.07146cm 0.30896cm 2.05021cm 1 29.7cm 21cm 0.2cm 0.2cm 0.5cm 0.5cm 0.13cm