"VER1.0","Clientess","Listado de Clientes"
;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,0,"ARIAL",22,0,0,"1000",""
3,"CABECERA","Nif",10,8,"ARIAL",8,0,0,"1000",""
0,"Condiciones : ",10,22,"ARIAL",8,0,0,"1000"
6,"Condiciones",35,22,"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] 14
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, "ABC de Clientes", 95, 3, "ARIAL", 20, 0, 2, "1000"
1, "lineaH1", 5, 17, 195, 17,,,
0,"Cdigo",7,18,"ARIAL",8,0,0,"1000"
0,"Nombre",26,18,"ARIAL",8,0,0,"1000"
0,"Total 2P",110,18,"ARIAL",8,0,1,"1000"
0,"Total B.I.",130,18,"ARIAL",8,0,1,"1000"
0,"Porcentaje",148,18,"ARIAL",8,0,1,"1000"
0,"Acumulado",175,18,"ARIAL",8,0,1,"1000"
0,"Porcentaje",193,18,"ARIAL",8,0,1,"1000"
1, "lineaH2", 5, 22, 195, 22,,,
[FICAP]

[PEU]
0, 0, #TRUE#, 0, #FALSE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 0
[FIPEU]

[FIGRUP]

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

;tipo, NomGrup, Select, From, GropBy
[GRUP]
2,"CAB1", #FALSE#
"SELECT Sum(IIF(BaseImponible1 Is Null, 0, Baseimponible1)+IIF(BaseImponible2 Is Null, 0, BaseImponible2)+IIF(BaseImponible3 Is Null, 0, BaseImponible3)) AS TotalGen "
" FROM VenFacturas " 
""
[ORDENACIONS] 0

[CONDICIONS] 2
"Seccion","Sec",0,1
"FechaFactura","Fecha",0,2
;"CodCliente","Codigo",0,1, -10
;"CodRepresentante","Representante",0,1

[CAPSALERA]
0, 0, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 0
[FICAP]

[PEU]
0, 12, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 4
1, "Cuadro", 65, 0, 195, 8, 1, 0,
0,"Total",72,2,"ARIAL",12,0,0,"1000"
5,0,"TotalO",110,2,"ARIAL",10,0,1,"0000","Total"
3,"CAB1","TotalGen",175,2,"ARIAL",10,0,1,"1000","Total"
[FIPEU]
[FIGRUP]


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

;tipo, NomGrup, Select, From, GropBy
;"SELECT CodCliente, NombreFiscal,  Sum(Total) AS TotalAcum "
[GRUP]
3,"COS", #FALSE#
"PARAMETERS SeccionI TEXT, SeccionF TEXT, FechaPI DATETIME, FechaPF DATETIME, FechaFacturaI DATETIME, FechaFacturaF DATETIME; SELECT CodCliente, LAST(NombreFiscal) AS Nombre, Sum(TotalAcum) AS TotalA, Sum(TotalAcu2) AS Total2  "
" FROM [#ABC2] " 
" GROUP BY CodCliente"

[CONDICIONS] 3
"Seccion","Seccion",5,1, "CAB1"
"FechaFactura","Fecha",5,2, "CAB1"
"FechaP","Fecha 2P",0,2
;"Cli", "CodCliente", 5, 1, "CAB1"
;"CodRepresentante","Representante",5,1, "CAB1"

[ORDENACIONS] 3
"Sum(TotalAcu2) DESC", "Acumulado", 0
"CodCliente", "Codigo cliente", 3
"Nombre", "Nombre cliente", 3

[CAPSALERA]
0, 5, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 7
3,"COS","CodCliente",7,0,"ARIAL",8,0,0,"0000",""
3,"COS","Nombre",26,0,"ARIAL",8,50,0,"0000",""
3,"COS","TotalA",110,0,"ARIAL",8,0,1,"0000","Total"
3,"COS","Total2",130,0,"ARIAL",8,0,1,"0000","Total"
8, "1", "DIV((Campo('COS','Total2')*100),Campo('CAB1','TotalGen')) ", 148, 0, "ARIAL", 8, 0, 1, "0000", "##0.00"
5,0,"TotalT",175,0,"ARIAL",8,0,1,"0000","Total"
8, "1", "DIV((Calculo('TotalT')*100),Campo('CAB1','TotalGen')) ", 193, 0, "ARIAL", 8, 0, 1, "0000", "##0.00"
;3,"COS","Porcen",170,0,"ARIAL",8,0,1,"0000","Total"
;3,"NombreFiscal",25,0,"ARIAL",8,50,0,"0000",""
[FICAP]
[FIGRUP]

[CALCULS] 2
"TotalT","COS","Total2","GENERAL"
"TotalO","COS","TotalA","GENERAL"

[FIDOCUM]



