davidbe
|
# Publicado: 16 Sep 2010 10:17
Buenos dias,
Tenemos abanq funcionando en nuestro pequeño negocio, y va muy bien, nuestra enhorabuena a los desarrolladores y colaboradores.
Tenemos un problema con las facturas de clientes: si hay pocos albaranes dentro de las facturas, el total de factura se imprime sin problemas mas o menos al final de la pagina, pero en cuanto pasa de los alaranes (+ 20 lineas) los campos colocados en el detailfooter ni siquiera se ven. Os pongo el codigo que tenemos a ver si alguien puede darnos una pista:
<!DOCTYPE KugarTemplate SYSTEM "kugartemplate.dtd">
<KugarTemplate BottomMargin='15' LeftMargin='30' PageOrientation='0' PageSize='0' RightMargin='30' TopMargin='70'>
<Detail Height='0' Level='0'></Detail>
<DetailHeader Height='190' Level='1'>
<CalculatedField BackgroundColor='255,255,255' BorderColor='0,0,0' BorderStyle='0' BorderWidth='1' CalculationType='6' CommaSeparator='44' Currency='32' DataType='2' DateFormat='11' Field='totalLineas' FontFamily='Arial' FontItalic='0' FontSize='10' FontWeight='65' ForegroundColor='0,0,0' FunctionName='flfactinfo.restaurarAcumulado' HAlignment='2' Height='0' NegValueColor='0,0,0' Precision='2' Text='[totalLineas]' VAlignment='1' Width='0' WordWrap='0' X='0' Y='0'></CalculatedField>
<Line BackgroundColor='255,255,255' Color='100,100,100' Style='0' Width='0' X='0' X1='0' X2='50' Y='0' Y1='0' Y2='20'></Line>
<Line BackgroundColor='255,255,255' Color='100,100,100' Style='0' Width='0' X='0' X1='0' X2='50' Y='0' Y1='174' Y2='20'></Line>
<Line BackgroundColor='255,255,255' Color='100,100,100' Style='0' Width='0' X='0' X1='0' X2='50' Y='0' Y1='0' Y2='20'></Line>
<Line BackgroundColor='255,255,255' Color='100,100,100' Style='0' Width='0' X='0' X1='210' X2='50' Y='0' Y1='0' Y2='20'></Line>
<Label BackgroundColor='255,255,255' BorderColor='0,0,0' BorderStyle='0' BorderWidth='1' FontFamily='Arial' FontItalic='0' FontSize='12' FontWeight='65' ForegroundColor='0,0,0' HAlignment='0' Height='19' Text='Factura' VAlignment='1' Width='120' WordWrap='0' X='6' Y='104'></Label>
<Field BackgroundColor='255,255,255' BorderColor='0,0,0' BorderStyle='0' BorderWidth='1' CommaSeparator='44' Currency='32' DataType='0' DateFormat='11' Field='facturascli.codigo' FontFamily='Tahoma' FontItalic='0' FontSize='10' FontWeight='50' ForegroundColor='0,0,0' HAlignment='0' Height='19' NegValueColor='0,0,0' Precision='2' Text='[facturascli.codigo]' VAlignment='1' Width='120' WordWrap='0' X='6' Y='124'></Field>
<Label BackgroundColor='255,255,255' BorderColor='0,0,0' BorderStyle='0' BorderWidth='1' FontFamily='Arial' FontItalic='0' FontSize='12' FontWeight='65' ForegroundColor='0,0,0' HAlignment='0' Height='19' Text='Data' VAlignment='1' Width='100' WordWrap='0' X='133' Y='104'></Label>
<Field BackgroundColor='255,255,255' BorderColor='0,0,0' BorderStyle='0' BorderWidth='1' CommaSeparator='44' Currency='32' DataType='3' DateFormat='19' Field='facturascli.fecha' FontFamily='Tahoma' FontItalic='0' FontSize='10' FontWeight='50' ForegroundColor='0,0,0' HAlignment='0' Height='18' NegValueColor='0,0,0' Precision='2' Text='[facturascli.fecha]' VAlignment='1' Width='100' WordWrap='0' X='134' Y='124'></Field>
<Label BackgroundColor='255,255,255' BorderColor='0,0,0' BorderStyle='0' BorderWidth='1' FontFamily='Arial' FontItalic='0' FontSize='10' FontWeight='50' ForegroundColor='0,0,0' HAlignment='0' Height='18' Text='Moneda' VAlignment='1' Width='55' WordWrap='0' X='1016' Y='102'></Label>
<Field BackgroundColor='255,255,255' BorderColor='0,0,0' BorderStyle='0' BorderWidth='1' CommaSeparator='44' Currency='32' DataType='0' DateFormat='11' Field='facturascli.coddivisa' FontFamily='Arial Narrow' FontItalic='0' FontSize='10' FontWeight='50' ForegroundColor='0,0,0' HAlignment='0' Height='18' NegValueColor='0,0,0' Precision='2' Text='[facturascli.coddivisa]' VAlignment='1' Width='100' WordWrap='0' X='1049' Y='126'></Field>
<Label BackgroundColor='255,255,255' BorderColor='0,0,0' BorderStyle='0' BorderWidth='1' FontFamily='Arial' FontItalic='0' FontSize='10' FontWeight='50' ForegroundColor='0,0,0' HAlignment='0' Height='18' Text='Pagina' VAlignment='1' Width='55' WordWrap='0' X='1155' Y='151'></Label>
<Special BackgroundColor='255,255,255' BorderColor='0,0,0' BorderStyle='0' BorderWidth='1' DataType='11' DateFormat='11' FontFamily='Arial Narrow' FontItalic='0' FontSize='10' FontWeight='50' ForegroundColor='0,0,0' HAlignment='0' Height='18' Text='[PageNo]' Type='1' VAlignment='1' Width='100' WordWrap='0' X='1181' Y='174'></Special>
<Field BackgroundColor='255,255,255' BorderColor='0,0,0' BorderStyle='0' BorderWidth='1' CommaSeparator='44' Currency='32' DataType='6' DateFormat='11' Field='facturascli.codigo' FontFamily='Arial' FontItalic='0' FontSize='10' FontWeight='50' ForegroundColor='0,0,0' HAlignment='0' Height='55' NegValueColor='0,0,0' Precision='2' Text='[facturascli.codigo]' VAlignment='1' Width='200' WordWrap='0' X='1128' Y='106'></Field>
<Line BackgroundColor='255,255,255' Color='100,100,100' Style='0' Width='0' X='0' X1='219' X2='50' Y='0' Y1='0' Y2='20'></Line>
<Line BackgroundColor='255,255,255' Color='100,100,100' Style='0' Width='0' X='0' X1='219' X2='50' Y='0' Y1='80' Y2='20'></Line>
<Line BackgroundColor='255,255,255' Color='100,100,100' Style='0' Width='0' X='0' X1='219' X2='50' Y='0' Y1='0' Y2='20'></Line>
<Line BackgroundColor='255,255,255' Color='100,100,100' Style='0' Width='0' X='0' X1='591' X2='50' Y='0' Y1='0' Y2='20'></Line>
<Label BackgroundColor='255,255,255' BorderColor='0,0,0' BorderStyle='0' BorderWidth='1' FontFamily='Arial Narrow' FontItalic='0' FontSize='10' FontWeight='50' ForegroundColor='0,0,0' HAlignment='0' Height='18' Text='CIF/NIF' VAlignment='1' Width='60' WordWrap='0' X='1046' Y='46'></Label>
<Field BackgroundColor='255,255,255' BorderColor='0,0,0' BorderStyle='0' BorderWidth='1' CommaSeparator='44' Currency='32' DataType='0' DateFormat='11' Field='empresa.cifnif' FontFamily='Arial Narrow' FontItalic='0' FontSize='10' FontWeight='50' ForegroundColor='0,0,0' HAlignment='0' Height='18' NegValueColor='0,0,0' Precision='2' Text='[empresa.cifnif]' VAlignment='1' Width='80' WordWrap='0' X='1005' Y='35'></Field>
<Line BackgroundColor='255,255,255' Color='100,100,100' Style='0' Width='0' X='0' X1='219' X2='50' Y='0' Y1='89' Y2='20'></Line>
<Line BackgroundColor='255,255,255' Color='100,100,100' Style='0' Width='0' X='0' X1='219' X2='50' Y='0' Y1='174' Y2='20'></Line>
<Line BackgroundColor='255,255,255' Color='100,100,100' Style='0' Width='0' X='0' X1='219' X2='50' Y='0' Y1='89' Y2='20'></Line>
<Line BackgroundColor='255,255,255' Color='100,100,100' Style='0' Width='0' X='0' X1='590' X2='50' Y='0' Y1='89' Y2='20'></Line>
<Label BackgroundColor='255,255,255' BorderColor='0,0,0' BorderStyle='0' BorderWidth='0' FontFamily='Arial' FontItalic='0' FontSize='12' FontWeight='65' ForegroundColor='0,0,0' HAlignment='0' Height='18' Text=' Client' VAlignment='1' Width='60' WordWrap='0' X='295' Y='50'></Label>
<Field BackgroundColor='255,255,255' BorderColor='0,0,0' BorderStyle='0' BorderWidth='0' CommaSeparator='44' Currency='32' DataType='0' DateFormat='11' Field='facturascli.codcliente' FontFamily='Arial Narrow' FontItalic='0' FontSize='12' FontWeight='65' ForegroundColor='0,0,0' HAlignment='0' Height='18' NegValueColor='0,0,0' Precision='2' Text='[facturascli.codcliente]' VAlignment='1' Width='298' WordWrap='0' X='355' Y='50'></Field>
<Field BackgroundColor='255,255,255' BorderColor='0,0,0' BorderStyle='0' BorderWidth='1' CommaSeparator='44' Currency='32' DataType='0' DateFormat='11' Field='facturascli.nombrecliente' FontFamily='Arial Narrow' FontItalic='0' FontSize='10' FontWeight='65' ForegroundColor='0,0,0' HAlignment='0' Height='18' NegValueColor='0,0,0' Precision='2' Text='[facturascli.nombrecliente]' VAlignment='1' Width='250' WordWrap='0' X='295' Y='75'></Field>
<Label BackgroundColor='255,255,255' BorderColor='0,0,0' BorderStyle='0' BorderWidth='1' FontFamily='Arial Narrow' FontItalic='0' FontSize='10' FontWeight='50' ForegroundColor='0,0,0' HAlignment='0' Height='18' Text='CIF/NIF' VAlignment='1' Width='50' WordWrap='0' X='1068' Y='104'></Label>
<Field BackgroundColor='255,255,255' BorderColor='0,0,0' BorderStyle='0' BorderWidth='1' CommaSeparator='44' Currency='32' DataType='0' DateFormat='11' Field='facturascli.direccion' FontFamily='Arial Narrow' FontItalic='0' FontSize='10' FontWeight='50' ForegroundColor='0,0,0' HAlignment='0' Height='16' NegValueColor='0,0,0' Precision='2' Text='[facturascli.direccion]' VAlignment='1' Width='350' WordWrap='0' X='295' Y='92'></Field>
<Field BackgroundColor='255,255,255' BorderColor='0,0,0' BorderStyle='0' BorderWidth='1' CommaSeparator='44' Currency='32' DataType='0' DateFormat='11' Field='facturascli.codpostal' FontFamily='Arial Narrow' FontItalic='0' FontSize='10' FontWeight='50' ForegroundColor='0,0,0' HAlignment='0' Height='16' NegValueColor='0,0,0' Precision='2' Text='[facturascli.codpostal]' VAlignment='1' Width='50' WordWrap='0' X='295' Y='109'></Field>
<Field BackgroundColor='255,255,255' BorderColor='0,0,0' BorderStyle='0' BorderWidth='1' CommaSeparator='44' Currency='32' DataType='0' DateFormat='11' Field='facturascli.ciudad' FontFamily='Arial Narrow' FontItalic='0' FontSize='10' FontWeight='50' ForegroundColor='0,0,0' HAlignment='0' Height='16' NegValueColor='0,0,0' Precision='2' Text='[facturascli.ciudad]' VAlignment='1' Width='160' WordWrap='0' X='345' Y='109'></Field>
<Field BackgroundColor='255,255,255' BorderColor='0,0,0' BorderStyle='0' BorderWidth='1' CommaSeparator='44' Currency='32' DataType='0' DateFormat='11' Field='facturascli.provincia' FontFamily='Arial Narrow' FontItalic='0' FontSize='10' FontWeight='50' ForegroundColor='0,0,0' HAlignment='0' Height='16' NegValueColor='0,0,0' Precision='2' Text='[facturascli.provincia]' VAlignment='1' Width='100' WordWrap='0' X='295' Y='125'></Field>
<Label BackgroundColor='220,220,220' BorderColor='0,0,0' BorderStyle='0' BorderWidth='1' FontFamily='Arial' FontItalic='0' FontSize='10' FontWeight='65' ForegroundColor='0,0,0' HAlignment='1' Height='20' Text='Referencia' VAlignment='1' Width='88' WordWrap='0' X='2' Y='165'></Label>
<La
|
davidbe
|
# Publicado: 16 Sep 2010 10:19
<DetailFooter Height='120' Level='1'>
<Label BackgroundColor='255,255,255' BorderColor='0,0,0' BorderStyle='0' BorderWidth='1' FontFamily='Arial' FontItalic='0' FontSize='12' FontWeight='75' ForegroundColor='0,0,0' HAlignment='0' Height='20' Text='Total Factura' VAlignment='1' Width='120' WordWrap='0' X='340' Y='430'></Label>
<CalculatedField BackgroundColor='255,255,255' BorderColor='0,0,0' BorderStyle='0' BorderWidth='1' CalculationType='5' CommaSeparator='44' Currency='32' DataType='0' DateFormat='11' Field='facturascli.total' FontFamily='Arial' FontItalic='0' FontSize='11' FontWeight='75' ForegroundColor='0,0,0' HAlignment='1' Height='20' NegValueColor='0,0,0' Precision='2' Text='[facturascli.total]' VAlignment='1' Width='70' WordWrap='0' X='480' Y='430'></CalculatedField>
<Label BackgroundColor='255,255,255' BorderColor='0,0,0' BorderStyle='0' BorderWidth='1' FontFamily='Arial' FontItalic='0' FontSize='12' FontWeight='75' ForegroundColor='0,0,0' HAlignment='0' Height='18' Text='Eur' VAlignment='1' Width='130' WordWrap='1' X='550' Y='430'></Label>
<Label BackgroundColor='255,255,255' BorderColor='0,0,0' BorderStyle='0' BorderWidth='1' FontFamily='Arial' FontItalic='0' FontSize='12' FontWeight='75' ForegroundColor='0,0,0' HAlignment='0' Height='18' Text=' Forma pagament' VAlignment='1' Width='130' WordWrap='1' X='340' Y='450'></Label>
<CalculatedField BackgroundColor='255,255,255' BorderColor='0,0,0' BorderStyle='0' BorderWidth='1' CalculationType='5' CommaSeparator='44' Currency='32' DataType='0' DateFormat='11' Field='formaspago.descripcion' FontFamily='Arial' FontItalic='0' FontSize='10' FontWeight='50' ForegroundColor='0,0,0' HAlignment='0' Height='18' NegValueColor='0,0,0' Precision='2' Text='[formaspago.descripcion]' VAlignment='1' Width='140' WordWrap='0' X='480' Y='450'></CalculatedField>
</DetailFooter>
<DetailHeader Height='27' Level='2'>
<Label BackgroundColor='255,255,255' BorderColor='0,0,0' BorderStyle='0' BorderWidth='1' FontFamily='Arial' FontItalic='0' FontSize='9' FontWeight='50' ForegroundColor='0,0,0' HAlignment='0' Height='18' Text='Albara' VAlignment='1' Width='60' WordWrap='0' X='4' Y='0'></Label>
<Field BackgroundColor='255,255,255' BorderColor='0,0,0' BorderStyle='0' BorderWidth='1' CommaSeparator='44' Currency='32' DataType='0' DateFormat='11' Field='albaranescli.codigo' FontFamily='Arial' FontItalic='0' FontSize='9' FontWeight='50' ForegroundColor='0,0,0' HAlignment='0' Height='18' NegValueColor='0,0,0' Precision='2' Text='[albaranescli.codigo]' VAlignment='1' Width='90' WordWrap='0' X='50' Y='1'></Field>
<Label BackgroundColor='255,255,255' BorderColor='0,0,0' BorderStyle='0' BorderWidth='1' FontFamily='Arial' FontItalic='0' FontSize='9' FontWeight='50' ForegroundColor='0,0,0' HAlignment='0' Height='18' Text='del' VAlignment='1' Width='15' WordWrap='0' X='130' Y='0'></Label>
<Field BackgroundColor='255,255,255' BorderColor='0,0,0' BorderStyle='0' BorderWidth='1' CommaSeparator='44' Currency='32' DataType='3' DateFormat='19' Field='albaranescli.fecha' FontFamily='Arial' FontItalic='0' FontSize='9' FontWeight='50' ForegroundColor='0,0,0' HAlignment='0' Height='18' NegValueColor='0,0,0' Precision='2' Text='[albaranescli.fecha]' VAlignment='1' Width='70' WordWrap='0' X='135' Y='0'></Field>
<Label BackgroundColor='255,255,255' BorderColor='0,0,0' BorderStyle='0' BorderWidth='1' FontFamily='Arial' FontItalic='0' FontSize='9' FontWeight='50' ForegroundColor='0,0,0' HAlignment='2' Height='18' Text='Obra' VAlignment='1' Width='40' WordWrap='0' X='200' Y='0'></Label>
<Field BackgroundColor='255,255,255' BorderColor='0,0,0' BorderStyle='0' BorderWidth='1' CommaSeparator='44' Currency='32' DataType='0' DateFormat='11' Field='albaranescli.observaciones' FontFamily='Arial' FontItalic='0' FontSize='9' FontWeight='50' ForegroundColor='0,0,0' HAlignment='0' Height='18' NegValueColor='0,0,0' Precision='0' Text='[albaranescli.observaciones]' VAlignment='1' Width='300' WordWrap='0' X='245' Y='1'></Field>
<Line BackgroundColor='255,255,255' Color='100,100,100' Style='3' Width='1' X='0' X1='0' X2='50' Y='0' Y1='20' Y2='20'></Line>
</DetailHeader>
<Detail Height='15' Level='2'>
<Field BackgroundColor='255,255,255' BorderColor='0,0,0' BorderStyle='0' BorderWidth='1' CommaSeparator='44' Currency='32' DataType='0' DateFormat='11' Field='lineasfacturascli.referencia' FontFamily='Arial Narrow' FontItalic='0' FontSize='9' FontWeight='50' ForegroundColor='0,0,0' HAlignment='0' Height='15' NegValueColor='0,0,0' Precision='2' Text='[lineasfacturascli.referencia]' VAlignment='1' Width='87' WordWrap='0' X='4' Y='1'></Field>
<Field BackgroundColor='255,255,255' BorderColor='0,0,0' BorderStyle='0' BorderWidth='1' CommaSeparator='44' Currency='32' DataType='0' DateFormat='11' Field='lineasfacturascli.descripcion' FontFamily='Arial Narrow' FontItalic='0' FontSize='9' FontWeight='50' ForegroundColor='0,0,0' HAlignment='0' Height='15' NegValueColor='0,0,0' Precision='2' Text='[lineasfacturascli.descripcion]' VAlignment='1' Width='287' WordWrap='0' X='91' Y='2'></Field>
<Field BackgroundColor='255,255,255' BorderColor='0,0,0' BorderStyle='0' BorderWidth='1' CommaSeparator='44' Currency='32' DataType='2' DateFormat='11' Field='lineasfacturascli.cantidad' FontFamily='Arial Narrow' FontItalic='0' FontSize='9' FontWeight='50' ForegroundColor='0,0,0' HAlignment='2' Height='15' NegValueColor='0,0,0' Precision='2' Text='[lineasfacturascli.cantidad]' VAlignment='1' Width='50' WordWrap='0' X='361' Y='1'></Field>
<Field BackgroundColor='255,255,255' BorderColor='0,0,0' BorderStyle='0' BorderWidth='1' CommaSeparator='44' Currency='32' DataType='2' DateFormat='11' Field='lineasfacturascli.pvpunitario' FontFamily='Arial Narrow' FontItalic='0' FontSize='9' FontWeight='50' ForegroundColor='0,0,0' HAlignment='2' Height='15' NegValueColor='0,0,0' Precision='2' Text='[lineasfacturascli.pvpunitario]' VAlignment='1' Width='50' WordWrap='0' X='413' Y='1'></Field>
<Field BackgroundColor='255,255,255' BorderColor='0,0,0' BorderStyle='0' BorderWidth='1' CommaSeparator='44' Currency='32' DataType='2' DateFormat='11' Field='lineasfacturascli.dtopor' FontFamily='Arial Narrow' FontItalic='0' FontSize='9' FontWeight='50' ForegroundColor='0,0,0' HAlignment='2' Height='15' NegValueColor='0,0,0' Precision='2' Text='[lineasfacturascli.dtopor]' VAlignment='1' Width='40' WordWrap='0' X='462' Y='1'></Field>
<Field BackgroundColor='255,255,255' BorderColor='0,0,0' BorderStyle='0' BorderWidth='1' CommaSeparator='44' Currency='32' DataType='2' DateFormat='11' Field='lineasfacturascli.pvptotal' FontFamily='Arial Narrow' FontItalic='0' FontSize='9' FontWeight='50' ForegroundColor='0,0,0' HAlignment='2' Height='15' NegValueColor='0,0,0' Precision='2' Text='[lineasfacturascli.pvptotal]' VAlignment='1' Width='51' WordWrap='0' X='503' Y='1'></Field>
</Detail>
</KugarTemplate>
|
