"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,10,"ARIAL", 8,0,0,"1000",""
0,"Condiciones : ",20,23,"ARIAL",8,0,0,"1000"
6,"Condiciones",45,23,"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] 11
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, "Comisiones de Representantes", 95, 4, "ARIAL", 20, 0, 2, "1000"
1, "lineaH1", 3, 17, 197, 17,,,
0,"Cdigo", 5,18,"ARIAL",8,0,0,"1000"
0,"Nombre", 17,18,"ARIAL",8,0,0,"1000"
0,"T. Base", 156,18,"ARIAL",8,0,1,"1000"
0,"T. Comisin", 195,18,"ARIAL",8,0,1,"1000"
1, "lineaH2", 3, 22, 197, 22,,,
[FICAP]

[PEU]
0, 25, #TRUE#, 0, #FALSE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 4
1, "lineaHF", 3, 0, 197, 0,,,
0,"Totales  :", 127,3,"ARIAL",11,0,1,"1000"
5,0,"T1", 156,3,"ARIAL", 10,0,1,"1000","Total"
5,0,"T2", 195,3,"ARIAL", 10,0,1,"1000","Total"
[FIPEU]

[FIGRUP]

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

;tipo, NomGrup, Select, From, GropBy
[GRUP]
3,"COS", #FALSE#
"SELECT Representantes.CodRepresentante, Representantes.Nombre, Representantes.Comision, Sum(IIf([BaseImponible1] Is Null,0,[BaseImponible1])+IIf([BaseImponible2] Is Null,0,[BaseImponible2])+IIf([BaseImponible3] Is Null,0,[BaseImponible3])) AS Totalbase, Sum(VenFacturas.TComision) AS TotalComision "
"FROM Representantes INNER JOIN VenFacturas ON Representantes.CodRepresentante = VenFacturas.CodRepresentante "
"GROUP BY Representantes.CodRepresentante, Representantes.Nombre, Representantes.Comision "

[CONDICIONS] 4
"Representantes.CodRepresentante","Codigo",0,1
"Nombre","Nombre",0,1
"Seccion","Seccin",0,1
"FechaFactura","Fecha",0,2
;"Seccion","Nmero de albarn",1,1,"CAB 2","Seccion"

[ORDENACIONS] 2
"Representantes.CodRepresentante", "Codigo representante", 3
"Nombre", "Nombre", 3

[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", "CodRepresentante", 5,0,"ARIAL", 9,0,0, "0000",""
3,"COS", "Nombre", 17,0,"ARIAL", 9,0,0, "0000",""
3,"COS", "TotalBase",156,0,"ARIAL", 9,0,1, "0000","Total"
3,"COS", "TotalComision",195,0,"ARIAL", 9,0,1, "0000","Total"
[FICAP]
[FIGRUP]

[CALCULS] 2
"T1", "COS", "TotalBase", "GENERAL"
"T2", "COS", "TotalComision", "GENERAL"

[FIDOCUM]


