0 SQL 5ab246e2-24f8-46ad-86b7-f292e4a9131a DummyDataSource true NumeroNota System.String NotaRef System.String DataEmissao System.String Natureza System.String ValorContabil System.String DataVencimento System.Decimal ValorParcela System.Decimal DataPagamento System.Decimal Banco System.String ValorPago System.String Desconto System.String Juros System.String Devolucao System.String Saldo System.String Historico System.String Tipo System.String DummyDataSource true Cod System.String CodClientes System.String Clientes System.String CodSituacao System.String Situacao System.String Numero System.String DataEmissao System.String ObservacaoHistorico System.String Tipo System.String ValorPagar System.String ValorPagoPagar System.String ValorReceber System.String ValorPagoReceber System.String DataPagamento System.String Banco System.String ValorPago System.String HistoricoPagamento System.String TotalValorPagar System.String TotalValorPagoPagar System.String TotalValorReceber System.String TotalValorPagoReceber System.String DummyDataSource true Tipo System.String Numero System.String CodCliente System.String Cliente System.String BancoEmpresa System.String Banco System.String Valor System.String Vencimento System.String Observacao System.String DummyDataSource true Campo System.String Valor System.String 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 7.42744cm 0.8cm 13.16291cm 0.3cm 2.03731cm 1.38641cm 6.05958cm 2.92585cm 2.3355cm 1.83866cm 2.3cm 6.55897cm 0.4cm true true Resumo de Cheques 0.3pt #caebfc 2pt 2pt 2pt 7 true true 0.3pt #caebfc 2pt 2pt 2pt 0.4cm true true =Fields!Tipo.Value 0.3pt #e8e8e8 2pt 2pt 2pt 7 true true 0.3pt #e8e8e8 2pt 2pt 2pt 0.4cm true true Numero Textbox132 0.3pt 2pt 2pt 2pt true true Cod Textbox133 0.3pt 2pt 2pt 2pt true true Cliente Textbox134 0.3pt 2pt 2pt 2pt true true BancoEmpresa Textbox139 0.3pt 2pt 2pt 2pt true true Banco Textbox140 0.3pt 2pt 2pt 2pt true true Vencimento Textbox141 0.3pt 2pt 2pt 2pt true true Valor Textbox143 0.3pt 2pt 2pt 2pt true true Observação Textbox8 0.3pt 2pt 2pt 2pt 0.4cm true true =Fields!Numero.Value Numero 0.3pt 2pt 2pt 2pt true true =Fields!CodCliente.Value CodCliente 0.3pt 2pt 2pt 2pt true true =Fields!Cliente.Value Cliente1 0.3pt 2pt 2pt 2pt true true =Fields!BancoEmpresa.Value BancoEmpresa 0.3pt 2pt 2pt 2pt true true =Fields!Banco.Value Banco 0.3pt 2pt 2pt 2pt true true =Fields!Vencimento.Value Vencimento 0.3pt 2pt 2pt 2pt true true =Fields!Valor.Value Valor1 0.3pt 2pt 2pt 2pt true true =Fields!Observacao.Value Observacao 0.3pt 2pt 2pt 2pt 0.4cm true true Total: Textbox153 0.3pt 2pt 2pt 2pt 6 true true =Sum(Fields!Valor.Value) Textbox159 0.3pt 2pt 2pt 2pt true true Textbox10 0.3pt 2pt 2pt 2pt 0.2cm true true Textbox106 0.3pt 2pt 2pt 2pt 8 0.07938cm true true 0.3pt 2pt 2pt 2pt After =Fields!Tipo.Value =Fields!Tipo.Value 0.07938cm true true 0.3pt 2pt 2pt 2pt After After Before 0.07938cm true true 0.3pt 2pt 2pt 2pt Before dsCheques 1.81747cm 2.2cm 25.52166cm 1 =Parameters!MostrarResumoCheques.Value = false Or Count(Fields!Numero.Value) = 0 0.3cm 0.5cm 6.5cm 6.5cm 6.5cm 2.5cm 2.5cm 11.08cm 0.4cm true true =Fields!Situacao.Value 0.3pt #caebfc 2pt 2pt 1pt 7 0.4cm true true 0.3pt 2pt 2pt 1pt true true =Microsoft.VisualBasic.Interaction.Iif(Fields!Tipo.Value = "P", "Pagar", "Receber") 0.3pt #caebfc 2pt 2pt 1pt 6 0.4cm true true 0.3pt 2pt 2pt 1pt true true Valor Textbox378 0.3pt #e1e1e1 2pt 2pt 1pt true true Valor Pago Textbox380 0.3pt #e1e1e1 2pt 2pt 1pt true true Saldo Textbox470 0.3pt #e1e1e1 2pt 2pt 1pt true true Textbox30 0.3pt #e1e1e1 2pt 2pt 1pt 3 0.4cm true true 0.3pt 2pt 2pt 1pt true true =Iif(Fields!Tipo.Value = "P", Sum(Fields!TotalValorPagar.Value), Sum(Fields!TotalValorReceber.Value)) Textbox474 0.3pt 2pt 2pt 1pt true true =Iif(Fields!Tipo.Value = "P", Sum(Fields!TotalValorPagoPagar.Value), Sum(Fields!TotalValorPagoReceber.Value)) Textbox475 0.3pt 2pt 2pt 1pt true true =Iif(Fields!Tipo.Value = "P", Sum(Fields!TotalValorPagar.Value) - Sum(Fields!TotalValorPagoPagar.Value), Sum(Fields!TotalValorReceber.Value) - Sum(Fields!TotalValorPagoReceber.Value)) Textbox476 0.3pt 2pt 2pt 1pt true true Textbox31 0.3pt 2pt 2pt 1pt 3 1.2cm true true 0.3pt 2pt 2pt 1pt 2.35cm 2.14cm 1.8cm 1.8cm 1.8cm 9.25063cm 2.14cm 3cm 1.8cm 9.14cm 0.4cm true true Número Textbox329 0.3pt #e8e8e8 2pt 2pt 1pt true true Data Emissão Textbox330 0.3pt #e8e8e8 2pt 2pt 1pt true true Valor Textbox331 0.3pt #e8e8e8 2pt 2pt 1pt true true Valor Pago Textbox332 0.3pt #e8e8e8 2pt 2pt 1pt true true Saldo Textbox333 0.3pt #e8e8e8 2pt 2pt 1pt true true Histórico Textbox33 0.3pt #e8e8e8 2pt 2pt 1pt true true Data Pagto Textbox89 0.3pt #e8e8e8 2pt 2pt 1pt true true Banco Textbox79 0.3pt #e8e8e8 2pt 2pt 1pt true true Valor Pago Textbox74 0.3pt #e8e8e8 2pt 2pt 1pt true true Historico Pagamento Textbox69 0.3pt #e8e8e8 2pt 2pt 1pt 0.4cm true true =Fields!CodClientes.Value & " - " & Fields!Clientes.Value 0.3pt #e8e8e8 2pt 2pt 1pt 10 0.4cm true true =Fields!Numero.Value Numero1 0.3pt 2pt 2pt 1pt true true =Fields!DataEmissao.Value DataEmissao1 0.3pt 2pt 2pt 1pt true true =Microsoft.VisualBasic.Interaction.Iif(Fields!Tipo.Value = "P", Sum(Fields!ValorPagar.Value), Sum(Fields!ValorReceber.Value)) Valor2 0.3pt 2pt 2pt 1pt true true =Microsoft.VisualBasic.Interaction.Iif(Fields!Tipo.Value = "P", Fields!ValorPagoPagar.Value, Fields!ValorPagoReceber.Value) ValorPago1 0.3pt 2pt 2pt 1pt true true =Microsoft.VisualBasic.Interaction.Iif(Fields!Tipo.Value = "P", Fields!ValorPagar.Value - Fields!ValorPagoPagar.Value, Fields!ValorReceber.Value - Fields!ValorPagoReceber.Value) Textbox20 0.3pt 2pt 2pt 1pt true true =Fields!ObservacaoHistorico.Value ObservacaoHistorico1 0.3pt 2pt 2pt 1pt true true =Fields!DataPagamento.Value DataPagamento1 0.3pt 2pt 2pt 1pt true true =Fields!Banco.Value Banco1 0.3pt 2pt 2pt 1pt true true =Fields!ValorPago.Value ValorPago1 0.3pt 2pt 2pt 1pt true true =Fields!HistoricoPagamento.Value HistoricoPagamento 0.3pt 2pt 2pt 1pt 0.07938cm true true 0.3pt 2pt 2pt 1pt 0.28cm true true 0.3pt 2pt 2pt 1pt After =Fields!CodClientes.Value =Fields!CodClientes.Value 0.07938cm true true 0.3pt 2pt 2pt 1pt 0.28cm true true 0.3pt 2pt 2pt 1pt After dtAdiantamentos 4 6 0.4cm true true Saldo Total (Receber - Pagar): Textbox456 0.3pt 2pt 2pt 1pt 3 true true =Sum(Sum(Fields!TotalValorReceber.Value) - Sum(Fields!TotalValorPagoReceber.Value)) - Sum(Sum(Fields!TotalValorPagar.Value) - Sum(Fields!TotalValorPagoPagar.Value)) Textbox471 0.3pt 2pt 2pt 1pt true true Textbox33 0.3pt 2pt 2pt 1pt 3 0.2cm true true 0.3pt 2pt 2pt 1pt 4 true true 0.3pt 2pt 2pt 1pt true true 0.3pt 2pt 2pt 1pt true true 0.3pt 2pt 2pt 1pt =Fields!CodSituacao.Value =Fields!CodSituacao.Value 0.07938cm true true 2pt 2pt 2pt 2pt 0.07938cm true true 2pt 2pt 2pt 2pt After =Fields!Tipo.Value =Fields!Tipo.Value 0.07938cm true true 2pt 2pt 2pt 2pt =Parameters!AnaliseAdiantamentos.Value = 0 0.07938cm true true 2pt 2pt 2pt 2pt Before 0.07938cm true true 2pt 2pt 2pt 2pt Before dtAdiantamentos 4.02744cm 3.4cm 36.23876cm 2 1.5cm 1.5cm 1.8cm 6.52062cm 2cm 1.95cm 2cm 1.9cm 4.27166cm 2cm 2cm 2cm 2cm 2cm 11.44188cm 0.4cm true true =iif(Fields!Tipo.Value = 0, "Entrada", "Saída") Textbox27 #caebfc 2pt 2pt 1pt 15 true 0.4cm true true Nr. Nota Textbox64 #caebfc 2pt 2pt 1pt true true Nt. Ref Textbox66 #caebfc 2pt 2pt 1pt true true Data Emis. Textbox68 #caebfc 2pt 2pt 1pt true true Natureza Textbox70 #caebfc 2pt 2pt 1pt true true Valor NF Textbox72 #caebfc 2pt 2pt 1pt true true Data Vencimento Textbox76 #caebfc 2pt 2pt 1pt true true Valor Parcela Textbox78 #caebfc 2pt 2pt 1pt true true Data Pagamento Textbox80 #caebfc 2pt 2pt 1pt true true Banco Textbox82 #caebfc 2pt 2pt 1pt true true Valor Pago Textbox84 #caebfc 2pt 2pt 1pt true true Desconto Textbox86 #caebfc 2pt 2pt 1pt true true Juros Textbox88 #caebfc 2pt 2pt 1pt true true Devolucao Textbox90 #caebfc 2pt 2pt 1pt true true Saldo Textbox92 #caebfc 2pt 2pt 1pt true true Historico Textbox94 #caebfc 2pt 2pt 1pt 0.4cm true true =Fields!NumeroNota.Value NumeroNota =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!NotaRef.Value NotaRef =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!DataEmissao.Value DataEmissao =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!Natureza.Value =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!ValorContabil.Value ValorContabil =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!DataVencimento.Value DataVencimento =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!ValorParcela.Value ValorParcela =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!DataPagamento.Value DataPagamento =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!Banco.Value =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!ValorPago.Value ValorPago =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!Desconto.Value Desconto =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!Juros.Value Juros =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!Devolucao.Value Devolucao =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!Saldo.Value Saldo =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!Historico.Value =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt 0.4cm true true TOTAL: Textbox1 2pt 2pt 1pt 9 true true =Sum(Fields!ValorPago.Value) Textbox13 2pt 2pt 1pt true true =Sum(Fields!Desconto.Value) Textbox14 2pt 2pt 1pt true true =Sum(Fields!Juros.Value) Textbox15 2pt 2pt 1pt true true =Sum(Fields!Devolucao.Value) Textbox16 2pt 2pt 1pt true true =Parameters!TotalSaldoTitulos.Value Textbox18 2pt 2pt 1pt true true 2pt 2pt 1pt 0.2cm true true Textbox39 2pt 2pt 1pt 15 =Fields!Tipo.Value =Fields!Tipo.Value 0.07938cm true true Textbox36 =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt =Parameters!AgruparEntradaSaida.Value = false After true After true =Fields!NumeroNota.Value 0.07938cm true true Textbox38 =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt Before dsDados 1.8cm 44.96354cm 3 3.23915in Textbox1 1.10175cm 0.49417cm 44.96354cm External =Parameters!LogoMenor.Value FitProportional 0.07938cm 1.52672cm 5.14717cm 1 0.30897cm true true true true =Now() Textbox4 0cm 0.09525cm 0.30896cm 4.27271cm true true ="Pag: " & Globals!PageNumber & " de " & Globals!TotalPages Textbox4 0.00001cm 41.57854cm 0.30896cm 3.385cm 1 21cm 34.5cm 0.3cm 0.3cm 0.5cm 0.5cm 0.13cm