0 SQL 5ab246e2-24f8-46ad-86b7-f292e4a9131a DummyDataSource true NumeroNota System.String Emitente System.String CNPJCPF System.String DataEmissao System.String ValorProdutos System.String Funrural System.String Senar System.String FETHAB System.String IMAFIR System.String FUNDEMS System.String FUNDERSUL System.String IAGRO System.String FUNDEINFRA System.String CDO System.String ValorContabil System.String CodClientes System.String CodCodigosFiscais System.String ValorLiquido System.Decimal ValorFunruralSenar System.Decimal BaseSuspenso System.Decimal ValorSuspenso System.Decimal AliquotaFunruralPessoaFisica System.Decimal CodCidades System.Decimal CidadeDescricao System.String BaseIntegral System.Decimal ValorFunruralIntegral System.Decimal ValorSenarIntegral System.Decimal BaseSomenteSenar System.Decimal ValorSomenteSenar System.Decimal Observacao System.String BaseFunruralSenar System.Decimal DummyDataSource true CodProdutos System.Integer DescricaoProduto System.String ValorFUNDEINFRA System.Decimal 1.7cm 1.44271cm 1.03cm 8.31546cm 2.78833cm 2.3cm 1.83854cm 2.3cm 1.81208cm 1.70625cm 1.8cm 1.8cm 1.8cm 2.2cm 1.8cm 2.2cm 1.8cm 0.4cm true true Textbox68 0.3pt 2pt 2pt 1pt true true Textbox69 0.3pt 2pt 2pt 2pt 2pt true true Textbox70 2pt 2pt 2pt 2pt true true Textbox71 2pt 2pt 2pt 2pt true true Textbox72 2pt 2pt 2pt 2pt true true Textbox73 2pt 2pt 2pt 2pt true true Textbox74 2pt 2pt 2pt 2pt true true Textbox75 2pt 2pt 2pt 2pt true true Textbox83 2pt 2pt 1pt true true Textbox84 2pt 2pt 1pt true true Textbox2 2pt 2pt 1pt true true Textbox38 2pt 2pt 1pt true true Textbox60 2pt 2pt 1pt true true Textbox65 2pt 2pt 1pt true true Textbox78 2pt 2pt 1pt true true Textbox85 2pt 2pt 1pt true true Textbox90 2pt 2pt 1pt 0.5cm true true Data Textbox3 0.3pt #caebfc 2pt 2pt 1pt true true Nº Nota Textbox4 0.3pt #caebfc 2pt 2pt 2pt 2pt true true CFOP Textbox37 #caebfc 2pt 2pt 2pt 2pt true true Cliente Textbox6 #caebfc 2pt 2pt 2pt 2pt true true Cidade Textbox8 #caebfc 2pt 2pt 2pt 2pt true true Base Textbox10 #caebfc 2pt 2pt 2pt 2pt true true A Recolher Textbox39 #caebfc 2pt 2pt 2pt 2pt true true Líquido Textbox18 #caebfc 2pt 2pt 2pt 2pt true true Funrural Textbox12 #caebfc 2pt 2pt 2pt 2pt true true Senar Textbox16 #caebfc 2pt 2pt 2pt 2pt true true FETHAB Textbox7 #caebfc 2pt 2pt 2pt 2pt true true IMAFIR Textbox45 #caebfc 2pt 2pt 2pt 2pt true true FUNDEMS Textbox61 #caebfc 2pt 2pt 2pt 2pt true true FUNDERSUL Textbox66 #caebfc 2pt 2pt 2pt 2pt true true IAGRO Textbox79 #caebfc 2pt 2pt 2pt 2pt true true FUNDEINFRA Textbox86 #caebfc 2pt 2pt 2pt 2pt true true CDO Textbox91 #caebfc 2pt 2pt 2pt 2pt 0.4cm true true =Fields!DataEmissao.Value DataEmissao =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!NumeroNota.Value NumeroNota =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!CodCodigosFiscais.Value CodCodigosFiscais =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!CodClientes.Value & " - " & Fields!Emitente.Value Emitente =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!CidadeDescricao.Value CidadeDescricao =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!BaseFunruralSenar.Value BaseFunruralSenar =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!ValorFunruralSenar.Value ValorFunruralSenar =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!ValorLiquido.Value ValorLiquido =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!Funrural.Value Funrural =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!Senar.Value Senar =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!FETHAB.Value FETHAB =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!IMAFIR.Value IMAFIR =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!FUNDEMS.Value FUNDEMS =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!FUNDERSUL.Value FUNDERSUL =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!IAGRO.Value IAGRO =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!FUNDEINFRA.Value FUNDEINFRA =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!CDO.Value CDO =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt 0.4cm true true =Fields!Observacao.Value Observacao =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt 10 true true Textbox13 =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true Textbox58 =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true Textbox63 =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true Textbox76 =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true Textbox81 =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true Textbox88 =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true Textbox95 =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt 0.5cm true true Textbox146 2pt 2pt 1pt true true Textbox147 2pt 2pt 1pt true true Textbox148 2pt 2pt 1pt true true Textbox149 2pt 2pt 1pt true true TOTAL Textbox150 2pt 2pt 2pt 2pt true true =Sum(Fields!BaseFunruralSenar.Value) BaseFunruralSenar1 2pt 2pt 1pt true true =Sum(Fields!ValorFunruralSenar.Value) Textbox152 2pt 2pt 1pt true true =Sum(Fields!ValorLiquido.Value) Textbox44 2pt 2pt 1pt true true =Sum(Fields!Funrural.Value) Textbox9 2pt 2pt 1pt true true =Sum(Fields!Senar.Value) Textbox11 2pt 2pt 1pt true true =Sum(Fields!FETHAB.Value) FETHAB1 2pt 2pt 1pt true true =Sum(Fields!IMAFIR.Value) Textbox59 2pt 2pt 1pt true true =Sum(Fields!FUNDEMS.Value) Textbox64 2pt 2pt 1pt true true =Sum(Fields!FUNDERSUL.Value) Textbox77 2pt 2pt 1pt true true =Sum(Fields!IAGRO.Value) Textbox82 2pt 2pt 1pt true true =Sum(Fields!FUNDEINFRA.Value) Textbox89 2pt 2pt 1pt true true =Sum(Fields!CDO.Value) Textbox96 2pt 2pt 1pt =Parameters!AnalisarFETHAB.Value = false =Parameters!AnalisarIMAFIR.Value = false =Parameters!AnalisarFUNDEMS.Value = false =Parameters!AnalisarFUNDERSUL.Value = false =Parameters!AnalisarIAGRO.Value = false =Parameters!AnalisarFUNDEINFRA.Value = false =Parameters!AnalisarCDO.Value = false After true After true =Fields!Observacao.Value = "" Before dsFunruralSenar 0.81792cm 2.2cm 38.63337cm 0.75pt 2pt 2pt 1pt 1.77271cm 11.89962cm 1.60417cm 6.33646cm 0.5cm true true Empresa: 2pt 2pt 2pt 2pt true true =Parameters!Empresa.Value 2pt 2pt 2pt 2pt true true Período: 2pt 2pt 2pt 2pt true true =Parameters!Periodo.Value 2pt 2pt 2pt 2pt dsFunruralSenar 0.07056cm 0.5cm 21.61296cm 1 2pt 2pt 1pt 4.61667cm 2.5cm 2.34125cm 2cm 3.61858cm 2.5cm 2.5cm 0.4cm true true Resumo de Movimentações por Cidade 2pt 2pt 1pt 7 0.4cm true true Cidade #e8e8e8 2pt 2pt 1pt true true Base Integral Textbox40 #e8e8e8 2pt 2pt 1pt true true Funrural Textbox121 #e8e8e8 2pt 2pt 1pt true true Senar Textbox125 #e8e8e8 2pt 2pt 1pt true true Somente Senar Base Textbox17 #e8e8e8 2pt 2pt 1pt true true Somente Senar Textbox26 #e8e8e8 2pt 2pt 1pt true true Líquido Textbox129 #e8e8e8 2pt 2pt 1pt 0.13229cm true true =Fields!CidadeDescricao.Value 2pt 2pt 2pt 2pt true true =Fields!ValorContabil.Value 2pt 2pt 2pt 2pt true true =Fields!Funrural.Value Funrural1 2pt 2pt 2pt 2pt true true Textbox126 2pt 2pt 2pt 2pt true true Textbox22 2pt 2pt 2pt 2pt true true Textbox27 2pt 2pt 2pt 2pt true true Textbox130 2pt 2pt 2pt 2pt 0.4cm true true =Fields!CidadeDescricao.Value 2pt 2pt 1pt true true =sum(Fields!BaseIntegral.Value) 2pt 2pt 1pt true true =sum(Fields!ValorFunruralIntegral.Value ) Funrural2 2pt 2pt 1pt true true =Sum(Fields!ValorSenarIntegral.Value ) Senar1 2pt 2pt 1pt true true =Sum(Fields!BaseSomenteSenar.Value ) Textbox24 2pt 2pt 1pt true true =Sum(Fields!ValorSomenteSenar.Value) Textbox28 2pt 2pt 1pt true true =Sum(Fields!ValorLiquido.Value) ValorLiquido1 2pt 2pt 1pt 0.4cm true true 2pt 2pt 1pt true true =sum(Fields!BaseIntegral.Value) 2pt 2pt 1pt true true =sum(Fields!ValorFunruralIntegral.Value ) Funrural3 2pt 2pt 1pt true true =sum(Fields!ValorSenarIntegral.Value) Senar2 2pt 2pt 1pt true true =sum(Fields!BaseSomenteSenar.Value) Textbox25 2pt 2pt 1pt true true =Sum(Fields!ValorSomenteSenar.Value ) Textbox30 2pt 2pt 1pt true true =Sum(Fields!ValorLiquido.Value) ValorLiquido2 2pt 2pt 1pt =Fields!CodCidades.Value =Fields!CodCidades.Value true Before dsFunruralSenar 3.43939cm 1.73229cm 20.0765cm 2 0.75pt 2pt 2pt 1pt 2.81852cm 2.34227cm 2.34227cm 0.38833cm true true Base Integral Textbox14 #e8e8e8 2pt 2pt 1pt true true Funrural Textbox20 #e8e8e8 2pt 2pt 1pt true true Senar Textbox23 #e8e8e8 2pt 2pt 1pt 0.07938cm true true =Fields!BaseIntegral.Value 2pt 2pt 1pt true true =Fields!ValorFunruralIntegral.Value 2pt 2pt 1pt true true =Fields!ValorSenarIntegral.Value 2pt 2pt 1pt 0.4cm true true =Sum(Fields!BaseIntegral.Value) 2pt 2pt 1pt true true =sum(Fields!ValorFunruralIntegral.Value) 2pt 2pt 1pt true true =sum(Fields!ValorSenarIntegral.Value) 2pt 2pt 1pt =1=1 =1=1 true Before dsFunruralSenar 3.45106cm 21.53969cm 0.86771cm 7.50306cm 3 2pt 2pt 1pt 3.99149cm 2.60892cm 0.37354cm true true Somente Senar Base Textbox50 #e8e8e8 2pt 2pt 1pt true true Valor Textbox52 #e8e8e8 2pt 2pt 1pt 0.07938cm true true =Fields!BaseSomenteSenar.Value 2pt 2pt 1pt true true =Fields!ValorSomenteSenar.Value 2pt 2pt 1pt 0.4cm true true =sum(Fields!BaseSomenteSenar.Value) 2pt 2pt 1pt true true =sum(Fields!ValorSomenteSenar.Value) 2pt 2pt 1pt =1=1 =1=1 true Before dsFunruralSenar 4.49516cm 21.53969cm 0.85292cm 6.60041cm 4 2pt 2pt 1pt 6.95792cm 3cm 2.2cm 2cm 2cm 3.5cm 2.5cm 2cm 0.4cm true true Resumo de Movimentações por Cliente 2pt 2pt 1pt 8 0.4cm true true Cliente #e8e8e8 2pt 2pt 1pt true true CNPJ/CPF #e8e8e8 2pt 2pt 1pt true true Base Integral Textbox40 #e8e8e8 2pt 2pt 1pt true true Funrural Textbox121 #e8e8e8 2pt 2pt 1pt true true Senar Textbox125 #e8e8e8 2pt 2pt 1pt true true Somente Senar Base Textbox17 #e8e8e8 2pt 2pt 1pt true true Somente Senar Textbox26 #e8e8e8 2pt 2pt 1pt true true Líquido Textbox129 #e8e8e8 2pt 2pt 1pt 0.13229cm true true =Fields!CidadeDescricao.Value 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true true =Fields!ValorContabil.Value 2pt 2pt 2pt 2pt true true =Fields!Funrural.Value Funrural1 2pt 2pt 2pt 2pt true true Textbox126 2pt 2pt 2pt 2pt true true Textbox22 2pt 2pt 2pt 2pt true true Textbox27 2pt 2pt 2pt 2pt true true Textbox130 2pt 2pt 2pt 2pt 0.4cm true true =Fields!CodClientes.Value & " - " & Fields!Emitente.Value 2pt 2pt 1pt true true text =Fields!CNPJCPF.Value Middle 2pt 2pt 1pt true true =Sum(Fields!BaseIntegral.Value) 2pt 2pt 1pt true true =Sum(Fields!ValorFunruralIntegral.Value) Funrural2 2pt 2pt 1pt true true =Sum(Fields!ValorSenarIntegral.Value) Senar1 2pt 2pt 1pt true true =Sum(Fields!BaseSomenteSenar.Value) Textbox24 2pt 2pt 1pt true true =Sum(Fields!ValorSomenteSenar.Value) Textbox28 2pt 2pt 1pt true true =Sum(Fields!ValorLiquido.Value) ValorLiquido1 2pt 2pt 1pt 0.4cm true true 2pt 2pt 1pt true true 2pt 2pt 1pt true true =Sum(Fields!BaseIntegral.Value) 2pt 2pt 1pt true true =Sum(Fields!ValorFunruralIntegral.Value) Funrural3 2pt 2pt 1pt true true =Sum(Fields!ValorSenarIntegral.Value) Senar2 2pt 2pt 1pt true true =Sum(Fields!BaseSomenteSenar.Value) Textbox25 2pt 2pt 1pt true true =Sum(Fields!ValorSomenteSenar.Value) Textbox30 2pt 2pt 1pt true true =Sum(Fields!ValorLiquido.Value) ValorLiquido2 2pt 2pt 1pt =Fields!CodClientes.Value =Fields!CodCidades.Value true Before true dsFunruralSenar 5.52649cm 1.73229cm 24.15792cm 5 =Parameters!MostrarResumoCliente.Value <> "True" 0.75pt 2pt 2pt 1pt 6.95792cm 4.03729cm 0.4cm true true Resumo de Produtos 2pt 2pt 1pt 2 0.4cm true true Produto #e8e8e8 2pt 2pt 1pt true true Valor FUNDEINFRA Textbox129 #e8e8e8 2pt 2pt 1pt 0.4cm true true =Fields!CodProdutos.Value & " - " & Fields!DescricaoProduto.Value 2pt 2pt 1pt true true =Sum(Fields!ValorFUNDEINFRA.Value) ValorLiquido1 2pt 2pt 1pt 0.4cm true true 2pt 2pt 1pt true true =Sum(Fields!ValorFUNDEINFRA.Value) ValorLiquido2 2pt 2pt 1pt =Fields!CodProdutos.Value =Fields!DescricaoProduto.Value true dsResumoProdutos 7.52575cm 1.6cm 10.99521cm 6 =IIF(Parameters!AnalisarFUNDEINFRA.Value <> "True" OR CountRows("dsResumoProdutos") = 0, True, False) 0.75pt 2pt 2pt 1pt 3.6449in 15.20999in 1.67583cm true true External =Parameters!LogoMenor.Value FitProportional 1.52672cm 5.14717cm true true Relatório de Contribuições Agro Textbox1 1.18166cm 0.49417cm 29.04275cm 1 Black 1pt 0.30896cm true true true true =Now() Textbox4 0.30896cm 4.27271cm true true ="Pag: " & Globals!PageNumber & " de " & Globals!TotalPages Textbox4 24.77004cm 0.30896cm 4.27271cm 1 21cm 29.7cm 0.3cm 0.3cm 0.3cm 0.3cm 0.13cm