A_Domina_2811 41aba2Fnku1GTNXM4JyoY4twey5NXUKMYlqh9Gh0NdeN8smDRgWTmWxKiInkWCGbgXC3r1dZQ83CE22E6QF3P8N4aSk= A_Domina_2811 A_INTERENG 9GxTiUZKQ7xgWNWBTdwl54vErUhIbeuEfwjt3GMAbi/EbIENTl1zvO0ZpZhqWCXj0mxl69hZw038QfkYZIigtw== A_INTERENG A_MGS_0303 41adCch1q4hqfP3A8FzhXotUZc9NBVKU7FqhmGn0d7vGWrXLWGciWXJMoRjLzDVq3yCLL+ZdQUX6Sb2F6T3jP+wMcYlIag== A_MGS_0303 A_Soin_0603 41bNCchNq4hqfP3A+VzhXot4m89Nebqk8VqhUGf0dxPGcM3L5EwiQXJ7oZlNCa5u3lSBLed3QQF6R73syrTtP8QM0eNhTPs= A_Soin_0603 ora 9GzZiURLQ21sW6FcYkxuKosUs0xIbKo18BPtgHF0KTvE8rmJRWxCzeNp/UTldCpejXSz684Dq9lF ora MASTER 41bNCchNq4hqfP3A6VzhXot4m8tNebuk8Vqh0Gd0dxPGcM3L5EwiwWJ7oZlNCa5u3lTBKedXQYF6R73syrTlP8QM0eNhTPs= MASTER Produto_Principal ProdCodEstr,System.String prodnome,System.String 10000000 Produto_Principal MASTER select ProdCodEstr, prodnome from produto With(NoLock) where ProdcodEstr between '10.01.0016' and '10.06.0202' and ProdDataValidFim is null and ProdGrupo = 'F' and ProdStat = 'Ativado' Order By ProdCodEstr PED_VENDA ProdCodEstr,System.String pedvendadatasolic,System.DateTime Quantidade,System.Decimal 10000000 PED_VENDA MASTER ProdCodEstr,Produto_Principal.ProdCodEstr,22,22 True select I.ProdCodEstr, pedvendadatasolic, Cast(Sum(I.ItpedVendaQtd) as numeric(14,2)) Quantidade from PED_VENDA P With(NoLock), ITEM_PED_VENDA I With(NoLock), NAT_OPERACAO N With(NoLock) Where (ProdCodEstr = @ProdCodEstr) and I.ItPedVendaUnidMedCod = 'CX' and P.StatPedVendaCod in ('07','01','02') and P.PedVendaTipoNota = 'Saída' and P.PedVendaTipo = 'Total' and (N.NatOpEntraRelVenda = 'Sim' Or P.PedVendaNatOpProd In ('5.910','5.910.001','5.910.002','5.910.003','6.910','6.910.001','6.910.002','6.910.003')) and P.PedVendaNatOpProd = N.NatOpCodEstr and I.ItPedVendaProdNome Is Not Null and P.EmpCod = I.EmpCod and P.PedVendaNum = I.Pedvendanum group by I.prodCodEstr, pedvendadatasolic order by I.prodCodEstr, pedvendadatasolic ESTOQUE ProdCodEstr,System.String Estoque,System.Decimal 10000000 ESTOQUE MASTER ProdCodEstr,Produto_Principal.ProdCodEstr,22,22 select Estq_loc_armaz.ProdCodEstr, sum(EstqLocArmazQtd/ProdUnidMedPeso)as Estoque from Estq_loc_armaz With(NoLock), Prod_Unid_med With(NoLock) where (Estq_loc_armaz.ProdCodEstr = @ProdCodEstr) and Estq_Loc_Armaz.LocArmazCodEstr <> '6.1' and Estq_Loc_Armaz.LocArmazCodEstr <> '6.2' and ProdUnidmedCod = 'cx' and ProdUnidMedDataValidFim is null and Estq_loc_armaz.ProdCodEstr = Prod_Unid_Med.ProdCodEstr Group by Estq_loc_armaz.prodcodestr order by Estq_loc_armaz.prodcodestr PRODUCAO ProdCodEstr,System.String Producao,System.Decimal 10000000 PRODUCAO MASTER ProdCodEstr,Produto_Principal.ProdCodEstr,22,22 Select ProdCodEstr, sum (OrdProducQtdNec-OrdProducQtdBoa) as Producao From Ord_Produc Where (ProdCodEstr = @ProdCodEstr) And OrdProducStat in ('Finalizada Parcial','Liberada') Group by Prodcodestr EmpresaFilial EMPCOD,System.String EMPNOME,System.String EMPLOGOTIPO,System.Byte[] 10000000 EmpresaFilial MASTER SELECT EF.EMPCOD, EF.EMPNOME, EF.EMPLOGOTIPO FROM EMPRESA_FILIAL EF WITH(NOLOCK) WHERE EF.EMPCOD = '1' DATAS pedvendadatasolic,System.DateTime 10000000 DATAS MASTER select distinct pedvendadatasolic from PED_VENDA P With(NoLock), ITEM_PED_VENDA I With(NoLock), NAT_OPERACAO N With(NoLock) Where ProdCodEstr in (select ProdCodEstr from produto With(NoLock) where ProdcodEstr between '10.01.0016' and '10.06.0202' and ProdDataValidFim is null and ProdGrupo = 'F' and ProdStat = 'Ativado' ) and I.ItPedVendaUnidMedCod = 'CX' and P.StatPedVendaCod in ('07','01','02') and P.PedVendaTipoNota = 'Saída' and P.PedVendaTipo = 'Total' and (N.NatOpEntraRelVenda = 'Sim' Or P.PedVendaNatOpProd In ('5.910','5.910.001','5.910.002','5.910.003','6.910','6.910.001','6.910.002','6.910.003')) and P.PedVendaNatOpProd = N.NatOpCodEstr and I.ItPedVendaProdNome Is Not Null and P.EmpCod = I.EmpCod and P.PedVendaNum = I.Pedvendanum order by pedvendadatasolic DATASXPRODXQTD ProdCodEstr,System.String prodnome,System.String pedvendadatasolic,System.DateTime Quantidade,System.Decimal ESTOQUE,System.Decimal PRODUCAO,System.Decimal 10000000 DATASXPRODXQTD MASTER select I.ProdCodEstr, PR.prodnome, pedvendadatasolic, Cast(Sum(I.ItpedVendaQtd) as numeric(14,2)) Quantidade, ISNULL( (SELECT sum(EstqLocArmazQtd/ProdUnidMedPeso) from Estq_loc_armaz With(NoLock), Prod_Unid_med With(NoLock) where (Estq_loc_armaz.ProdCodEstr = I.ProdCodEstr) and Estq_Loc_Armaz.LocArmazCodEstr <> '6.1' and Estq_Loc_Armaz.LocArmazCodEstr <> '6.2' and ProdUnidmedCod = 'cx' and ProdUnidMedDataValidFim is null and Estq_loc_armaz.ProdCodEstr = Prod_Unid_Med.ProdCodEstr),0) ESTOQUE, ISNULL((Select sum (OrdProducQtdNec-OrdProducQtdBoa) From Ord_Produc Where (ProdCodEstr = I.ProdCodEstr) And OrdProducStat in ('Finalizada Parcial','Liberada')),0) PRODUCAO from PED_VENDA P With(NoLock), ITEM_PED_VENDA I With(NoLock), NAT_OPERACAO N With(NoLock), PRODUTO PR With(NoLock) Where (I.ProdCodEstr in (select ProdCodEstr from produto With(NoLock) where ProdcodEstr between '10.01.0016' and '10.06.0202' and ProdDataValidFim is null and ProdGrupo = 'F' and ProdStat = 'Ativado')) and I.ItPedVendaUnidMedCod = 'CX' and P.StatPedVendaCod in ('07','01','02') and P.PedVendaTipoNota = 'Saída' and P.PedVendaTipo = 'Total' and (N.NatOpEntraRelVenda = 'Sim' Or P.PedVendaNatOpProd In ('5.910','5.910.001','5.910.002','5.910.003','6.910','6.910.001','6.910.002','6.910.003')) and P.PedVendaNatOpProd = N.NatOpCodEstr and I.ItPedVendaProdNome Is Not Null and P.EmpCod = I.EmpCod and P.PedVendaNum = I.Pedvendanum and I.prodCodEstr = PR.prodCodEstr group by I.prodCodEstr, pedvendadatasolic, PR.prodnome order by I.prodCodEstr, pedvendadatasolic Relação pedvendadatasolic Relação Relação pedvendadatasolic ,ExportFormat,ExportFormat,,System.String,,False,False,False,False EngineV2 None;Black;2;Solid;False;4;Black Transparent All;Black;1;Solid;False;4;Black Transparent 0,0.4,27.7,1.3 None;White;1;Solid;False;4;Black Transparent 11.45,0.35,4.8,0.6 Arial,10,Bold| Italic Center 0,0,0,0 Text42 TITULO [31:73:125] Typographic Expression Center PageHeaderBand2 Transparent 0,1.9,16.6,6.3 All;[155:155:155];1;Solid;False;4;Black White 0,0.45,3,0.4 Arial,8 14b7fc95474f4bf28023dfbc9b622fc4 0,0,0,0 3,0 CrossTab1_Row1_Title False AllowMove, AllowResize, AllowSelect, AllowChange Código Produto [105:105:105] Typographic Row:CrossTab1_Row1 All;[155:155:155];1;Solid;False;4;Black White 0,0,7.3,0.4 Arial,8 ba9fce63a3944ebbac5810cabcf72dfa 0,0,0,0 CrossTab1_LeftTitle False AllowMove, AllowResize, AllowSelect, AllowChange [105:105:105] Typographic LeftTitle All;[155:155:155];1;Solid;False;4;Black White 3,0.45,1.3,0.4 Arial,8 4b67ffe972c349ce849419fbc9497c48 0,0,0,0 CrossTab1_Row2_Title AllowMove, AllowResize, AllowSelect, AllowChange Produto [105:105:105] Typographic Row:CrossTab1_Row2 All;[155:155:155];1;Solid;False;4;Black [255:255:255] 0,0,1,0 Arial,8 1c778c16cf9d405699e51ac33a190a59 0,0,0,0 CrossTab1_RowTotal1 AllowMove, AllowResize, AllowSelect, AllowChange Total Black Typographic All;[155:155:155];1;Solid;False;4;Black [255:255:255] 0,0,1,0 Arial,8 17aad7d70ee141dfa02475a6d3e72556 0,0,0,0 CrossTab1_RowTotal2 AllowMove, AllowResize, AllowSelect, AllowChange Total Black Typographic All;[155:155:155];1;Solid;False;4;Black [255:255:255] 10.35,0.45,3,0.4 Arial,8 94f1ec0289534af6b48f69b6febfd2f9 0,0,0,0 3,0 CrossTab1_ColTotal1 AllowMove, AllowResize, AllowSelect, AllowChange Total Black Typographic All;[155:155:155];1;Solid;False;4;Black [255:255:255] 4.3,1.3,3,0 Arial,8 825167695b2944f9968cbe89f8583cb7 0,0,0,0 CrossTab1_RowTotal3 AllowMove, AllowResize, AllowSelect, AllowChange Total Black Typographic All;[155:155:155];1;Solid;False;4;Black White 4.3,0.45,3,0.4 Arial,8 39261dff6a594b45ac684c24941d7e6f 0,0,0,0 3,0 CrossTab1_Row3_Title AllowMove, AllowResize, AllowSelect, AllowChange Estoque [105:105:105] Typographic Row:CrossTab1_Row3 All;[155:155:155];1;Solid;False;4;Black White 7.35,0,6,0.4 Arial,8 b4844543f0804de8b757d9524bab4086 0,0,0,0 CrossTab1_RightTitle AllowMove, AllowResize, AllowSelect, AllowChange pedvendadatasolic [105:105:105] Typographic RightTitle ProdCodEstr All;[155:155:155];1;Solid;False;4;Black White 0,0.9,3,0.4 {DATASXPRODXQTD.ProdCodEstr} Arial,8 7ed66d0c9b374b008bf318c27ecbf78b 0,0,0,0 3,0 CrossTab1_Row1 AllowMove, AllowResize, AllowSelect, AllowChange False ProdCodEstr [105:105:105] Typographic 1c778c16cf9d405699e51ac33a190a59 {DATASXPRODXQTD.ProdCodEstr} prodnome All;[155:155:155];1;Solid;False;4;Black White 3,0.9,1.3,0.4 {DATASXPRODXQTD.prodnome} Arial,8 5b4acb8bf98445279c19df4d6d2f99bb Left 0,0,0,0 CrossTab1_Row2 AllowMove, AllowResize, AllowSelect, AllowChange False prodnome [105:105:105] Typographic 17aad7d70ee141dfa02475a6d3e72556 {DATASXPRODXQTD.prodnome} ESTOQUE All;[155:155:155];1;Solid;False;4;Black White 4.3,0.9,3,0.4 {DATASXPRODXQTD.ESTOQUE} Arial,8 f4cfed7e9c5142228bb97686e1331b73 0,0,0,0 3,0 CrossTab1_Row3 False AllowMove, AllowResize, AllowSelect, AllowChange False ESTOQUE [105:105:105] , . 1 Typographic 825167695b2944f9968cbe89f8583cb7 {DATASXPRODXQTD.ESTOQUE} pedvendadatasolic All;[155:155:155];1;Solid;False;4;Black White 7.35,0.45,3,0.4 {DATASXPRODXQTD.Relação.pedvendadatasolic} Arial,8 d5111eefac5641de946430b30d0f696d 0,0,0,0 3,0 CrossTab1_Column1 AllowMove, AllowResize, AllowSelect, AllowChange pedvendadatasolic [105:105:105] Typographic 94f1ec0289534af6b48f69b6febfd2f9 {DATASXPRODXQTD.Relação.pedvendadatasolic} Quantidade All;[155:155:155];1;Solid;False;4;Black [255:255:255] 7.35,0.9,3,0.4 Arial,8 751c11d043ef43c7a8d5dcb32f9005f6 0,0,0,0 3,0 CrossTab1_Sum1 AllowMove, AllowResize, AllowSelect, AllowChange 0 Black 0 , . 1 False Typographic {DATASXPRODXQTD.Quantidade} Relação DATASXPRODXQTD c94500b75aee4d808fa6f3220ce5f378 CrossTab1 False 4cc2468787804a1199aaa8014f03b857 1,1,1,1 PDF Landscape 21 29.7 Arial,100 [50:0:0:0] None;Black;2;Solid;False;4;Black Transparent Transparent 0,0,16.6,6.3 All;[155:155:155];1;Solid;False;4;Black White 0,0,7.3,0.4 Arial,8 ba9fce63a3944ebbac5810cabcf72dfa 0,0,0,0 CrossTitle2 False AllowMove, AllowResize, AllowSelect, AllowChange [105:105:105] Typographic LeftTitle All;[155:155:155];1;Solid;False;4;Black [255:255:255] 0,0,1,0 Arial,8 1c778c16cf9d405699e51ac33a190a59 0,0,0,0 CrossTab2_RowTotal1 AllowMove, AllowResize, AllowSelect, AllowChange Total Black Typographic All;[155:155:155];1;Solid;False;4;Black [255:255:255] 0,0,1,0 Arial,8 17aad7d70ee141dfa02475a6d3e72556 0,0,0,0 CrossTab2_RowTotal2 AllowMove, AllowResize, AllowSelect, AllowChange Total Black Typographic All;[155:155:155];1;Solid;False;4;Black [255:255:255] 10.35,0.45,3,0.4 Arial,8 94f1ec0289534af6b48f69b6febfd2f9 0,0,0,0 3,0 CrossTab2_ColTotal1 AllowMove, AllowResize, AllowSelect, AllowChange Total Black Typographic All;[155:155:155];1;Solid;False;4;Black White 0,0.45,3,0.4 Arial,8 e04ed7b4d155402882832bd874fe45b9 0,0,0,0 CrossTab2_Row1_Title AllowMove, AllowResize, AllowSelect, AllowChange Cód. Produto [105:105:105] Typographic Row:CrossTab2_Row1 All;[155:155:155];1;Solid;False;4;Black White 3,0.45,1.3,0.4 Arial,8 4a2378c5c67241dda07d4daca3413bdf 0,0,0,0 CrossTab2_Row2_Title AllowMove, AllowResize, AllowSelect, AllowChange Produto [105:105:105] Typographic Row:CrossTab2_Row2 All;[155:155:155];1;Solid;False;4;Black [255:255:255] 4.3,1.3,1.4,0 Arial,8 ec2f97282ef34e77adefeeb229291c80 0,0,0,0 CrossTab2_RowTotal3 AllowMove, AllowResize, AllowSelect, AllowChange Total Black Typographic All;[155:155:155];1;Solid;False;4;Black White 4.3,0.45,3,0.4 Arial,8 fcb9584e4e1d465cad7fa27acbb2f0ab 0,0,0,0 3,0 CrossTab2_Row3_Title AllowMove, AllowResize, AllowSelect, AllowChange Estoque [105:105:105] Typographic Row:CrossTab2_Row3 All;[155:155:155];1;Solid;False;4;Black White 7.35,0,6,0.4 Arial,8 705e2fd9e9c6404f8ed02de8107348fd 0,0,0,0 CrossTab2_RightTitle AllowMove, AllowResize, AllowSelect, AllowChange Data [105:105:105] Typographic RightTitle ProdCodEstr All;[155:155:155];1;Solid;False;4;Black White 0,0.9,3,0.4 {DATASXPRODXQTD.ProdCodEstr} Arial,8 7ed66d0c9b374b008bf318c27ecbf78b 0,0,0,0 3,0 CrossTab2_Row1 False AllowMove, AllowResize, AllowSelect, AllowChange False ProdCodEstr [105:105:105] Typographic 1c778c16cf9d405699e51ac33a190a59 {DATASXPRODXQTD.ProdCodEstr} prodnome All;[155:155:155];1;Solid;False;4;Black White 3,0.9,1.3,0.4 {DATASXPRODXQTD.prodnome} Arial,8 5b4acb8bf98445279c19df4d6d2f99bb Left 0,0,0,0 CrossTab2_Row2 False AllowMove, AllowResize, AllowSelect, AllowChange False prodnome [105:105:105] Typographic 17aad7d70ee141dfa02475a6d3e72556 {DATASXPRODXQTD.prodnome} ESTOQUE All;[155:155:155];1;Solid;False;4;Black White 4.3,0.9,3,0.4 {DATASXPRODXQTD.ESTOQUE} Arial,8 014fcbce3cdf4145a09446ad4891f295 0,0,0,0 3,0 CrossTab2_Row3 False AllowMove, AllowResize, AllowSelect, AllowChange False ESTOQUE [105:105:105] , . 1 Typographic ec2f97282ef34e77adefeeb229291c80 {DATASXPRODXQTD.ESTOQUE} pedvendadatasolic All;[155:155:155];1;Solid;False;4;Black White 7.35,0.45,3,0.4 {DATASXPRODXQTD.Relação.pedvendadatasolic} Arial,8 d5111eefac5641de946430b30d0f696d 0,0,0,0 3,0 CrossTab2_Column1 False AllowMove, AllowResize, AllowSelect, AllowChange pedvendadatasolic [105:105:105] Typographic 94f1ec0289534af6b48f69b6febfd2f9 {DATASXPRODXQTD.Relação.pedvendadatasolic} Quantidade All;[155:155:155];1;Solid;False;4;Black [255:255:255] 7.35,0.9,3,0.4 Arial,8 751c11d043ef43c7a8d5dcb32f9005f6 0,0,0,0 3,0 CrossTab2_Sum1 AllowMove, AllowResize, AllowSelect, AllowChange 0 Black 0 , . 1 False Typographic {DATASXPRODXQTD.Quantidade} DATASXPRODXQTD c94500b75aee4d808fa6f3220ce5f378 CrossTab2 44621eaa43124ae3a84794990535e265 1,1,1,1 Excel Landscape 21 29.7 False True Arial,100 [50:0:0:0] System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll PPCP_008_PlanProducDataSolicTeste 4/2/2018 2:28:13 PM 7/4/2016 11:48:46 AM X:\ProgramData\Riosoft\Riosoft.Net\Soin\ReportSource\PPCP_008_PlanProducDataSolicTeste.mrt 5f6c46c80a22409c8862d101bc00521f PPCP_008_PlanProducDataSolicTeste Centimeters 2018.1.6.0 CSharp