"VER1.0","Centro de Costes","Centro de Coste: Resumen de todos los Centros"
;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",15,0,"ARIAL",22,0,0,"1000",""
3,"CABECERA","Nif",20,8,"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] 12
0,"Página :",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, "Resumen de Centros de Coste", 20, 5, "ARIAL",16, 0, 0, "1000"
1,"lineaH1",15,17,200,17,,,
0,"Centro",15,18,"ARIAL",8,0,0,"1000"
0,"Descripción",45,18,"ARIAL",8,0,0,"1000"
0,"Gastos",145,18,"ARIAL",8,0,1,"1000"
0,"Ingresos",170,18,"ARIAL",8,0,1,"1000"
0,"Resultado",195,18,"ARIAL",8,0,1,"1000"
1,"lineaH2",15,22,200,22,,,
[FICAP]

[PEU]
0, 20, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 4
0,"Totales :",80,10,"ARIAL",12,0,1,"1000"
5,0,"TotalGastosGeneral",145,10,"ARIAL",10,0,1,"0000","Total"
5,0,"TotalIngresosGeneral",170,10,"ARIAL",10,0,1,"0000","Total"
5,0,"TotalResultadoGeneral",195,10,"ARIAL",10,0,1,"0000","Total"
[FIPEU]

[FIGRUP]

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

;tipo, NomGrup, Select, From, GropBy
[GRUP]
3,"PORCENTRO", #FALSE#
"SELECT CentrosCoste.CodCentroCoste, CentrosCoste.Descripcion, Sum(IIF(SubCuentas08.CodCuenta<'7',Apuntes.CantidadD-Apuntes.CantidadH,0)) AS ImporteGasto, Sum(IIF(SubCuentas08.CodCuenta<'7',0,Apuntes.CantidadH-Apuntes.CantidadD)) AS ImporteIngreso, Sum(IIF(SubCuentas08.CodCuenta<'7',-(Apuntes.CantidadD-Apuntes.CantidadH),Apuntes.CantidadH-Apuntes.CantidadD)) AS ImporteResultado "
"FROM (CentrosCoste INNER JOIN Apuntes ON CentrosCoste.CodCentroCoste = Apuntes.CentroCoste) INNER JOIN SubCuentas08 ON Apuntes.CodCuenta = SubCuentas08.CodCuenta WHERE (SubCuentas08.CodCuenta>='6' AND SubCuentas08.CodCuenta<'8') "
"GROUP BY CentrosCoste.CodCentroCoste, CentrosCoste.Descripcion"

[CONDICIONS] 1
"Apuntes.FechaAsiento","Fecha",0,2

[ORDENACIONS] 2
"CentrosCoste.CodCentroCoste","Código",3
; 3/11: el alias de un agregado no vale en el ORDER BY de Access; va la expresion entera.
"Sum(IIF(SubCuentas08.CodCuenta<'7',-(Apuntes.CantidadD-Apuntes.CantidadH),Apuntes.CantidadH-Apuntes.CantidadD)) DESC","Resultado (mayor a menor)",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,"PORCENTRO","CodCentroCoste",15,0,"ARIAL",8,0,0,"0000",""
3,"PORCENTRO","Descripcion",45,0,"ARIAL",8,95,0,"0000",""
3,"PORCENTRO","ImporteGasto",145,0,"ARIAL",8,0,1,"0000","Total"
3,"PORCENTRO","ImporteIngreso",170,0,"ARIAL",8,0,1,"0000","Total"
3,"PORCENTRO","ImporteResultado",195,0,"ARIAL",8,0,1,"0000","Total"
[FICAP]

[FIGRUP]

[CALCULS] 3
"TotalGastosGeneral","PORCENTRO","ImporteGasto","GENERAL"
"TotalIngresosGeneral","PORCENTRO","ImporteIngreso","GENERAL"
"TotalResultadoGeneral","PORCENTRO","ImporteResultado","GENERAL"
[FIDOCUM]
