Eclipse Community Forums: BIRT

Home » Archived » BIRT » Birt performance

Birt performance [message #361967]

Thu, 24 April 2008 11:05

Eclipse User

Hi !!

I'm facing a perfomance problem, a report with one row in one table,
takes about ten seconds to be displayed. This is unacceptable, thinking
that real report will contain about 1000 rows.

How can I improve birt performance?

Many thanks,
Hans.

Re: Birt performance [message #361970 is a reply to message #361967]

Thu, 24 April 2008 13:52

Eclipse User

Originally posted by: jasonweathersby.alltel.net

Hans,

Can you give us some more detail? What datasource are you using?
Can you post the report?

Jason

Hans wrote:
> Hi !!
>
> I'm facing a perfomance problem, a report with one row in one table,
> takes about ten seconds to be displayed. This is unacceptable, thinking
> that real report will contain about 1000 rows.
>
> How can I improve birt performance?
>
> Many thanks,
> Hans.

Re: Birt performance [message #361972 is a reply to message #361970]

Thu, 24 April 2008 14:53

Eclipse User

Jason,

I'm using a jdbc datasource and i call a stored procedure.

This is the report (now it has 2 tables)

------------------------

<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.15"
id="1">
<property name="createdBy">Eclipse BIRT Designer Version
2.3.0.v20080103 Build <2.3.0.v20080107-0800></property>
<property name="units">in</property>
<property name="comments">Copyright (c) 2007 <<Your Company
Name here>></property>
<html-property name="description">Creates a blank report with no
predefined content.</html-property>
<text-property name="displayName">Blank Report</text-property>
<property name="iconFile">/templates/blank_report.gif</property>
<list-property name="cssStyleSheets">
<structure>
<property name="fileName">otros/estilos-reportes.css</property>
</structure>
</list-property>
<parameters>
<scalar-parameter name="mesContable" id="2640">
<text-property name="helpText">mesContable</text-property>
<property name="valueType">static</property>
<property name="dataType">integer</property>
<property name="paramType">simple</property>
<text-property name="promptText">mesContable</text-property>
<property name="isRequired">true</property>
<property name="controlType">text-box</property>
<property name="defaultValue">1</property>
<property name="distinct">true</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="anioContable" id="2641">
<text-property name="helpText">anioContable</text-property>
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="paramType">simple</property>
<text-property name="promptText">anioContable</text-property>
<property name="isRequired">true</property>
<property name="controlType">text-box</property>
<property name="defaultValue">2008</property>
<property name="distinct">true</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="compania" id="2642">
<text-property name="helpText">compania</text-property>
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="paramType">simple</property>
<text-property name="promptText">compania</text-property>
<property name="isRequired">true</property>
<property name="controlType">text-box</property>
<property name="defaultValue">generales</property>
<property name="distinct">true</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="reaseguro" id="2643">
<text-property name="helpText">reaseguro</text-property>
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="paramType">simple</property>
<text-property name="promptText">reaseguro</text-property>
<property name="isRequired">true</property>
<property name="controlType">text-box</property>
<property name="defaultValue">n</property>
<property name="distinct">true</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="tipoProducto" id="2644">
<text-property name="helpText">tipoProducto</text-property>
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="paramType">simple</property>
<text-property name="promptText">tipoProducto</text-property>
<property name="isRequired">true</property>
<property name="controlType">text-box</property>
<property name="defaultValue">colectivo</property>
<property name="distinct">true</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="emitidor" id="2645">
<text-property name="helpText">emitidor</text-property>
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="paramType">simple</property>
<text-property name="promptText">emitidor</text-property>
<property name="controlType">text-box</property>
<property name="defaultValue">Anónimo</property>
<property name="distinct">true</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="valorUF" id="2646">
<text-property name="helpText">valorUF</text-property>
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="paramType">simple</property>
<text-property name="promptText">valorUF</text-property>
<property name="controlType">text-box</property>
<property name="defaultValue">18500</property>
<property name="distinct">true</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="esquema" id="3086">
<property name="hidden">false</property>
<text-property name="helpText">esquema</text-property>
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="paramType">simple</property>
<text-property name="promptText">esquema</text-property>
<property name="controlType">text-box</property>
<property name="defaultValue">CIERRESQA</property>
<property name="distinct">true</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="areaResponsable" id="4960">
<text-property name="helpText">areaResponsable</text-property>
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="paramType">simple</property>
<text-property
name="promptText">areaResponsable</text-property>
<property name="controlType">text-box</property>
<property name="defaultValue">no disponible</property>
<property name="distinct">true</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="jefeAreaResponsable" id="4961">
<text-property
name="helpText">jefeAreaResponsable</text-property>
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="paramType">simple</property>
<text-property
name="promptText">jefeAreaResponsable</text-property>
<property name="controlType">text-box</property>
<property name="defaultValue">no disponible</property>
<property name="distinct">true</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
</parameters>
<data-sources>
<oda-data-source
extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source"
id="2647">
<method name="beforeOpen"><![CDATA[importPackage(
Packages.javax.xml.parsers);
importPackage( Packages.org.xml.sax);
importPackage( Packages.org.w3c.dom);
importPackage( Packages.java.io);

function getTagValue(file, tagName)
{
factory = DocumentBuilderFactory.newInstance();
builder = factory.newDocumentBuilder();
document = builder.parse( new InputSource( new FileInputStream(
file )) );
nlist = document.getElementsByTagName(tagName);
return nlist.item(0).getFirstChild().getNodeValue();
}

try
{
this.setExtensionProperty("odaDriverClass",
getTagValue("c:/O2/Procesos/config-BIRT-Cierres/conf.xml",
"odaDriverClass"));
this.setExtensionProperty("odaURL",
getTagValue("c:/O2/Procesos/config-BIRT-Cierres/conf.xml", "odaURL"));
this.setExtensionProperty("odaUser",
getTagValue("c:/O2/Procesos/config-BIRT-Cierres/conf.xml", "odaUser"));
this.setExtensionProperty("odaPassword",
getTagValue("c:/O2/Procesos/config-BIRT-Cierres/conf.xml", "odaPassword"));
}
catch(e)
{
}]]></method>
<property
name="odaDriverClass">oracle.jdbc.driver.OracleDriver</property >
<property
name="odaURL">jdbc:oracle:thin:@caipirina.txp:1521:heracle2 </property>
<property name="odaUser">cierresdev</property>
<encrypted-property name="odaPassword"
encryptionID="base64">Y2llcnJlc2Rldg==</encrypted-property >
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.SPSelectDataSet "
name="Data Set" id="3247">
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">REGISTRO</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">DLR_RUTSOCIO</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">DLR_NOMBRESOCIO</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">PRIMAAFECTA</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">PRIMAEXENTA</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">IMPUESTO</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">PRIMABRUTA</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">PRIMAAFECTAMO</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">PRIMAEXENTAMO</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">IMPUESTOMO</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">PRIMABRUTAMO</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">DIFERENCIAPRIMAS</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">MONEDAORIGEN</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<method name="beforeOpen"><![CDATA[this.queryText = "{call
" + params["esquema"].value +
".PCK_LIBROS_RECAUDACIONES.PRC_GENRESRECXFACT(?,?,?,?,?,?)}"]] ></method>
<list-property name="parameters">
<structure>
<property name="name">EV_COMPANIA</property>
<property name="paramName">compania</property>
<property name="nativeName">EV_COMPANIA</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
<property name="position">1</property>
<property name="isOptional">true</property>
<property name="allowNull">true</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">EN_MESCONTABLE</property>
<property name="paramName">mesContable</property>
<property name="nativeName">EN_MESCONTABLE</property>
<property name="dataType">string</property>
<property name="nativeDataType">3</property>
<property name="position">2</property>
<property name="isOptional">true</property>
<property name="allowNull">true</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">EN_ANOCONTABLE</property>
<property name="paramName">anioContable</property>
<property name="nativeName">EN_ANOCONTABLE</property>
<property name="dataType">string</property>
<property name="nativeDataType">3</property>
<property name="position">3</property>
<property name="isOptional">true</property>
<property name="allowNull">true</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">EV_REASEGURO</property>
<property name="paramName">reaseguro</property>
<property name="nativeName">EV_REASEGURO</property>
<property name="dataType">string</property>
<property name="nativeDataType">1</property>
<property name="position">4</property>
<property name="isOptional">true</property>
<property name="allowNull">true</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">EV_TIPO</property>
<property name="paramName">tipoProducto</property>
<property name="nativeName">EV_TIPO</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
<property name="position">5</property>
<property name="isOptional">true</property>
<property name="allowNull">true</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">SC_RESUMEN</property>
<property name="nativeName">SC_RESUMEN</property>
<property name="dataType">any</property>
<property name="nativeDataType">-10</property>
<property name="position">6</property>
<property name="isOptional">false</property>
<property name="allowNull">true</property>
<property name="isOutput">true</property>
</structure>
</list-property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">REGISTRO</property>
<property name="nativeName">REGISTRO</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">DLR_RUTSOCIO</property>
<property name="nativeName">DLR_RUTSOCIO</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">DLR_NOMBRESOCIO</property>
<property name="nativeName">DLR_NOMBRESOCIO</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">PRIMAAFECTA</property>
<property name="nativeName">PRIMAAFECTA</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">PRIMAEXENTA</property>
<property name="nativeName">PRIMAEXENTA</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">IMPUESTO</property>
<property name="nativeName">IMPUESTO</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">PRIMABRUTA</property>
<property name="nativeName">PRIMABRUTA</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">PRIMAAFECTAMO</property>
<property name="nativeName">PRIMAAFECTAMO</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">PRIMAEXENTAMO</property>
<property name="nativeName">PRIMAEXENTAMO</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">IMPUESTOMO</property>
<property name="nativeName">IMPUESTOMO</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">PRIMABRUTAMO</property>
<property name="nativeName">PRIMABRUTAMO</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">DIFERENCIAPRIMAS</property>
<property name="nativeName">DIFERENCIAPRIMAS</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">MONEDAORIGEN</property>
<property name="nativeName">MONEDAORIGEN</property>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="queryText">{call
CIERRESQA.PCK_LIBROS_RECAUDACIONES.PRC_GENRESRECXFACT(?,?,?, ?,?,?)} </property>
<xml-property name="designerValues"><![CDATA[<?xml
version="1.0" encoding="UTF-8"?>
<model:DesignValues
xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design"
xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>1.0</Version>
<design:DataSetParameters>
<design:parameterDefinitions>
<design:inOutMode>In</design:inOutMode>
<design:attributes>
<design:name>EV_COMPANIA</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:inputAttributes>
<design:elementAttributes>
<design:optional>true</design:optional>
</design:elementAttributes>
</design:inputAttributes>
</design:parameterDefinitions>
<design:parameterDefinitions>
<design:inOutMode>In</design:inOutMode>
<design:attributes>
<design:name>EN_MESCONTABLE</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>3</design:nativeDataTypeCode>
<design:precision>22</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:inputAttributes>
<design:elementAttributes>
<design:optional>true</design:optional>
</design:elementAttributes>
</design:inputAttributes>
</design:parameterDefinitions>
<design:parameterDefinitions>
<design:inOutMode>In</design:inOutMode>
<design:attributes>
<design:name>EN_ANOCONTABLE</design:name>
<design:position>3</design:position>
<design:nativeDataTypeCode>3</design:nativeDataTypeCode>
<design:precision>22</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:inputAttributes>
<design:elementAttributes>
<design:optional>true</design:optional>
</design:elementAttributes>
</design:inputAttributes>
</design:parameterDefinitions>
<design:parameterDefinitions>
<design:inOutMode>In</design:inOutMode>
<design:attributes>
<design:name>EV_REASEGURO</design:name>
<design:position>4</design:position>
<design:nativeDataTypeCode>1</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:inputAttributes>
<design:elementAttributes>
<design:optional>true</design:optional>
</design:elementAttributes>
</design:inputAttributes>
</design:parameterDefinitions>
<design:parameterDefinitions>
<design:inOutMode>In</design:inOutMode>
<design:attributes>
<design:name>EV_TIPO</design:name>
<design:position>5</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:inputAttributes>
<design:elementAttributes>
<design:optional>true</design:optional>
</design:elementAttributes>
</design:inputAttributes>
</design:parameterDefinitions>
<design:parameterDefinitions>
<design:inOutMode>Out</design:inOutMode>
<design:attributes>
<design:name>SC_RESUMEN</design:name>
<design:position>6</design:position>
<design:nativeDataTypeCode>-10</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
</design:parameterDefinitions>
</design:DataSetParameters>
</model:DesignValues>]]></xml-property>
</oda-data-set>
</data-sets>
<styles>
<style name="crosstab-cell" id="4">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
<style name="crosstab" id="5">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
<style name="cuadro" id="1767">
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
</style>
<style name="cuerpo-reporte" id="1768">
<property name="fontFamily">"Arial"</property>
<property name="fontSize">x-small</property>
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">#,##0</property>
</structure>
</style>
<style name="grupo-footer" id="1938">
<property name="borderBottomStyle">none</property>
<property name="borderBottomWidth">thin</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
</style>
<style name="tabla-aux" id="1939">
<property name="paddingTop">0pt</property>
<property name="paddingLeft">0pt</property>
<property name="paddingBottom">0pt</property>
<property name="paddingRight">0pt</property>
</style>
<style name="tabla-cabecera" id="1764">
<property name="backgroundColor">#000000</property>
<property name="fontFamily">"Arial"</property>
<property name="fontSize">x-small</property>
<property name="fontWeight">bold</property>
<property name="color">#FFFFFF</property>
<property name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderLeftColor">#000000</property>
<property name="borderLeftStyle">solid</property>
<property name="borderRightColor">#000000</property>
<property name="borderRightStyle">solid</property>
<property name="borderTopColor">#000000</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<property name="textAlign">center</property>
<property name="canShrink">false</property>
</style>
<style name="tabla-detalle-celda" id="1765">
<property name="backgroundColor">#FFFFFF</property>
<property name="fontFamily">"Arial"</property>
<property name="fontSize">x-small</property>
<property name="color">#000000</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopStyle">none</property>
<property name="borderTopWidth">medium</property>
<property name="textAlign">center</property>
</style>
<style name="tabla-footer" id="1766">
<property name="backgroundColor">#93BE95</property>
<property name="fontFamily">sans-serif</property>
<property name="fontSize">x-small</property>
<property name="fontWeight">bold</property>
<property name="color">#FFFFE0</property>
<property name="borderBottomColor">#483D8B</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftColor">#483D8B</property>
<property name="borderRightColor">#483D8B</property>
<property name="borderTopColor">#483D8B</property>
<property name="borderTopStyle">double</property>
</style>
<style name="annio" id="4179">
<structure name="numberFormat">
<property name="category">Custom</property>
<property name="pattern">####</property>
</structure>
</style>
<style name="decimal2" id="4180">
<structure name="numberFormat">
<property name="category">Fixed</property>
<property name="pattern">#,##0.00</property>
</structure>
</style>
<style name="fechaDDMMYYYY" id="4178">
<structure name="dateTimeFormat">
<property name="category">Custom</property>
<property name="pattern">dd/MM/YYYY</property>
</structure>
</style>
<style name="numberAlignment" id="4181">
<property name="textAlign">right</property>
</style>
<style name="monto-mo" id="4959">
<structure name="numberFormat">
<property name="category">Fixed</property>
<property name="pattern">#,##0.00</property>
</structure>
</style>
<style name="monto-pesos" id="4958">
<structure name="numberFormat">
<property name="category">Fixed</property>
<property name="pattern">#,##0</property>
</structure>
</style>
</styles>
<page-setup>
<simple-master-page name="Simple MasterPage" id="2">
<property name="type">custom</property>
<property name="height">12in</property>
<property name="width">20in</property>
<property name="style">cuerpo-reporte</property>
</simple-master-page>
</page-setup>
<body>
<grid id="2240">
<property name="style">cuerpo-reporte</property>
<property name="numberAlign">right</property>
<property name="width">100%</property>
<column id="2241"/>
<column id="2242"/>
<column id="2243"/>
<column id="2244"/>
<column id="2245"/>
<column id="2246"/>
<column id="2247"/>
<column id="2248"/>
<column id="2249"/>
<column id="2250"/>
<column id="2251"/>
<column id="2252"/>
<column id="2253"/>
<column id="2254"/>
<column id="2255"/>
<column id="2256"/>
<column id="2257"/>
<column id="2258"/>
<column id="2259"/>
<row id="2260">
<cell id="2261">
<property name="colSpan">4</property>
<property name="rowSpan">1</property>
<data id="3093">
<property name="fontWeight">bold</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">encabezado</property>
<expression name="expression">'Compañía
de Seguros ' + params["compania"].toUpperCase() + ' Cardif S.A'</expression>
<property name="dataType">any</property>
</structure>
</list-property>
<property
name="resultSetColumn">encabezado</property>
</data>
</cell>
<cell id="2265"/>
<cell id="2266"/>
<cell id="2267"/>
<cell id="2268"/>
<cell id="2269"/>
<cell id="2270"/>
<cell id="2271"/>
<cell id="2272"/>
<cell id="2273"/>
<cell id="2274"/>
<cell id="2275"/>
<cell id="2276"/>
<cell id="2277"/>
<cell id="2278"/>
<cell id="2279"/>
</row>
<row id="2280">
<cell id="2281">
<property name="colSpan">3</property>
<property name="rowSpan">1</property>
<data id="4176">
<property name="fontWeight">bold</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">Rut</property>
<expression name="expression">if (
params["compania"].toUpperCase() == 'VIDA')
'96837630-6'
else
'96837640-3'</expression>
<property name="dataType">any</property>
</structure>
</list-property>
<property name="resultSetColumn">Rut</property>
</data>
</cell>
<cell id="2284"/>
<cell id="2285"/>
<cell id="2286"/>
<cell id="2287"/>
<cell id="2288"/>
<cell id="2289"/>
<cell id="2290"/>
<cell id="2291"/>
<cell id="2292"/>
<cell id="2293"/>
<cell id="2294"/>
<cell id="2295"/>
<cell id="2296"/>
<cell id="2297"/>
<cell id="2298"/>
<cell id="2299"/>
</row>
<row id="2300">
<cell id="2301"/>
<cell id="2302"/>
<cell id="2303"/>
<cell id="2304"/>
<cell id="2305"/>
<cell id="2306"/>
<cell id="2307"/>
<cell id="2308"/>
<cell id="2309"/>
<cell id="2310"/>
<cell id="2311"/>
<cell id="2312"/>
<cell id="2313"/>
<cell id="2314"/>
<cell id="2315"/>
<cell id="2316"/>
<cell id="2317"/>
<cell id="2318"/>
<cell id="2319"/>
</row>
<row id="2320">
<cell id="2321"/>
<cell id="2322">
<property name="colSpan">4</property>
<property name="rowSpan">1</property>
<data id="1936">
<property name="fontWeight">bold</property>
<property name="textAlign">center</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">titulo</property>
<property
name="displayName">titulo</property>
<expression name="expression">var mes =
params["mesContable"];
var smes = '';

if (mes<10)
smes='0' + mes;
else
smes=mes;

'RESUMEN RECAUDACIÓN POR TIPO DE FACTURACION ' + smes + '/' +
params["anioContable"];</expression>
<property name="dataType">any</property>
</structure>
</list-property>
<property name="resultSetColumn">titulo</property>
</data>
</cell>
<cell id="2326"/>
<cell id="2327"/>
<cell id="2328"/>
<cell id="2329"/>
<cell id="2330"/>
<cell id="2331"/>
<cell id="2332"/>
<cell id="2333"/>
<cell id="2334"/>
<cell id="2335"/>
<cell id="2336"/>
<cell id="2337"/>
<cell id="2338"/>
<cell id="2339"/>
</row>
<row id="2340">
<cell id="2341"/>
<cell id="2342">
<property name="colSpan">4</property>
<property name="rowSpan">1</property>
<data id="3204">
<property name="fontWeight">bold</property>
<property name="textAlign">center</property>
<list-property name="boundDataColumns">
<structure>
<property
name="name">tipoReporte</property>
<expression
name="expression">params["tipoProducto"].toUpperCase()</expression >
<property name="dataType">any</property>
</structure>
</list-property>
<property
name="resultSetColumn">tipoReporte</property>
</data>
</cell>
<cell id="2346"/>
<cell id="2347"/>
<cell id="2348"/>
<cell id="2349"/>
<cell id="2350"/>
<cell id="2351"/>
<cell id="2352"/>
<cell id="2353"/>
<cell id="2354"/>
<cell id="2355"/>
<cell id="2356"/>
<cell id="2357"/>
<cell id="2358"/>
<cell id="2359"/>
</row>
<row id="2360">
<cell id="2361"/>
<cell id="2362"/>
<cell id="2363"/>
<cell id="2364"/>
<cell id="2365"/>
<cell id="2366"/>
<cell id="2367"/>
<cell id="2368"/>
<cell id="2369"/>
<cell id="2370"/>
<cell id="2371"/>
<cell id="2372"/>
<cell id="2373"/>
<cell id="2374"/>
<cell id="2375"/>
<cell id="2376"/>
<cell id="2377"/>
<cell id="2378"/>
<cell id="2379"/>
</row>
<row id="2380">
<cell id="2381"/>
<cell id="2382"/>
<cell id="2383"/>
<cell id="2384"/>
<cell id="2385"/>
<cell id="2386"/>
<cell id="2387"/>
<cell id="2388"/>
<cell id="2389"/>
<cell id="2390"/>
<cell id="2391"/>
<cell id="2392"/>
<cell id="2393"/>
<cell id="2394"/>
<cell id="2395"/>
<cell id="2396"/>
<cell id="2397"/>
<cell id="2398"/>
<cell id="2399"/>
</row>
<row id="2400">
<cell id="2401">
<property name="colSpan">19</property>
<property name="rowSpan">1</property>
<table id="2649">
<list-property name="mapRules">
<structure>
<expression
name="testExpr">row["PRIMABRUTA"]</expression>

Re: Birt performance [message #361975 is a reply to message #361972]

Thu, 24 April 2008 15:34

Eclipse User

Originally posted by: jasonweathersby.alltel.net

Hans,

Looking at the xml for the report, it appears that the data set is bound
to 13 tables. I did not check to see if you where hiding or dropping
any of the tables, but you may want to look at the binding tab on each
table and just bind the first table to the data set, and then bind the
others to the first table. Doing that should speed it up. Remember
that you have to name the first table.

You can also add a script to the onFetch of your dataset to see how many
times it is being called:

importPackage( Packages.java.io );
out = new PrintWriter( new FileWriter( "c:/temp/fetchevents.txt", true ) );
out.println( "anotherFetch");
out.close();

Also how long is the SP taking to run?

Jason

Hans wrote:
> Jason,
>
> I'm using a jdbc datasource and i call a stored procedure.
>
> This is the report (now it has 2 tables)
>
> ------------------------
>
> <?xml version="1.0" encoding="UTF-8"?>
> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.15"
> id="1">
> <property name="createdBy">Eclipse BIRT Designer Version
> 2.3.0.v20080103 Build <2.3.0.v20080107-0800></property>
> <property name="units">in</property>
> <property name="comments">Copyright (c) 2007 <<Your Company
> Name here>></property>
> <html-property name="description">Creates a blank report with no
> predefined content.</html-property>
> <text-property name="displayName">Blank Report</text-property>
> <property name="iconFile">/templates/blank_report.gif</property>
> <list-property name="cssStyleSheets">
> <structure>
> <property name="fileName">otros/estilos-reportes.css</property>
> </structure>
> </list-property>
> <parameters>
> <scalar-parameter name="mesContable" id="2640">
> <text-property name="helpText">mesContable</text-property>
> <property name="valueType">static</property>
> <property name="dataType">integer</property>
> <property name="paramType">simple</property>
> <text-property name="promptText">mesContable</text-property>
> <property name="isRequired">true</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue">1</property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="anioContable" id="2641">
> <text-property name="helpText">anioContable</text-property>
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <text-property name="promptText">anioContable</text-property>
> <property name="isRequired">true</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue">2008</property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="compania" id="2642">
> <text-property name="helpText">compania</text-property>
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <text-property name="promptText">compania</text-property>
> <property name="isRequired">true</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue">generales</property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="reaseguro" id="2643">
> <text-property name="helpText">reaseguro</text-property>
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <text-property name="promptText">reaseguro</text-property>
> <property name="isRequired">true</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue">n</property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="tipoProducto" id="2644">
> <text-property name="helpText">tipoProducto</text-property>
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <text-property name="promptText">tipoProducto</text-property>
> <property name="isRequired">true</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue">colectivo</property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="emitidor" id="2645">
> <text-property name="helpText">emitidor</text-property>
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <text-property name="promptText">emitidor</text-property>
> <property name="controlType">text-box</property>
> <property name="defaultValue">Anónimo</property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="valorUF" id="2646">
> <text-property name="helpText">valorUF</text-property>
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <text-property name="promptText">valorUF</text-property>
> <property name="controlType">text-box</property>
> <property name="defaultValue">18500</property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="esquema" id="3086">
> <property name="hidden">false</property>
> <text-property name="helpText">esquema</text-property>
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <text-property name="promptText">esquema</text-property>
> <property name="controlType">text-box</property>
> <property name="defaultValue">CIERRESQA</property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="areaResponsable" id="4960">
> <text-property name="helpText">areaResponsable</text-property>
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <text-property
> name="promptText">areaResponsable</text-property>
> <property name="controlType">text-box</property>
> <property name="defaultValue">no disponible</property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="jefeAreaResponsable" id="4961">
> <text-property
> name="helpText">jefeAreaResponsable</text-property>
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <text-property
> name="promptText">jefeAreaResponsable</text-property>
> <property name="controlType">text-box</property>
> <property name="defaultValue">no disponible</property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> </parameters>
> <data-sources>
> <oda-data-source
> extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source"
> id="2647">
> <method name="beforeOpen"><![CDATA[importPackage(
> Packages.javax.xml.parsers);
> importPackage( Packages.org.xml.sax);
> importPackage( Packages.org.w3c.dom);
> importPackage( Packages.java.io);
>
> function getTagValue(file, tagName)
> {
> factory = DocumentBuilderFactory.newInstance();
> builder = factory.newDocumentBuilder();
> document = builder.parse( new InputSource( new FileInputStream( file
> )) );
> nlist = document.getElementsByTagName(tagName);
> return nlist.item(0).getFirstChild().getNodeValue();
> }
>
> try
> {
> this.setExtensionProperty("odaDriverClass",
> getTagValue("c:/O2/Procesos/config-BIRT-Cierres/conf.xml",
> "odaDriverClass"));
> this.setExtensionProperty("odaURL",
> getTagValue("c:/O2/Procesos/config-BIRT-Cierres/conf.xml", "odaURL"));
> this.setExtensionProperty("odaUser",
> getTagValue("c:/O2/Procesos/config-BIRT-Cierres/conf.xml", "odaUser"));
> this.setExtensionProperty("odaPassword",
> getTagValue("c:/O2/Procesos/config-BIRT-Cierres/conf.xml", "odaPassword"));
> }
> catch(e)
> {
> }]]></method>
> <property
> name="odaDriverClass">oracle.jdbc.driver.OracleDriver</property >
> <property
> name="odaURL">jdbc:oracle:thin:@caipirina.txp:1521:heracle2 </property>
> <property name="odaUser">cierresdev</property>
> <encrypted-property name="odaPassword"
> encryptionID="base64">Y2llcnJlc2Rldg==</encrypted-property >
> </oda-data-source>
> </data-sources>
> <data-sets>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.SPSelectDataSet "
> name="Data Set" id="3247">
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">REGISTRO</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">DLR_RUTSOCIO</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">DLR_NOMBRESOCIO</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">PRIMAAFECTA</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">PRIMAEXENTA</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">IMPUESTO</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">PRIMABRUTA</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">8</property>
> <property name="name">PRIMAAFECTAMO</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">9</property>
> <property name="name">PRIMAEXENTAMO</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">10</property>
> <property name="name">IMPUESTOMO</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">11</property>
> <property name="name">PRIMABRUTAMO</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">12</property>
> <property name="name">DIFERENCIAPRIMAS</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">13</property>
> <property name="name">MONEDAORIGEN</property>
> <property name="dataType">string</property>
> </structure>
> </list-property>
> </structure>
> <property name="dataSource">Data Source</property>
> <method name="beforeOpen"><![CDATA[this.queryText = "{call "
> + params["esquema"].value +
> ".PCK_LIBROS_RECAUDACIONES.PRC_GENRESRECXFACT(?,?,?,?,?,?)}"]] ></method>
> <list-property name="parameters">
> <structure>
> <property name="name">EV_COMPANIA</property>
> <property name="paramName">compania</property>
> <property name="nativeName">EV_COMPANIA</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> <property name="position">1</property>
> <property name="isOptional">true</property>
> <property name="allowNull">true</property>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> <structure>
> <property name="name">EN_MESCONTABLE</property>
> <property name="paramName">mesContable</property>
> <property name="nativeName">EN_MESCONTABLE</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">3</property>
> <property name="position">2</property>
> <property name="isOptional">true</property>
> <property name="allowNull">true</property>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> <structure>
> <property name="name">EN_ANOCONTABLE</property>
> <property name="paramName">anioContable</property>
> <property name="nativeName">EN_ANOCONTABLE</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">3</property>
> <property name="position">3</property>
> <property name="isOptional">true</property>
> <property name="allowNull">true</property>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> <structure>
> <property name="name">EV_REASEGURO</property>
> <property name="paramName">reaseguro</property>
> <property name="nativeName">EV_REASEGURO</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">1</property>
> <property name="position">4</property>
> <property name="isOptional">true</property>
> <property name="allowNull">true</property>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> <structure>
> <property name="name">EV_TIPO</property>
> <property name="paramName">tipoProducto</property>
> <property name="nativeName">EV_TIPO</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> <property name="position">5</property>
> <property name="isOptional">true</property>
> <property name="allowNull">true</property>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> <structure>
> <property name="name">SC_RESUMEN</property>
> <property name="nativeName">SC_RESUMEN</property>
> <property name="dataType">any</property>
> <property name="nativeDataType">-10</property>
> <property name="position">6</property>
> <property name="isOptional">false</property>
> <property name="allowNull">true</property>
> <property name="isOutput">true</property>
> </structure>
> </list-property>
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">REGISTRO</property>
> <property name="nativeName">REGISTRO</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">DLR_RUTSOCIO</property>
> <property name="nativeName">DLR_RUTSOCIO</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">DLR_NOMBRESOCIO</property>
> <property name="nativeName">DLR_NOMBRESOCIO</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">PRIMAAFECTA</property>
> <property name="nativeName">PRIMAAFECTA</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">PRIMAEXENTA</property>
> <property name="nativeName">PRIMAEXENTA</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">IMPUESTO</property>
> <property name="nativeName">IMPUESTO</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">PRIMABRUTA</property>
> <property name="nativeName">PRIMABRUTA</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">8</property>
> <property name="name">PRIMAAFECTAMO</property>
> <property name="nativeName">PRIMAAFECTAMO</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">9</property>
> <property name="name">PRIMAEXENTAMO</property>
> <property name="nativeName">PRIMAEXENTAMO</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">10</property>
> <property name="name">IMPUESTOMO</property>
> <property name="nativeName">IMPUESTOMO</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">11</property>
> <property name="name">PRIMABRUTAMO</property>
> <property name="nativeName">PRIMABRUTAMO</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">12</property>
> <property name="name">DIFERENCIAPRIMAS</property>
> <property name="nativeName">DIFERENCIAPRIMAS</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">13</property>
> <property name="name">MONEDAORIGEN</property>
> <property name="nativeName">MONEDAORIGEN</property>
> <property name="dataType">string</property>
> </structure>
> </list-property>
> <property name="queryText">{call
> CIERRESQA.PCK_LIBROS_RECAUDACIONES.PRC_GENRESRECXFACT(?,?,?, ?,?,?)} </property>
>
> <xml-property name="designerValues"><![CDATA[<?xml
> version="1.0" encoding="UTF-8"?>
> <model:DesignValues
> xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design"
> xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
> <Version>1.0</Version>
> <design:DataSetParameters>
> <design:parameterDefinitions>
> <design:inOutMode>In</design:inOutMode>
> <design:attributes>
> <design:name>EV_COMPANIA</design:name>
> <design:position>1</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>0</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> </design:attributes>
> <design:inputAttributes>
> <design:elementAttributes>
> <design:optional>true</design:optional>
> </design:elementAttributes>
> </design:inputAttributes>
> </design:parameterDefinitions>
> <design:parameterDefinitions>
> <design:inOutMode>In</design:inOutMode>
> <design:attributes>
> <design:name>EN_MESCONTABLE</design:name>
> <design:position>2</design:position>
> <design:nativeDataTypeCode>3</design:nativeDataTypeCode>
> <design:precision>22</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> </design:attributes>
> <design:inputAttributes>
> <design:elementAttributes>
> <design:optional>true</design:optional>
> </design:elementAttributes>
> </design:inputAttributes>
> </design:parameterDefinitions>
> <design:parameterDefinitions>
> <design:inOutMode>In</design:inOutMode>
> <design:attributes>
> <design:name>EN_ANOCONTABLE</design:name>
> <design:position>3</design:position>
> <design:nativeDataTypeCode>3</design:nativeDataTypeCode>
> <design:precision>22</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> </design:attributes>
> <design:inputAttributes>
> <design:elementAttributes>
> <design:optional>true</design:optional>
> </design:elementAttributes>
> </design:inputAttributes>
> </design:parameterDefinitions>
> <design:parameterDefinitions>
> <design:inOutMode>In</design:inOutMode>
> <design:attributes>
> <design:name>EV_REASEGURO</design:name>
> <design:position>4</design:position>
> <design:nativeDataTypeCode>1</design:nativeDataTypeCode>
> <design:precision>0</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> </design:attributes>
> <design:inputAttributes>
> <design:elementAttributes>
> <design:optional>true</design:optional>
> </design:elementAttributes>
> </design:inputAttributes>
> </design:parameterDefinitions>
> <design:parameterDefinitions>
> <design:inOutMode>In</design:inOutMode>
> <design:attributes>
> <design:name>EV_TIPO</design:name>
> <design:position>5</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>0</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> </design:attributes>
> <design:inputAttributes>
> <design:elementAttributes>
> <design:optional>true</design:optional>
> </design:elementAttributes>
> </design:inputAttributes>
> </design:parameterDefinitions>
> <design:parameterDefinitions>
> <design:inOutMode>Out</design:inOutMode>
> <design:attributes>
> <design:name>SC_RESUMEN</design:name>
> <design:position>6</design:position>
> <design:nativeDataTypeCode>-10</design:nativeDataTypeCode>
> <design:precision>0</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> </design:attributes>
> </design:parameterDefinitions>
> </design:DataSetParameters>
> </model:DesignValues>]]></xml-property>
> </oda-data-set>
> </data-sets>
> <styles>
> <style name="crosstab-cell" id="4">
> <property name="borderBottomColor">#CCCCCC</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">1pt</property>
> <property name="borderLeftColor">#CCCCCC</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">1pt</property>
> <property name="borderRightColor">#CCCCCC</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">1pt</property>
> <property name="borderTopColor">#CCCCCC</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">1pt</property>
> </style>
> <style name="crosstab" id="5">
> <property name="borderBottomColor">#CCCCCC</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">1pt</property>
> <property name="borderLeftColor">#CCCCCC</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">1pt</property>
> <property name="borderRightColor">#CCCCCC</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">1pt</property>
> <property name="borderTopColor">#CCCCCC</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">1pt</property>
> </style>
> <style name="cuadro" id="1767">
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> </style>
> <style name="cuerpo-reporte" id="1768">
> <property name="fontFamily">"Arial"</property>
> <property name="fontSize">x-small</property>
> <structure name="numberFormat">
> <property name="category">Currency</property>
> <property name="pattern">#,##0</property>
> </structure>
> </style>
> <style name="grupo-footer" id="1938">
> <property name="borderBottomStyle">none</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> </style>
> <style name="tabla-aux" id="1939">
> <property name="paddingTop">0pt</property>
> <property name="paddingLeft">0pt</property>
> <property name="paddingBottom">0pt</property>
> <property name="paddingRight">0pt</property>
> </style>
> <style name="tabla-cabecera" id="1764">
> <property name="backgroundColor">#000000</property>
> <property name="fontFamily">"Arial"</property>
> <property name="fontSize">x-small</property>
> <property name="fontWeight">bold</property>
> <property name="color">#FFFFFF</property>
> <property name="borderBottomColor">#000000</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderLeftColor">#000000</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderRightColor">#000000</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderTopColor">#000000</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <property name="textAlign">center</property>
> <property name="canShrink">false</property>
> </style>
> <style name="tabla-detalle-celda" id="1765">
> <property name="backgroundColor">#FFFFFF</property>
> <property name="fontFamily">"Arial"</property>
> <property name="fontSize">x-small</property>
> <property name="color">#000000</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopStyle">none</property>
> <property name="borderTopWidth">medium</property>
> <property name="textAlign">center</property>
> </style>
> <style name="tabla-footer" id="1766">
> <property name="backgroundColor">#93BE95</property>
> <property name="fontFamily">sans-serif</property>
> <property name="fontSize">x-small</property>
> <property name="fontWeight">bold</property>
> <property name="color">#FFFFE0</property>
> <property name="borderBottomColor">#483D8B</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftColor">#483D8B</property>
> <property name="borderRightColor">#483D8B</property>
> <property name="borderTopColor">#483D8B</property>
> <property name="borderTopStyle">double</property>
> </style>
> <style name="annio" id="4179">
> <structure name="numberFormat">
> <property name="category">Custom</property>
> <property name="pattern">####</property>
> </structure>
> </style>
> <style name="decimal2" id="4180">
> <structure name="numberFormat">
> <property name="category">Fixed</property>
> <property name="pattern">#,##0.00</property>
> </structure>
> </style>
> <style name="fechaDDMMYYYY" id="4178">
> <structure name="dateTimeFormat">
> <property name="category">Custom</property>
> <property name="pattern">dd/MM/YYYY</property>
> </structure>
> </style>
> <style name="numberAlignment" id="4181">
> <property name="textAlign">right</property>
> </style>
> <style name="monto-mo" id="4959">
> <structure name="numberFormat">
> <property name="category">Fixed</property>
> <property name="pattern">#,##0.00</property>
> </structure>
> </style>
> <style name="monto-pesos" id="4958">
> <structure name="numberFormat">
> <property name="category">Fixed</property>
> <property name="pattern">#,##0</property>
> </structure>
> </style>
> </styles>
> <page-setup>
> <simple-master-page name="Simple MasterPage" id="2">
> <property name="type">custom</property>
> <property name="height">12in</property>
> <property name="width">20in</property>
> <property name="style">cuerpo-reporte</property>
> </simple-master-page>
> </page-setup>
> <body>
> <grid id="2240">
> <property name="style">cuerpo-reporte</property>
> <property name="numberAlign">right</property>
> <property name="width">100%</property>
> <column id="2241"/>
> <column id="2242"/>
> <column id="2243"/>
> <column id="2244"/>
> <column id="2245"/>
> <column id="2246"/>
> <column id="2247"/>
> <column id="2248"/>
> <column id="2249"/>
> <column id="2250"/>
> <column id="2251"/>
> <column id="2252"/>
> <column id="2253"/>
> <column id="2254"/>
> <column id="2255"/>
> <column id="2256"/>
> <column id="2257"/>
> <column id="2258"/>
> <column id="2259"/>
> <row id="2260">
> <cell id="2261">
> <property name="colSpan">4</property>
> <property name="rowSpan">1</property>
> <data id="3093">
> <property name="fontWeight">bold</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">encabezado</property>
> <expression name="expression">'Compañía
> de Seguros ' + params["compania"].toUpperCase() + ' Cardif
> S.A'</expression>
> <property name="dataType">any</property>
> </structure>
> </list-property>
> <property
> name="resultSetColumn">encabezado</property>
> </data>
> </cell>
> <cell id="2265"/>
> <cell id="2266"/>
> <cell id="2267"/>
> <cell id="2268"/>
> <cell id="2269"/>
> <cell id="2270"/>
> <cell id="2271"/>
> <cell id="2272"/>
> <cell id="2273"/>
> <cell id="2274"/>
> <cell id="2275"/>
> <cell id="2276"/>
> <cell id="2277"/>
> <cell id="2278"/>
> <cell id="2279"/>
> </row>
> <row id="2280">
> <cell id="2281">
> <property name="colSpan">3</property>
> <property name="rowSpan">1</property>
> <data id="4176">
> <property name="fontWeight">bold</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">Rut</property>
> <expression name="expression">if (
> params["compania"].toUpperCase() == 'VIDA')
> '96837630-6'
> else
> '96837640-3'</expression>
> <property name="dataType">any</property>
> </structure>
> </list-property>
> <property name="resultSetColumn">Rut</property>
> </data>
> </cell>
> <cell id="2284"/>
> <cell id="2285"/>
> <cell id="2286"/>
> <cell id="2287"/>
> <cell id="2288"/>
> <cell id="2289"/>
> <cell id="2290"/>
> <cell id="2291"/>
> <cell id="2292"/>
> <cell id="2293"/>
> <cell id="2294"/>
> <cell id="2295"/>
> <cell id="2296"/>
> <cell id="2297"/>
> <cell id="2298"/>
> <cell id="2299"/>
> </row>
> <row id="2300">
> <cell id="2301"/>
> <cell id="2302"/>
> <cell id="2303"/>
> <cell id="2304"/>
> <cell id="2305"/>
> <cell id="2306"/>
> <cell id="2307"/>
> <cell id="2308"/>
> <cell id="2309"/>
> <cell id="2310"/>
> <cell id="2311"/>
> <cell id="2312"/>
> <cell id="2313"/>
> <cell id="2314"/>
> <cell id="2315"/>
> <cell id="2316"/>
> <cell id="2317"/>
> <cell id="2318"/>
> <cell id="2319"/>
> </row>
> <row id="2320">
> <cell id="2321"/>
> <cell id="2322">
> <property name="colSpan">4</property>
> <property name="rowSpan">1</property>
> <data id="1936">
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">titulo</property>
> <property
> name="displayName">titulo</property>
> <expression name="expression">var mes =
> params["mesContable"];
> var smes = '';
>
> if (mes<10)
> smes='0' + mes;
> else
> smes=mes;
>
> 'RESUMEN RECAUDACIÓN POR TIPO DE FACTURACION ' + smes + '/' +
> params["anioContable"];</expression>
> <property name="dataType">any</property>
> </structure>
> </list-property>
> <property name="resultSetColumn">titulo</property>
> </data>
> </cell>
> <cell id="2326"/>
> <cell id="2327"/>
> <cell id="2328"/>
> <cell id="2329"/>
> <cell id="2330"/>
> <cell id="2331"/>
> <cell id="2332"/>
> <cell id="2333"/>
> <cell id="2334"/>
> <cell id="2335"/>
> <cell id="2336"/>
> <cell id="2337"/>
> <cell id="2338"/>
> <cell id="2339"/>
> </row>
> <row id="2340">
> <cell id="2341"/>
> <cell id="2342">
> <property name="colSpan">4</property>
> <property name="rowSpan">1</property>
> <data id="3204">
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> <list-property name="boundDataColumns">
> <

Re: Birt performance [message #361978 is a reply to message #361975]

Thu, 24 April 2008 16:20

Eclipse User

Jason,

Good observation. The tables are for summary fields, grouping per one
field, ie:

report footer:

field1 field2
a sum(x, a)
b sum(x, b)
c sum(x, c)

I didn't know that binding directly to dataset would slow down the
report, good point Jason!

BTW, the SP takes one second to run and one to show the cursor created.

Many thanks,
Hans.

Jason Weathersby escribió:
> Hans,
>
> Looking at the xml for the report, it appears that the data set is bound
> to 13 tables. I did not check to see if you where hiding or dropping
> any of the tables, but you may want to look at the binding tab on each
> table and just bind the first table to the data set, and then bind the
> others to the first table. Doing that should speed it up. Remember
> that you have to name the first table.
>
>
> You can also add a script to the onFetch of your dataset to see how many
> times it is being called:
>
> importPackage( Packages.java.io );
> out = new PrintWriter( new FileWriter( "c:/temp/fetchevents.txt", true ) );
> out.println( "anotherFetch");
> out.close();
>
> Also how long is the SP taking to run?
>
> Jason
>
> Hans wrote:
>> Jason,
>>
>> I'm using a jdbc datasource and i call a stored procedure.
>>
>> This is the report (now it has 2 tables)
>>
>> ------------------------
>>
>> <?xml version="1.0" encoding="UTF-8"?>
>> <report xmlns="http://www.eclipse.org/birt/2005/design"
>> version="3.2.15" id="1">
>> <property name="createdBy">Eclipse BIRT Designer Version
>> 2.3.0.v20080103 Build <2.3.0.v20080107-0800></property>
>> <property name="units">in</property>
>> <property name="comments">Copyright (c) 2007 <<Your Company
>> Name here>></property>
>> <html-property name="description">Creates a blank report with no
>> predefined content.</html-property>
>> <text-property name="displayName">Blank Report</text-property>
>> <property name="iconFile">/templates/blank_report.gif</property>
>> <list-property name="cssStyleSheets">
>> <structure>
>> <property
>> name="fileName">otros/estilos-reportes.css</property>
>> </structure>
>> </list-property>
>> <parameters>
>> <scalar-parameter name="mesContable" id="2640">
>> <text-property name="helpText">mesContable</text-property>
>> <property name="valueType">static</property>
>> <property name="dataType">integer</property>
>> <property name="paramType">simple</property>
>> <text-property name="promptText">mesContable</text-property>
>> <property name="isRequired">true</property>
>> <property name="controlType">text-box</property>
>> <property name="defaultValue">1</property>
>> <property name="distinct">true</property>
>> <structure name="format">
>> <property name="category">Unformatted</property>
>> </structure>
>> </scalar-parameter>
>> <scalar-parameter name="anioContable" id="2641">
>> <text-property name="helpText">anioContable</text-property>
>> <property name="valueType">static</property>
>> <property name="dataType">string</property>
>> <property name="paramType">simple</property>
>> <text-property name="promptText">anioContable</text-property>
>> <property name="isRequired">true</property>
>> <property name="controlType">text-box</property>
>> <property name="defaultValue">2008</property>
>> <property name="distinct">true</property>
>> <structure name="format">
>> <property name="category">Unformatted</property>
>> </structure>
>> </scalar-parameter>
>> <scalar-parameter name="compania" id="2642">
>> <text-property name="helpText">compania</text-property>
>> <property name="valueType">static</property>
>> <property name="dataType">string</property>
>> <property name="paramType">simple</property>
>> <text-property name="promptText">compania</text-property>
>> <property name="isRequired">true</property>
>> <property name="controlType">text-box</property>
>> <property name="defaultValue">generales</property>
>> <property name="distinct">true</property>
>> <structure name="format">
>> <property name="category">Unformatted</property>
>> </structure>
>> </scalar-parameter>
>> <scalar-parameter name="reaseguro" id="2643">
>> <text-property name="helpText">reaseguro</text-property>
>> <property name="valueType">static</property>
>> <property name="dataType">string</property>
>> <property name="paramType">simple</property>
>> <text-property name="promptText">reaseguro</text-property>
>> <property name="isRequired">true</property>
>> <property name="controlType">text-box</property>
>> <property name="defaultValue">n</property>
>> <property name="distinct">true</property>
>> <structure name="format">
>> <property name="category">Unformatted</property>
>> </structure>
>> </scalar-parameter>
>> <scalar-parameter name="tipoProducto" id="2644">
>> <text-property name="helpText">tipoProducto</text-property>
>> <property name="valueType">static</property>
>> <property name="dataType">string</property>
>> <property name="paramType">simple</property>
>> <text-property name="promptText">tipoProducto</text-property>
>> <property name="isRequired">true</property>
>> <property name="controlType">text-box</property>
>> <property name="defaultValue">colectivo</property>
>> <property name="distinct">true</property>
>> <structure name="format">
>> <property name="category">Unformatted</property>
>> </structure>
>> </scalar-parameter>
>> <scalar-parameter name="emitidor" id="2645">
>> <text-property name="helpText">emitidor</text-property>
>> <property name="valueType">static</property>
>> <property name="dataType">string</property>
>> <property name="paramType">simple</property>
>> <text-property name="promptText">emitidor</text-property>
>> <property name="controlType">text-box</property>
>> <property name="defaultValue">Anónimo</property>
>> <property name="distinct">true</property>
>> <structure name="format">
>> <property name="category">Unformatted</property>
>> </structure>
>> </scalar-parameter>
>> <scalar-parameter name="valorUF" id="2646">
>> <text-property name="helpText">valorUF</text-property>
>> <property name="valueType">static</property>
>> <property name="dataType">string</property>
>> <property name="paramType">simple</property>
>> <text-property name="promptText">valorUF</text-property>
>> <property name="controlType">text-box</property>
>> <property name="defaultValue">18500</property>
>> <property name="distinct">true</property>
>> <structure name="format">
>> <property name="category">Unformatted</property>
>> </structure>
>> </scalar-parameter>
>> <scalar-parameter name="esquema" id="3086">
>> <property name="hidden">false</property>
>> <text-property name="helpText">esquema</text-property>
>> <property name="valueType">static</property>
>> <property name="dataType">string</property>
>> <property name="paramType">simple</property>
>> <text-property name="promptText">esquema</text-property>
>> <property name="controlType">text-box</property>
>> <property name="defaultValue">CIERRESQA</property>
>> <property name="distinct">true</property>
>> <structure name="format">
>> <property name="category">Unformatted</property>
>> </structure>
>> </scalar-parameter>
>> <scalar-parameter name="areaResponsable" id="4960">
>> <text-property
>> name="helpText">areaResponsable</text-property>
>> <property name="valueType">static</property>
>> <property name="dataType">string</property>
>> <property name="paramType">simple</property>
>> <text-property
>> name="promptText">areaResponsable</text-property>
>> <property name="controlType">text-box</property>
>> <property name="defaultValue">no disponible</property>
>> <property name="distinct">true</property>
>> <structure name="format">
>> <property name="category">Unformatted</property>
>> </structure>
>> </scalar-parameter>
>> <scalar-parameter name="jefeAreaResponsable" id="4961">
>> <text-property
>> name="helpText">jefeAreaResponsable</text-property>
>> <property name="valueType">static</property>
>> <property name="dataType">string</property>
>> <property name="paramType">simple</property>
>> <text-property
>> name="promptText">jefeAreaResponsable</text-property>
>> <property name="controlType">text-box</property>
>> <property name="defaultValue">no disponible</property>
>> <property name="distinct">true</property>
>> <structure name="format">
>> <property name="category">Unformatted</property>
>> </structure>
>> </scalar-parameter>
>> </parameters>
>> <data-sources>
>> <oda-data-source
>> extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source"
>> id="2647">
>> <method name="beforeOpen"><![CDATA[importPackage(
>> Packages.javax.xml.parsers);
>> importPackage( Packages.org.xml.sax);
>> importPackage( Packages.org.w3c.dom);
>> importPackage( Packages.java.io);
>>
>> function getTagValue(file, tagName)
>> {
>> factory = DocumentBuilderFactory.newInstance();
>> builder = factory.newDocumentBuilder();
>> document = builder.parse( new InputSource( new FileInputStream(
>> file )) );
>> nlist = document.getElementsByTagName(tagName);
>> return nlist.item(0).getFirstChild().getNodeValue();
>> }
>>
>> try
>> {
>> this.setExtensionProperty("odaDriverClass",
>> getTagValue("c:/O2/Procesos/config-BIRT-Cierres/conf.xml",
>> "odaDriverClass"));
>> this.setExtensionProperty("odaURL",
>> getTagValue("c:/O2/Procesos/config-BIRT-Cierres/conf.xml", "odaURL"));
>> this.setExtensionProperty("odaUser",
>> getTagValue("c:/O2/Procesos/config-BIRT-Cierres/conf.xml", "odaUser"));
>> this.setExtensionProperty("odaPassword",
>> getTagValue("c:/O2/Procesos/config-BIRT-Cierres/conf.xml",
>> "odaPassword"));
>> }
>> catch(e)
>> {
>> }]]></method>
>> <property
>> name="odaDriverClass">oracle.jdbc.driver.OracleDriver</property >
>> <property
>> name="odaURL">jdbc:oracle:thin:@caipirina.txp:1521:heracle2 </property>
>> <property name="odaUser">cierresdev</property>
>> <encrypted-property name="odaPassword"
>> encryptionID="base64">Y2llcnJlc2Rldg==</encrypted-property >
>> </oda-data-source>
>> </data-sources>
>> <data-sets>
>> <oda-data-set
>> extensionID="org.eclipse.birt.report.data.oda.jdbc.SPSelectDataSet "
>> name="Data Set" id="3247">
>> <structure name="cachedMetaData">
>> <list-property name="resultSet">
>> <structure>
>> <property name="position">1</property>
>> <property name="name">REGISTRO</property>
>> <property name="dataType">string</property>
>> </structure>
>> <structure>
>> <property name="position">2</property>
>> <property name="name">DLR_RUTSOCIO</property>
>> <property name="dataType">string</property>
>> </structure>
>> <structure>
>> <property name="position">3</property>
>> <property name="name">DLR_NOMBRESOCIO</property>
>> <property name="dataType">string</property>
>> </structure>
>> <structure>
>> <property name="position">4</property>
>> <property name="name">PRIMAAFECTA</property>
>> <property name="dataType">decimal</property>
>> </structure>
>> <structure>
>> <property name="position">5</property>
>> <property name="name">PRIMAEXENTA</property>
>> <property name="dataType">decimal</property>
>> </structure>
>> <structure>
>> <property name="position">6</property>
>> <property name="name">IMPUESTO</property>
>> <property name="dataType">decimal</property>
>> </structure>
>> <structure>
>> <property name="position">7</property>
>> <property name="name">PRIMABRUTA</property>
>> <property name="dataType">decimal</property>
>> </structure>
>> <structure>
>> <property name="position">8</property>
>> <property name="name">PRIMAAFECTAMO</property>
>> <property name="dataType">decimal</property>
>> </structure>
>> <structure>
>> <property name="position">9</property>
>> <property name="name">PRIMAEXENTAMO</property>
>> <property name="dataType">decimal</property>
>> </structure>
>> <structure>
>> <property name="position">10</property>
>> <property name="name">IMPUESTOMO</property>
>> <property name="dataType">decimal</property>
>> </structure>
>> <structure>
>> <property name="position">11</property>
>> <property name="name">PRIMABRUTAMO</property>
>> <property name="dataType">decimal</property>
>> </structure>
>> <structure>
>> <property name="position">12</property>
>> <property name="name">DIFERENCIAPRIMAS</property>
>> <property name="dataType">decimal</property>
>> </structure>
>> <structure>
>> <property name="position">13</property>
>> <property name="name">MONEDAORIGEN</property>
>> <property name="dataType">string</property>
>> </structure>
>> </list-property>
>> </structure>
>> <property name="dataSource">Data Source</property>
>> <method name="beforeOpen"><![CDATA[this.queryText = "{call
>> " + params["esquema"].value +
>> ".PCK_LIBROS_RECAUDACIONES.PRC_GENRESRECXFACT(?,?,?,?,?,?)}"]] ></method>
>> <list-property name="parameters">
>> <structure>
>> <property name="name">EV_COMPANIA</property>
>> <property name="paramName">compania</property>
>> <property name="nativeName">EV_COMPANIA</property>
>> <property name="dataType">string</property>
>> <property name="nativeDataType">12</property>
>> <property name="position">1</property>
>> <property name="isOptional">true</property>
>> <property name="allowNull">true</property>
>> <property name="isInput">true</property>
>> <property name="isOutput">false</property>
>> </structure>
>> <structure>
>> <property name="name">EN_MESCONTABLE</property>
>> <property name="paramName">mesContable</property>
>> <property name="nativeName">EN_MESCONTABLE</property>
>> <property name="dataType">string</property>
>> <property name="nativeDataType">3</property>
>> <property name="position">2</property>
>> <property name="isOptional">true</property>
>> <property name="allowNull">true</property>
>> <property name="isInput">true</property>
>> <property name="isOutput">false</property>
>> </structure>
>> <structure>
>> <property name="name">EN_ANOCONTABLE</property>
>> <property name="paramName">anioContable</property>
>> <property name="nativeName">EN_ANOCONTABLE</property>
>> <property name="dataType">string</property>
>> <property name="nativeDataType">3</property>
>> <property name="position">3</property>
>> <property name="isOptional">true</property>
>> <property name="allowNull">true</property>
>> <property name="isInput">true</property>
>> <property name="isOutput">false</property>
>> </structure>
>> <structure>
>> <property name="name">EV_REASEGURO</property>
>> <property name="paramName">reaseguro</property>
>> <property name="nativeName">EV_REASEGURO</property>
>> <property name="dataType">string</property>
>> <property name="nativeDataType">1</property>
>> <property name="position">4</property>
>> <property name="isOptional">true</property>
>> <property name="allowNull">true</property>
>> <property name="isInput">true</property>
>> <property name="isOutput">false</property>
>> </structure>
>> <structure>
>> <property name="name">EV_TIPO</property>
>> <property name="paramName">tipoProducto</property>
>> <property name="nativeName">EV_TIPO</property>
>> <property name="dataType">string</property>
>> <property name="nativeDataType">12</property>
>> <property name="position">5</property>
>> <property name="isOptional">true</property>
>> <property name="allowNull">true</property>
>> <property name="isInput">true</property>
>> <property name="isOutput">false</property>
>> </structure>
>> <structure>
>> <property name="name">SC_RESUMEN</property>
>> <property name="nativeName">SC_RESUMEN</property>
>> <property name="dataType">any</property>
>> <property name="nativeDataType">-10</property>
>> <property name="position">6</property>
>> <property name="isOptional">false</property>
>> <property name="allowNull">true</property>
>> <property name="isOutput">true</property>
>> </structure>
>> </list-property>
>> <list-property name="resultSet">
>> <structure>
>> <property name="position">1</property>
>> <property name="name">REGISTRO</property>
>> <property name="nativeName">REGISTRO</property>
>> <property name="dataType">string</property>
>> </structure>
>> <structure>
>> <property name="position">2</property>
>> <property name="name">DLR_RUTSOCIO</property>
>> <property name="nativeName">DLR_RUTSOCIO</property>
>> <property name="dataType">string</property>
>> </structure>
>> <structure>
>> <property name="position">3</property>
>> <property name="name">DLR_NOMBRESOCIO</property>
>> <property
>> name="nativeName">DLR_NOMBRESOCIO</property>
>> <property name="dataType">string</property>
>> </structure>
>> <structure>
>> <property name="position">4</property>
>> <property name="name">PRIMAAFECTA</property>
>> <property name="nativeName">PRIMAAFECTA</property>
>> <property name="dataType">decimal</property>
>> </structure>
>> <structure>
>> <property name="position">5</property>
>> <property name="name">PRIMAEXENTA</property>
>> <property name="nativeName">PRIMAEXENTA</property>
>> <property name="dataType">decimal</property>
>> </structure>
>> <structure>
>> <property name="position">6</property>
>> <property name="name">IMPUESTO</property>
>> <property name="nativeName">IMPUESTO</property>
>> <property name="dataType">decimal</property>
>> </structure>
>> <structure>
>> <property name="position">7</property>
>> <property name="name">PRIMABRUTA</property>
>> <property name="nativeName">PRIMABRUTA</property>
>> <property name="dataType">decimal</property>
>> </structure>
>> <structure>
>> <property name="position">8</property>
>> <property name="name">PRIMAAFECTAMO</property>
>> <property name="nativeName">PRIMAAFECTAMO</property>
>> <property name="dataType">decimal</property>
>> </structure>
>> <structure>
>> <property name="position">9</property>
>> <property name="name">PRIMAEXENTAMO</property>
>> <property name="nativeName">PRIMAEXENTAMO</property>
>> <property name="dataType">decimal</property>
>> </structure>
>> <structure>
>> <property name="position">10</property>
>> <property name="name">IMPUESTOMO</property>
>> <property name="nativeName">IMPUESTOMO</property>
>> <property name="dataType">decimal</property>
>> </structure>
>> <structure>
>> <property name="position">11</property>
>> <property name="name">PRIMABRUTAMO</property>
>> <property name="nativeName">PRIMABRUTAMO</property>
>> <property name="dataType">decimal</property>
>> </structure>
>> <structure>
>> <property name="position">12</property>
>> <property name="name">DIFERENCIAPRIMAS</property>
>> <property
>> name="nativeName">DIFERENCIAPRIMAS</property>
>> <property name="dataType">decimal</property>
>> </structure>
>> <structure>
>> <property name="position">13</property>
>> <property name="name">MONEDAORIGEN</property>
>> <property name="nativeName">MONEDAORIGEN</property>
>> <property name="dataType">string</property>
>> </structure>
>> </list-property>
>> <property name="queryText">{call
>> CIERRESQA.PCK_LIBROS_RECAUDACIONES.PRC_GENRESRECXFACT(?,?,?, ?,?,?)} </property>
>>
>> <xml-property name="designerValues"><![CDATA[<?xml
>> version="1.0" encoding="UTF-8"?>
>> <model:DesignValues
>> xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design"
>> xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
>> <Version>1.0</Version>
>> <design:DataSetParameters>
>> <design:parameterDefinitions>
>> <design:inOutMode>In</design:inOutMode>
>> <design:attributes>
>> <design:name>EV_COMPANIA</design:name>
>> <design:position>1</design:position>
>> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>> <design:precision>0</design:precision>
>> <design:scale>0</design:scale>
>> <design:nullability>Nullable</design:nullability>
>> </design:attributes>
>> <design:inputAttributes>
>> <design:elementAttributes>
>> <design:optional>true</design:optional>
>> </design:elementAttributes>
>> </design:inputAttributes>
>> </design:parameterDefinitions>
>> <design:parameterDefinitions>
>> <design:inOutMode>In</design:inOutMode>
>> <design:attributes>
>> <design:name>EN_MESCONTABLE</design:name>
>> <design:position>2</design:position>
>> <design:nativeDataTypeCode>3</design:nativeDataTypeCode>
>> <design:precision>22</design:precision>
>> <design:scale>0</design:scale>
>> <design:nullability>Nullable</design:nullability>
>> </design:attributes>
>> <design:inputAttributes>
>> <design:elementAttributes>
>> <design:optional>true</design:optional>
>> </design:elementAttributes>
>> </design:inputAttributes>
>> </design:parameterDefinitions>
>> <design:parameterDefinitions>
>> <design:inOutMode>In</design:inOutMode>
>> <design:attributes>
>> <design:name>EN_ANOCONTABLE</design:name>
>> <design:position>3</design:position>
>> <design:nativeDataTypeCode>3</design:nativeDataTypeCode>
>> <design:precision>22</design:precision>
>> <design:scale>0</design:scale>
>> <design:nullability>Nullable</design:nullability>
>> </design:attributes>
>> <design:inputAttributes>
>> <design:elementAttributes>
>> <design:optional>true</design:optional>
>> </design:elementAttributes>
>> </design:inputAttributes>
>> </design:parameterDefinitions>
>> <design:parameterDefinitions>
>> <design:inOutMode>In</design:inOutMode>
>> <design:attributes>
>> <design:name>EV_REASEGURO</design:name>
>> <design:position>4</design:position>
>> <design:nativeDataTypeCode>1</design:nativeDataTypeCode>
>> <design:precision>0</design:precision>
>> <design:scale>0</design:scale>
>> <design:nullability>Nullable</design:nullability>
>> </design:attributes>
>> <design:inputAttributes>
>> <design:elementAttributes>
>> <design:optional>true</design:optional>
>> </design:elementAttributes>
>> </design:inputAttributes>
>> </design:parameterDefinitions>
>> <design:parameterDefinitions>
>> <design:inOutMode>In</design:inOutMode>
>> <design:attributes>
>> <design:name>EV_TIPO</design:name>
>> <design:position>5</design:position>
>> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>> <design:precision>0</design:precision>
>> <design:scale>0</design:scale>
>> <design:nullability>Nullable</design:nullability>
>> </design:attributes>
>> <design:inputAttributes>
>> <design:elementAttributes>
>> <design:optional>true</design:optional>
>> </design:elementAttributes>
>> </design:inputAttributes>
>> </design:parameterDefinitions>
>> <design:parameterDefinitions>
>> <design:inOutMode>Out</design:inOutMode>
>> <design:attributes>
>> <design:name>SC_RESUMEN</design:name>
>> <design:position>6</design:position>
>> <design:nativeDataTypeCode>-10</design:nativeDataTypeCode>
>> <design:precision>0</design:precision>
>> <design:scale>0</design:scale>
>> <design:nullability>Nullable</design:nullability>
>> </design:attributes>
>> </design:parameterDefinitions>
>> </design:DataSetParameters>
>> </model:DesignValues>]]></xml-property>
>> </oda-data-set>
>> </data-sets>
>> <styles>
>> <style name="crosstab-cell" id="4">
>> <property name="borderBottomColor">#CCCCCC</property>
>> <property name="borderBottomStyle">solid</property>
>> <property name="borderBottomWidth">1pt</property>
>> <property name="borderLeftColor">#CCCCCC</property>
>> <property name="borderLeftStyle">solid</property>
>> <property name="borderLeftWidth">1pt</property>
>> <property name="borderRightColor">#CCCCCC</property>
>> <property name="borderRightStyle">solid</property>
>> <property name="borderRightWidth">1pt</property>
>> <property name="borderTopColor">#CCCCCC</property>
>> <property name="borderTopStyle">solid</property>
>> <property name="borderTopWidth">1pt</property>
>> </style>
>> <style name="crosstab" id="5">
>> <property name="borderBottomColor">#CCCCCC</property>
>> <property name="borderBottomStyle">solid</property>
>> <property name="borderBottomWidth">1pt</property>
>> <property name="borderLeftColor">#CCCCCC</property>
>> <property name="borderLeftStyle">solid</property>
>> <property name="borderLeftWidth">1pt</property>
>> <property name="borderRightColor">#CCCCCC</property>
>> <property name="borderRightStyle">solid</property>
>> <property name="borderRightWidth">1pt</property>
>> <property name="borderTopColor">#CCCCCC</property>
>> <property name="borderTopStyle">solid</property>
>> <property name="borderTopWidth">1pt</property>
>> </style>
>> <style name="cuadro" id="1767">
>> <property name="borderBottomStyle">solid</property>
>> <property name="borderBottomWidth">thin</property>
>> <property name="borderLeftStyle">solid</property>
>> <property name="borderLeftWidth">thin</property>
>> <property name="borderRightStyle">solid</property>
>> <property name="borderRightWidth">thin</property>
>> <property name="borderTopStyle">solid</property>
>> <property name="borderTopWidth">thin</property>
>> </style>
>> <style name="cuerpo-reporte" id="1768">
>> <property name="fontFamily">"Arial"</property>
>> <property name="fontSize">x-small</property>
>> <structure name="numberFormat">
>> <property name="category">Currency</property>
>> <property name="pattern">#,##0</property>
>> </structure>
>> </style>
>> <style name="grupo-footer" id="1938">
>> <property name="borderBottomStyle">none</property>
>> <property name="borderBottomWidth">thin</property>
>> <property name="borderTopStyle">solid</property>
>> <property name="borderTopWidth">thin</property>
>> </style>
>> <style name="tabla-aux" id="1939">
>> <property name="paddingTop">0pt</property>
>> <property name="paddingLeft">0pt</property>
>> <property name="paddingBottom">0pt</property>
>> <property name="paddingRight">0pt</property>
>> </style>
>> <style name="tabla-cabecera" id="1764">
>> <property name="backgroundColor">#000000</property>
>> <property name="fontFamily">"Arial"</property>
>> <property name="fontSize">x-small</property>
>> <property name="fontWeight">bold</property>
>> <property name="color">#FFFFFF</property>
>> <property name="borderBottomColor">#000000</property>
>> <property name="borderBottomStyle">solid</property>
>> <property name="borderLeftColor">#000000</property>
>> <property name="borderLeftStyle">solid</property>
>> <property name="borderRightColor">#000000</property>
>> <property name="borderRightStyle">solid</property>
>> <property name="borderTopColor">#000000</property>
>> <property name="borderTopStyle">solid</property>
>> <property name="borderTopWidth">thin</property>
>> <property name="textAlign">center</property>
>> <property name="canShrink">false</property>
>> </style>
>> <style name="tabla-detalle-celda" id="1765">
>> <property name="backgroundColor">#FFFFFF</property>
>> <property name="fontFamily">"Arial"</property>
>> <property name="fontSize">x-small</property>
>> <property name="color">#000000</property>
>> <property name="borderLeftStyle">solid</property>
>> <property name="borderLeftWidth">thin</property>
>> <property name="borderRightStyle">solid</property>
>> <property name="borderRightWidth">thin</property>
>> <property name="borderTopStyle">none</property>
>> <property name="borderTopWidth">medium</property>
>> <property name="textAlign">center</property>
>> </style>
>> <style name="tabla-footer" id="1766">
>> <property name="backgroundColor">#93BE95</property>
>> <property name="fontFamily">sans-serif</property>
>> <property name="fontSize">x-small</property>
>> <property name="fontWeight">bold</property>
>> <property name="color">#FFFFE0</property>
>> <property name="borderBottomColor">#483D8B</property>
>> <property name="borderBottomStyle">solid</property>
>> <property name="borderBottomWidth">thin</property>
>> <property name="borderLeftColor">#483D8B</property>
>> <property name="borderRightColor">#483D8B</property>
>> <property name="borderTopColor">#483D8B</property>
>> <property name="borderTopStyle">double</property>
>> </style>
>> <style name="annio" id="4179">
>> <structure name="numberFormat">
>> <property name="category">Custom</property>
>> <property name="pattern">####</property>
>> </structure>
>> </style>
>> <style name="decimal2" id="4180">
>> <structure name="numberFormat">
>> <property name="category">Fixed</property>
>> <property name="pattern">#,##0.00</property>
>> </structure>
>> </style>
>> <style name="fechaDDMMYYYY" id="4178">
>> <structure name="dateTimeFormat">
>> <property name="category">Custom</property>
>> <property name="pattern">dd/MM/YYYY</property>
>> </structure>
>> </style>
>> <style name="numberAlignment" id="4181">
>> <property name="textAlign">right</property>
>> </style>
>> <style name="monto-mo" id="4959">
>> <structure name="numberFormat">
>> <property name="category">Fixed</property>
>> <property name="pattern">#,##0.00</property>
>> </structure>
>> </style>
>> <style name="monto-pesos" id="4958">
>> <structure name="numberFormat">
>> <property name="category">Fixed</property>
>> <property name="pattern">#,##0</property>
>> </structure>
>> </style>
>> </styles>
>> <page-setup>
>> <simple-master-page name="Simple MasterPage" id="2">
>> <property name="type">custom</property>
>> <property name="height">12in</property>
>> <property name="width">20in</property>
>> <property name="style">cuerpo-reporte</property>
>> </simple-master-page>
>> </page-setup>
>> <body>
>> <grid id="2240">
>> <property name="style">cuerpo-reporte</property>
>> <property name="numberAlign">right</property>
>> <property name="width">100%</property>
>> <column id="2241"/>
>> <column id="2242"/>
>> <column id="2243"/>
>> <column id="2244"/>
>> <column id="2245"/>
>> <column id="2246"/>
>> <column id="2247"/>
>> <column id="2248"/>
>> <column id="2249"/>
>> <column id="2250"/>
>> <column id="2251"/>
>> <column id="2252"/>
>> <column id="2253"/>
>> <column id="2254"/>
>> <column id="2255"/>
>> <column id="2256"/>
>> <column id="2257"/>
>> <column id="2258"/>
>> <column id="2259"/>
>> <row id="2260">
>> <cell id="2261">
>> <property name="colSpan">4</property>
>> <property name="rowSpan">1</property>
>> <data id="3093">
>> <property name="fontWeight">bold</property>
>> <list-property name="boundDataColumns">
>> <structure>
>> <property
>> name="name">encabezado</property>
>> <expression
>> name="expression">'Compañía de Seguros ' +
>> params["compania"].toUpperCase() + ' Cardif S.A'</expression>
>> <property name="dataType">any</property>
>> </structure>
>> </list-property>
>> <property
>> name="resultSetColumn">encabezado</property>
>> </data>
>> </cell>
>> <cell id="2265"/>
>> <cell id="2266"/>
>> <cell id="2267"/>
>> <cell id="2268"/>
>> <cell id="2269"/>
>> <cell id="2270"/>
>> <cell id="2271"/>
>> <cell id="2272"/>
>> <cell id="2273"/>
>> <cell id="2274"/>
>> <cell id="2275"/>
>> <cell id="2276"/>
>> <cell id="2277"/>
>> <cell id="2278"/>
>> <cell id="2279"/>
>> </row>
>> <row id="2280">
>> <cell id="2281">
>> <property name="colSpan">3</property>
>> <property name="rowSpan">1</property>
>> <data id="4176">
>> <property name="fontWeight">bold</property>
>> <list-property name="boundDataColumns">
>> <structure>
>> <property name="name">Rut</property>
>> <expression name="expression">if (
>> params["compania"].toUpperCase() == 'VIDA')
>> '96837630-6'
>> else
>> '96837640-3'</expression>
>> <property name="dataType">any</property>
>> </structure>
>> </list-property>
>> <property name="resultSetColumn">Rut</property>
>> </data>
>> </cell>
>> <cell id="2284"/>
>> <cell id="2285"/>
>> <cell id="2286"/>
>> <cell id="2287"/>
>> <cell id="2288"/>
>> <cell id="2289"/>
>> <cell id="2290"/>
>> <cell id="2291"/>
>> <cell id="2292"/>
>> <cell id="2293"/>
>> <cell id="2294"/>
>> <cell id="2295"/>
>> <cell id="2296"/>
>> <cell id="2297"/>
>> <cell id="2298"/>
>> <cell id="2299"/>
>> </row>
>> <row id="2300">
>> <cell id="2301"/>
>> <cell id="2302"/>
>> <cell id="2303"/>
>> <cell id="2304"/>
>> <cell id="2305"/>
>> <cell id="2306"/>
>> <cell id="2307"/>
>> <cell id="2308"/>
>> <cell id="2309"/>
>> <cell id="2310"/>
>> <cell id="2311"/>
>> <cell id="2312"/>
>> <cell id="2313"/>
>> <cell id="2314"/>
&g

Previous Topic:	Add marker using dataset
Next Topic:	FileNotFoundException /webcontent/birt/pages/layout/RunFragment.jsp

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Aug 06 13:39:29 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter