[List description] [Description] Text=Tarifas de Precios por Familias (Descripción) 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=24/07/2013, 13:40:53 LastModifiedByApp=DOMINUSTPV.EXE [1.0.0.0] LastModifiedByDLL=CMLL12.DLL [12,15,0,0 (07-08-07 09:10)] LastModifiedByUser=admin on ADMIN-PC CreatedByCallFrom=DominusTPV.exe [Layout] P1.Template= P2.Template= xOffset=0 yOffset=0 xSize=210100 ySize=296900 P1.xOffset=0 P1.yOffset=0 P1.xSize=210100 P1.ySize=296900 P2.xOffset=0 P2.yOffset=0 P2.xSize=210100 P2.ySize=296900 P1.nPaperFormat=9 P1.xPaperSize=209900 P1.yPaperSize=297000 P1.ForcePaperFormat=TRUE P2.nPaperFormat=9 P2.xPaperSize=209900 P2.yPaperSize=297000 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.Objecttype6=(0,0,197000,225000) ObjectCount=8 [UserSection] BASE articu FINLST TITULO=Informe Tarifas de Precios por Familias Descripción * Says valores, filas y columnas TEXTOSAY=Desde Nombre Artículo:,Hasta:,Desde Familia:,Hasta:,¿Imprimir Tarifa1?(S/N):,¿Imprimir Tarifa2?(S/N):,¿Imprimir Tarifa3?(S/N):,¿Imprimir PMP?(S/N):,¿Inventariable?(S/N/T):,¿Fabricado?(S/N/T): FILASAY=1,2,3,3,4.5,5.5,6.5,7.5,9,9 COLUMSAY=2,2,2,18,2,2,2,2,2,15 TAMFIJO= * Gets valores por defecto, tipos, pictures, valids y columnas VALORDEF=space(50),"zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz",space(10),"zzzzzzzzzz","S","S","S","S","T","T" VALORTIPO=c,c,c,c,c,c,c,c,c,c VALORPICT=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX,,,,@!,@!,@!,@!,@!,@! VALORVALID=nada,,,,siono,siono,siono,siono,tinvfab,tinvfab VALORNCOL=14.5,14.5,14.5,30.5,14.5,14.5,14.5,14.5,14.5,27.5 * Valor desde-hasta y clave para comparar VDESDE=0 VHASTA=0 VCLAVE=HASTAFIN * Filtro para el listado FILTRO=.t. * FACEPTAR=pidedart(aDef[1],aDef[2],aDef[3],aDef[4],.f.) ACUMULA= CONDACUM= BLOQUES=oPublic:cVLcantidad,oPublic:cVLprecio,oPublic:cVLtlinea,oPublic:cCLcantidad,oPublic:cCLprecio,oPublic:cCLtlinea,oPublic:cTLdocVto,oPublic:cLAcumula QUERY=select a.codart,a.descart,a.pvp1,a.pvp2,a.pvp3,a.pmp,a.ivainc,a.iva,a.controls,a.fabri, b.familia,b.familia1,b.familia2,b.familia3,b.familia4 FROM articu a, familias b WHERE a.familia=b.familia AND (a.descart>='#1#' AND a.descart<='#2#') AND (a.familia>='#3#' AND a.familia<='#4#') AND '1' IN ( SELECT CASE WHEN ( '#9#'='S' OR '#9#'='T') AND c.controls='S' THEN '1' ELSE ( case when c.controls<>'S' then '1' else '0' end) END FROM articu c WHERE a.id=c.id) AND '1' IN ( SELECT CASE WHEN ( '#10#'='S' OR '#10#'='T') AND c.fabri='S' THEN '1' ELSE ( case when c.fabri<>'S' then '1' else '0' end) END FROM articu c WHERE a.id=c.id) ORDER BY a.familia, a.descart RUPTURA= ACCIONRUPTURA= [SumVariables] [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=-17336 LayerID=0 GroupID=0 Identifier= Condition=True UserLocked=False WrapBefore=False Position/Left=169600 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=-10680 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="Tarifas de Precios por Familias " Tab=0 TabAlign=0 } } } [Object] ObjectID=1 ObjectName=Texto Locked=FALSE LinkID=16 LinkToID=0 LinkMode=32 LinkTest=-26871 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=-7409 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=8 ObjectName=Elipse Locked=FALSE LinkID=30 LinkToID=0 LinkMode=32 LinkTest=-5477 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=1 ObjectName=Texto Locked=FALSE LinkID=8 LinkToID=0 LinkMode=32 LinkTest=-13689 LayerID=0 GroupID=0 Identifier= Condition=True UserLocked=False WrapBefore=False Position/Left=12000 Position/Top=39000 Position/Width=190000 Position/Height=15000 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=8.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=1 PageWrapAllowed=False SpaceOptimization=True Spacing.Paragraph=0 Spacing.Line=0 OutputFormatter= Condition=True Text="Desde el Artículo: " +OMEM_ADEF.1_Desde_Nombre_Artículo_ + " / " +"Hasta:"+OMEM_ADEF.2_Hasta_+¤", ¿Inventariable?: "+OMEM_ADEF.9__Inventariable__S_N_T__+",¿Fabricado?: "+OMEM_ADEF.10__Fabricado__S_N_T__ Tab=0 TabAlign=0 } [Line] { [Font] { Default=True } Align=0 Adjusted=False Uneraseable=True LineWrap=1 PageWrapAllowed=False SpaceOptimization=False Spacing.Paragraph=0 Spacing.Line=0 OutputFormatter= Condition=True Text="Desde Familia: "+OMEM_ADEF.3_Desde_Familia_+" / "+OMEM_ADEF.4_Hasta_+" ,Ordenado por Familia-Descripcion del Artículo" Tab=0 TabAlign=0 } } } [Object] ObjectID=6 ObjectName=Tabla Locked=FALSE LinkID=4 LinkToID=0 LinkMode=32 LinkTest=-5039 LayerID=0 GroupID=0 Identifier= Condition=True UserLocked=False WrapBefore=False Position/Left=6000 Position/Top=55000 Position/Width=197000 Position/Height=225000 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=7 [Column] { Width=27000 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.codart } [Column] { Width=68000 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.descart } [Column] { Width=24000 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=If (OMEM_ADEF.5__Imprimir_Tarifa1__S_N__ ="S".and.OMEMQUERY.pvp1<>0,Atrim$(FStr$(OMEMQUERY.pvp1,OMEM_PICTURES.cVLprecio)),"") } [Column] { Width=24000 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=If (OMEM_ADEF.6__Imprimir_Tarifa2__S_N__ ="S".and.OMEMQUERY.pvp2<>0,Atrim$(FStr$(OMEMQUERY.pvp2,OMEM_PICTURES.cVLprecio)),"") } [Column] { Width=24000 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=If (OMEM_ADEF.7__Imprimir_Tarifa3__S_N__="S".and.OMEMQUERY.pvp3<>0,Atrim$(FStr$(OMEMQUERY.pvp3,OMEM_PICTURES.cVLprecio)),"") } [Column] { Width=24000 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=If (OMEM_ADEF.8__Imprimir_PMP__S_N__="S".and.OMEMQUERY.pmp<>0,Atrim$(FStr$(OMEMQUERY.pmp,OMEM_PICTURES.cVLprecio)),"") } [Column] { Width=8000 Height=10000 bIsotropic=False PlainTextFormat=True Align=1 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.ivainc } } [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=(OMEM_ADEF.9__Inventariable__S_N_T__="T".and.OMEM_ADEF.10__Fabricado__S_N_T__="T").or.¤(OMEMQUERY.controls=OMEM_ADEF.9__Inventariable__S_N_T__.and.OMEMQUERY.fabri=OMEM_ADEF.10__Fabricado__S_N_T__).or.¤(OMEM_ADEF.9__Inventariable__S_N_T__="T".and.OMEM_ADEF.10__Fabricado__S_N_T__=OMEMQUERY.fabri).or.¤(OMEM_ADEF.9__Inventariable__S_N_T__=OMEMQUERY.controls.and.OMEM_ADEF.10__Fabricado__S_N_T__="T")¤ IgnoreEmpty=TRUE Description= DisplayInDesigner=TRUE } } } } [Header] { [Options] { } [Lines] { [Line] { LineID=0 [Columns] { Columns=3 [Column] { Width=15000 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="Familia:" } [Column] { Width=30000 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.familia } [Column] { Width=141000 Height=10000 bIsotropic=True PlainTextFormat=True Align=0 AlignDecPosition=-10000 VAlign=0 Adjusted=False LineWrap=1 bFill=0 Raster=1 BkColor=RGB(224,224,224) BkColor2=LL.Color.White BkColor3=LL.Color.White BkColor.Alpha=50 FgColor=LL.Color.Black SpaceOptimization=True Link.URL= WithText=False [Frame] { Default=False Layout=1 [Left] { Line=False } [Top] { Line=False } [Right] { Line=False } [Bottom] { Line=False } } [Font] { Default=True } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text=OMEMQUERY.familia1+" - "+OMEMQUERY.familia2+" - "+OMEMQUERY.familia3+" - "+OMEMQUERY.familia4 } } [Options] { [Frame0] { SpaceOut=1000 } [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=len(OMEMQUERY.familia)=0.OR.(OMEMQUERY.familia=Previous (OMEMQUERY.familia).AND.Page()<>1) IgnoreEmpty=TRUE Description=Definición de línea 1 DisplayInDesigner=TRUE } } [Line] { LineID=1 [Columns] { Columns=7 [Column] { Width=27000 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="Referencia:" } [Column] { Width=68000 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="Descripción del Artículo" } [Column] { Width=24000 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=If( OMEM_ADEF.5__Imprimir_Tarifa1__S_N__ ="S","Tarifa1","") } [Column] { Width=24000 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=If(OMEM_ADEF.6__Imprimir_Tarifa2__S_N__="S","Tarifa2","") } [Column] { Width=24000 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=If(OMEM_ADEF.7__Imprimir_Tarifa3__S_N__="S","Tarifa3","") } [Column] { Width=24000 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=If(OMEM_ADEF.8__Imprimir_PMP__S_N__="S","P.M.P.","") } [Column] { Width=8000 Height=10000 bIsotropic=False PlainTextFormat=True Align=1 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="I I" } } [Options] { [Frame0] { SpaceOut=1000 } [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=len(OMEMQUERY.familia)=0.OR.(OMEMQUERY.familia=Previous (OMEMQUERY.familia).AND.Page()<>1) IgnoreEmpty=TRUE Description=Definición de línea 2 DisplayInDesigner=TRUE } } } } [Footer] { } [GroupHeader] { [Options] { } [Lines] { [Line] { LineID=0 [Columns] { Columns=3 [Column] { Width=15000 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="Familia:" } [Column] { Width=30000 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.familia } [Column] { Width=147000 Height=10000 bIsotropic=True PlainTextFormat=True Align=0 AlignDecPosition=-10000 VAlign=0 Adjusted=False LineWrap=1 bFill=0 Raster=1 BkColor=RGB(224,224,224) BkColor2=LL.Color.White BkColor3=LL.Color.White BkColor.Alpha=50 FgColor=LL.Color.Black SpaceOptimization=True Link.URL= WithText=False [Frame] { Default=False Layout=1 [Left] { Line=False } [Top] { Line=False } [Right] { Line=False } [Bottom] { Line=False } } [Font] { Default=True } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text=OMEMQUERY.familia1+" - "+OMEMQUERY.familia2+" - "+OMEMQUERY.familia3+" - "+OMEMQUERY.familia4 } } [Options] { [Frame0] { SpaceOut=1000 } [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=Definición de línea 1 OnNewPage=True PrintRightAfterHeader=False GroupCondition=OMEMQUERY.familia DisplayInDesigner=TRUE } } [Line] { LineID=1 [Columns] { Columns=7 [Column] { Width=27000 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="Referencia" } [Column] { Width=68000 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="Descripción del Artículo" } [Column] { Width=24000 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=If( OMEM_ADEF.5__Imprimir_Tarifa1__S_N__ ="S","Tarifa1","") } [Column] { Width=24000 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=If( OMEM_ADEF.6__Imprimir_Tarifa2__S_N__ ="S","Tarifa2","") } [Column] { Width=24000 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=If(OMEM_ADEF.7__Imprimir_Tarifa3__S_N__ ="S","Tarifa3","") } [Column] { Width=24000 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=If(OMEM_ADEF.8__Imprimir_PMP__S_N__="S","P.M.P.","") } [Column] { Width=8000 Height=10000 bIsotropic=False PlainTextFormat=True Align=1 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="I I" } } [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=Definición de línea 2 OnNewPage=False PrintRightAfterHeader=False GroupCondition=OMEMQUERY.familia DisplayInDesigner=TRUE } } } } [GroupFooter] { } } } } [Object] ObjectID=5 ObjectName=Dibujo Locked=FALSE LinkID=5 LinkToID=0 LinkMode=32 LinkTest=-28868 LayerID=0 GroupID=0 Identifier= Condition=True UserLocked=False WrapBefore=False Position/Left=170000 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= [UserVariables] User1=@User01;If(OMEMQUERY.ivainc="S",OMEMQUERY.pvp1/(1+(OMEMQUERY.iva/100)),OMEMQUERY.pvp1) 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=Tarifas de Precios por Familias (Descripción) } } [UsedIdentifiers] Variables=OMEM_ADEF.1_desde nombre artículo_;OMEM_ADEF.10_¿fabricado?(s/n/t)_;OMEM_ADEF.2_hasta_;OMEM_ADEF.3_desde familia_;OMEM_ADEF.4_hasta_;OMEM_ADEF.9_¿inventariable?(s/n/t)_;OMEM_PUBLICAS.conlogo;OMEM_PUBLICAS.empresa;OMEM_PUBLICAS.fechaletras;OMEM_PUBLICAS.fullnamelogo;OMEM_PUBLICAS.nomlogo Fields=OMEM_ADEF.10_¿fabricado?(s/n/t)_;OMEM_ADEF.5_¿imprimir tarifa1?(s/n)_;OMEM_ADEF.6_¿imprimir tarifa2?(s/n)_;OMEM_ADEF.7_¿imprimir tarifa3?(s/n)_;OMEM_ADEF.8_¿imprimir pmp?(s/n)_;OMEM_ADEF.9_¿inventariable?(s/n/t)_;OMEM_PICTURES.cvlprecio;OMEMQUERY.codart;OMEMQUERY.controls;OMEMQUERY.descart;OMEMQUERY.fabri;OMEMQUERY.familia;OMEMQUERY.familia1;OMEMQUERY.familia2;OMEMQUERY.familia3;OMEMQUERY.familia4;OMEMQUERY.iva;OMEMQUERY.ivainc;OMEMQUERY.pmp;OMEMQUERY.pvp1;OMEMQUERY.pvp2;OMEMQUERY.pvp3