Jump to content
We've recently updated our Privacy Statement, available here ×

mauricio

Members
 View Profile  See their activity

  • Posts

    9

  • Joined

  • Last visited

 Content Type 

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Security Advisories

Downloads

Posts posted by mauricio

    My report is generating almost 400000 pages, that's wrong

    in Products

    Posted

    Hello, I've a report, which data source is a xml file, it contains references to images and the report embed this images, four images of about 100 Kb each

     

    Till today I was using IReport 4.1 with no problem, but this report given me the error

     

    Error filling print... java.lang.OutOfMemoryError: GC overhead limit exceeded null

     

    I've changed the file ~/iReport-4.1.3/etc/ireport.conf , -J-Xms256m -J-Xmx512m to

     

    default_options="--branding ireport -J-Xms512m -J-Xmx1024m -J-Dorg.netbeans.ProxyClassLoader.level=1000 -J-XX:MaxPermSize=512m"

     

    hoping this help, but no. So I decided to update Ireport and install Jaspersoft® Studio 6.1 final

     

    trying to run the report at Jaspersoft® Studio it starts , but generates about 400000 (yes, a lot) pages, when the report should have three or four pages

     

    may some one give some help on this, what should I do or look for

     

    also, if I remove the references to the images on xml file, the report loads pretty good on IReport 4.1

     

    I'll try to upload the source files (jrxml, xml)

     

    thanks in advance

     

    xml source file

    ###################

    <?xml version="1.0" encoding="UTF-8"?>

    <instalaciones type="array"><instalacion><instalacion_id>3541</instalacion_id><instalacion_codigo_cliente/><instalacion_codigo_va>PIU_39</instalacion_codigo_va><instalacion_nombre>Salas Eléctricas Sector Planta Flotación</instalacion_nombre><superficie>150.00</superficie><volumen/><destino>Industrial</destino><comentario/><imagen_logo><nombre>pelambres150x150.png</nombre><url>http://127.0.0.1/sites/default/files/empresa_logo/pelambres150x150.png</url><size>6654</size></imagen_logo><area_empresa_nombre>Los Piuquenes</area_empresa_nombre><area_empresa_acronimo>PIU</area_empresa_acronimo><faena_nombre>Los Pelambres </faena_nombre><cliente_nombre>Minera Los Pelambres</cliente_nombre><instalacion_ubicacion><latitude>-31.811615</latitude><longitude>-70.581287</longitude></instalacion_ubicacion><imagenes><imagen><nombre>salas_electricas_sector_planta_flotacion.jpg</nombre><url>http://127.0.0.1/sites/default/files/instalacion/salas_electricas_sector_planta_flotacion.jpg</url><size>104762</size></imagen></imagenes>

     

    <imagenes-planimetria type="array">

     

    <imagen-planimetria><imagen><nombre>planta.jpg</nombre><url>http://127.0.0.1/sites/default/files/planta_3.jpg</url><size>113390</size><title>PLANTAS DE ARQUITECTURA</title></imagen>

    </imagen-planimetria>

     


     


     

    </imagenes-planimetria>

     

    <permisos><permiso><permiso_coleccion_id>11144</permiso_coleccion_id><permiso_nombre>Permiso de Edificación de Obra Nueva</permiso_nombre><permiso_criticidad_nominal/><permiso_responsable_gestion>Mandante</permiso_responsable_gestion><permiso_estado_tramitacion>En trámite</permiso_estado_tramitacion><permiso_criticidad/><permiso_criticidad_contrato/><organismo_publico_nombre>Dirección de Obras Municipales</organismo_publico_nombre><organismo_publico_acronimo>DOM</organismo_publico_acronimo><permiso_comentario/><permiso_fecha_resolucion/><documentos_adjuntos/></permiso><permiso><permiso_coleccion_id>11146</permiso_coleccion_id><permiso_nombre>Recepción Definitiva de Obras de Edificación</permiso_nombre><permiso_criticidad_nominal>No crítico</permiso_criticidad_nominal><permiso_responsable_gestion>Mandante</permiso_responsable_gestion><permiso_estado_tramitacion>En proceso</permiso_estado_tramitacion><permiso_criticidad/><permiso_criticidad_contrato/><organismo_publico_nombre>Dirección de Obras Municipales</organismo_publico_nombre><organismo_publico_acronimo>DOM</organismo_publico_acronimo><permiso_comentario/><permiso_fecha_resolucion/><documentos_adjuntos/></permiso><permiso><permiso_coleccion_id>11148</permiso_coleccion_id><permiso_nombre>Declaración Instalación Eléctrica Interior</permiso_nombre><permiso_criticidad_nominal>Crítico</permiso_criticidad_nominal><permiso_responsable_gestion>Mandante</permiso_responsable_gestion><permiso_estado_tramitacion>En proceso</permiso_estado_tramitacion><permiso_criticidad/><permiso_criticidad_contrato/><organismo_publico_nombre>Superintendencia de Electricidad y Combustible</organismo_publico_nombre><organismo_publico_acronimo>SEC</organismo_publico_acronimo><permiso_comentario/><permiso_fecha_resolucion/><documentos_adjuntos/></permiso><permiso><permiso_coleccion_id>11150</permiso_coleccion_id><permiso_nombre>Informe Favorable para la Construcción (Ex CUS)</permiso_nombre><permiso_criticidad_nominal>Moderadamente crítico</permiso_criticidad_nominal><permiso_responsable_gestion>Mandante</permiso_responsable_gestion><permiso_estado_tramitacion>Tramitado</permiso_estado_tramitacion><permiso_criticidad/><permiso_criticidad_contrato/><organismo_publico_nombre>Servicio Agrícola y Ganadero</organismo_publico_nombre><organismo_publico_acronimo>SAG</organismo_publico_acronimo><permiso_comentario>Se fusionan los proyectos PIU_39 y PIU_40</permiso_comentario><permiso_fecha_resolucion>03/12/2015</permiso_fecha_resolucion><documentos_adjuntos><documento_adjunto><nombre>2015.12.03_res_ndeg119_minagri_ifc_sala_electrica_5b_y_sala_electrica_planta_de_flotacion.pdf</nombre><resolucion/><url>http://127.0.0.1/es/system/files/instalacion/2015.12.03_res_ndeg119_minagri_ifc_sala_electrica_5b_y_sala_electrica_planta_de_flotacion.pdf</url><size>70805</size></documento_adjunto></documentos_adjuntos></permiso></permisos></instalacion></instalaciones>


    ###################

     

    report file

    ###################

    <?xml version="1.0" encoding="UTF-8"?>

    <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="instalacion" pageWidth="612" pageHeight="792" columnWidth="552" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20">

    <property name="ireport.scriptlethandling" value="0"/>

    <property name="ireport.encoding" value="UTF-8"/>

    <property name="ireport.zoom" value="1.0"/>

    <property name="ireport.x" value="0"/>

    <property name="ireport.y" value="372"/>

    <import value="net.sf.jasperreports.engine.*"/>

    <import value="java.util.*"/>

    <import value="net.sf.jasperreports.engine.data.*"/>

    <style name="bordes">

    <box>

    <topPen lineWidth="0.25" lineStyle="Solid"/>

    <leftPen lineWidth="0.25" lineStyle="Solid"/>

    <bottomPen lineWidth="0.25" lineStyle="Solid"/>

    <rightPen lineWidth="0.25" lineStyle="Solid"/>

    </box>

    </style>

    <style name="paddingGeneral">

    <box topPadding="5" leftPadding="5" bottomPadding="5" rightPadding="5"/>

    </style>

    <subDataset name="permisos">

    <queryString language="xpath2">

    <![CDATA[/instalaciones/instalacion/permisos/permiso]]>

    </queryString>

    <field name="permiso_coleccion_id" class="java.lang.String">

    <fieldDescription><![CDATA[permiso_coleccion_id]]></fieldDescription>

    </field>

    <field name="permiso_nombre" class="java.lang.String">

    <fieldDescription><![CDATA[permiso_nombre]]></fieldDescription>

    </field>

    <field name="permiso_criticidad_nominal" class="java.lang.String">

    <fieldDescription><![CDATA[permiso_criticidad_nominal]]></fieldDescription>

    </field>

    <field name="permiso_responsable_gestion" class="java.lang.String">

    <fieldDescription><![CDATA[permiso_responsable_gestion]]></fieldDescription>

    </field>

    <field name="permiso_estado_tramitacion" class="java.lang.String">

    <fieldDescription><![CDATA[permiso_estado_tramitacion]]></fieldDescription>

    </field>

    <field name="permiso_criticidad" class="java.lang.String">

    <fieldDescription><![CDATA[permiso_criticidad]]></fieldDescription>

    </field>

    <field name="organismo_publico_nombre" class="java.lang.String">

    <fieldDescription><![CDATA[organismo_publico_nombre]]></fieldDescription>

    </field>

    <field name="organismo_publico_acronimo" class="java.lang.String">

    <fieldDescription><![CDATA[organismo_publico_acronimo]]></fieldDescription>

    </field>

    <field name="permiso_comentario" class="java.lang.String">

    <fieldDescription><![CDATA[permiso_comentario]]></fieldDescription>

    </field>

    <field name="permiso_fecha_resolucion" class="java.lang.String">

    <fieldDescription><![CDATA[permiso_fecha_resolucion]]></fieldDescription>

    </field>

    <field name="permiso_criticidad_contrato" class="java.lang.String">

    <fieldDescription><![CDATA[permiso_criticidad_contrato]]></fieldDescription>

    </field>

    <variable name="criticidad" class="java.lang.String">

    <variableExpression><![CDATA[$F{permiso_criticidad_contrato}==null?$F{permiso_criticidad_nominal}+"":$F{permiso_criticidad_contrato}+""]]></variableExpression>

    </variable>

    </subDataset>

    <subDataset name="adjuntos">

    <queryString language="xpath2">

    <![CDATA[/instalaciones/instalacion/permisos/permiso/documentos_adjuntos/documento_adjunto]]>

    </queryString>

    <field name="nombre" class="java.lang.String">

    <fieldDescription><![CDATA[nombre]]></fieldDescription>

    </field>

    <field name="resolucion" class="java.lang.String">

    <fieldDescription><![CDATA[resolucion]]></fieldDescription>

    </field>

    <field name="url" class="java.lang.String">

    <fieldDescription><![CDATA]></fieldDescription>































































































































































































































































































































































































































































































































































































































































































































































































































































































































































    is it possible to make a crosstab to be "float" horizontally ?

    in Products

    Posted

    Is it possible to make a crosstab to be "float" horizontally ?, so I can put two (or more) crosstabs one besides the other and get correct display. By now I'm getting overlapped crosstabs (using iReport 4.1.3 on Ubuntu 14.04 LTS)

    first crosstab (most left) expands and I can't know how much space it will takes, when I put a second crosstab to the right of the first one, both overlap

    any advice on how to get something similar is welcome

    thanks in advance

    Is it possible to merge two (or more) xpath2 dataset

    in Products

    Posted

    hello, I'm using iReport 4.1.3

    I have one report which data source is an xml file, so I'm using xpath2
     
    I'm interested on getting charts about the "request" node as total (count, state based on request properties inside each one)
     
    I can define 3 different datasets for each group of requests and get usefull info for each one, say:
    -root/requests
    -root/particular/requests
    -root/particular/more_particular/requests
     
    but I need now some way to merge all request and get info from them, as if I were looking a complete requests array, something as
     
    total/requests = ( root/requests + root/particular/requests + root/particular/more_particular/requests )
     
    each request has an id, no repeated data, all request have similar structure inside
     
    hope someone can help, thanks in advance
     
    xml file is structured similar to this
    <root>
    <particular>
    <requets>
    <request>
    <request>
    <request>
    </requests>
    <more_particular>
    <requets>
    <request>
    <request>
    </requests>
    </more_particular>
    </particular>
    <requets>
    <request>
    <request>
    </requests>
    </root>

    group sum total used to change group header style?

    in Products

    Posted

    hi all, I want to change (hopefully using styles, and no including subreports) the apepearance of a field (forecolor) placed at group header based on the results of a summatory of a field placed at detail band (something like: sum is positive value: green, sum is negative value: red)

     

    I have a report containing a group, for that group I'm using a variable (using a field value on details) to calculate the group total. I can show summatory total value at group header and group footer

     

    If I define a style to change the forecolor and apply that style to group header and group footer, just the group footer is changing as spected, so I think the style of the group header is applied before summatory is performed

     

    Is there a way to achieve that the group header change its forecolor based on the results of the summatory performed using the detail data?

     

    thanks in advance

    How to know total pages in a report

    in Products

    Posted

    hi

     

    do the jasperrepors masters have some idea of how to solve this issue??

     

    I mean, it's a very usefull skill to perform actions or take decisions at outer levels of report (headers), based on whats going on with detail report data, not just to be able of draw things based on it

     

    I've tried to solve it playing with subreports and retrieving values from them, but always face the same problem: variables placed at headers can't to react based on detail data

     

    please let me know if there's some way to bypass this issue

×
×
  • Create New...

© 2024 Cloud Software Group,
Inc. All rights reserved.

Products

Explore