mirror of https://github.com/interlegis/sigi.git
You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
365 lines
18 KiB
365 lines
18 KiB
14 years ago
|
<?xml version="1.0" encoding="UTF-8"?>
|
||
|
|
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.22" id="1">
|
||
|
|
<property name="author">Sesóstris Vieira</property>
|
||
|
|
<property name="createdBy">Eclipse BIRT Designer Versão 2.6.2.r262_v20110209 Build <2.6.2.v20110214-1523></property>
|
||
|
|
<text-property name="title">Relatório criado para testar o uso de parâmetros</text-property>
|
||
|
|
<property name="units">in</property>
|
||
|
|
<text-property name="displayName">Teste de parâmetros</text-property>
|
||
|
|
<property name="iconFile">/templates/blank_report.gif</property>
|
||
|
|
<property name="bidiLayoutOrientation">rtl</property>
|
||
|
|
<property name="imageDPI">96</property>
|
||
|
|
<parameters>
|
||
|
|
<scalar-parameter name="prm_sub_titulo" id="9">
|
||
|
|
<property name="hidden">false</property>
|
||
|
|
<text-property name="helpText">Ajuda subtitulo</text-property>
|
||
|
|
<text-property name="promptText">Sub título</text-property>
|
||
|
|
<property name="valueType">static</property>
|
||
|
|
<property name="dataType">string</property>
|
||
|
|
<property name="distinct">true</property>
|
||
|
|
<simple-property-list name="defaultValue">
|
||
|
|
<value type="constant">Relatório de teste</value>
|
||
|
|
</simple-property-list>
|
||
|
|
<property name="paramType">simple</property>
|
||
|
|
<property name="concealValue">true</property>
|
||
|
|
<property name="controlType">text-box</property>
|
||
|
|
<structure name="format">
|
||
|
|
<property name="category">Unformatted</property>
|
||
|
|
</structure>
|
||
|
|
</scalar-parameter>
|
||
|
|
<scalar-parameter name="prm_booleano" id="12">
|
||
|
|
<property name="hidden">false</property>
|
||
|
|
<text-property name="helpText">Marque ou desmarque a vontade ;)</text-property>
|
||
|
|
<text-property name="promptText">Booleano</text-property>
|
||
|
|
<property name="valueType">static</property>
|
||
|
|
<property name="isRequired">true</property>
|
||
|
|
<property name="dataType">boolean</property>
|
||
|
|
<property name="distinct">true</property>
|
||
|
|
<simple-property-list name="defaultValue">
|
||
|
|
<value type="constant">true</value>
|
||
|
|
</simple-property-list>
|
||
|
|
<property name="paramType">simple</property>
|
||
|
|
<property name="controlType">check-box</property>
|
||
|
|
<structure name="format"/>
|
||
|
|
</scalar-parameter>
|
||
|
|
<scalar-parameter name="prm_cores" id="13">
|
||
|
|
<text-property name="promptText">Cores</text-property>
|
||
|
|
<property name="valueType">static</property>
|
||
|
|
<property name="dataType">string</property>
|
||
|
|
<property name="distinct">true</property>
|
||
|
|
<simple-property-list name="defaultValue">
|
||
|
|
<value type="constant">blue</value>
|
||
|
|
</simple-property-list>
|
||
|
|
<list-property name="selectionList">
|
||
|
|
<structure>
|
||
|
|
<property name="value">red</property>
|
||
|
|
<property name="label">Vermelho</property>
|
||
|
|
</structure>
|
||
|
|
<structure>
|
||
|
|
<property name="value">green</property>
|
||
|
|
<property name="label">Verde</property>
|
||
|
|
</structure>
|
||
|
|
<structure>
|
||
|
|
<property name="value">blue</property>
|
||
|
|
<property name="label">Azul</property>
|
||
|
|
</structure>
|
||
|
|
</list-property>
|
||
|
|
<property name="paramType">multi-value</property>
|
||
|
|
<property name="controlType">list-box</property>
|
||
|
|
<property name="mustMatch">true</property>
|
||
|
|
<property name="fixedOrder">true</property>
|
||
|
|
<structure name="format">
|
||
|
|
<property name="category">Unformatted</property>
|
||
|
|
</structure>
|
||
|
|
</scalar-parameter>
|
||
|
|
<scalar-parameter name="prm_estado" id="14">
|
||
|
|
<text-property name="promptText">Estado</text-property>
|
||
|
|
<property name="valueType">dynamic</property>
|
||
|
|
<property name="dataSetName">estados</property>
|
||
|
|
<expression name="valueExpr" type="javascript">dataSetRow["codigo_ibge"]</expression>
|
||
|
|
<expression name="labelExpr" type="javascript">dataSetRow["nome"]</expression>
|
||
|
|
<property name="dataType">integer</property>
|
||
|
|
<property name="distinct">true</property>
|
||
|
|
<property name="paramType">simple</property>
|
||
|
|
<property name="controlType">list-box</property>
|
||
|
|
<property name="mustMatch">false</property>
|
||
|
|
<property name="fixedOrder">true</property>
|
||
|
|
<structure name="format">
|
||
|
|
<property name="category">Unformatted</property>
|
||
|
|
</structure>
|
||
|
|
</scalar-parameter>
|
||
|
|
<scalar-parameter name="NewParameter" id="15">
|
||
|
|
<text-property name="promptText">NewParameter</text-property>
|
||
|
|
<property name="valueType">static</property>
|
||
|
|
<property name="dataType">string</property>
|
||
|
|
<property name="distinct">true</property>
|
||
|
|
<list-property name="selectionList">
|
||
|
|
<structure>
|
||
|
|
<property name="value">1</property>
|
||
|
|
<property name="label">Opção 1</property>
|
||
|
|
</structure>
|
||
|
|
<structure>
|
||
|
|
<property name="value">2</property>
|
||
|
|
<property name="label">opção 2</property>
|
||
|
|
</structure>
|
||
|
|
<structure>
|
||
|
|
<property name="value">3</property>
|
||
|
|
<property name="label">Opção 3</property>
|
||
|
|
</structure>
|
||
|
|
</list-property>
|
||
|
|
<property name="paramType">simple</property>
|
||
|
|
<property name="controlType">radio-button</property>
|
||
|
|
<property name="fixedOrder">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.dbprofile" name="sigi" id="7">
|
||
|
|
<list-property name="privateDriverProperties">
|
||
|
|
<ex-property>
|
||
|
|
<name>org.eclipse.datatools.connectivity.db.connectionProperties</name>
|
||
|
|
</ex-property>
|
||
|
|
<ex-property>
|
||
|
|
<name>org.eclipse.datatools.connectivity.oda.profile.db.provider.id</name>
|
||
|
|
<value>org.eclipse.datatools.enablement.postgresql.connectionProfile</value>
|
||
|
|
</ex-property>
|
||
|
|
<ex-property>
|
||
|
|
<name>org.eclipse.datatools.connectivity.db.savePWD</name>
|
||
|
|
<value>true</value>
|
||
|
|
</ex-property>
|
||
|
|
<ex-property>
|
||
|
|
<name>org.eclipse.datatools.connectivity.drivers.defnType</name>
|
||
|
|
<value>org.eclipse.datatools.enablement.postgresql.postgresqlDriverTemplate</value>
|
||
|
|
</ex-property>
|
||
|
|
<ex-property>
|
||
|
|
<name>org.eclipse.datatools.connectivity.driverDefinitionID</name>
|
||
|
|
<value>DriverDefn.org.eclipse.datatools.enablement.postgresql.postgresqlDriverTemplate.Sigi PostgreDatabase</value>
|
||
|
|
</ex-property>
|
||
|
|
<ex-property>
|
||
|
|
<name>org.eclipse.datatools.connectivity.db.version</name>
|
||
|
|
<value>8.x</value>
|
||
|
|
</ex-property>
|
||
|
|
<ex-property>
|
||
|
|
<name>org.eclipse.datatools.connectivity.db.vendor</name>
|
||
|
|
<value>postgres</value>
|
||
|
|
</ex-property>
|
||
|
|
</list-property>
|
||
|
|
<property name="databaseName">sigi</property>
|
||
|
|
<property name="username">sigi</property>
|
||
|
|
<encrypted-property name="password" encryptionID="base64">MTIzNDU2</encrypted-property>
|
||
|
|
<property name="URL">jdbc:postgresql://localhost:5432/sigi</property>
|
||
|
|
<property name="driverClass">org.postgresql.Driver</property>
|
||
|
|
<property name="jarList">/opt/eclipse/plugins/postgresql-8.1-404.jdbc2.jar</property>
|
||
|
|
</oda-data-source>
|
||
|
|
</data-sources>
|
||
|
|
<data-sets>
|
||
|
|
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.dbprofile.sqbDataSet" name="estados" id="8">
|
||
|
|
<list-property name="columnHints">
|
||
|
|
<structure>
|
||
|
|
<property name="columnName">codigo_ibge</property>
|
||
|
|
<text-property name="displayName">codigo_ibge</text-property>
|
||
|
|
<text-property name="heading">codigo_ibge</text-property>
|
||
|
|
</structure>
|
||
|
|
<structure>
|
||
|
|
<property name="columnName">nome</property>
|
||
|
|
<text-property name="displayName">nome</text-property>
|
||
|
|
<text-property name="heading">nome</text-property>
|
||
|
|
</structure>
|
||
|
|
</list-property>
|
||
|
|
<list-property name="sortHints">
|
||
|
|
<structure>
|
||
|
|
<property name="columnName">nome</property>
|
||
|
|
<property name="position">0</property>
|
||
|
|
<property name="direction">asc</property>
|
||
|
|
<property name="nullValueOrdering">unknown</property>
|
||
|
|
<property name="isOptional">false</property>
|
||
|
|
</structure>
|
||
|
|
</list-property>
|
||
|
|
<structure name="cachedMetaData">
|
||
|
|
<list-property name="resultSet">
|
||
|
|
<structure>
|
||
|
|
<property name="position">1</property>
|
||
|
|
<property name="name">codigo_ibge</property>
|
||
|
|
<property name="dataType">integer</property>
|
||
|
|
</structure>
|
||
|
|
<structure>
|
||
|
|
<property name="position">2</property>
|
||
|
|
<property name="name">nome</property>
|
||
|
|
<property name="dataType">string</property>
|
||
|
|
</structure>
|
||
|
|
</list-property>
|
||
|
|
</structure>
|
||
|
|
<property name="dataSource">sigi</property>
|
||
|
|
<list-property name="resultSet">
|
||
|
|
<structure>
|
||
|
|
<property name="position">1</property>
|
||
|
|
<property name="name">codigo_ibge</property>
|
||
|
|
<property name="nativeName">codigo_ibge</property>
|
||
|
|
<property name="dataType">integer</property>
|
||
|
|
</structure>
|
||
|
|
<structure>
|
||
|
|
<property name="position">2</property>
|
||
|
|
<property name="name">nome</property>
|
||
|
|
<property name="nativeName">nome</property>
|
||
|
|
<property name="dataType">string</property>
|
||
|
|
</structure>
|
||
|
|
</list-property>
|
||
|
|
<xml-property name="queryText"><![CDATA[SELECT "codigo_ibge", "nome" || ' (' || "sigla" || ')' AS "nome"
|
||
|
|
FROM "public"."contatos_unidadefederativa"
|
||
|
|
ORDER BY "nome" ASC
|
||
|
|
]]></xml-property>
|
||
|
|
<structure name="designerState">
|
||
|
|
<property name="version">1.0</property>
|
||
|
|
<property name="stateContentAsString"><?xml version="1.0" encoding="UTF-8"?>
|
||
|
|
<SQLQueryBuilder editorInputType="SQLBuilderStorageEditorInput" name="estados" version="1.0">
|
||
|
|
<SQLStatement>SELECT &quot;codigo_ibge&quot;, &quot;nome&quot; || &apos; (&apos; || &quot;sigla&quot; || &apos;)&apos; AS &quot;nome&quot;&#x0A; FROM &quot;public&quot;.&quot;contatos_unidadefederativa&quot;&#x0A; ORDER BY &quot;nome&quot; ASC&#x0A;</SQLStatement>
|
||
|
|
<connInfo>postgres_8.x:Transient.org.eclipse.datatools.enablement.postgresql.connectionProfile:sigi:sigi</connInfo>
|
||
|
|
<omitSchemaInfo>false:true:</omitSchemaInfo>
|
||
|
|
<editorInputUsageOptions>useWindowState=true</editorInputUsageOptions>
|
||
|
|
<windowState height="698" version="1.0" width="1211">
|
||
|
|
<control height="217" isHideable="true" isVisible="true" name="SQLSourceViewer" width="1186"/>
|
||
|
|
<control height="230" isHideable="true" isVisible="true" name="DesignViewer" width="1199"/>
|
||
|
|
<control height="219" isHideable="true" isVisible="true" name="GraphControl" width="1191"/>
|
||
|
|
<control height="219" isHideable="true" isVisible="false" name="OutlineViewer" width="156"/>
|
||
|
|
</windowState>
|
||
|
|
</SQLQueryBuilder></property>
|
||
|
|
</structure>
|
||
|
|
<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>2.0</Version>
|
||
|
|
<design:ResultSets derivedMetaData="true">
|
||
|
|
<design:resultSetDefinitions>
|
||
|
|
<design:resultSetColumns>
|
||
|
|
<design:resultColumnDefinitions>
|
||
|
|
<design:attributes>
|
||
|
|
<design:identifier>
|
||
|
|
<design:name>codigo_ibge</design:name>
|
||
|
|
<design:position>1</design:position>
|
||
|
|
</design:identifier>
|
||
|
|
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
|
||
|
|
<design:precision>10</design:precision>
|
||
|
|
<design:scale>0</design:scale>
|
||
|
|
<design:nullability>NotNullable</design:nullability>
|
||
|
|
<design:uiHints>
|
||
|
|
<design:displayName>codigo_ibge</design:displayName>
|
||
|
|
</design:uiHints>
|
||
|
|
</design:attributes>
|
||
|
|
<design:usageHints>
|
||
|
|
<design:label>codigo_ibge</design:label>
|
||
|
|
<design:formattingHints>
|
||
|
|
<design:displaySize>11</design:displaySize>
|
||
|
|
</design:formattingHints>
|
||
|
|
</design:usageHints>
|
||
|
|
</design:resultColumnDefinitions>
|
||
|
|
<design:resultColumnDefinitions>
|
||
|
|
<design:attributes>
|
||
|
|
<design:identifier>
|
||
|
|
<design:name>nome</design:name>
|
||
|
|
<design:position>2</design:position>
|
||
|
|
</design:identifier>
|
||
|
|
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
|
||
|
|
<design:precision>25</design:precision>
|
||
|
|
<design:scale>0</design:scale>
|
||
|
|
<design:nullability>NotNullable</design:nullability>
|
||
|
|
<design:uiHints>
|
||
|
|
<design:displayName>nome</design:displayName>
|
||
|
|
</design:uiHints>
|
||
|
|
</design:attributes>
|
||
|
|
<design:usageHints>
|
||
|
|
<design:label>nome</design:label>
|
||
|
|
<design:formattingHints>
|
||
|
|
<design:displaySize>25</design:displaySize>
|
||
|
|
</design:formattingHints>
|
||
|
|
</design:usageHints>
|
||
|
|
</design:resultColumnDefinitions>
|
||
|
|
<design:resultColumnDefinitions>
|
||
|
|
<design:attributes>
|
||
|
|
<design:identifier>
|
||
|
|
<design:name>sigla</design:name>
|
||
|
|
<design:position>3</design:position>
|
||
|
|
</design:identifier>
|
||
|
|
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
|
||
|
|
<design:precision>2</design:precision>
|
||
|
|
<design:scale>0</design:scale>
|
||
|
|
<design:nullability>NotNullable</design:nullability>
|
||
|
|
<design:uiHints>
|
||
|
|
<design:displayName>sigla</design:displayName>
|
||
|
|
</design:uiHints>
|
||
|
|
</design:attributes>
|
||
|
|
<design:usageHints>
|
||
|
|
<design:label>sigla</design:label>
|
||
|
|
<design:formattingHints>
|
||
|
|
<design:displaySize>2</design:displaySize>
|
||
|
|
</design:formattingHints>
|
||
|
|
</design:usageHints>
|
||
|
|
</design:resultColumnDefinitions>
|
||
|
|
</design:resultSetColumns>
|
||
|
|
<design:criteria>
|
||
|
|
<design:rowOrdering>
|
||
|
|
<design:sortKeys>
|
||
|
|
<design:columnIdentifier>
|
||
|
|
<design:name>nome</design:name>
|
||
|
|
</design:columnIdentifier>
|
||
|
|
<design:sortDirection>Ascending</design:sortDirection>
|
||
|
|
<design:optional>false</design:optional>
|
||
|
|
</design:sortKeys>
|
||
|
|
</design:rowOrdering>
|
||
|
|
</design:criteria>
|
||
|
|
</design:resultSetDefinitions>
|
||
|
|
</design:ResultSets>
|
||
|
|
</model:DesignValues>]]></xml-property>
|
||
|
|
</oda-data-set>
|
||
|
|
</data-sets>
|
||
|
|
<styles>
|
||
|
|
<style name="report" id="4">
|
||
|
|
<property name="fontFamily">sans-serif</property>
|
||
|
|
<property name="fontSize">10pt</property>
|
||
|
|
</style>
|
||
|
|
<style name="crosstab-cell" 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="crosstab" id="6">
|
||
|
|
<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>
|
||
|
|
<body>
|
||
|
|
<text-data id="11">
|
||
|
|
<expression name="valueExpr">params["prm_sub_titulo"].value</expression>
|
||
|
|
<property name="contentType">html</property>
|
||
|
|
</text-data>
|
||
|
|
</body>
|
||
|
|
</report>
|