[List description] [Description] Text=Cuenta de Explotació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=14/09/2020, 13:54:59 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=297000 ySize=210000 P1.xOffset=0 P1.yOffset=0 P1.xSize=297000 P1.ySize=210000 P2.xOffset=0 P2.yOffset=0 P2.xSize=297000 P2.ySize=210000 P1.nPaperFormat=9 P1.xPaperSize=297100 P1.yPaperSize=209900 P1.ForcePaperFormat=TRUE P2.nPaperFormat=9 P2.xPaperSize=297100 P2.yPaperSize=209900 P2.ForcePaperFormat=TRUE xGrid=1000 yGrid=1000 GridShow=TRUE GridSnap=TRUE PhysicalPage=TRUE P1.PhysicalPage=TRUE P2.PhysicalPage=TRUE Orientation=2 P1.Orientation=2 P2.Orientation=2 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,270000,5000) DefaultSize.Objecttype5=(0,0,37000,20000) DefaultSize.Objecttype6=(0,0,287000,167000) DefaultSize.Objecttype8=(0,0,2000,4000) ObjectCount=8 [UserSection] BASE lfaccli ORDEN 1 RELACIONA faccli POR CAMPO c_serie+str(c_numfaccl,6) RELACIONA articu POR CAMPO c_codart FINLST TITULO=Beneficio de Ventas x Zona * Says valores, filas y columnas TEXTOSAY=Desde Fecha:,Hasta Fecha:,Desde Serie:,Hasta Serie:,Desde Nº Factura:,Hasta Nº Factura:,Desde Vendedor:,Hasta Vendedor: FILASAY=2,2,3,3,4,4,5,5 COLUMSAY=4,20,4,20,4,20,4,20 TAMFIJO= * Gets valores por defecto, tipos, pictures, valids y columnas VALORDEF=cTod("01/01/"+Substr(str(year(date());4);3;2)),date(),space(2),"zz",000001,999999,space(3),"zzz" VALORTIPO=d,d,c,c,n,n,c,c VALORPICT=99/99/99,,,,,999999,, VALORVALID=nada,,,,,,, VALORNCOL=13,29,13,29,13,29,13,29 * Valor desde-hasta y clave para comparar *VDESDE=aDef[3]+space(6)+space(4) *VHASTA=aDef[4]+Replicate("z",6)+Replicate("z",4) *VCLAVE=c_serie+str(c_numfaccl,6)+str(c_linea,4) * Valor desde-hasta y clave para comparar VDESDE=0 VHASTA=0 VCLAVE=HASTAFIN * Filtro para el listado FILTRO=.t. FACEPTAR=pCtaexpl(aDef[1],aDef[2],aDef[3],aDef[4],aDef[5],aDef[6],aDef[7],aDef[8]) *BLOQUES=M->nPagosp,M->nSalidasv BLOQUES=M->nPagosp,M->nSalidasv,oPublic:cVLcantidad,oPublic:cVLprecio,oPublic:cVLtlinea,oPublic:cCLcantidad,oPublic:cCLprecio,oPublic:cCLtlinea,oPublic:cTLdocVto,oPublic:cLAcumula * RESUMEN=.t. PIESJUNTO=.t. *SALTOPIE=.t. ACUMULA= CONDACUM= QUERY=SELECT * FROM ( SELECT *,sum(tventa) over(ORDER BY zona,codart ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS acumventas, sum(tcosto) over(ORDER BY zona,codart ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS acumcosto, sum(impBeneficio) over(ORDER BY zona,codart ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS acumbeneficio, sum(100*impBeneficio/tventa) over(ORDER BY zona,codart ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS porcmedio FROM ( SELECT *, (tcosto/tcant) AS pmp, (tventa-tcosto) AS impBeneficio, (100*(tventa-tcosto)) / tventa AS porcBeneficio FROM ( SELECT p4.zona,codart, descart, sum(cantidad) AS tcant, sum(tlinea) as tventa, sum(cantidad*pmpcalc) AS tcosto FROM ( SELECT b.codigoc,a.seriefac, a.numfac, a.fechamov, a.codart, c.descart, a.cantidad, a.tlinea, a.pmpcalc FROM vlineasdocpmp AS a LEFT JOIN faccli AS b ON(a.tipodoc=b.tipodoc AND a.seriefac=b.seriefac AND a.numfac=b.numfac),articu AS c WHERE a.codart=c.codart AND a.tipodoc='SV' AND a.numfac<>0 AND a.fechamov BETWEEN '#1#' AND '#2#' AND a.seriefac BETWEEN '#3#' AND '#4#' AND a.numfac BETWEEN #5# AND #6# AND b.vende BETWEEN '#7#' AND '#8#' ORDER BY b.vende,a.codart, a.fechamov ASC ) AS p1 LEFT JOIN cliente AS p4 ON(p1.codigoc=p4.codigoc) GROUP BY p4.zona,codart, descart ) AS p2 WHERE tventa<>0 ) AS p3 ) AS x RUPTURA= ACCIONRUPTURA= NETIQUETA= [SumVariables] Sum1=@Sum01;F;OMEMQUERY.tventa Sum2=@Sum02;F;OMEMQUERY.tcant*OMEMQUERY.pmp Sum3=@Suma03;F;OMEMQUERY.tventa Sum4=@TotalBeneficio;F;OMEMQUERY.impbeneficio Sum5=@TotalCantidad;F;OMEMQUERY.tcant Sum6=@TotalCoste;F;OMEMQUERY.tcant*OMEMQUERY.pmp Sum7=@TotalVenta;F;OMEMQUERY.tventa [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=24 LinkToID=0 LinkMode=32 LinkTest=-12913 LayerID=0 GroupID=0 Identifier= Condition=True UserLocked=False WrapBefore=False Position/Left=11500 Position/Top=22800 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="Beneficios de Ventas x Zona" Tab=0 TabAlign=0 } } } [Object] ObjectID=6 ObjectName=Tabla Locked=FALSE LinkID=29 LinkToID=0 LinkMode=32 LinkTest=-24531 LayerID=0 GroupID=0 Identifier= Condition=True UserLocked=False WrapBefore=False Position/Left=6500 Position/Top=38000 Position/Width=287000 Position/Height=167000 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=True } [DataLines] { bKeepTogether=True bSuppress=False bForceSumCalculation=True } ZebraPattern=True [ZebraPattern] { Pattern=1 Color=RGB(236,236,236) 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=12 [Column] { Width=18000 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=7.0 Width=0 Bold=False 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=OMEMQUERY.codart } [Column] { Width=55000 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=7.0 Width=0 Bold=False 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=OMEMQUERY.descart } [Column] { Width=23000 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=7.0 Width=0 Bold=False 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=If(OMEMQUERY.tcant==0,"", FStr$(OMEMQUERY.tcant,OMEM_PICTURES.cVLcantidad)) } [Column] { Width=23000 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=7.0 Width=0 Bold=False 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=If(OMEMQUERY.tventa==0,"",FStr$(OMEMQUERY.tventa,OMEM_PICTURES.cTLdocVto)) } [Column] { Width=20000 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=7.0 Width=0 Bold=False 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=If(OMEMQUERY.tcant==0 .and. OMEMQUERY.tventa==0,""¤,FStr$(OMEMQUERY.tventa/OMEMQUERY.tcant,OMEM_PICTURES.cVLprecio)) } [Column] { Width=20000 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=7.0 Width=0 Bold=False 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=If(OMEMQUERY.pmp==0,"",FStr$(OMEMQUERY.pmp,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=False FaceName="Arial" GdiCharSet=0 Size=7.0 Width=0 Bold=False 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=If(OMEMQUERY.impbeneficio==0,"",FStr$(OMEMQUERY.impbeneficio,OMEM_PICTURES.cVLprecio)) } [Column] { Width=12000 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=7.0 Width=0 Bold=False 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$( OMEMQUERY.porcbeneficio,"---&.##") } [Column] { Width=27000 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=7.0 Width=0 Bold=False 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=If(OMEMQUERY.acumventas==0,"",FStr$(OMEMQUERY.acumventas,OMEM_PICTURES.cLAcumula)) } [Column] { Width=25000 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=7.0 Width=0 Bold=False 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=If(OMEMQUERY.acumcosto==0,"",FStr$(OMEMQUERY.acumcosto,OMEM_PICTURES.cLAcumula)) } [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=False FaceName="Arial" GdiCharSet=0 Size=7.0 Width=0 Bold=False 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=If(OMEMQUERY.acumbeneficio==0,"",FStr$(OMEMQUERY.acumbeneficio,OMEM_PICTURES.cLAcumula)) } [Column] { Width=12000 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=7.0 Width=0 Bold=False 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$((100*(OMEMQUERY.acumbeneficio)) / OMEMQUERY.acumventas,"---&.##") } } [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 } } } } [Header] { [Options] { } [Lines] { [Line] { LineID=0 [Columns] { Columns=12 [Column] { Width=18000 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=300 } } [Font] { Default=True } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text="Referencia" } [Column] { Width=55000 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=300 } } [Font] { Default=True } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text="Descripción" } [Column] { Width=23000 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=300 } } [Font] { Default=True } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text="Cantidad" } [Column] { Width=23000 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=300 } } [Font] { Default=True } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text="T. Venta" } [Column] { Width=20000 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=300 } } [Font] { Default=True } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text="PV.Unidad" } [Column] { Width=20000 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=300 } } [Font] { Default=True } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text="P.Costo" } [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=300 } } [Font] { Default=True } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text="Imp. Beneficio" } [Column] { Width=12000 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=300 } } [Font] { Default=True } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text="%Ben." } [Column] { Width=27000 Height=10000 bIsotropic=False PlainTextFormat=True Align=2 AlignDecPosition=-10000 VAlign=0 Adjusted=False LineWrap=0 bFill=True Raster=1 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=300 } } [Font] { Default=False FaceName="Arial" GdiCharSet=0 Size=8.0 Width=0 Bold=False Italic=False Underline=False Strikeout=False Color=LL.Color.White PitchAndFamily=34 OutPrecision=3 } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text="Ventas acum." } [Column] { Width=25000 Height=10000 bIsotropic=False PlainTextFormat=True Align=2 AlignDecPosition=-10000 VAlign=0 Adjusted=False LineWrap=0 bFill=True Raster=1 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=300 } } [Font] { Default=False FaceName="Arial" GdiCharSet=0 Size=8.0 Width=0 Bold=False Italic=False Underline=False Strikeout=False Color=LL.Color.White PitchAndFamily=34 OutPrecision=3 } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text="Costo acum." } [Column] { Width=24000 Height=10000 bIsotropic=False PlainTextFormat=True Align=2 AlignDecPosition=-10000 VAlign=0 Adjusted=False LineWrap=0 bFill=True Raster=1 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=300 } } [Font] { Default=False FaceName="Arial" GdiCharSet=0 Size=8.0 Width=0 Bold=False Italic=False Underline=False Strikeout=False Color=LL.Color.White PitchAndFamily=34 OutPrecision=3 } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text="Beneficio Acum." } [Column] { Width=12000 Height=10000 bIsotropic=False PlainTextFormat=True Align=2 AlignDecPosition=-10000 VAlign=0 Adjusted=False LineWrap=0 bFill=True Raster=1 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=300 } } [Font] { Default=False FaceName="Arial" GdiCharSet=0 Size=8.0 Width=0 Bold=False Italic=False Underline=False Strikeout=False Color=LL.Color.White PitchAndFamily=34 OutPrecision=3 } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text="%Medio" } } [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 1 DisplayInDesigner=TRUE } } } } [Footer] { } [GroupHeader] { [Options] { } [Lines] { [Line] { LineID=0 [Columns] { Columns=2 [Column] { Width=25000 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=12 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="Zona: " } [Column] { Width=200000 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=12 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=if(empty(OMEMQUERY.zona),"(Sin Zona)",OMEMQUERY.zona) } } [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) OnNewPage=False PrintRightAfterHeader=True GroupCondition=OMEMQUERY.zona DisplayInDesigner=TRUE } } } } [GroupFooter] { [Options] { } [Lines] { [Line] { LineID=0 [Columns] { Columns=9 [Column] { Width=18000 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=9 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=55000 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=9 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=23000 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=9 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$(@TotalCantidad,OMEM_PICTURES.clacumula) } [Column] { Width=23000 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=9 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$(@TotalVenta,OMEM_PICTURES.cTLdocVto) } [Column] { Width=20000 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=9 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=20000 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=9 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=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=False FaceName="Arial" GdiCharSet=0 Size=9 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$(@TotalBeneficio,OMEM_PICTURES.clacumula) } [Column] { Width=14000 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=9 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$(@TotalBeneficio*100/@TotalVenta,"###&.##")+ "%" } [Column] { Width=12000 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=9 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="" } } [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) ResetSums=@TotalBeneficio;@TotalCantidad;@TotalVenta; TriggerNewPage=False GroupCondition=OMEMQUERY.zona DisplayInDesigner=TRUE } } [Line] { LineID=1 [Columns] { Columns=8 [Column] { Width=18000 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=9 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=55000 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=9 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=23000 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=9 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=23000 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=9 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=20000 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=9 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=20000 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=9 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=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=False FaceName="Arial" GdiCharSet=0 Size=9 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=12000 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=9 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="" } } [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 (2) ResetSums=@TotalBeneficio;@TotalCantidad;@TotalVenta; TriggerNewPage=False GroupCondition=OMEMQUERY.zona DisplayInDesigner=TRUE } } } } } } } [Object] ObjectID=1 ObjectName=Texto Locked=FALSE LinkID=16 LinkToID=0 LinkMode=32 LinkTest=-10945 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=-14515 LayerID=0 GroupID=0 Identifier= Condition=True UserLocked=False WrapBefore=False Position/Left=125000 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=-32416 LayerID=0 GroupID=0 Identifier= Condition=OMEM_PUBLICAS.Conlogo="S" UserLocked=False WrapBefore=False Position/Left=254000 Position/Top=16000 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=-5095 LayerID=0 GroupID=0 Identifier= Condition=True UserLocked=False WrapBefore=False Position/Left=8000 Position/Top=25600 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=1 LinkToID=0 LinkMode=32 LinkTest=-15585 LayerID=0 GroupID=0 Identifier= Condition=True UserLocked=False WrapBefore=False Position/Left=12000 Position/Top=32800 Position/Width=270000 Position/Height=5000 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=6.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="Fecha:" +date$(OMEM_ADEF.1_desde_fecha_,'%x') + ¤ " - " +date$(OMEM_ADEF.2_hasta_fecha_,'%x') + ", Serie: "+OMEM_ADEF.3_desde_serie_ + " / " +OMEM_ADEF.4_hasta_serie_ + ¤ ", Nº Factura: " + fstr$(OMEM_ADEF.5_desde_nº_factura_,"&&&&&&") + " / " +¤fstr$(OMEM_ADEF.6_hasta_nº_factura_,"&&&&&&")+¤", Vendedor: " +OMEM_ADEF.7_desde_vendedor_ + " / "+OMEM_ADEF.8_hasta_vendedor_¤¤ Tab=0 TabAlign=0 } } } [Object] ObjectID=1 ObjectName=Texto Locked=FALSE LinkID=4 LinkToID=0 LinkMode=32 LinkTest=-22465 LayerID=0 GroupID=0 Identifier= Condition=True UserLocked=False WrapBefore=False Position/Left=254000 Position/Top=9000 Position/Width=28000 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=True Uneraseable=False LineWrap=0 PageWrapAllowed=False SpaceOptimization=True Spacing.Paragraph=0 Spacing.Line=0 OutputFormatter= Condition=True Text=Atrim$("Página "+Page$()+" de "+TotalPages$()) Tab=0 TabAlign=0 } } } [UserVariables] User1=@User01;OMEMQUERY.tventa-(OMEMQUERY.tcant*OMEMQUERY.pmp) User2=@User02;OMEMQUERY.tventa/OMEMQUERY.tcant User3=@User03;100*(@User02-OMEMQUERY.pmp)/@User02 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=Cuenta de Explotación } } [UsedIdentifiers] Variables=OMEM_ADEF.1_desde fecha_;OMEM_ADEF.2_hasta fecha_;OMEM_ADEF.3_desde serie_;OMEM_ADEF.4_hasta serie_;OMEM_ADEF.5_desde nº factura_;OMEM_ADEF.6_hasta nº factura_;OMEM_ADEF.7_desde vendedor_;OMEM_ADEF.8_hasta vendedor_;OMEM_PUBLICAS.conlogo;OMEM_PUBLICAS.empresa;OMEM_PUBLICAS.fechaletras;OMEM_PUBLICAS.fullnamelogo Fields=OMEM_PICTURES.clacumula;OMEM_PICTURES.ctldocvto;OMEM_PICTURES.cvlcantidad;OMEM_PICTURES.cvlprecio;OMEMQUERY.acumbeneficio;OMEMQUERY.acumcosto;OMEMQUERY.acumventas;OMEMQUERY.codart;OMEMQUERY.descart;OMEMQUERY.impbeneficio;OMEMQUERY.nomvende;OMEMQUERY.pmp;OMEMQUERY.porcbeneficio;OMEMQUERY.tcant;OMEMQUERY.tventa;OMEMQUERY.vende ChartFields=