0 SQL 5ab246e2-24f8-46ad-86b7-f292e4a9131a DummyDataSource true Cod System.String Descricao System.String NCM System.String UN System.String ClienteFornecedor System.String Lote System.String EstoqueAtual System.String CustoMedio System.String TotalItem System.String Tributacao System.String Isento System.String Tributado System.String ST System.String CodEmpresas System.String Empresa System.String EmpresaCNPJ System.String Grupo System.String Nivel System.String TipoEstoque System.String Marca System.String DummyDataSource true Cod System.String Descricao System.String NCM System.String UN System.String TipoEstoque System.String TipoEstoqueDescricao System.String Empresa System.String EstoqueAtual System.String CustoMedio System.String TotalItem System.String DummyDataSource true RazaoSocial System.String CNPJ System.String Cidade System.String Estado System.String 1.1cm 4.62821cm 1.55cm 0.85cm 3.72cm 2.33023cm 2.18255cm 2.16514cm 1.80062cm 0.4cm true true =Fields!Empresa.Value + " CNPJ: " + Fields!EmpresaCNPJ.Value 0.3pt #caebfc 2pt 2pt 9 0.4cm true true =Fields!TipoEstoque.Value 0.3pt #e1e1e1 2pt 2pt 5 true true ISENTO 0.3pt #e1e1e1 2pt 2pt true true TRIB Textbox55 0.3pt #e1e1e1 2pt 2pt true true ST Textbox56 0.3pt #e1e1e1 2pt 2pt true true TOTAL Textbox60 0.3pt #e1e1e1 2pt 2pt 0.4cm true true =Fields!Grupo.Value 0.3pt 2pt 2pt 5 true true =Sum(Fields!Isento.Value) Textbox23 0.3pt 2pt 2pt true true =Sum(Fields!Tributado.Value) Textbox50 0.3pt 2pt 2pt true true =Sum(Fields!ST.Value) Textbox68 0.3pt 2pt 2pt true true =Sum(Fields!TotalItem.Value) Textbox68 0.3pt 2pt 2pt 0.4cm true true Cod 0.3pt 2pt 2pt true true Descricao 0.3pt 2pt 2pt true true NCM Textbox59 0.3pt 2pt 2pt true true UN Textbox61 0.3pt 2pt 2pt true true Cliente/Fornecedor 0.3pt 2pt 2pt true true Lote 0.3pt 2pt 2pt true true Quantidade Textbox63 0.3pt 2pt 2pt true true Unitário Textbox65 0.3pt 2pt 2pt true true Total Textbox67 0.3pt 2pt 2pt 0.4cm true true =Fields!Cod.Value 0.3pt 2pt 2pt true true =Fields!Descricao.Value 0.3pt 2pt 2pt true true =Fields!NCM.Value NCM 0.3pt 2pt 2pt true true =Fields!UN.Value UN 0.3pt 2pt 2pt true true =Fields!ClienteFornecedor.Value ClienteFornecedor 0.3pt 2pt 2pt true true =Fields!Lote.Value 0.3pt 2pt 2pt true true =Fields!EstoqueAtual.Value EstoqueAtual 0.3pt 2pt 2pt true true =Fields!CustoMedio.Value CustoMedio 0.3pt 2pt 2pt true true =Fields!TotalItem.Value TotalItem 0.3pt 2pt 2pt 0.4cm true true 0.3pt 2pt 2pt true true 0.3pt 2pt 2pt true true Textbox72 0.3pt 2pt 2pt true true Textbox75 0.3pt 2pt 2pt true true Textbox149 0.3pt 2pt 2pt true true Total Tipo Estoque: Textbox76 0.3pt 2pt 2pt 2 true true =Sum(Fields!TotalItem.Value) Textbox68 0.3pt 2pt 2pt 2 0.4cm true true 0.3pt 2pt 2pt true true 0.3pt 2pt 2pt true true Textbox117 0.3pt 2pt 2pt true true Textbox118 0.3pt 2pt 2pt true true Textbox150 0.3pt 2pt 2pt true true Total Empresa: Textbox120 0.3pt 2pt 2pt 2 true true =Sum(Fields!TotalItem.Value) Textbox68 0.3pt 2pt 2pt 2 0.22959cm true true 0.3pt 2pt 2pt true true 0.3pt 2pt 2pt true true Textbox132 0.3pt 2pt 2pt true true Textbox133 0.3pt 2pt 2pt true true Textbox151 0.3pt 2pt 2pt true true Textbox111 0.3pt 2pt 2pt true true Textbox135 0.3pt 2pt 2pt true true Textbox136 0.3pt 2pt 2pt true true Textbox137 0.3pt 2pt 2pt 0.4cm true true 0.3pt 2pt 2pt true true 0.3pt 2pt 2pt true true Textbox18 0.3pt 2pt 2pt true true Textbox19 0.3pt 2pt 2pt true true Textbox152 0.3pt 2pt 2pt true true Total Geral: Textbox21 0.3pt 2pt 2pt 2 true true =Sum(Fields!TotalItem.Value) Textbox23 0.3pt 2pt 2pt 2 0.1cm true true 0.3pt 2pt 2pt true true 0.3pt 2pt 2pt true true Textbox36 0.3pt 2pt 2pt true true Textbox41 0.3pt 2pt 2pt true true Textbox153 0.3pt 2pt 2pt true true Textbox46 0.3pt 2pt 2pt true true Textbox48 0.3pt 2pt 2pt true true Textbox49 0.3pt 2pt 2pt true true Textbox51 0.3pt 2pt 2pt =Parameters!TipoControlaEstoque.Value <> "S" =Fields!CodEmpresas.Value =Fields!CodEmpresas.Value true true =Fields!TipoEstoque.Value =Fields!TipoEstoque.Value Descending After true true =Fields!Nivel.Value =Fields!Nivel.Value After true true =Parameters!TipoAnalise.Value = "S" After true true =Parameters!TipoAnalise.Value = "S" Before true true dsInventario =Fields!Descricao.Value 3.52959cm 20.32675cm =Parameters!Layout.Value <> "N" 5.08124cm 2.49999cm 0.4cm true true Resumo por Tributação ICMS #e1e1e1 2pt 2pt 2pt true true #e1e1e1 2pt 2pt 2pt 0.4cm true true =Fields!Tributacao.Value 0.3pt 2pt 2pt 2pt true true =Sum(Fields!TotalItem.Value) Textbox25 0.3pt 2pt 2pt 2pt 0.4cm true true Total: 0.3pt 2pt 2pt 2pt true true =Sum(Fields!TotalItem.Value) Textbox4 0.3pt 2pt 2pt 2pt 0.1cm true true 2pt 2pt 2pt 2 After =Fields!Tributacao.Value Before Before dsInventario 3.56714cm 1.3cm 7.58123cm 1 =Parameters!Layout.Value <> "N" true true 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt true true Textbox87 0.3pt 2pt 2pt 2pt 2pt true true Textbox92 0.3pt 2pt 2pt 2pt 2pt 1.95cm 2.44709cm 2.5cm 2.76459cm 0.4cm true true 0.3pt #caebfc 2pt 2pt 2pt 2pt true true 0.3pt #caebfc 2pt 2pt 2pt 2pt true true 0.3pt #caebfc 2pt 2pt 2pt 2pt true true 0.3pt #caebfc 2pt 2pt 2pt 2pt 0.4cm true true =Fields!Empresa.Value Empresa1 0.3pt #e1e1e1 2pt 2pt 1pt true true Total Qtd. Est. Textbox38 0.3pt #e1e1e1 2pt 2pt 1pt true true Unitário Textbox38 0.3pt #e1e1e1 2pt 2pt 1pt true true =IIF(Parameters!EmpresaAtiva.Value = 1813,"Total Est x Preço","Total Est. x CM") Textbox40 0.3pt #e1e1e1 2pt 2pt 1pt 0.4cm true true =Sum(Fields!EstoqueAtual.Value) EstoqueAtual1 0.3pt 2pt 2pt 1pt true true =Sum(Fields!EstoqueAtual.Value) EstoqueAtual2 0.3pt 2pt 2pt 1pt true true =Fields!CustoMedio.Value Textbox21 0.3pt 2pt 2pt 1pt true true =Sum(Fields!TotalItem.Value) CustoMedio1 0.3pt 2pt 2pt 1pt 0.4cm true true =Sum(Fields!EstoqueAtual.Value) EstoqueAtual2 0.3pt 2pt 2pt 1pt true true =Sum(Fields!EstoqueAtual.Value) EstoqueAtual2 0.3pt 2pt 2pt 1pt true true Textbox22 0.3pt 2pt 2pt 1pt true true =Sum(Fields!TotalItem.Value) Textbox42 0.3pt 2pt 2pt 1pt =Fields!Empresa.Value =Fields!Empresa.Value 0.07938cm true true 0.3pt 2pt 2pt 2pt 2pt 0.07938cm true true 0.3pt 2pt 2pt 2pt 2pt 0.07938cm true true 0.3pt 2pt 2pt 2pt 2pt 0.07938cm true true 0.3pt 2pt 2pt 2pt 2pt =Fields!TipoEstoque.Value =Fields!TipoEstoque.Value 10.40836cm true true =Fields!TipoEstoqueDescricao.Value 0.3pt #caebfc 2pt 2pt 2pt 2pt After 1.3094cm true true Cod 0.3pt #e1e1e1 2pt 2pt 1pt 6.58937cm true true Descricao 0.3pt #e1e1e1 2pt 2pt 1pt 1.65cm true true NCM Textbox98 0.3pt #e1e1e1 2pt 2pt 1pt 0.85959cm true true UN Textbox61 0.3pt #e1e1e1 2pt 2pt 1pt After =Fields!Descricao.Value 1.3094cm true true =Fields!Cod.Value 0.3pt 2pt 2pt 1pt 6.58937cm true true =Fields!Descricao.Value 0.3pt 2pt 2pt 1pt 1.65cm true true =Fields!NCM.Value NCM1 0.3pt 2pt 2pt 1pt 0.85959cm true true =Fields!UN.Value UN1 0.3pt 2pt 2pt 1pt 1.3094cm true true 0.3pt 2pt 2pt 1pt 6.58937cm true true Total: Textbox28 0.3pt 2pt 2pt 1pt 1.65cm true true Textbox101 0.3pt 2pt 2pt 1pt 0.85959cm true true Textbox30 0.3pt 2pt 2pt 1pt dsInventarioPorColunas 7.7875cm 1.67938cm 20.07004cm 2 =(Parameters!Layout.Value <> "C") Or (Parameters!Layout.Value = "C" And Parameters!AgruparProduto.Value = True) 7.58123cm 2.49999cm 2.5cm 0.4cm true true Resumo por Grupo de Produtos 0.3pt #e1e1e1 2pt 2pt 2pt true true Quantidade Textbox52 0.3pt #e1e1e1 2pt 2pt 2pt true true Valor Textbox52 0.3pt #e1e1e1 2pt 2pt 2pt 0.4cm true true =Fields!Grupo.Value 0.3pt 2pt 2pt 2pt true true =Sum(Fields!EstoqueAtual.Value) Textbox25 0.3pt 2pt 2pt 2pt true true =Sum(Fields!TotalItem.Value) Textbox90 0.3pt 2pt 2pt 2pt 0.4cm true true Total: 0.3pt 2pt 2pt 2pt true true =Sum(Fields!EstoqueAtual.Value) Textbox83 0.3pt 2pt 2pt 2pt true true =Sum(Fields!TotalItem.Value) Textbox93 0.3pt 2pt 2pt 2pt After =Fields!Grupo.Value =Fields!Grupo.Value Before dsInventario 4.91116cm 1.2cm 12.58122cm 3 =Parameters!ResumoGrupos.Value = 0 7.58123cm 2.49999cm 2.5cm 0.4cm true true Resumo de Marcas 0.3pt #e1e1e1 2pt 2pt 2pt true true Quantidade Textbox52 0.3pt #e1e1e1 2pt 2pt 2pt true true Valor Textbox52 0.3pt #e1e1e1 2pt 2pt 2pt 0.4cm true true =Fields!Marca.Value 0.3pt 2pt 2pt 2pt true true =Sum(Fields!EstoqueAtual.Value) Textbox25 0.3pt 2pt 2pt 2pt true true =Sum(Fields!TotalItem.Value) Textbox90 0.3pt 2pt 2pt 2pt 0.4cm true true Total: 0.3pt 2pt 2pt 2pt true true =Sum(Fields!EstoqueAtual.Value) Textbox83 0.3pt 2pt 2pt 2pt true true =Sum(Fields!TotalItem.Value) Textbox93 0.3pt 2pt 2pt 2pt After =Fields!Marca.Value =Fields!Grupo.Value Before dsInventario 6.41111cm 1.2cm 12.58122cm 4 =Parameters!MostrarResumoMarcas.Value = "False" true true 0.3pt 2pt 2pt 2pt 2pt true true 0.3pt 2pt 2pt 2pt 2pt true true Textbox87 0.3pt 2pt 2pt 2pt 2pt true true Textbox92 0.3pt 2pt 2pt 2pt 2pt 1.95cm 2.44709cm 2.5cm 2.76459cm 0.4cm true true 0.3pt #caebfc 2pt 2pt 2pt 2pt true true 0.3pt #caebfc 2pt 2pt 2pt 2pt true true 0.3pt #caebfc 2pt 2pt 2pt 2pt true true 0.3pt #caebfc 2pt 2pt 2pt 2pt 0.4cm true true =Fields!Empresa.Value Empresa1 0.3pt #e1e1e1 2pt 2pt 1pt true true Total Qtd. Est. Textbox38 0.3pt #e1e1e1 2pt 2pt 1pt true true Unitário Textbox38 0.3pt #e1e1e1 2pt 2pt 1pt true true =IIF(Parameters!EmpresaAtiva.Value = 1813, "Total Est x Preço", "Total Est. x CM") Textbox40 0.3pt #e1e1e1 2pt 2pt 1pt 0.45cm true true =Sum(Fields!EstoqueAtual.Value) EstoqueAtual1 0.3pt 2pt 2pt 1pt true true =Sum(Fields!EstoqueAtual.Value) EstoqueAtual2 0.3pt 2pt 2pt 1pt true true =Sum(Fields!EstoqueAtual.Value * Fields!CustoMedio.Value)/Sum(Fields!EstoqueAtual.Value) Textbox21 0.3pt 2pt 2pt 1pt true true =Sum(Fields!TotalItem.Value) CustoMedio1 0.3pt 2pt 2pt 1pt 0.4cm true true =Sum(Fields!EstoqueAtual.Value) EstoqueAtual2 0.3pt 2pt 2pt 1pt true true =Sum(Fields!EstoqueAtual.Value) EstoqueAtual2 0.3pt 2pt 2pt 1pt true true Textbox22 0.3pt 2pt 2pt 1pt true true =Sum(Fields!TotalItem.Value) Textbox42 0.3pt 2pt 2pt 1pt =Fields!Empresa.Value =Fields!Empresa.Value 0.07938cm true true 0.3pt 2pt 2pt 2pt 2pt 0.07938cm true true 0.3pt 2pt 2pt 2pt 2pt 0.07938cm true true 0.3pt 2pt 2pt 2pt 2pt 0.07938cm true true 0.3pt 2pt 2pt 2pt 2pt =Fields!TipoEstoque.Value =Fields!TipoEstoque.Value 10.40836cm true true =Fields!TipoEstoqueDescricao.Value 0.3pt #caebfc 2pt 2pt 2pt 2pt 1.3094cm true true Cod 0.3pt #e1e1e1 2pt 2pt 1pt 6.58937cm true true Descricao 0.3pt #e1e1e1 2pt 2pt 1pt 1.65cm true true NCM Textbox98 0.3pt #e1e1e1 2pt 2pt 1pt 0.85959cm true true UN Textbox61 0.3pt #e1e1e1 2pt 2pt 1pt =Fields!Cod.Value =Fields!Descricao.Value 1.3094cm true true =Fields!Cod.Value 0.3pt 2pt 2pt 1pt 6.58937cm true true =Fields!Descricao.Value 0.3pt 2pt 2pt 1pt 1.65cm true true =Fields!NCM.Value NCM1 0.3pt 2pt 2pt 1pt 0.85959cm true true =Fields!UN.Value UN1 0.3pt 2pt 2pt 1pt 1.3094cm true true 0.3pt 2pt 2pt 1pt 6.58937cm true true Total: Textbox28 0.3pt 2pt 2pt 1pt 1.65cm true true Textbox101 0.3pt 2pt 2pt 1pt 0.85959cm true true Textbox30 0.3pt 2pt 2pt 1pt dsInventarioPorColunas 9.5473cm 1.72938cm 20.07004cm 5 =(Parameters!Layout.Value <> "C" Or Parameters!AgruparProduto.Value = False) 4.43964in Textbox1 0.6cm 20.31876cm 0.3pt 2pt 2pt 2pt 2pt true true ="Empresa: " + First(Fields!RazaoSocial.Value, "dsEmpresa") 2pt 2pt 2pt 2pt true true ="Página: " & (Globals!PageNumber + (Parameters!Pagina.Value - 1)) Textbox10 0.6cm 17.97752cm 0.6cm 2.30949cm 2 =Parameters!Pagina.Value = "" 2pt 2pt 2pt 2pt true true ="CNPJ: " & First(Fields!CNPJ.Value, "dsEmpresa") & " - " & First(Fields!Cidade.Value, "dsEmpresa") & " - " & First(Fields!Estado.Value, "dsEmpresa") 0.3pt 2pt 2pt 2pt 2pt true true ="Período: " & Parameters!Data.Value Textbox11 1.2cm 14.71848cm 0.6cm 5.56853cm 4 0.3pt 2pt 2pt 2pt 2pt true true =iif(Parameters!NumeroLivro.Value = "", "", "Nº Livro: " & Parameters!NumeroLivro.Value) Textbox10 0.59637cm 14.75023cm 0.6cm 3.19201cm 5 2pt 2pt 2pt 2pt 0.33542cm true true true true =Now() Textbox4 0.30896cm 4.27271cm 29.7cm 21cm 0.5cm 0.5cm 0.5cm 0.5cm 0.13cm