[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
[birt-dev] problem with linking report parameters with DataSet parameters onBIRT 2.2.2
|
Dear BIRT developers,
After migrating from BIRT 2.2.1.1 to BIRT 2.2.2 I'm not able anymore to
link DataSet parameters to "dynamic" report parameters which are
associated to a DataSet. I discover this while working with our own ODA
extensions and at first I though this was because we were missing
something or doing something wrong. After debugging a bit I discover
that the steps involved in the creation of the "standard "
JdbcSelectDataSet where exactly the same as the ones involved in the
creation of our extension. So, I decided to try to build example using
only JdbcSelectDataSets.
With version 2.2.1.1 I'm able to create a DataSet, link it to dynamic
parameters and later on edit it (DataSet2211). With version 2.2.2 I can
create the DataSet (see DataSet222) but not edit it. I think the problem
arises because 2.2.2 is failing to correctly create the XML tag:
<design:dynamicValueChoices>: it creates something like:
<design:dynamicValueChoices>
<design:enabled>false</design:enabled>
</design:dynamicValueChoices>
while version 2.2.1.1 creates something like:
<design:dynamicValueChoices>
<design:dataSetDesign>
<design:name>Equipos</design:name>
<design:odaExtensionDataSetId>org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet</design:odaExtensionDataSetId>
<design:dataSourceDesign>
<design:name>Informix</design:name>
<design:odaExtensionId>org.eclipse.birt.report.data.oda.jdbc</design:odaExtensionId>
<design:publicProperties>
<design:properties>
<design:nameValue>
<design:name>odaDriverClass</design:name>
<design:value>com.informix.jdbc.IfxDriver</design:value>
</design:nameValue>
</design:properties>
<design:properties>
<design:nameValue>
<design:name>odaURL</design:name>
<design:value>jdbc:informix-sqli://blifx1:1526/ma_prc_maquinaria:INFORMIXSERVER=olblifx1;user=Fccsg\ema;password=Fccsa2004;DBDATE=DMY4;IFX_TRIMTRAILINGSPACES=1;IFX_USEPUT=1;IFX_BATCHUPDATE_PER_SPEC=0;OPTOFC=1;DB_LOCALE=es_es.CP1252</design:value>
</design:nameValue>
</design:properties>
<design:properties>
<design:nameValue>
<design:name>odaUser</design:name>
</design:nameValue>
</design:properties>
<design:properties>
<design:nameValue>
<design:name>odaPassword</design:name>
</design:nameValue>
</design:properties>
<design:properties>
<design:nameValue>
<design:name>odaJndiName</design:name>
</design:nameValue>
</design:properties>
<design:properties>
<design:nameValue>
<design:name>OdaConnProfileName</design:name>
</design:nameValue>
</design:properties>
<design:properties>
<design:nameValue>
<design:name>OdaConnProfileStorePath</design:name>
</design:nameValue>
</design:properties>
</design:publicProperties>
</design:dataSourceDesign>
<design:query>
<design:queryText>select * from maqeqc</design:queryText>
</design:query>
<design:publicProperties>
<design:properties>
<design:nameValue>
<design:name>queryTimeOut</design:name>
</design:nameValue>
</design:properties>
</design:publicProperties>
<design:resultSets>
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>equ_eqc</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:uiHints>
<design:displayName>equ_eqc</design:displayName>
</design:uiHints>
</design:attributes>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>com_eqc</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:uiHints>
<design:displayName>com_eqc</design:displayName>
</design:uiHints>
</design:attributes>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>den_eqc</design:name>
<design:position>3</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:uiHints>
<design:displayName>den_eqc</design:displayName>
</design:uiHints>
</design:attributes>
</design:resultColumnDefinitions>
</design:resultSetColumns>
</design:resultSetDefinitions>
</design:resultSets>
</design:dataSetDesign>
<design:enabled>true</design:enabled>
<design:valueColumn>dataSetRow["equ_eqc"]</design:valueColumn>
<design:displayNameColumn>dataSetRow["den_eqc"]</design:displayNameColumn>
</design:dynamicValueChoices>
(See attachment for complete report XML).
Am I missing something? Or is this a bug?
Best regards,
Ernesto
*************************************************************
Este correo ha sido procesado por el antivirus del Grupo FCC.
*************************************************************
<?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.2.2.r222_v20071226 Build <2.2.2.v20080226-1155></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>
<parameters>
<scalar-parameter name="ficha" id="2011">
<text-property name="helpText">Ficha maquinaria</text-property>
<property name="valueType">dynamic</property>
<property name="dataType">string</property>
<property name="paramType">simple</property>
<text-property name="promptText">Ficha maquinaria</text-property>
<property name="controlType">list-box</property>
<property name="dataSetName">Fichas</property>
<expression name="valueExpr">dataSetRow["fch_fch"]</expression>
<expression name="labelExpr">dataSetRow["den_fch"]</expression>
<property name="mustMatch">true</property>
<property name="fixedOrder">false</property>
<property name="defaultValue">001</property>
<property name="distinct">true</property>
<property name="sortBy">label</property>
<property name="sortDirection">asc</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="equipos" id="2015">
<property name="valueType">dynamic</property>
<property name="dataType">string</property>
<property name="paramType">simple</property>
<property name="controlType">list-box</property>
<property name="dataSetName">Equipos</property>
<expression name="valueExpr">dataSetRow["equ_eqc"]</expression>
<expression name="labelExpr">dataSetRow["den_eqc"]</expression>
<property name="mustMatch">true</property>
<property name="fixedOrder">false</property>
<property name="defaultValue">001</property>
<property name="distinct">true</property>
<property name="sortBy">label</property>
<property name="sortDirection">asc</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="Informix" id="397">
<property name="odaDriverClass">com.informix.jdbc.IfxDriver</property>
<property name="odaURL">jdbc:informix-sqli://XXXX:1526/ma_prc_maquinaria:INFORMIXSERVER=XXXX;user=XXXX;password=XXXX;DBDATE=DMY4;IFX_TRIMTRAILINGSPACES=1;IFX_USEPUT=1;IFX_BATCHUPDATE_PER_SPEC=0;OPTOFC=1;DB_LOCALE=es_es.CP1252</property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Fichas" id="1673">
<list-property name="columnHints">
<structure>
<property name="columnName">fch_fch</property>
<property name="displayName">fch_fch</property>
</structure>
<structure>
<property name="columnName">den_fch</property>
<property name="displayName">den_fch</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">fch_fch</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">den_fch</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Informix</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">fch_fch</property>
<property name="nativeName">fch_fch</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">den_fch</property>
<property name="nativeName">den_fch</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<property name="queryText">select *
from maqfch</property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Equipos" id="2014">
<list-property name="columnHints">
<structure>
<property name="columnName">equ_eqc</property>
<property name="displayName">equ_eqc</property>
</structure>
<structure>
<property name="columnName">com_eqc</property>
<property name="displayName">com_eqc</property>
</structure>
<structure>
<property name="columnName">den_eqc</property>
<property name="displayName">den_eqc</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">equ_eqc</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">com_eqc</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">den_eqc</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Informix</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">equ_eqc</property>
<property name="nativeName">equ_eqc</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">com_eqc</property>
<property name="nativeName">com_eqc</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">den_eqc</property>
<property name="nativeName">den_eqc</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<property name="queryText">select * from maqeqc</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:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>equ_eqc</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>equ_eqc</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>equ_eqc</design:label>
<design:formattingHints>
<design:displaySize>5</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>com_eqc</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>com_eqc</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>com_eqc</design:label>
<design:formattingHints>
<design:displaySize>5</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>den_eqc</design:name>
<design:position>3</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>den_eqc</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>den_eqc</design:label>
<design:formattingHints>
<design:displaySize>80</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="DataSet2211" id="2016">
<list-property name="columnHints">
<structure>
<property name="columnName">com_com</property>
<property name="displayName">com_com</property>
</structure>
<structure>
<property name="columnName">den_com</property>
<property name="displayName">den_com</property>
</structure>
<structure>
<property name="columnName">tit_com</property>
<property name="displayName">tit_com</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">com_com</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">den_com</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">tit_com</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Informix</property>
<list-property name="parameters">
<structure>
<property name="name">param_1</property>
<property name="paramName">equipos</property>
<property name="nativeName"></property>
<property name="dataType">string</property>
<property name="nativeDataType">1</property>
<property name="position">1</property>
<property name="isOptional">false</property>
<property name="allowNull">false</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">param_2</property>
<property name="paramName">ficha</property>
<property name="nativeName"></property>
<property name="dataType">string</property>
<property name="nativeDataType">1</property>
<property name="position">2</property>
<property name="isOptional">false</property>
<property name="allowNull">false</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
</list-property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">com_com</property>
<property name="nativeName">com_com</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">den_com</property>
<property name="nativeName">den_com</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">tit_com</property>
<property name="nativeName">tit_com</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<property name="queryText">SELECT distinct com_com, den_com, TRIM(den_tcm) || ": " || TRIM(den_com) as tit_com
FROM maqeqc,maqtcm,maqcom
WHERE tcm_com = tcm_tcm
AND equ_eqc = ?
AND com_eqc = com_com
AND exists ( select * from maqvat where com_vat = com_com
and exists ( select * from maqfha where fch_fha = ? and atr_fha=atr_vat)
)
order by com_com, den_com</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></design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>1</design:nativeDataTypeCode>
<design:nullability>Unknown</design:nullability>
<design:uiHints/>
</design:attributes>
<design:inputAttributes>
<design:elementAttributes>
<design:defaultScalarValue>001</design:defaultScalarValue>
<design:optional>false</design:optional>
<design:masksValue>false</design:masksValue>
<design:dynamicValueChoices>
<design:dataSetDesign>
<design:name>Equipos</design:name>
<design:odaExtensionDataSetId>org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet</design:odaExtensionDataSetId>
<design:dataSourceDesign>
<design:name>Informix</design:name>
<design:odaExtensionId>org.eclipse.birt.report.data.oda.jdbc</design:odaExtensionId>
<design:publicProperties>
<design:properties>
<design:nameValue>
<design:name>odaDriverClass</design:name>
<design:value>com.informix.jdbc.IfxDriver</design:value>
</design:nameValue>
</design:properties>
<design:properties>
<design:nameValue>
<design:name>odaURL</design:name>
<design:value>jdbc:informix-sqli://blifx1:1526/ma_prc_maquinaria:INFORMIXSERVER=olblifx1;user=Fccsg\ema;password=Fccsa2004;DBDATE=DMY4;IFX_TRIMTRAILINGSPACES=1;IFX_USEPUT=1;IFX_BATCHUPDATE_PER_SPEC=0;OPTOFC=1;DB_LOCALE=es_es.CP1252</design:value>
</design:nameValue>
</design:properties>
<design:properties>
<design:nameValue>
<design:name>odaUser</design:name>
</design:nameValue>
</design:properties>
<design:properties>
<design:nameValue>
<design:name>odaPassword</design:name>
</design:nameValue>
</design:properties>
<design:properties>
<design:nameValue>
<design:name>odaJndiName</design:name>
</design:nameValue>
</design:properties>
<design:properties>
<design:nameValue>
<design:name>OdaConnProfileName</design:name>
</design:nameValue>
</design:properties>
<design:properties>
<design:nameValue>
<design:name>OdaConnProfileStorePath</design:name>
</design:nameValue>
</design:properties>
</design:publicProperties>
</design:dataSourceDesign>
<design:query>
<design:queryText>select * from maqeqc</design:queryText>
</design:query>
<design:publicProperties>
<design:properties>
<design:nameValue>
<design:name>queryTimeOut</design:name>
</design:nameValue>
</design:properties>
</design:publicProperties>
<design:resultSets>
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>equ_eqc</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:uiHints>
<design:displayName>equ_eqc</design:displayName>
</design:uiHints>
</design:attributes>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>com_eqc</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:uiHints>
<design:displayName>com_eqc</design:displayName>
</design:uiHints>
</design:attributes>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>den_eqc</design:name>
<design:position>3</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:uiHints>
<design:displayName>den_eqc</design:displayName>
</design:uiHints>
</design:attributes>
</design:resultColumnDefinitions>
</design:resultSetColumns>
</design:resultSetDefinitions>
</design:resultSets>
</design:dataSetDesign>
<design:enabled>true</design:enabled>
<design:valueColumn>dataSetRow["equ_eqc"]</design:valueColumn>
<design:displayNameColumn>dataSetRow["den_eqc"]</design:displayNameColumn>
</design:dynamicValueChoices>
<design:uiHints>
<design:promptStyle>SelectableList</design:promptStyle>
</design:uiHints>
</design:elementAttributes>
</design:inputAttributes>
</design:parameterDefinitions>
<design:parameterDefinitions>
<design:inOutMode>In</design:inOutMode>
<design:attributes>
<design:name></design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>1</design:nativeDataTypeCode>
<design:nullability>Unknown</design:nullability>
<design:uiHints>
<design:displayName>Ficha maquinaria</design:displayName>
<design:description>Ficha maquinaria</design:description>
</design:uiHints>
</design:attributes>
<design:inputAttributes>
<design:elementAttributes>
<design:defaultScalarValue>001</design:defaultScalarValue>
<design:optional>false</design:optional>
<design:masksValue>false</design:masksValue>
<design:dynamicValueChoices>
<design:dataSetDesign>
<design:name>Fichas</design:name>
<design:odaExtensionDataSetId>org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet</design:odaExtensionDataSetId>
<design:dataSourceDesign>
<design:name>Informix</design:name>
<design:odaExtensionId>org.eclipse.birt.report.data.oda.jdbc</design:odaExtensionId>
<design:publicProperties>
<design:properties>
<design:nameValue>
<design:name>odaDriverClass</design:name>
<design:value>com.informix.jdbc.IfxDriver</design:value>
</design:nameValue>
</design:properties>
<design:properties>
<design:nameValue>
<design:name>odaURL</design:name>
<design:value>jdbc:informix-sqli://blifx1:1526/ma_prc_maquinaria:INFORMIXSERVER=olblifx1;user=Fccsg\ema;password=Fccsa2004;DBDATE=DMY4;IFX_TRIMTRAILINGSPACES=1;IFX_USEPUT=1;IFX_BATCHUPDATE_PER_SPEC=0;OPTOFC=1;DB_LOCALE=es_es.CP1252</design:value>
</design:nameValue>
</design:properties>
<design:properties>
<design:nameValue>
<design:name>odaUser</design:name>
</design:nameValue>
</design:properties>
<design:properties>
<design:nameValue>
<design:name>odaPassword</design:name>
</design:nameValue>
</design:properties>
<design:properties>
<design:nameValue>
<design:name>odaJndiName</design:name>
</design:nameValue>
</design:properties>
<design:properties>
<design:nameValue>
<design:name>OdaConnProfileName</design:name>
</design:nameValue>
</design:properties>
<design:properties>
<design:nameValue>
<design:name>OdaConnProfileStorePath</design:name>
</design:nameValue>
</design:properties>
</design:publicProperties>
</design:dataSourceDesign>
<design:query>
<design:queryText>select *
from maqfch</design:queryText>
</design:query>
<design:publicProperties>
<design:properties>
<design:nameValue>
<design:name>queryTimeOut</design:name>
</design:nameValue>
</design:properties>
</design:publicProperties>
<design:resultSets>
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>fch_fch</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:uiHints>
<design:displayName>fch_fch</design:displayName>
</design:uiHints>
</design:attributes>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>den_fch</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:uiHints>
<design:displayName>den_fch</design:displayName>
</design:uiHints>
</design:attributes>
</design:resultColumnDefinitions>
</design:resultSetColumns>
</design:resultSetDefinitions>
</design:resultSets>
</design:dataSetDesign>
<design:enabled>true</design:enabled>
<design:valueColumn>dataSetRow["fch_fch"]</design:valueColumn>
<design:displayNameColumn>dataSetRow["den_fch"]</design:displayNameColumn>
</design:dynamicValueChoices>
<design:uiHints>
<design:promptStyle>SelectableList</design:promptStyle>
</design:uiHints>
</design:elementAttributes>
</design:inputAttributes>
</design:parameterDefinitions>
</design:DataSetParameters>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>com_com</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>com_com</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>com_com</design:label>
<design:formattingHints>
<design:displaySize>5</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>den_com</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>den_com</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>den_com</design:label>
<design:formattingHints>
<design:displaySize>80</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>tit_com</design:name>
<design:position>3</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>tit_com</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>tit_com</design:label>
<design:formattingHints>
<design:displaySize>162</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="DataSet222" id="2017">
<list-property name="columnHints">
<structure>
<property name="columnName">com_com</property>
<property name="displayName">com_com</property>
</structure>
<structure>
<property name="columnName">den_com</property>
<property name="displayName">den_com</property>
</structure>
<structure>
<property name="columnName">tit_com</property>
<property name="displayName">tit_com</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">com_com</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">den_com</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">tit_com</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Informix</property>
<list-property name="parameters">
<structure>
<property name="name">param_1</property>
<property name="paramName">equipos</property>
<property name="nativeName"></property>
<property name="dataType">string</property>
<property name="nativeDataType">1</property>
<property name="position">1</property>
<property name="isOptional">false</property>
<property name="allowNull">false</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">param_2</property>
<property name="paramName">ficha</property>
<property name="nativeName"></property>
<property name="dataType">string</property>
<property name="nativeDataType">1</property>
<property name="position">2</property>
<property name="isOptional">false</property>
<property name="allowNull">false</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
</list-property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">com_com</property>
<property name="nativeName">com_com</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">den_com</property>
<property name="nativeName">den_com</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">tit_com</property>
<property name="nativeName">tit_com</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<property name="queryText">SELECT distinct com_com, den_com, TRIM(den_tcm) || ": " || TRIM(den_com) as tit_com
FROM maqeqc,maqtcm,maqcom
WHERE tcm_com = tcm_tcm
AND equ_eqc = ?
AND com_eqc = com_com
AND exists ( select * from maqvat where com_vat = com_com
and exists ( select * from maqfha where fch_fha = ? and atr_fha=atr_vat)
)
order by com_com, den_com</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></design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>1</design:nativeDataTypeCode>
<design:nullability>Unknown</design:nullability>
<design:uiHints/>
</design:attributes>
<design:inputAttributes>
<design:elementAttributes>
<design:defaultScalarValue>001</design:defaultScalarValue>
<design:optional>false</design:optional>
<design:masksValue>false</design:masksValue>
<design:dynamicValueChoices>
<design:enabled>false</design:enabled>
</design:dynamicValueChoices>
<design:uiHints>
<design:promptStyle>SelectableList</design:promptStyle>
</design:uiHints>
</design:elementAttributes>
</design:inputAttributes>
</design:parameterDefinitions>
<design:parameterDefinitions>
<design:inOutMode>In</design:inOutMode>
<design:attributes>
<design:name></design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>1</design:nativeDataTypeCode>
<design:nullability>Unknown</design:nullability>
<design:uiHints>
<design:displayName>Ficha maquinaria</design:displayName>
<design:description>Ficha maquinaria</design:description>
</design:uiHints>
</design:attributes>
<design:inputAttributes>
<design:elementAttributes>
<design:defaultScalarValue>001</design:defaultScalarValue>
<design:optional>false</design:optional>
<design:masksValue>false</design:masksValue>
<design:dynamicValueChoices>
<design:enabled>false</design:enabled>
</design:dynamicValueChoices>
<design:uiHints>
<design:promptStyle>SelectableList</design:promptStyle>
</design:uiHints>
</design:elementAttributes>
</design:inputAttributes>
</design:parameterDefinitions>
</design:DataSetParameters>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>com_com</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>com_com</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>com_com</design:label>
<design:formattingHints>
<design:displaySize>5</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>den_com</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>den_com</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>den_com</design:label>
<design:formattingHints>
<design:displaySize>80</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>tit_com</design:name>
<design:position>3</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>tit_com</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>tit_com</design:label>
<design:formattingHints>
<design:displaySize>162</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
</design:resultSetDefinitions>
</design:ResultSets>
</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>
</styles>
<page-setup>
<simple-master-page name="Simple MasterPage" id="2">
<page-footer>
<text id="3">
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<value-of>new Date()</value-of>]]></text-property>
</text>
</page-footer>
</simple-master-page>
</page-setup>
</report>