"VER1.0","Representantes","Listado de Representantes"
;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] 4
3,"CABECERA","NombreComercial", 10,2,"ARIAL",20,0,0,"1000",""
3,"CABECERA","Nif", 10,9,"ARIAL",10,0,0,"1000",""
0,"Condiciones : ",20,23,"ARIAL",8,0,0,"1000"
6,"Condiciones",45,23,"ARIAL",8,0,0,"1000",""
[FICAP]

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

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


; Tipo, NomGrup, InicNumPag,   Select, From, GropBy
[GRUP]
0, "GENERAL", #FALSE#
""
""
""
;[ordenaciones] y [condiciones]
[CAPSALERA]
5, 30, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 13
0,"Listado Comisiones por Familia",45,10,"ARIAL",18,0,0,"1001"
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",""
1,"linea2",5,24,195,24,,,
1,"linea1",5,29,195,29,,,
0,"Fam.",7,25,"ARIAL",8,0,0,"1000"
0,"Sec.",16,25,"ARIAL",8,0,0,"1000"
0,"Albaran",25,25,"ARIAL",8,0,0,"1000"
0,"Familia",44,25,"ARIAL",8,0,0,"1000"
0,"Descripcion",85,25,"ARIAL",8,0,0,"1000"
0,"Total",190,25,"ARIAL",8,0,1,"1000"
[FICAP]

[PEU]
0, 8, #TRUE#, 0, #FALSE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 3
1, "Cuadro", 90, 0, 195, 8, 1, 0,
0,"Total General",100,2,"ARIAL",12,0,0,"1000"
5,0,"TotalPG",190,2,"ARIAL",10,0,1,"1000","Total"
[FIPEU]

[FIGRUP]

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


;tipo, NomGrup, Select, From, GropBy
[GRUP]
2,"CAB2", #FALSE#
"SELECT CodRepresentante & ' - ' & Nombre as Titulo2, * "
"FROM Representantes"
""
[ORDENACIONS] 1
"CodRepresentante", "Codigo", 3

[CONDICIONS] 1
"CodRepresentante", "Cdigo", 0, 1

[CAPSALERA]
0, 7, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 1
3,"CAB2","Titulo2",5,0,"ARIAL",10,0,0,"1001",""
[FICAP]

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



;tipo, NomGrup, Select, From, GropBy
[GRUP]
3,"COS", #FALSE#
"SELECT VenAlba.CodRepresentante, VenAlba.Seccion, Articulos.CodFamilia, Familias.Descripcion, VenAlbaLin.*"
"FROM ((VenAlbaLin LEFT JOIN Articulos ON VenAlbaLin.CodArticulo = Articulos.CodArticulo) LEFT JOIN VenAlba ON (VenAlbaLin.NumAlbaran = VenAlba.NumAlbaran) AND (VenAlbaLin.CodCliente = VenAlba.CodCliente)) LEFT JOIN Familias ON Articulos.CodFamilia = Familias.CodFamilia "
""

[ORDENACIONS] 0
;"FechaFactura","Fecha",0,2

[CONDICIONS] 4
"CodRepresentante", "CodRepresentante", 1, 1, "CAB2", "CodRepresentante"
"FechaFactura","FechaFactura",0,2
"VenAlba.Seccion","Seccion",0,1
"((VenAlba.Facturado)=True) ","",4

[CAPSALERA]
0, 5, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 6
3,"COS","CodFamilia",7,0,"ARIAL",8,50,0,"0000",""
3,"COS","VenAlbaLin.Seccion",16,0,"ARIAL",8,50,0,"0000",""
3,"COS","NumAlbaran", 25,0,"ARIAL",10,0,0,"0000",""
3,"COS","Familias.Descripcion", 44,0,"ARIAL",10,40,0,"0000",""
3,"COS","VenAlbaLin.Descripcion", 85,0,"ARIAL",10,85,0,"0000",""
3,"COS","Total", 190,0,"ARIAL",10,0,1,"0000","SubTotal"
[FICAP]
[FIGRUP]


[CALCULS] 2
"TotalP","COS","Total","CAB2"
"TotalPG","COS","Total","GENERAL"

[FIDOCUM]


