"VER1.0","Articulos","Listado de Articulos Cliente"
;Versio, Categoria, Descripcion

;Ampla, Llarg, [EspaiCos]
;MargenX,MargenY, EtiLin, EtiPag
[DOCUM]
0, 0, 0
0,0,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, 0, #FALSE#, 0, #FALSE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 2
3,"CABECERA","NombreComercial",10,0,"ARIAL",22,0,0,"1000",""
3,"CABECERA","Nif",10,8,"ARIAL",8,0,0,"1000",""
[FICAP]

[FIGRUP]

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

; Tipo, NomGrup, InicNumPag,   Select, From, GropBy
[GRUP]
0, "GENERAL", #FALSE#
""
""
""
;[ordenaciones] y [condiciones]
[CAPSALERA]
10, 25, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 12
0,"Pgina :",165,0,"ARIAL",8,0,0,"1000"
6,"Pagina",195,0,"ARIAL",8,0,1,"1000",""
0,"Fecha :",165,5,"ARIAL",8,0,0,"1000"
6,"Fecha",195,5,"ARIAL",8,0,1,"1000",""
0, "Ventas de Artculos por Cliente", 100, 6, "ARIAL",20, 0, 2, "1000"
1,"lineaH1",5,17,195,17,,,
0,"Codigo",7,18,"ARIAL",8,0,0,"1000"
0,"Descripcion",32,18,"ARIAL",8,0,0,"1000"
0,"Unidades.",140,18,"ARIAL",8,0,1,"1000"
0,"Importe",165,18,"ARIAL",8,0,1,"1000"
0,"N Factura",190,18,"ARIAL",8,0,1,"1000"
1,"lineaH2",5,22,195,22,,,
;0,"Precio Venta Medio",200,18,"ARIAL",8,0,1,"1000"
[FICAP]

[PEU]
0, 5, #TRUE#, 0, #FALSE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 2
0,"Total",140,2,"ARIAL",12,0,1,"1000"
5,0,"T2",190,2,"ARIAL",10,0,1,"1000","Total"
[FIPEU]

[FIGRUP]


;tipo, NomGrup, Select, From, GropBy
[GRUP]
2,"CAB1", #FALSE#
"SELECT CodCliente & ' - ' & Nombre as Titulo, * "
"FROM Clientes"
""
[CONDICIONS] 2
"CodCliente","Cdigo Cliente",0,1, -10
"Nombre","Nombre Cliente",0,1

[ORDENACIONS] 2
"CodCliente","Codigo Cliente",3
"Nombre","Nombre Cliente",3


[CAPSALERA]
0, 6, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 1
3,"CAB1","Titulo",10,1,"ARIAL",10,0,0,"1001",""
[FICAP]

[PEU]
0, 7, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 2
0,"Total  : ",120, 1,"ARIAL",11,0,0,"1000"
5,0,"Total1",165, 1,"ARIAL",11,0,1,"1000" ,"Total"
[FIPEU]
[FIGRUP]


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

;tipo, NomGrup, Select, From, GropBy
[GRUP]
3,"COS", #FALSE#
"SELECT VenAlbaLin.CodArticulo, First(VenAlbaLin.Descripcion) AS des, Sum(VenAlbaLin.Cantidad) AS SumaDeCantidad, Sum(VenAlbaLin.Total) AS SumaDePrecio, VenAlba.CodRepresentante, First(VenAlba.NumFactura) AS PrimeroDeNumFactura"
"FROM VenAlba INNER JOIN VenAlbaLin ON (VenAlba.CodCliente = VenAlbaLin.CodCliente) AND (VenAlba.NumAlbaran = VenAlbaLin.NumAlbaran) AND (VenAlba.Seccion = VenAlbaLin.Seccion)"
"GROUP BY VenAlbaLin.CodArticulo, VenAlba.CodRepresentante"

[CONDICIONS] 5
"CodArticulo","Cod. Articulo",0,1
"FechaAlbaran","Fecha Albarn",0,2
"VenAlba.Seccion","Seccin",0,1
"VenAlbaLin.CodCliente","CodCliente",1,1,"CAB1","CodCliente"
"CodRepresentante","Cod. Representante",0,1

[ORDENACIONS] 2
"CodArticulo","Codigo artculo",3
; 3/11: con GROUP BY, la descripcion solo puede ir agregada (Access: no incluye la expresion... funcion de agregado).
"FIRST(VenAlbaLin.Descripcion)","Descripcion",3

[CAPSALERA]
0, 5, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 5
3,"COS","CodArticulo",7,0,"ARIAL",8,0,0,"0000",""
3,"COS","Des",32,0,"ARIAL",8,120,0,"0000",""
3,"COS","SumaDeCantidad",140,0,"ARIAL",8,0,1,"0000","Total"
3,"COS","SumaDePrecio",165,0,"ARIAL",8,0,1,"0000","Total"
3,"COS","PrimeroDeNumFactura",190,0,"ARIAL",8,0,1,"0000",""
;3,"COS","precioventamedio",195,0,"ARIAL",8,0,1,"0000","Total"
[FICAP]
[FIGRUP]

[CALCULS] 2
"Total1","COS","SumadePrecio","CAB1"
"T2","COS","SumadePrecio","GENERAL"

[FIDOCUM]






