"VER1.0","Articulos","Listado de articulos por famlias"
;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, 10, #TRUE#, 0, #TRUE#, #FALSE#, 2
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 0
;0,"Total General",150,0,"ARIAL",12,0,1,"1000"
;5,0,"Total",190,0,"ARIAL",10,0,1,"1000","Total"
[FIPEU]
[FIGRUP]

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


; Tipo, NomGrup, InicNumPag,   Select, From, GropBy
[GRUP]
0, "GENERAL", #FALSE#
""
""
""
;[ordenaciones] y [condiciones]
[CAPSALERA]
10, 30, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 12
0,"Pgina :",170,0,"ARIAL",8,0,0,"1000"
6,"Pagina",200,0,"ARIAL",8,0,1,"1000",""
0,"Fecha :",170,5,"ARIAL",8,0,0,"1000"
6,"Fecha",200,5,"ARIAL",8,0,1,"1000",""
0, "Listado de Facturas Por zonas", 95, 3, "ARIAL", 20, 0, 2, "1000"
1,"lineaH1",5,17,200,17,,,
0,"N Factura",5,18,"ARIAL",10,0,0,"1000"
0,"Cliente",30,18,"ARIAL",10,0,0,"1000"
0,"Fecha",135,18,"ARIAL",10,0,0,"1000"
0,"Portes",160,18,"ARIAL",10,0,0,"1000"
0,"Total",190,18,"ARIAL",10,0,1,"1000"
1,"lineaH2",5,22,200,22,,,
[FICAP]

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

[FIGRUP]

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


;tipo, NomGrup, Select, From, GropBy
[GRUP]
2,"CAB2", #FALSE#
"SELECT CodZona & ' - ' & Descripcion as Titulo2, * "
"FROM Zonas"
""
[ORDENACIONS] 1
"CodZona", "Codigo Zona", 3

[CONDICIONS] 1
"CodZona", "Cod. Zona", 0, 1
;"Descripcion", "Descripcin", 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,"0001",""
[FICAP]
[PEU]
0, 10, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 2
0,"Total",150,2,"ARIAL",10,0,0,"0001"
5,0,"TotalP",190,2,"ARIAL",10,0,3,"1000","Total"
[FIPEU]
[FIGRUP]



;tipo, NomGrup, Select, From, GropBy
[GRUP]
3,"COS", #FALSE#
"SELECT VenFacturas.CodCliente, VenFacturas.NumFactura, VenFacturas.Seccion, VenFacturas.FechaFactura, VenFacturas.NOrden, VenFacturas.NombreFiscal, VenFacturas.NIF, First(VenFacturas.Total) AS SumaDeTotal, Sum(VenFacturas.TIRPF) AS SumaDeTIRPF, Sum(VenFacturas.TDesCo) AS SumaDeTDesCo, Sum(VenFacturas.TDesPP) AS SumaDeTDesPP, Sum(VenFacturas.BaseImponible1) AS SumaDeBaseImponible1, Sum(VenFacturas.TIva1) AS SumaDeTIva1, Sum(VenFacturas.TRE1) AS SumaDeTRE1, Sum(VenFacturas.BaseImponible2) AS SumaDeBaseImponible2, Sum(VenFacturas.TIva2) AS SumaDeTIva2, Sum(VenFacturas.TRE2) AS SumaDeTRE2, Sum(VenFacturas.BaseImponible3) AS SumaDeBaseImponible3, Sum(VenFacturas.TIva3) AS SumaDeTIva3, Sum(VenFacturas.TRE3) AS SumaDeTRE3, Clientes.CodGrupo, Clientes.CodZona, (Sum(IIf(IsNull(VenFacturas.BaseImponible1),0,VenFacturas.BaseImponible1))+Sum(IIf(IsNull(VenFacturas.BaseImponible2),0,VenFacturas.BaseImponible2))+Sum(IIf(IsNull(VenFacturas.BaseImponible3),0,VenFacturas.BaseImponible3))) AS SumaDeBases"
"FROM VenFacturas INNER JOIN Clientes ON VenFacturas.CodCliente = Clientes.CodCliente"
"GROUP BY VenFacturas.CodCliente, VenFacturas.NumFactura, VenFacturas.Seccion, VenFacturas.FechaFactura, VenFacturas.NOrden, VenFacturas.NombreFiscal, VenFacturas.NIF, Clientes.CodGrupo, Clientes.CodZona"
[CONDICIONS] 7
"NumFactura","Nmero Factura",0,1
"CodCliente","Codigo Cliente",0,1, -10
"NombreFiscal","Nombre Cliente",0,1
"VenFacturas.FechaFactura","Fecha Factura",0,2
"Seccion","Seccin",0,1
"CodZona", "CodZona", 1, 1, "CAB2", "CodZona"
"CodGrupo","Cdigo Grupo",0,1

[ORDENACIONS] 2
"VenFacturas.FechaFactura","Fecha",3
"NumFactura","Nmero de Factura",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", "NumFactura", 5,0,"ARIAL",10,0,0,"0000",""
3, "COS", "NombreFiscal", 30,0,"ARIAL",10,115,0,"0000",""
3, "COS", "FechaFactura", 135,0,"ARIAL",10,0,0,"0000",""
3, "COS", "SumaDeImportePorte", 170,0,"ARIAL",10,0,1,"0000",""
3, "COS", "SumaDeBases", 190,0,"ARIAL",10,0,3,"0000","Total"
[FICAP]
[FIGRUP]

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

[FIDOCUM]


