ReportName = FORMAT_B1; if (FORMAT_E1 == "N"){ GroupHeaderBand1.Enabled = false; }; if (FORMAT_E7 == "N") { Criterios1.Enabled = false; }; if (FORMAT_E3 == "N") { Text19.Enabled = false; Text9.Enabled = false; Text17.Enabled = false; Text39.Enabled = false; Text38.Enabled = false; Text21.Enabled = false; Text42.Enabled = false; Text10.Enabled = false; Text40.Enabled = false; Text8.Enabled = false; /*Compras*/ Text18.Left = 15.3; Text45.Left = 15.3; Text41.Left = 15.3; Text13.Left = 15.3; Text11.Left = 17.3; Text20.Left = 17.3; Text16.Left = 13.6; Text6.Left = 13.6; Text30.Left = 13.6; Text33.Left = 13.6; Text26.Left = 13.6; Text32.Left = 13.6; /*Ubicación*/ Text23.Left = 12; Text22.Left = 12; /*stock */ Text15.Left = 9.8; Text7.Left = 10.2; Text36.Left = 10; /*Descripción*/ Text5.Width = 9; }; if (FORMAT_E2 == "N") { Text20.Enabled = false; Text18.Enabled = false; Text45.Enabled = false; Text11.Enabled = false; Text13.Enabled = false; Text41.Enabled = false; Text21.Enabled = false; Text42.Enabled = false; Text10.Enabled = false; Text40.Enabled = false; /* ventas*/ Text17.Left = 15.3; Text38.Left = 15.3; Text39.Left = 15.3; Text9.Left = 15.3; Text19.Left = 17.3; Text8.Left = 17.3; Text16.Left = 13.6; Text6.Left = 13.6; Text30.Left = 13.6; Text33.Left = 13.6; Text26.Left = 13.6; Text32.Left = 13.6; /*Ubicación*/ Text23.Left = 12; Text22.Left = 12; /*stock */ Text15.Left = 9.8; Text7.Left = 10.2; Text36.Left = 10; /*Descripción*/ Text5.Width = 9; }; if ( FORMAT_E4 == "N" ) { Text20.Enabled = false; Text8.Enabled = false; Text18.Enabled = false; Text45.Enabled = false; Text11.Enabled = false; Text41.Enabled = false; Text21.Enabled = false; Text42.Enabled = false; Text10.Enabled = false; Text40.Enabled = false; Text23.Left = 17; Text22.Left = 17; Text16.Left = 14.5; Text6.Left = 14.5; Text30.Left = 14.5; Text33.Left = 14.5; Text26.Left = 14.5; Text32.Left = 14.5; Text15.Left = 12.4; Text7.Left = 12.8; Text36.Left = 12.6; Text5.Width = 12; }; Oracle Oracle HR.AUX_INVENTARIO SESION,System.Decimal EMP_CODIGO,System.String ALM_CODIGO,System.Decimal ART_CODIGO,System.String DESCRIPCION,System.String STOCK,System.Decimal INV_PC_E,System.Decimal INV_PV_E,System.Decimal IMP_PC_E,System.Decimal IMP_PV_E,System.Decimal DIF_INV_E,System.Decimal INV_PC_P,System.Decimal INV_PV_P,System.Decimal IMP_PC_P,System.Decimal IMP_PV_P,System.Decimal DIF_INV_P,System.Decimal FAM_CODIGO,System.String SUBF_CODIGO,System.String CATEGORIA,System.String UBICACION,System.String GT_CODIGO,System.String LAB_CODIGO,System.Decimal PRV_CODIGO,System.Decimal FECHA_CAD,System.DateTime IMP_CODIGO,System.String CLASE,System.String MOTIVO,System.Decimal COMUNIDAD,System.String CODIGO_CJTO,System.String DESC_CJTO,System.String TIPO_CJTO,System.String PVP_ARTICULO_E,System.Decimal PVP_ARTICULO_P,System.Decimal DIF_PRECIO_E,System.Decimal DIF_PRECIO_P,System.Decimal STOCK_MIN,System.Decimal ROTACION,System.Decimal FECHA_INVENT,System.DateTime CLASE_BOT,System.String 30 a1d0829e71e64f78a750e0ffbdd4735e HR.AUX_INVENTARIO Oracle select * from HR.AUX_INVENTARIO ,SESION,SESION,El_x0020_número_x0020_de_x0020_sesión.,System.String,,False,False,False,False ,EMPRESA,EMPRESA,El_x0020_código_x0020_de_x0020_empresa.,System.String,_x0027_EMP1_x0027_,False,False,False,False ,SQL1,Where,Where_x0020_de_x0020_la_x0020_tabla_x0020_aux_inventario,System.String,,False,False,False,False ,SQL2,Order_x0020_,Order_x0020_by_x0020_de_x0020_la_x0020_tabla_x0020_AUX_INVENTARIO,System.String,,False,False,False,False ,FORMAT_B1,TITULO,,System.String,_x000D__x000A_,False,True,False,False ,FORMAT_B2,SUBTITULO,,System.String,,False,False,False,False ,FORMAT_B3,CRITERIOS,,System.String,N,False,False,False,False ,FORMAT_B4,Texto_precio,,System.String,,False,False,False,False ,FORMAT_B5,Texto_precio_x0020_2,,System.String,,False,False,False,False ,FORMAT_B6,Texto_precios3,,System.String,,False,False,False,False ,FORMAT_E1,Varios_Almacenes,Tiene_x0020_varios_x0020_almacenes,System.String,S,False,False,False,False ,FORMAT_E2,Mostrar_P_compra,Mostrar_x0020_los_x0020_precios_x0020_de_x0020_compra,System.String,N,False,False,False,False ,FORMAT_E3,Mostrar_P_Venta,Mostrar_x0020_los_x0020_precios_x0020_de_x0020_venta,System.String,S,False,False,False,False ,FORMAT_E4,Valorados,El_x0020_informes_x0020_es_x0020_valorado,System.String,N,False,False,False,False ,FORMAT_E5,Mostrar_descripcion,Mostrar_x0020_la_x0020_descripción_x0020_completa,System.String,,False,False,False,False ,FORMAT_E6,Expandir,Mostra_x0020_la_x0020_informacióne_x0020_expandida,System.String,,False,False,False,False ,FORMAT_E7,Mostrar_criterios,Mostrar_x0020_los_x0020_criterios_x0020_de_x0020_selección,System.String,,False,False,False,False ,FORMAT_E8,Habilitar_pag,,System.String,,False,False,False,False ,FORMAT_E9,Campo_x0020_opcional,,System.String,,False,False,False,False Totales Totales,TotalStock,TotalStock,,System.Decimal,,False,False,False,False Totales,TotalImpVta,TotalImpVta,,System.Decimal,,False,False,False,False Totales,TotalPMA,TotalPMA,,System.Decimal,,False,False,False,False Totales,TotalDif,TotalDif,,System.Decimal,,False,False,False,False Totales,reinicio,reinicio,,System.Boolean,false,False,True,False,False Totales,aux,aux,,System.Boolean,true,False,True,False,False Totales,lineas,lineas,,System.Decimal,,False,False,False,False ,FECHA,FECHA,,System.DateTime,,False,False,False,False ,FORMAT_E10,AUX_FECHA,,System.String,,False,False,False,False EngineV2 83ede87161a546a89b7a25be41c4fd8e if(FORMAT_E9 == "C"){ Text30.Enabled = false; Text26.Enabled = false; Text33.Enabled = false; Text32.Enabled = false; } else if(FORMAT_E9 == "S") { Text16.Enabled = false; Text26.Enabled = false; Text6.Enabled = false; Text32.Enabled = false; } else if(FORMAT_E9 == "R") { Text16.Enabled = false; Text30.Enabled = false; Text6.Enabled = false; Text33.Enabled = false;} else{ Text16.Enabled = false; Text30.Enabled = false; Text26.Enabled = false; Text6.Enabled = false; Text33.Enabled = false; Text32.Enabled = false; } None;Transparent;2;Solid;False;4;Black Transparent [245:245:245] 0,0.4,19,1.6 True Transparent 0.2,0,7.4,0.8 Titulo Arial,16 23f1cccddc2441ee8643a144248e1897 0,0,0,0 Text1 {FORMAT_B1} [0:0:0] Wysiwyg Expression Center None;[91:91:91];1;Solid;False;4;Black Transparent 17.4,0.2,1.4,1.2 AA_EMP_FOTO.FOTO 817d649131564c33b23a110f9cc3673b Center 68, 114, 196 0,0,0,0 Image1 True Center Transparent 11.4,0.8,5.8,0.6 Fecha Arial,10 e1a844c698974c558a0ac229d4b043bc Right 0,0,0,0 Text4 {FECHA} [0:0:0] D Expression Center Transparent 0.2,0.8,7.4,0.6 Subtitulo Arial,14 86bc74c5520542f896e1946715a55466 0,0,0,0 Text78 {FORMAT_B2} [0:0:0] Expression Center 0,1.4,19,0.0254 205, 92, 92 RayasDobles IndianRed 4c95f54901464b28b5c4f91518737729 HorizontalLinePrimitive1 IndianRed CabeceraPagina 0dcac1a1c163423c88383727c4dbfc32 CabeceraPagina [245:245:245] 0,26.9,19,0.8 Transparent 16,0.3,2.8,0.4 NumeroPagina Arial,8 0d5a0af76c854c5ab59d9a779a9587a2 Right 0,0,0,0 Text31 {PageNofM} [0:0:0] SystemVariables 0,0.1,19,0.0254 205, 92, 92 RayasDobles IndianRed ab99e31848c146a4a86337dd892eba88 HorizontalLinePrimitive5 IndianRed CabeceraPagina 4a7b01c50c8147e095ab0fc8080d36bf PiePagina Transparent True 0,2.8,19,0.8 [205:92:92] 0,0,19,0.4 CabeceraDetalle Microsoft Sans Serif,8,Bold 0,0,0,0 Text25 [250:250:250] [205:92:92] True True 0,0,1.2,0.4 CabeceraDetalle Microsoft Sans Serif,8,Bold bc2235dc901847fe86408eafbca460ec 0,0,0,0 Text14 Código [250:250:250] Expression [205:92:92] True True 1.2,0,4,0.4 CabeceraDetalle Microsoft Sans Serif,8,Bold b3bd17d414844905a2b86dec667323b8 0,0,0,0 Text12 Descripción [250:250:250] Expression [205:92:92] True True 6.8,0,1.8,0.4 CabeceraDetalle Microsoft Sans Serif,8,Bold 1756979171054c1f973e73a0589ab235 Center 0,0,0,0 Text16 Caducidad [250:250:250] Expression [205:92:92] True True 10.2,0,2,0.4 CabeceraDetalle Microsoft Sans Serif,8,Bold d64ae3a522934224ade5b707621b9a1b Right 0,0,0,0 Text17 Imp. Vta [250:250:250] Expression [205:92:92] True True 12.2,0,2,0.4 CabeceraDetalle Microsoft Sans Serif,8,Bold 8c1fbcc467eb4b00a3bcd6316ba09bd7 Right 0,0,0,0 Text18 {FORMAT_B6} [250:250:250] Expression [205:92:92] True True 17.2,0,1.8,0.4 CabeceraDetalle Microsoft Sans Serif,8,Bold 723f5de53e1e407cb8e4c55e2b53ffab Right 0,0,0,0 Text21 Diferencia [250:250:250] Expression [205:92:92] True True 14.2,0,1.4,0.4 CabeceraDetalle Microsoft Sans Serif,8,Bold 270553f403a54dee8b96078c69d6147b Right 0,0,0,0 Text19 P. Vta [250:250:250] Expression [184:204:228] True True 8.6,0.4,4.6,0.4 _x007B_IsFirstPage_x007D_,Red,Transparent,Arial_x002C_8,False,False,,,None Microsoft Sans Serif,8,Bold f3ce30a64b284a2181a7b843fa928fe1 Right 0,0,0,0 Text38 ExceptFirstPage {cSumRunning(Datos,HR_AUX_INVENTARIO.IMP_PV_E)-cSum(Datos,HR_AUX_INVENTARIO.IMP_PV_E)} Black 2 , . 1 False Expression Transparent True True 17.2,0.4,1.8,0.4 _x007B_IsFirstPage_x007D_,Red,Transparent,Arial_x002C_8,False,False,,,None Microsoft Sans Serif,8,Bold c1c13af3515d414d81e71c25607dbe92 Right 0,0,0,0 Text42 ExceptFirstPage {cSumRunning(Datos,HR_AUX_INVENTARIO.DIF_INV_E)-cSum(Datos,HR_AUX_INVENTARIO.DIF_INV_E)} Black 2 , . 1 False Expression [205:92:92] True True 15.6,0,1.6,0.4 CabeceraDetalle Microsoft Sans Serif,8,Bold c77461969f0d40f4a91836974513dc6a Right 0,0,0,0 Text20 {FORMAT_B5} [250:250:250] Expression Transparent True True 13,0.4,2,0.4 _x007B_IsFirstPage_x007D_,Red,Transparent,Arial_x002C_8,False,False,,,None Microsoft Sans Serif,8,Bold a17ddc1411f94c18a001db688095929c Right 0,0,0,0 Text45 ExceptFirstPage {cSumRunning(Datos,HR_AUX_INVENTARIO.IMP_PC_E)-cSum(Datos,HR_AUX_INVENTARIO.IMP_PC_E)} Black 2 , . 1 False Expression [205:92:92] True True 5.2,0,1.6,0.4 CabeceraDetalle Microsoft Sans Serif,8,Bold b283e2eea4624e74bc4bee4cafaa00b3 Right 0,0,0,0 Text15 Stock [250:250:250] Expression [205:92:92] True True 6.8,0,1.8,0.4 CabeceraDetalle Microsoft Sans Serif,8,Bold 0ed79531251a4ef782d88143edccc5da Right 0,0,0,0 Text26 Rotación [250:250:250] Expression [205:92:92] True True 6.8,0,1.8,0.4 CabeceraDetalle Microsoft Sans Serif,8,Bold ad926abb5682489b989df1bf2b8e8996 Right 0,0,0,0 Text30 Stock mín [250:250:250] Expression [205:92:92] True True 8.6,0,1.6,0.4 CabeceraDetalle Microsoft Sans Serif,8,Bold 5054335a13c4418c82f1f47acef8ac46 0,0,0,0 Text23 Ubicación [250:250:250] Expression HeaderBand1 White 0,4.4,19,0.6 Transparent 0.4,0,10.8,0.6 Microsoft Sans Serif,12,Bold 0,0,0,0 Text24 [0:0:0] Expression {HR_AUX_INVENTARIO.ALM_CODIGO} GroupHeaderBand1 None TotalStock = 0; TotalPMA = 0; TotalImpVta = 0; TotalDif = 0; None;[0:0:0:0];1;Solid;False;5;Black Transparent True 0,5.8,19,0.4 if (FORMAT_E5 == "S") { Text5.WordWrap = true; }; [250:250:250] True True 1.2,0,4.6,0.4 Datos1_Pares Microsoft Sans Serif,8 True 0,0,0,0 Text5 {HR_AUX_INVENTARIO.DESCRIPCION} [0:0:0] Wysiwyg Expression [250:250:250] True True 0,0,1.2,0.4 Datos1_Pares Microsoft Sans Serif,8 True 0,0,0,0 Text3 {HR_AUX_INVENTARIO.ART_CODIGO} [0:0:0] Expression [250:250:250] True True 17.2,0,1.8,0.4 Datos1_Pares Microsoft Sans Serif,8 True Right 0,0,0,0 Text10 {HR_AUX_INVENTARIO.DIF_INV_E} [0:0:0] 2 , . 1 False Expression [250:250:250] True True 14.2,0,1.4,0.4 Datos1_Pares Microsoft Sans Serif,8 True Right 0,0,0,0 Text8 {HR_AUX_INVENTARIO.INV_PV_E} [0:0:0] 2 , . 1 False Expression [250:250:250] True True 12.2,0,2,0.4 Datos1_Pares Microsoft Sans Serif,8 True Right 0,0,0,0 Text13 {HR_AUX_INVENTARIO.IMP_PC_E} [0:0:0] 2 , . 1 False Expression [250:250:250] True True 15.6,0,1.6,0.4 Datos1_Pares Microsoft Sans Serif,8 True Right 0,0,0,0 Text11 {HR_AUX_INVENTARIO.INV_PC_E} [0:0:0] 2 , . 1 False Expression [250:250:250] True True 10,0,2.2,0.4 Datos1_Pares Microsoft Sans Serif,8 True Right 0,0,0,0 Text9 {HR_AUX_INVENTARIO.IMP_PV_E} [0:0:0] 2 , . 1 False Expression [250:250:250] True True 5.8,0,1,0.4 Datos1_Pares Microsoft Sans Serif,8 True Right 0,0,0,0 Text7 {HR_AUX_INVENTARIO.STOCK} [0:0:0] 0 , . 1 False Expression [250:250:250] True True 8.6,0,1.6,0.4 Datos1_Pares Microsoft Sans Serif,8 True 0,0,0,0 Text22 {HR_AUX_INVENTARIO.UBICACION} [0:0:0] Expression [250:250:250] True True 6.8,0,1.8,0.4 Datos1_Pares Microsoft Sans Serif,8 True Center 0,0,0,0 Text6 {HR_AUX_INVENTARIO.FECHA_CAD} [0:0:0] MM/yyyy Expression [250:250:250] True True 6.8,0,1.8,0.4 Datos1_Pares Microsoft Sans Serif,8 True Right 0,0,0,0 Text33 {HR_AUX_INVENTARIO.STOCK_MIN} [0:0:0] 0 , . 1 False Expression [250:250:250] True True 6.8,0,1.8,0.4 Datos1_Pares Microsoft Sans Serif,8 True Right 0,0,0,0 Text32 {HR_AUX_INVENTARIO.ROTACION} [0:0:0] 2 , . 1 False Expression HR.AUX_INVENTARIO Datos1_Pares Datos Datos1_Impares TotalStock = TotalStock + HR_AUX_INVENTARIO.STOCK; TotalPMA = TotalPMA + HR_AUX_INVENTARIO.IMP_PC_E; TotalImpVta = TotalImpVta + HR_AUX_INVENTARIO.IMP_PV_E; TotalDif = TotalDif + HR_AUX_INVENTARIO.DIF_INV_E; lineas++; [205:92:92] True 0,7,19,0.4 [205:92:92] True True 1.2,0,1.4,0.4 CabeceraDetalle Microsoft Sans Serif,8,Bold 4043198d93fd43a5bd7cad7b56d52688 0,0,0,0 Text37 Totales [250:250:250] Expression [205:92:92] True True 5.6,0,1.2,0.4 CabeceraDetalle Microsoft Sans Serif,8,Bold eabdaa2823014f8a9fe127649debfe9d Right 0,0,0,0 Text36 {TotalStock} [250:250:250] 0 , . 1 False Expression [205:92:92] True True 10,0,2.2,0.4 CabeceraDetalle Microsoft Sans Serif,8,Bold 8752536b2a7a453b9232b2ad58064957 Right 0,0,0,0 Text39 {TotalImpVta} [250:250:250] 2 , . 1 False Expression [205:92:92] True True 17.2,0,1.8,0.4 CabeceraDetalle Microsoft Sans Serif,8,Bold 563e9b7c3a46422099acb5cfc0e54a4a Right 0,0,0,0 Text40 {TotalDif} [250:250:250] 2 , . 1 False Expression [205:92:92] True True 12.2,0,2,0.4 CabeceraDetalle Microsoft Sans Serif,8,Bold e6f70ffd89194998b25d99d426bc56e0 Right 0,0,0,0 Text41 {TotalPMA} [250:250:250] 2 , . 1 False Expression [205:92:92] True True 3.2,0,1,0.4 CabeceraDetalle Microsoft Sans Serif,8,Bold fc6d110d2d9b40579821c5db88684eb5 0,0,0,0 Text34 Líneas [250:250:250] Expression [205:92:92] True True 4.2,0,1.2,0.4 CabeceraDetalle Microsoft Sans Serif,8,Bold 7e34a5acf8b842008eecd3d861088666 Right 0,0,0,0 Text35 {lineas} [250:250:250] 0 , . 1 False Expression CabeceraDetalle FooterBand1 Transparent True 0,8.2,19,3.8 Transparent 0.4,0.3,5.2,0.6 TituloCriteriosSeleccion Microsoft Sans Serif,12,Bold 2fbc3b816b0245a7b8a51a6f40c4bec0 0,0,0,0 Text28 OnlyLastPage Criterios de selección: [0:0:0] Expression Center Transparent True True 0.4,0.9,17.8,2.8 TextoCriteriosSeleccion Microsoft Sans Serif,8 bb0a13c3bab7490aae091b32534a6229 0,0,0,0 Text29 {FORMAT_B3} [0:0:0] Wysiwyg Expression 227a79a2bd67473994f5eadd24dd44de False Criterios1 False 37f5489048694a58bb7613cb1559c49d 1,1,1,1 Pagina1 29.7 21 System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll Report 1/27/2023 4:10:13 PM 4/3/2014 5:22:08 PM C:\Users\Developer\Downloads\ALMA0500changed1.mrt b862785dd6da42499696dd1be7c29377 Report Centimeters 2023.1.6.0 CSharp [245:245:245] Pagina,fondo Microsoft Sans Serif,8 CabeceraPagina Red [0:0:0] Transparent Informe,Titulo Arial,16 Titulo Red [0:0:0] Transparent Informe,Subtitulo Arial,14 Subtitulo Red [0:0:0] Transparent Empresa,Nombre Arial,12 NombreEmpresa Red [0:0:0] Transparent Fecha Arial,10 Fecha Red [0:0:0] None;[205:92:92];1;Double;False;4;Black [205:92:92] Pagina,Lineas Arial,8 RayasDobles Red [205:92:92] [245:245:245] Cabecera Microsoft Sans Serif,8 CabeceraAgrupa Red [0:0:0] [205:92:92] Detalle, cabecera y pie Microsoft Sans Serif,8,Bold CabeceraDetalle Red [250:250:250] [220:220:220] Coleccion DataOddStyle Placement, PlacementNestedLevel Detalle,fondo Microsoft Sans Serif,8 Datos1_Impares Red [0:0:0] [250:250:250] Coleccion DataEvenStyle Placement, PlacementNestedLevel Datos_pares Microsoft Sans Serif,8 Datos1_Pares Red [0:0:0] All;[250:250:250];1;Solid;False;4;Black [205:92:92] Tablas,cabecera Microsoft Sans Serif,8,Bold Center CabeceraTabla Red [250:250:250] Center All;[250:250:250];1;Solid;False;4;Black [255:160:122] Tablas, fila par Microsoft Sans Serif,8 Center TablaImpar Red [0:0:0] Center All;[250:250:250];1;Solid;False;4;Black [255:228:196] Tablas, fila impar Microsoft Sans Serif,8 Center TablaPar Red [0:0:0] Center Transparent Pagina,numero Arial,8 NumeroPagina Red [0:0:0] Transparent Seleccion,titulo Microsoft Sans Serif,12,Bold TituloCriteriosSeleccion Red [0:0:0] Transparent Seleccion,texto Microsoft Sans Serif,8 TextoCriteriosSeleccion Red [0:0:0] Transparent Etiquetas de los maestros Microsoft Sans Serif,8,Bold EtiquetasMaestro Red [205:92:92] [205:92:92] Lineas maestro Arial,8 LineasMaestro Red [205:92:92] Transparent Descripcion agrupacion Microsoft Sans Serif,10 DescripcionAgru Red [0:0:0]