"VER1.0","Informes Nuevos","Ranking de artículos más vendidos"
;Versio, Categoria, Descripcion

;Ampla, Llarg, [EspaiCos]
;MargenX,MargenY, EtiLin, EtiPag
[DOCUM]
V, 9, 0
10,10,0,0

; Tipo, NomGrup, InicNumPag,   Select, From, GropBy
[GRUP]
1,"CABECERA", #FALSE#
"SELECT * , CodigoPostal & ' - ' & Poblacion as Direc, 'Tel : ' & Telefono1 as Tel "
"FROM Configuracion"
""
[CAPSALERA]
0, 10, #FALSE#, 0, #FALSE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 1
3,"CABECERA","NombreComercial",0,0,"ARIAL",14,0,0,"1000",""
[FICAP]

[FIGRUP]

;-----------------------------------------

; Tipo, NomGrup, InicNumPag,   Select, From, GropBy
[GRUP]
0, "RESUMEN", #FALSE#
""
""
""

[CAPSALERA]
0, 62, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 6
0,"Top artículos más vendidos",0,0,"ARIAL",16,0,0,"1000"
6,"Fecha",165,1,"ARIAL",8,0,1,"1000",""
1,"barraTitulo",0,9,190,11,8,5,#TRUE#
0,"Filtro de fecha opcional (vacío = todo el histórico). Elige orden (importe/unidades) abajo.",0,15,"ARIAL",8,0,0,"0000"
1,"marcoGrafico",0,21,190,60,8,7,#FALSE#
9,"COS","ImporteTotal","Descripcion",5,26,185,55,5,8
[FICAP]

[FIGRUP]

;-----------------------------------------

; Tipo, NomGrup, InicNumPag,   Select, From, GropBy
[GRUP]
0, "GENERAL", #FALSE#
""
""
""

[CAPSALERA]
0, 12, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 6
0,"Página :",150,0,"ARIAL",8,0,0,"1000"
6,"Pagina",170,0,"ARIAL",8,0,1,"1000",""
0,"Código",0,6,"ARIAL",8,0,0,"1000"
0,"Descripción",22,6,"ARIAL",8,0,0,"1000"
0,"Unidades",155,6,"ARIAL",8,0,1,"1000"
0,"Importe",190,6,"ARIAL",8,0,1,"1000"
[FICAP]

[PEU]
0, 10, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 4
1,"lineaTotal",0,0,190,0,0,7,
0,"Totales (todo el listado) :",0,3,"ARIAL",9,0,0,"1000"
5,0,"UnidadesGeneral",155,3,"ARIAL",10,0,1,"1000","Total"
5,0,"ImporteGeneral",190,3,"ARIAL",10,0,1,"1000","Total"
[FIPEU]

[FIGRUP]

;-----------------------------------------

;tipo, NomGrup, Select, From, GropBy
[GRUP]
3,"COS", #FALSE#
"SELECT VenAlbaLin.CodArticulo, Articulos.Descripcion, Sum(VenAlbaLin.Cantidad) AS CantidadTotal, Sum(VenAlbaLin.Total) AS ImporteTotal "
" FROM (VenAlba INNER JOIN VenAlbaLin ON (VenAlba.NumAlbaran = VenAlbaLin.NumAlbaran) AND (VenAlba.Seccion = VenAlbaLin.Seccion) AND (VenAlba.CodCliente = VenAlbaLin.CodCliente)) LEFT JOIN Articulos ON VenAlbaLin.CodArticulo = Articulos.CodArticulo WHERE VenAlba.Facturado = True "
" GROUP BY VenAlbaLin.CodArticulo, Articulos.Descripcion"

[CONDICIONS] 1
"FechaAlbaran", "Fecha albarán (dejar en blanco = todo el histórico)", 0, 2

[ORDENACIONS] 2
"Sum(VenAlbaLin.Total) DESC", "Por importe (mayor primero)", 0
"Sum(VenAlbaLin.Cantidad) DESC", "Por unidades (mayor primero)", 0

[CAPSALERA]
0, 5, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 4
3,"COS","CodArticulo",0,0,"ARIAL",8,0,0,"0000",""
3,"COS","Descripcion",22,0,"ARIAL",8,120,0,"0000",""
3,"COS","CantidadTotal",155,0,"ARIAL",8,0,1,"0000","#,##0"
3,"COS","ImporteTotal",190,0,"ARIAL",8,0,1,"0000","Total"
[FICAP]
[FIGRUP]

[CALCULS] 2
"UnidadesGeneral","COS","CantidadTotal","GENERAL"
"ImporteGeneral","COS","ImporteTotal","GENERAL"

[FIDOCUM]
