← Back to branch summary

~openbias/bias-trunk/addons_minerales

« back to all changes in this revision

Viewing changes to jasper_reports/custom_reports/xls_sheet1.jrxml

  • Committer: Jose Patricio
  • Date: 2011-12-01 16:01:00 UTC
  • mfrom: (546.1.7 addons_mx)
  • Revision ID: josepato@bias.com.mx-20111201160100-k10fh8uok4pnnwdq
el merge 

Show diffs side-by-side

added added

removed removed

Lines of Context:
jasper_reports/custom_reports/xls_sheet1.jrxml
1
1
<?xml version="1.0" encoding="UTF-8"?>
2
 
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="Reporte_produccion_produccion" language="groovy" pageWidth="1008" pageHeight="1008" orientation="Landscape" whenNoDataType="AllSectionsNoDetail" columnWidth="968" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" isFloatColumnFooter="true">
3
 
        <property name="ireport.zoom" value="1.1000000000000019"/>
 
2
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="Reporte_produccion_produccion" language="groovy" pageWidth="1008" pageHeight="1008" orientation="Landscape" whenNoDataType="AllSectionsNoDetail" columnWidth="968" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" isTitleNewPage="true" isSummaryNewPage="true" isSummaryWithPageHeaderAndFooter="true" isFloatColumnFooter="true" isIgnorePagination="true">
 
3
        <property name="ireport.zoom" value="1.3310000000000035"/>
4
4
        <property name="ireport.x" value="0"/>
5
5
        <property name="ireport.y" value="0"/>
6
6
        <property name="net.sf.jasperreports.export.xls.one.page.per.sheet" value="Boolean.False"/>
 
7
        <property name="net.sf.jasperreports.export.xls.remove.empty.space.between.rows" value="Boolean.False"/>
 
8
        <property name="net.sf.jasperreports.export.xls.remove.empty.space.between.columns" value="Boolean.False"/>
 
9
        <property name="net.sf.jasperreports.export.xls.detect.cell.type" value="Boolean.False"/>
 
10
        <property name="net.sf.jasperreports.export.xls.ignore.cell.border" value="Boolean.False"/>
7
11
        <property name="net.sf.jasperreports.export.xls.sheet.names.sheet1" value="Produccion"/>
8
12
        <style name="celdas_titulo" mode="Opaque" forecolor="#FFFFFF" backcolor="#0B5595" fontSize="8">
9
13
                <pen lineWidth="0.0" lineStyle="Dotted" lineColor="#FEFEFE"/>
322
326
                                        <textElement verticalAlignment="Middle">
323
327
                                                <font size="7"/>
324
328
                                        </textElement>
325
 
                                        <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_1}.equalsIgnoreCase("vacio")?$V{var1}:$P{pqty_1}]]></textFieldExpression>
 
329
                                        <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_1}.equalsIgnoreCase("vacio")?$V{var1}:$P{pqty_1} + " "]]></textFieldExpression>
326
330
                                </textField>
327
331
                                <textField isBlankWhenNull="true">
328
332
                                        <reportElement style="encabezado_2" x="141" y="18" width="52" height="17"/>
329
333
                                        <textElement verticalAlignment="Middle">
330
334
                                                <font size="7"/>
331
335
                                        </textElement>
332
 
                                        <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_2}.equalsIgnoreCase("vacio")?$V{var1}:$P{pqty_2}]]></textFieldExpression>
 
336
                                        <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_2}.equalsIgnoreCase("vacio")?$V{var1}:$P{pqty_2} + " "]]></textFieldExpression>
333
337
                                </textField>
334
338
                                <textField isBlankWhenNull="true">
335
339
                                        <reportElement style="encabezado_2" x="193" y="18" width="52" height="17"/>
336
340
                                        <textElement verticalAlignment="Middle">
337
341
                                                <font size="7"/>
338
342
                                        </textElement>
339
 
                                        <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_3}.equalsIgnoreCase("vacio")?$V{var1}:$P{pqty_3}]]></textFieldExpression>
 
343
                                        <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_3}.equalsIgnoreCase("vacio")?$V{var1}:$P{pqty_3} + " "]]></textFieldExpression>
340
344
                                </textField>
341
345
                                <textField isBlankWhenNull="true">
342
346
                                        <reportElement style="encabezado_2" x="245" y="18" width="52" height="17"/>
343
347
                                        <textElement verticalAlignment="Middle">
344
348
                                                <font size="7"/>
345
349
                                        </textElement>
346
 
                                        <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_4}.equalsIgnoreCase("vacio")?$V{var1}:$P{pqty_4}]]></textFieldExpression>
 
350
                                        <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_4}.equalsIgnoreCase("vacio")?$V{var1}:$P{pqty_4} + " "]]></textFieldExpression>
347
351
                                </textField>
348
352
                                <textField isBlankWhenNull="true">
349
353
                                        <reportElement style="encabezado_2" x="297" y="18" width="52" height="17"/>
350
354
                                        <textElement verticalAlignment="Middle">
351
355
                                                <font size="7"/>
352
356
                                        </textElement>
353
 
                                        <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_5}.equalsIgnoreCase("vacio")?$V{var1}:$P{pqty_5}]]></textFieldExpression>
 
357
                                        <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_5}.equalsIgnoreCase("vacio")?$V{var1}:$P{pqty_5} + " "]]></textFieldExpression>
354
358
                                </textField>
355
359
                                <textField>
356
360
                                        <reportElement style="encabezado_2" x="349" y="18" width="52" height="17"/>
357
361
                                        <textElement verticalAlignment="Middle">
358
362
                                                <font size="7"/>
359
363
                                        </textElement>
360
 
                                        <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_6}.equalsIgnoreCase("vacio")?$V{var1}:$P{pqty_6}]]></textFieldExpression>
 
364
                                        <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_6}.equalsIgnoreCase("vacio")?$V{var1}:$P{pqty_6} + " "]]></textFieldExpression>
361
365
                                </textField>
362
366
                                <textField>
363
367
                                        <reportElement style="encabezado_2" x="401" y="18" width="52" height="17"/>
364
368
                                        <textElement verticalAlignment="Middle">
365
369
                                                <font size="7"/>
366
370
                                        </textElement>
367
 
                                        <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_7}.equalsIgnoreCase("vacio")?$V{var1}:$P{pqty_7}]]></textFieldExpression>
 
371
                                        <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_7}.equalsIgnoreCase("vacio")?$V{var1}:$P{pqty_7} + " "]]></textFieldExpression>
368
372
                                </textField>
369
373
                                <textField isBlankWhenNull="true">
370
374
                                        <reportElement style="encabezado_2" x="453" y="18" width="52" height="17"/>
371
375
                                        <textElement verticalAlignment="Middle">
372
376
                                                <font size="7"/>
373
377
                                        </textElement>
374
 
                                        <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_8}.equalsIgnoreCase("vacio")?$V{var1}:$P{pqty_8}]]></textFieldExpression>
 
378
                                        <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_8}.equalsIgnoreCase("vacio")?$V{var1}:$P{pqty_8} + " "]]></textFieldExpression>
375
379
                                </textField>
376
380
                                <textField isBlankWhenNull="true">
377
381
                                        <reportElement style="encabezado_1" x="453" y="0" width="52" height="18"/>
378
382
                                        <textElement textAlignment="Center" verticalAlignment="Middle">
379
383
                                                <font size="8"/>
380
384
                                        </textElement>
381
 
                                        <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_8}.equalsIgnoreCase("vacio")?$V{var1}:"Toneladas"]]></textFieldExpression>
 
385
                                        <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_8}.equalsIgnoreCase("vacio")?$V{var1}:"Toneladas "]]></textFieldExpression>
382
386
                                </textField>
383
387
                                <textField isBlankWhenNull="true">
384
388
                                        <reportElement style="encabezado_1" x="401" y="0" width="52" height="18"/>
385
389
                                        <textElement textAlignment="Center" verticalAlignment="Middle">
386
390
                                                <font size="8"/>
387
391
                                        </textElement>
388
 
                                        <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_7}.equalsIgnoreCase("vacio")?$V{var1}:"Toneladas"]]></textFieldExpression>
 
392
                                        <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_7}.equalsIgnoreCase("vacio")?$V{var1}:"Toneladas "]]></textFieldExpression>
389
393
                                </textField>
390
394
                                <textField isBlankWhenNull="true">
391
395
                                        <reportElement style="encabezado_1" x="349" y="0" width="52" height="18"/>
392
396
                                        <textElement verticalAlignment="Middle">
393
397
                                                <font size="8"/>
394
398
                                        </textElement>
395
 
                                        <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_6}.equalsIgnoreCase("vacio")?$V{var1}:"Toneladas"]]></textFieldExpression>
 
399
                                        <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_6}.equalsIgnoreCase("vacio")?$V{var1}:"Toneladas "]]></textFieldExpression>
396
400
                                </textField>
397
401
                                <textField isBlankWhenNull="true">
398
402
                                        <reportElement style="encabezado_1" x="297" y="0" width="52" height="18"/>
399
403
                                        <textElement verticalAlignment="Middle">
400
404
                                                <font size="8"/>
401
405
                                        </textElement>
402
 
                                        <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_5}.equalsIgnoreCase("vacio")?$V{var1}:"Toneladas"]]></textFieldExpression>
 
406
                                        <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_5}.equalsIgnoreCase("vacio")?$V{var1}:"Toneladas "]]></textFieldExpression>
403
407
                                </textField>
404
408
                                <textField isBlankWhenNull="true">
405
409
                                        <reportElement style="encabezado_1" x="245" y="0" width="52" height="18"/>
406
410
                                        <textElement verticalAlignment="Middle">
407
411
                                                <font size="8"/>
408
412
                                        </textElement>
409
 
                                        <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_4}.equalsIgnoreCase("vacio")?$V{var1}:"Toneladas"]]></textFieldExpression>
 
413
                                        <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_4}.equalsIgnoreCase("vacio")?$V{var1}:"Toneladas "]]></textFieldExpression>
410
414
                                </textField>
411
415
                                <textField isBlankWhenNull="true">
412
416
                                        <reportElement style="encabezado_1" x="193" y="0" width="52" height="18"/>
413
417
                                        <textElement verticalAlignment="Middle">
414
418
                                                <font size="8"/>
415
419
                                        </textElement>
416
 
                                        <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_3}.equalsIgnoreCase("vacio")?$V{var1}:"Toneladas"]]></textFieldExpression>
 
420
                                        <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_3}.equalsIgnoreCase("vacio")?$V{var1}:"Toneladas "]]></textFieldExpression>
417
421
                                </textField>
418
422
                                <textField isBlankWhenNull="true">
419
423
                                        <reportElement style="encabezado_1" x="141" y="0" width="52" height="18"/>
420
424
                                        <textElement verticalAlignment="Middle">
421
425
                                                <font size="8"/>
422
426
                                        </textElement>
423
 
                                        <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_2}.equalsIgnoreCase("vacio")?$V{var1}:"Toneladas"]]></textFieldExpression>
 
427
                                        <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_2}.equalsIgnoreCase("vacio")?$V{var1}:"Toneladas "]]></textFieldExpression>
424
428
                                </textField>
425
429
                                <textField isBlankWhenNull="true">
426
430
                                        <reportElement style="encabezado_1" x="89" y="0" width="52" height="18"/>
427
431
                                        <textElement verticalAlignment="Middle">
428
432
                                                <font size="8"/>
429
433
                                        </textElement>
430
 
                                        <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_1}.equalsIgnoreCase("vacio")?$V{var1}:"Toneladas"]]></textFieldExpression>
 
434
                                        <textFieldExpression class="java.lang.String"><![CDATA[$P{pqty_1}.equalsIgnoreCase("vacio")?$V{var1}:"Toneladas "]]></textFieldExpression>
431
435
                                </textField>
432
436
                        </frame>
433
437
                        <frame>
458
462
                                        <textElement textAlignment="Right" verticalAlignment="Middle">
459
463
                                                <font size="7"/>
460
464
                                        </textElement>
461
 
                                        <textFieldExpression class="java.math.BigDecimal"><![CDATA[$P{pqty_3}.equalsIgnoreCase("vacio")?$V{var1}:$F{pqty_3}]]></textFieldExpression>
 
465
                                        <textFieldExpression class="java.math.BigDecimal"><![CDATA[$P{pqty_2}.equalsIgnoreCase("vacio")?$V{var1}:$F{pqty_2}]]></textFieldExpression>
462
466
                                </textField>
463
467
                                <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
464
468
                                        <reportElement style="celda_contenido" stretchType="RelativeToTallestObject" mode="Transparent" x="245" y="0" width="52" height="15"/>
533
537
                                <textField isStretchWithOverflow="true" isBlankWhenNull="true">
534
538
                                        <reportElement style="celda_contenido" stretchType="RelativeToTallestObject" x="611" y="0" width="357" height="15" isPrintWhenDetailOverflows="true"/>
535
539
                                        <textElement verticalAlignment="Middle">
536
 
                                                <font size="7"/>
 
540
                                                <font fontName="Serif" size="6"/>
537
541
                                        </textElement>
538
 
                                        <textFieldExpression class="java.lang.String"><![CDATA[$F{nota}]]></textFieldExpression>
 
542
                                        <textFieldExpression class="java.lang.String"><![CDATA[$F{nota}.equals(null) ? $V{var1} : " " + $F{nota}]]></textFieldExpression>
539
543
                                </textField>
540
544
                                <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
541
545
                                        <reportElement style="celda_contenido" stretchType="RelativeToTallestObject" mode="Transparent" x="453" y="0" width="52" height="15"/>