"VER1.0","Clientes","Etiquetas de Clientes"
;Versio, Categoria, Descripcion


;Ampla, Llarg, [EspaiCos]
;MargenX,MargenY, EtiLin, EtiPag
[DOCUM]
105, 37, 0
0, 0, 2, 7
;-----------------------------------------


;Tipo, NomGrup, Select, From, GropBy
[GRUP]
1,"CABECERA", #FALSE#
"SELECT *, CodigoPostal & ' - ' & Poblacion as CPP "
"FROM Configuracion"
""

[CAPSALERA]
0, 0, #TRUE#, 0, #FALSE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 4
2, "Anagrama.BMP", 0, 0, 20, 20
3, "CABECERA", "NombreComercial", 30, 0, "ARIAL", 7, 0, 0, "0000", ""
3, "CABECERA", "Domicilio", 30, 3, "ARIAL", 7, 0, 0, "0000", ""
3, "CABECERA", "CPP", 30, 6, "ARIAL", 7, 0, 0, "0000", ""
[FICAP]

; En Impresos recomendable crear con valor PrintAll a True
[PEU]
0, 0, #TRUE#, 0, #FALSE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[FIPEU]
[FIGRUP]

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

;Tipo, NomGrup, Select, From, GropBy
[GRUP]
0, "GENERAL", #FALSE#
""
""
""

;[ordenaciones] y [condiciones]

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

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

[FIGRUP]


;-----------------------------------------
;"SELECT * "
;"FROM VenAlba"

;tipo, NomGrup, Select, From, GropBy
[GRUP]
3,"COS", #FALSE#
" SELECT VenAlba.*, VenAlba.CodPostal & ' - ' & CodigosPostales.Ciudad as CPyPoblacion, Provincias.Provincia & ' - ' &  Paises.Pais  as ProPais "
" FROM (VenAlba INNER JOIN (Paises INNER JOIN CodigosPostales ON Paises.CodPais = CodigosPostales.CodPais) ON (VenAlba.CodPais = CodigosPostales.CodPais) AND (VenAlba.CodPostal = CodigosPostales.CodPostal)) INNER JOIN Provincias ON (CodigosPostales.CodProvincia = Provincias.CodProvincia) AND (CodigosPostales.CodPais = Provincias.CodPais) "
""
[CONDICIONS] 3
"CodCliente", "Codigo Cliente :",0,1, -10
"NumAlbaran", "Numero Albaran: ", 0, 0
"Seccion", "Seccin: ", 0, 1

[CAPSALERA]
0, 0, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
;1, "cuadro", 0, 0, 105, 37, 8, 0, #FALSE#

[CAMPS] 6
3, "COS", "Destinatario", 5, 10, "ARIAL", 10, 0, 0, "1000", ""
3, "COS", "Direccion", 5, 15, "ARIAL", 10, 0, 0, "1000", ""
3, "COS", "CPyPoblacion", 5, 20, "ARIAL", 10, 0, 0, "1000", ""
3, "COS", "ProPais", 5, 25, "ARIAL", 10, 0, 0, "1000", ""
0,  "Bultos:",80, 30, "ARIAL", 10, 0, 0, "0000"
3, "COS", "Bultos", 95, 30, "ARIAL", 10, 0, 0, "0000", ""
[FICAP]
[FIGRUP]

[CALCULS] 1
"@ETI","COS","Bultos","COS"

[FIDOCUM]

