0 SQL 5ab246e2-24f8-46ad-86b7-f292e4a9131a DummyDataSource true Cod System.String Produto System.String Marca System.String Referencia System.String Quantidade System.String Emissao System.String ValorTotal System.String QuantidadeTotal System.String Valor System.String Repr System.String ValorAcumulado System.String Estoque System.String Disponivel System.String ReprAcumulada System.String Classe System.String ClasseCusto System.String Localizacao System.String UN System.String Categoria System.String DummyDataSource true Classe System.String valor System.String Itens System.String ReprItens System.String DummyDataSource true campo System.String valor System.String 1.03185cm 2.19136cm 7.57398cm 0.95715cm 1.89503cm 1.84383cm 2.5cm 1.57145cm 1.57145cm 1.5cm 1.8903cm 0.91251cm 0.91251cm 1.08907cm 1.08907cm 0.4cm true true COD Textbox7 0.3pt #caebfc 2pt 2pt 1pt true true REF. Textbox4 0.3pt #caebfc 2pt 2pt 1pt true true PRODUTO Textbox14 0.3pt #caebfc 2pt 2pt 1pt true true UN. Textbox38 0.3pt #caebfc 2pt 2pt 1pt true true MARCA Textbox6 0.3pt #caebfc 2pt 2pt 1pt true true CATEGORIA Textbox40 0.3pt #caebfc 2pt 2pt 1pt true true LOCALIZAÇÃO Textbox3 0.3pt #caebfc 2pt 2pt 1pt true true =iif((UCase(Parameters!MostrarTipoEstoque.Value)) = "E","Estoque","Disponível") Textbox29 0.3pt #caebfc 2pt 2pt 1pt true true QTD Textbox29 0.3pt #caebfc 2pt 2pt 1pt true true =Fields!Emissao.Value Emissao 0.3pt #caebfc 2pt 2pt 1pt true true VALOR Textbox11 0.3pt #caebfc 2pt 2pt 1pt true true % Textbox18 0.3pt #caebfc 2pt 2pt 1pt true true % Ac Textbox13 0.3pt #caebfc 2pt 2pt 1pt true true Classe Textbox16 0.3pt #caebfc 2pt 2pt 1pt true true XYZ Textbox16 0.3pt #caebfc 2pt 2pt 1pt 0.4cm true true =Fields!Cod.Value Cod 0.3pt =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!Referencia.Value 0.3pt =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!Produto.Value 0.3pt =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!UN.Value UN 0.3pt =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!Marca.Value Marca 0.3pt =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!Categoria.Value Categoria 0.3pt =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true true =Fields!Localizacao.Value Localizacao 0.3pt =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!Estoque.Value Estoque 0.3pt =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Sum(Fields!Quantidade.Value) Quantidade1 0.3pt =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Sum(Fields!Quantidade.Value) Quantidade1 0.3pt =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Sum(Fields!Valor.Value) Valor 0.3pt =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!Repr.Value Repr 0.3pt =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!ReprAcumulada.Value ReprAcumulada 0.3pt =IIf(((RowNumber(nothing) mod 2) =0), "White", "#e8e8e8") 2pt 2pt 1pt true true =Fields!Classe.Value Classe 0.3pt =IIf((Fields!Classe.Value = "A"), "#83db00", iif((Fields!Classe.Value = "B"), "#fff370", iif((Fields!Classe.Value = "C"), "#ff9977", "White"))) 2pt 2pt 1pt true true =Fields!ClasseCusto.Value ClasseCusto 0.3pt =IIf((Fields!ClasseCusto.Value = "Z"), "#83db00", iif((Fields!ClasseCusto.Value = "Y"), "#fff370", iif((Fields!ClasseCusto.Value = "X"), "#ff9977", "White"))) 2pt 2pt 1pt 0.4cm true true 0.3pt #caebfc 2pt 2pt 1pt true true 0.3pt #caebfc 2pt 2pt 1pt true true 0.3pt #caebfc 2pt 2pt 1pt true true Textbox41 0.3pt #caebfc 2pt 2pt 1pt true true TOTAL: Textbox8 0.3pt #caebfc 2pt 2pt 1pt true true Textbox43 0.3pt #caebfc 2pt 2pt 1pt true true Textbox39 0.3pt #caebfc 2pt 2pt 1pt true true =Parameters!EstoqueTotal.Value Estoque1 0.3pt #caebfc 2pt 2pt 1pt true true =Sum(Fields!Quantidade.Value) Quantidade 0.3pt #caebfc 2pt 2pt 1pt true true Textbox12 0.3pt #caebfc 2pt 2pt 1pt true true =Sum(Fields!Valor.Value) Textbox10 0.3pt #caebfc 2pt 2pt 1pt true true Textbox20 0.3pt #caebfc 2pt 2pt 1pt true true Textbox15 0.3pt #caebfc 2pt 2pt 1pt true true Textbox22 0.3pt #caebfc 2pt 2pt 1pt true true Textbox24 0.3pt #caebfc 2pt 2pt 1pt =Parameters!MostrarCategorias.Value = False =Parameters!MostrarLocalizacaoEstoque.Value = False =Fields!Emissao.Value =CDate(Fields!Emissao.Value) =Parameters!MostrarQuantidadeMes.Value= false =Parameters!MostrarQuantidadeMes.Value = false or Fields!Emissao.Value = "" =Parameters!MostrarCurvaXYZ.Value = false true true true true =Fields!Cod.Value =Fields!Produto.Value true true true dsProdutos 0cm 1.2cm 28.52956cm 0.3pt 2.58709cm 8.9725cm 0.4cm true true FILTROS: 0.3pt #caebfc 2pt 2pt 2pt 2 0.4cm true true =Fields!Campo.Value 0.3pt =IIf(((RowNumber(Nothing) mod 2) =0), "#e8e8e8", "White") 2pt 2pt 2pt true true =Fields!Valor.Value 0.3pt =IIf(((RowNumber(Nothing) mod 2) =0), "#e8e8e8", "White") 2pt 2pt 2pt After dsFiltros 3.74569cm 0.8cm 11.55959cm 1 2.25cm 2cm 2cm 2.25cm 0.4cm true true Classe Textbox9 #caebfc 2pt 2pt 1pt true true Valor Textbox17 #caebfc 2pt 2pt 1pt true true Itens Textbox25 #caebfc 2pt 2pt 1pt true true Repr. Itens Textbox28 #caebfc 2pt 2pt 1pt 0.4cm true true =Fields!Classe.Value Classe1 =IIf((Fields!Classe.Value = "Classe A"), "#83db00", iif((Fields!Classe.Value = "Classe B"), "#fff370", iif((Fields!Classe.Value = "Classe C"), "#ff9977", "White"))) 2pt 2pt 1pt true true =Fields!Valor.Value Valor1 =IIf((Fields!Classe.Value = "Classe A"), "#83db00", iif((Fields!Classe.Value = "Classe B"), "#fff370", iif((Fields!Classe.Value = "Classe C"), "#ff9977", "White"))) 2pt 2pt 1pt true true =Fields!Itens.Value Itens =IIf((Fields!Classe.Value = "Classe A"), "#83db00", iif((Fields!Classe.Value = "Classe B"), "#fff370", iif((Fields!Classe.Value = "Classe C"), "#ff9977", "White"))) 2pt 2pt 1pt true true =Fields!ReprItens.Value ReprItens =IIf((Fields!Classe.Value = "Classe A"), "#83db00", iif((Fields!Classe.Value = "Classe B"), "#fff370", iif((Fields!Classe.Value = "Classe C"), "#ff9977", "White"))) 2pt 2pt 1pt After =Fields!Classe.Value dsClasse 1.37171cm 0.8cm 8.5cm 2 4.21979cm 2.03021cm 2.25cm 0.4cm true true Marca Textbox23 #caebfc 2pt 2pt 1pt true true Quantidade Textbox30 #caebfc 2pt 2pt 1pt true true Valor Textbox32 #caebfc 2pt 2pt 1pt 0.4cm true true =Fields!Marca.Value 2pt 2pt 1pt true true =SUM(Fields!Quantidade.Value) Textbox31 2pt 2pt 1pt true true =Sum(Fields!Valor.Value) Textbox33 2pt 2pt 1pt 0.4cm true true TOTAL: Textbox34 2pt 2pt 1pt true true =Sum(Fields!Quantidade.Value) Textbox35 2pt 2pt 1pt true true =Sum(Fields!Valor.Value) Textbox36 2pt 2pt 1pt After true true =Fields!Marca.Value =Sum(Fields!Valor.Value) Descending Before dsProdutos 2.3481cm 1.2cm 8.5cm 3 =Parameters!ResumoMarcas.Value = false 1.78964in Textbox1 1.15779cm 0.54708cm 20.32454cm 2pt 2pt 2pt 2pt External =Parameters!LogoMenor.Value FitProportional 0.05732cm 1.52672cm 5.14717cm 1 0.83813cm true true true ="Pag: " & Globals!PageNumber & " de " & Globals!TotalPages Textbox4 16.05183cm 0.30896cm 4.27271cm true true =Now() Textbox4 0.30896cm 4.27271cm 1 29.7cm 21cm 0.5cm 0.3cm 0.5cm 0.5cm 0.13cm