[List description] [Description] Text=Informe de Inventario x Almacenes sin Valorar FileVersion=7 Units=SCM-Units Metric=0 TextQuote.Start=1 TextQuote.End=1 RepresentationCode.CondStart=171 RepresentationCode.CondSep=166 RepresentationCode.CondEnd=187 RepresentationCode.Tab=247 RepresentationCode.Ret=182 RepresentationCode.PhantomSpace=2 RepresentationCode.LockNextChar=3 RepresentationCode.ExprSep=164 LCID=10 Created=08/01/2000, 05:08:03 CreatedByApp=PRU.EXE [] CreatedByDLL=CMBTL6.DLL [6.075] CreatedByUser= LastModified=19/12/2022, 13:18:56 LastModifiedByApp=TOUCHDOMINUSSCALE.EXE [1.0.0.0] LastModifiedByDLL=CMLL12.DLL [12,15,0,0 (07-08-07 09:10)] LastModifiedByUser=admin on WIN10-JOA CreatedByCallFrom=TouchDominusScale.exe [Layout] P1.Template= P2.Template= xOffset=0 yOffset=0 xSize=210100 ySize=297100 P1.xOffset=0 P1.yOffset=0 P1.xSize=210100 P1.ySize=297100 P2.xOffset=0 P2.yOffset=0 P2.xSize=210100 P2.ySize=297100 P1.nPaperFormat=9 P1.xPaperSize=210100 P1.yPaperSize=297100 P1.ForcePaperFormat=TRUE P2.nPaperFormat=9 P2.xPaperSize=210100 P2.yPaperSize=297100 P2.ForcePaperFormat=TRUE xGrid=1000 yGrid=1000 GridShow=TRUE GridSnap=TRUE PhysicalPage=TRUE P1.PhysicalPage=TRUE P2.PhysicalPage=TRUE Orientation=1 P1.Orientation=1 P2.Orientation=1 EnhancedExpressions=TRUE EnhancedOldExpressions=FALSE Decimals=2 DefFont={(0,0,0),8.000000,-13,0,0,0,400,0,0,0,0,3,2,1,34,Arial} HelpLines.Horizontal= HelpLines.Vertical= PDF.MaxOutlineDepth=2 DefaultSize.Objecttype1=(0,0,29000,5700) DefaultSize.Objecttype5=(0,0,30000,20000) DefaultSize.Objecttype6=(0,0,81000,247000) DefaultSize.Objecttype11=(0,0,205000,61000) ObjectCount=7 [UserSection] BASE almacen ORDEN 1 RELACIONA articu POR CAMPO c_codart FINLST TITULO=Ventas x Módulos e Importes * Says valores, filas y columnas TEXTOSAY=Desde el módulo:,Hasta el: FILASAY=2,2 COLUMSAY=2,14 TAMFIJO= * Gets valores por defecto, tipos, pictures, valids y columnas VALORDEF=space(9),"zzzzzzzzz" VALORTIPO=c,c VALORPICT=XXXXXXXXX,XXXXXXXXX VALORVALID=nada, VALORNCOL=12.5,24.5 * Valor desde-hasta y clave para comparar VDESDE=aDef[1]+Space(13) VHASTA=aDef[2]+Replicate("z",13) VCLAVE=c_alm+c_codart * Filtro para el listado FILTRO=like(aDef[3],c_codart) * ACUMULA= CONDACUM= BLOQUES=oPublic:cVLcantidad,oPublic:cVLprecio,oPublic:cVLtlinea,oPublic:cCLcantidad,oPublic:cCLprecio,oPublic:cCLtlinea,oPublic:cTLdocVto,oPublic:cLAcumula QUERY=select codmodulo , sum(case tnpuestos when 0 then nmodulos else tnpuestos end) as tpuestos, sum(timporte) as timportes from vlicenciasmodulos v group by codmodulo order by tpuestos DESC RUPTURA= ACCIONRUPTURA= NETIQUETA= [SumVariables] Sum1=@Timportes;F;OMEMQUERY.timportes Sum2=@Tpuestos;F;OMEMQUERY.tpuestos [Layer] Name=Base Condition= WorkspaceColor=(0,0,0) Visible=TRUE LayerID=0 [Layer] Name=Imprimir Líneas Condition= WorkspaceColor=(0,128,64) Visible=TRUE LayerID=1 [Layer] Name=Following Pages Condition=Page() <> 1 WorkspaceColor=(0,0,255) Visible=TRUE LayerID=2 [Object] ObjectID=1 ObjectName=Texto Locked=FALSE LinkID=3 LinkToID=0 LinkMode=32 LinkTest=-16091 LayerID=0 GroupID=0 Identifier= Condition=True UserLocked=False WrapBefore=False Position/Left=157000 Position/Top=9300 Position/Width=29000 Position/Height=5700 Direction=0 bFill=0 BkColor=RGB(255,255,255) Frame/Layout=0 Frame/Left/Line=False Frame/Top/Line=False Frame/Right/Line=False Frame/Bottom/Line=False bPageWrap=False bBottomAligned=False [@Lines] { [Lines] { [Line] { [Font] { Default=False FaceName="Arial" GdiCharSet=0 Size=10.0 Width=0 Bold=False Italic=False Underline=False Strikeout=False Color=LL.Color.Black PitchAndFamily=34 OutPrecision=3 } Align=2 Adjusted=False Uneraseable=False LineWrap=0 PageWrapAllowed=False SpaceOptimization=True Spacing.Paragraph=0 Spacing.Line=0 OutputFormatter= Condition=True Text="Hoja Nº:"+Fstr$(Page(),"####") Tab=0 TabAlign=0 } } } [Object] ObjectID=1 ObjectName=Texto Locked=FALSE LinkID=24 LinkToID=0 LinkMode=32 LinkTest=-31060 LayerID=0 GroupID=0 Identifier= Condition=True UserLocked=False WrapBefore=False Position/Left=11500 Position/Top=28000 Position/Width=146900 Position/Height=8000 Direction=0 bFill=0 BkColor=RGB(255,255,255) Frame/Layout=0 Frame/Left/Line=False Frame/Top/Line=False Frame/Right/Line=False Frame/Bottom/Line=False bPageWrap=False bBottomAligned=False [@Lines] { [Lines] { [Line] { [Font] { Default=False FaceName="Arial" GdiCharSet=0 Size=20.0 Width=0 Bold=False Italic=True Underline=False Strikeout=False Color=LL.Color.Black PitchAndFamily=34 OutPrecision=3 } Align=0 Adjusted=False Uneraseable=True LineWrap=0 PageWrapAllowed=False SpaceOptimization=False Spacing.Paragraph=0 Spacing.Line=0 OutputFormatter= Condition=True Text="Resúmen Distribuidores e Importes" Tab=0 TabAlign=0 } } } [Object] ObjectID=1 ObjectName=Texto Locked=FALSE LinkID=16 LinkToID=0 LinkMode=32 LinkTest=-31186 LayerID=0 GroupID=0 Identifier= Condition=True UserLocked=False WrapBefore=False Position/Left=10000 Position/Top=9000 Position/Width=70000 Position/Height=6000 Direction=0 bFill=0 BkColor=RGB(255,255,255) Frame/Layout=0 Frame/Left/Line=False Frame/Top/Line=False Frame/Right/Line=False Frame/Bottom/Line=False bPageWrap=False bBottomAligned=False [@Lines] { [Lines] { [Line] { [Font] { Default=False FaceName="Arial" GdiCharSet=0 Size=10.0 Width=0 Bold=False Italic=False Underline=False Strikeout=False Color=LL.Color.Black PitchAndFamily=34 OutPrecision=3 } Align=0 Adjusted=False Uneraseable=False LineWrap=0 PageWrapAllowed=False SpaceOptimization=True Spacing.Paragraph=0 Spacing.Line=0 OutputFormatter= Condition=True Text=OMEM_PUBLICAS.FechaLetras Tab=0 TabAlign=0 } } } [Object] ObjectID=1 ObjectName=Texto Locked=FALSE LinkID=19 LinkToID=0 LinkMode=32 LinkTest=-26308 LayerID=0 GroupID=0 Identifier= Condition=True UserLocked=False WrapBefore=False Position/Left=98000 Position/Top=9000 Position/Width=51000 Position/Height=6000 Direction=0 bFill=0 BkColor=RGB(255,255,255) Frame/Layout=0 Frame/Left/Line=False Frame/Top/Line=False Frame/Right/Line=False Frame/Bottom/Line=False bPageWrap=False bBottomAligned=False [@Lines] { [Lines] { [Line] { [Font] { Default=False FaceName="Arial" GdiCharSet=0 Size=10.0 Width=0 Bold=False Italic=False Underline=False Strikeout=False Color=LL.Color.Black PitchAndFamily=34 OutPrecision=3 } Align=0 Adjusted=False Uneraseable=False LineWrap=0 PageWrapAllowed=False SpaceOptimization=True Spacing.Paragraph=0 Spacing.Line=0 OutputFormatter= Condition=True Text="Empresa: " + OMEM_PUBLICAS.Empresa Tab=0 TabAlign=0 } } } [Object] ObjectID=5 ObjectName=Dibujo Locked=FALSE LinkID=22 LinkToID=0 LinkMode=32 LinkTest=-12032 LayerID=0 GroupID=0 Identifier= Condition=True UserLocked=False WrapBefore=False Position/Left=157400 Position/Top=17000 Position/Width=30000 Position/Height=20000 Direction=0 Frame/Layout=0 Frame/Left/Line=False Frame/Top/Line=False Frame/Right/Line=False Frame/Bottom/Line=False bIsotropic=True Mode=1 Filename= bRelPath=False Formula=Drawing (OMEM_PUBLICAS.fullnamelogo) Variablename= UserParameters= [Object] ObjectID=8 ObjectName=Elipse Locked=FALSE LinkID=30 LinkToID=0 LinkMode=32 LinkTest=-9502 LayerID=0 GroupID=0 Identifier= Condition=True UserLocked=False WrapBefore=False Position/Left=8000 Position/Top=30000 Position/Width=2000 Position/Height=4000 Direction=0 bFrame=1 FgColor=RGB(0,0,0) Width=0 LineType=0 bFill=1 Raster=1 BkColor=RGB(255,0,0) BkColor2=LL.Color.White BkColor3=LL.Color.White BkColor.Alpha=50 bForceCircle=True [Object] ObjectID=6 ObjectName=Tabla Locked=FALSE LinkID=4 LinkToID=0 LinkMode=32 LinkTest=-11609 LayerID=0 GroupID=0 Identifier= Condition=True UserLocked=False WrapBefore=False Position/Left=64000 Position/Top=42000 Position/Width=81000 Position/Height=247000 Direction=0 bFooterOnBottom=False bFillBottom=False DefaultFont=default FgColor=RGB(0,0,0) bFill=False Raster=1 BkColor=RGB(255,255,255) BkColor2=LL.Color.White BkColor3=LL.Color.White BkColor.Alpha=50 [@Tables] { [Tables] { [Table] { TableType=List TableID= RelationID= [GroupHeaderLines] { bConcatDataLines=True } [GroupFooterLines] { bAlsoOnEmptyGroup=False } [DataLines] { bKeepTogether=True bSuppress=False bForceSumCalculation=False } ZebraPattern=0 [ZebraPattern] { Pattern=6 Color=LL.Color.Black Color2=LL.Color.White Color3=LL.Color.White Color.Alpha=50 } [FooterLines] { bKeepTogether=True } PageBreakCondition=False [DefaultFrame] { Layout=1 [Left] { Line=True [Line] { Color=LL.Color.Black LineType=0 } LineWidth=0 } [Top] { Line=True [Line] { Color=LL.Color.Black LineType=0 } LineWidth=0 } [Right] { Line=True [Line] { Color=LL.Color.Black LineType=0 } LineWidth=0 } [Bottom] { Line=True [Line] { Color=LL.Color.Black LineType=0 } LineWidth=0 } } [Body] { [Options] { } [Lines] { [Line] { LineID=0 [Columns] { Columns=3 [Column] { Width=34000 Height=10000 bIsotropic=False PlainTextFormat=True Align=0 AlignDecPosition=-10000 VAlign=0 Adjusted=False LineWrap=0 bFill=False Raster=0 BkColor=LL.Color.Black BkColor2=LL.Color.White BkColor3=LL.Color.White BkColor.Alpha=50 FgColor=LL.Color.Black SpaceOptimization=False Link.URL= WithText=False [Frame] { Default=False Layout=1 [Left] { Spacing=1000 Line=False } [Top] { Spacing=500 Line=False } [Right] { Spacing=1000 Line=False } [Bottom] { Spacing=500 Line=False } } [Font] { Default=True } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text=OMEMQUERY.codmodulo } [Column] { Width=19000 Height=10000 bIsotropic=False PlainTextFormat=True Align=2 AlignDecPosition=-10000 VAlign=0 Adjusted=False LineWrap=0 bFill=False Raster=0 BkColor=LL.Color.Black BkColor2=LL.Color.White BkColor3=LL.Color.White BkColor.Alpha=50 FgColor=LL.Color.Black SpaceOptimization=False Link.URL= WithText=False [Frame] { Default=False Layout=1 [Left] { Spacing=1000 Line=False } [Top] { Spacing=500 Line=False } [Right] { Spacing=1000 Line=False } [Bottom] { Spacing=500 Line=False } } [Font] { Default=True } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text=Fstr$(OMEMQUERY.tpuestos,"###,###") } [Column] { Width=26000 Height=10000 bIsotropic=False PlainTextFormat=True Align=2 AlignDecPosition=-10000 VAlign=0 Adjusted=False LineWrap=0 bFill=False Raster=0 BkColor=LL.Color.Black BkColor2=LL.Color.White BkColor3=LL.Color.White BkColor.Alpha=50 FgColor=LL.Color.Black SpaceOptimization=False Link.URL= WithText=False [Frame] { Default=False Layout=1 [Left] { Spacing=1000 Line=False } [Top] { Spacing=500 Line=False } [Right] { Spacing=1000 Line=False } [Bottom] { Spacing=500 Line=False } } [Font] { Default=True } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text=Fstr$(OMEMQUERY.timportes,OMEM_PICTURES.clacumula)¤ } } [Options] { [Frame0] { SpaceOut=0 } [Frame1] { SpaceOut=0 } [Frame2] { SpaceOut=0 } [Frame3] { SpaceOut=0 } LFont={(0,0,0),8.000000,-13,0,0,0,400,0,0,0,0,3,2,1,34,Arial} LCondition= IgnoreEmpty=TRUE Description=Definición de línea 1 DisplayInDesigner=TRUE } } } } [Header] { [Options] { } [Lines] { [Line] { LineID=0 [Columns] { Columns=3 [Column] { Width=34000 Height=10000 bIsotropic=False PlainTextFormat=True Align=0 AlignDecPosition=-10000 VAlign=0 Adjusted=False LineWrap=0 bFill=False Raster=0 BkColor=LL.Color.Black BkColor2=LL.Color.White BkColor3=LL.Color.White BkColor.Alpha=50 FgColor=LL.Color.Black SpaceOptimization=False Link.URL= WithText=False [Frame] { Default=False Layout=1 [Left] { Spacing=1000 Line=False } [Top] { Spacing=500 Line=False } [Right] { Spacing=1000 Line=False } [Bottom] { Spacing=500 Line=True [Line] { Color=LL.Color.Black LineType=0 } LineWidth=0 } } [Font] { Default=True } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text="Código Módulo" } [Column] { Width=19000 Height=10000 bIsotropic=False PlainTextFormat=True Align=2 AlignDecPosition=-10000 VAlign=0 Adjusted=False LineWrap=0 bFill=False Raster=0 BkColor=LL.Color.Black BkColor2=LL.Color.White BkColor3=LL.Color.White BkColor.Alpha=50 FgColor=LL.Color.Black SpaceOptimization=False Link.URL= WithText=False [Frame] { Default=False Layout=1 [Left] { Spacing=1000 Line=False } [Top] { Spacing=500 Line=False } [Right] { Spacing=1000 Line=False } [Bottom] { Spacing=500 Line=True [Line] { Color=LL.Color.Black LineType=0 } LineWidth=0 } } [Font] { Default=True } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text="Total Puestos" } [Column] { Width=26000 Height=10000 bIsotropic=False PlainTextFormat=True Align=2 AlignDecPosition=-10000 VAlign=0 Adjusted=False LineWrap=0 bFill=False Raster=0 BkColor=LL.Color.Black BkColor2=LL.Color.White BkColor3=LL.Color.White BkColor.Alpha=50 FgColor=LL.Color.Black SpaceOptimization=False Link.URL= WithText=False [Frame] { Default=False Layout=1 [Left] { Spacing=1000 Line=False } [Top] { Spacing=500 Line=False } [Right] { Spacing=1000 Line=False } [Bottom] { Spacing=500 Line=True [Line] { Color=LL.Color.Black LineType=0 } LineWidth=0 } } [Font] { Default=True } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text="Total Ventas" } } [Options] { [Frame0] { SpaceOut=0 } [Frame1] { SpaceOut=0 } [Frame2] { SpaceOut=0 } [Frame3] { SpaceOut=0 } LFont={(0,0,0),8.000000,-13,0,0,0,700,0,0,0,0,3,2,1,34,Arial} LCondition= IgnoreEmpty=TRUE Description=Titulos lineas datos (1) DisplayInDesigner=TRUE } } } } [Footer] { [Options] { } [Lines] { [Line] { LineID=0 [Columns] { Columns=3 [Column] { Width=34000 Height=10000 bIsotropic=False PlainTextFormat=True Align=0 AlignDecPosition=-10000 VAlign=0 Adjusted=False LineWrap=0 bFill=False Raster=0 BkColor=LL.Color.Black BkColor2=LL.Color.White BkColor3=LL.Color.White BkColor.Alpha=50 FgColor=LL.Color.Black SpaceOptimization=False Link.URL= WithText=False [Frame] { Default=False Layout=1 [Left] { Spacing=1000 Line=False } [Top] { Spacing=500 Line=False } [Right] { Spacing=1000 Line=False } [Bottom] { Spacing=500 Line=False } } [Font] { Default=False FaceName="Arial" GdiCharSet=0 Size=8.0 Width=0 Bold=True Italic=False Underline=False Strikeout=False Color=LL.Color.Black PitchAndFamily=34 OutPrecision=3 } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text="" } [Column] { Width=19000 Height=10000 bIsotropic=False PlainTextFormat=True Align=2 AlignDecPosition=-10000 VAlign=0 Adjusted=False LineWrap=0 bFill=False Raster=0 BkColor=LL.Color.Black BkColor2=LL.Color.White BkColor3=LL.Color.White BkColor.Alpha=50 FgColor=LL.Color.Black SpaceOptimization=False Link.URL= WithText=False [Frame] { Default=False Layout=1 [Left] { Spacing=1000 Line=False } [Top] { Spacing=500 Line=False } [Right] { Spacing=1000 Line=False } [Bottom] { Spacing=500 Line=False } } [Font] { Default=False FaceName="Arial" GdiCharSet=0 Size=8.0 Width=0 Bold=True Italic=False Underline=False Strikeout=False Color=LL.Color.Black PitchAndFamily=34 OutPrecision=3 } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text=Fstr$(@Tpuestos,"###,###") } [Column] { Width=26000 Height=10000 bIsotropic=False PlainTextFormat=True Align=2 AlignDecPosition=-10000 VAlign=0 Adjusted=False LineWrap=0 bFill=False Raster=0 BkColor=LL.Color.Black BkColor2=LL.Color.White BkColor3=LL.Color.White BkColor.Alpha=50 FgColor=LL.Color.Black SpaceOptimization=False Link.URL= WithText=False [Frame] { Default=False Layout=1 [Left] { Spacing=1000 Line=False } [Top] { Spacing=500 Line=False } [Right] { Spacing=1000 Line=False } [Bottom] { Spacing=500 Line=False } } [Font] { Default=False FaceName="Arial" GdiCharSet=0 Size=8.0 Width=0 Bold=True Italic=False Underline=False Strikeout=False Color=LL.Color.Black PitchAndFamily=34 OutPrecision=3 } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text=Fstr$(@Timportes,OMEM_PICTURES.clacumula)+" €"¤ } } [Options] { [Frame0] { SpaceOut=0 } [Frame1] { SpaceOut=0 } [Frame2] { SpaceOut=0 } [Frame3] { SpaceOut=0 } LFont={(0,0,0),8.000000,-13,0,0,0,400,0,0,0,0,3,2,1,34,Arial} LCondition= IgnoreEmpty=TRUE Description=Definición de línea 1 (1) DisplayInDesigner=TRUE } } } } [GroupHeader] { } [GroupFooter] { } } } } [UserVariables] User1=@User01; User2=@User02; User3=@User03; User4=@User04; User5=@User05; User6=@User06; User7=@User07; User8=@User08; User9=@User09; User10=@User10; User11=@User11; User12=@User12; User13=@User13; User14=@User14; User15=@User15; User16=@User16; User17=@User17; User18=@User18; User19=@User19; User20=@User20; User21=@User21; User22=@User22; User23=@User23; User24=@User24; User25=@User25; User26=@User26; User27=@User27; User28=@User28; User29=@User29; User30=@User30; User31=@User31; User32=@User32; User33=@User33; User34=@User34; User35=@User35; User36=@User36; User37=@User37; User38=@User38; User39=@User39; User40=@User40; User41=@User41; User42=@User42; User43=@User43; User44=@User44; User45=@User45; User46=@User46; User47=@User47; User48=@User48; User49=@User49; User50=@User50; [Parameters] [@Parameters] { [Parameters] { LL.ProjectDescription=Informe de Inventario x Almacenes sin Valorar } } [UsedIdentifiers] Variables=OMEM_ADEF.1_desde el distribuidor_;OMEM_ADEF.2_hasta el_;OMEM_PUBLICAS.empresa;OMEM_PUBLICAS.fechaletras;OMEM_PUBLICAS.fullnamelogo Fields=OMEM_PICTURES.clacumula;OMEMQUERY.coddistri;OMEMQUERY.cpdistri;OMEMQUERY.rsocialdistri;OMEMQUERY.timplicencia;OMEMQUERY.timplicenciatotal;OMEMQUERY.timpmant;OMEMQUERY.timpmantteorico;OMEMQUERY.timpnomant;OMEMQUERY.tnpuestos;OMEMQUERY.tnumlicencias ChartFields=