Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Grouping Mailing Labels
Grouping Mailing Labels [message #482745] Thu, 27 August 2009 18:28 Go to next message
SuperTime is currently offline SuperTimeFriend
Messages: 45
Registered: July 2009
Member
BIRT 2.3.2

I have set up my 3X10 mailing label report. I want to group the mailing
labels by different attributes of the customer, eg. group them by state.
I tried using the nested table concept the performance is a major issue
with this... What I did was place the main grid which has three tables
into one main table which has the grouping. I am not sure how to link the
the main table with the three nested tables.

Please advice, what is the best way to do this?

Below is a sample mailing label report which I want to group by State for
example.

------------------------------------------------------------ ---------------
<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.17"
id="1">
<property name="createdBy">Eclipse BIRT Designer Version
2.3.2.r232_20090202 Build &lt;2.3.2.v20090304-1357></property>
<property name="units">in</property>
<property name="comments">Copyright (c) 2007 &lt;&lt;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>
<data-sources>
<oda-data-source
extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source"
id="38">
<property
name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver </property>
<property name="odaURL">jdbc:classicmodels:sampledb</property>
<property name="odaUser">ClassicModels</property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="Data Set" id="39">
<list-property name="computedColumns">
<structure>
<property name="name">CityStateZip</property>
<expression name="expression">row["CITY"] + ", " +
row["STATE"] + " " + row["POSTALCODE"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">Attention</property>
<expression name="expression">"Attention: " +
row["CONTACTFIRSTNAME"] + " " + row["CONTACTLASTNAME"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">Address</property>
<expression name="expression">if (row["ADDRESSLINE2"]
== null){
row["ADDRESSLINE1"];
}
else{
row["ADDRESSLINE1"] + ", " + row["ADDRESSLINE2"];
}</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">Row Number</property>
<expression
name="expression">row["CUSTOMERNUMBER"]</expression>
<property name="dataType">integer</property>
<property
name="aggregateFunction">RUNNINGCOUNT</property>
</structure>
</list-property>
<list-property name="columnHints">
<structure>
<property name="columnName">CUSTOMERNUMBER</property>
<property name="displayName">CUSTOMERNUMBER</property>
</structure>
<structure>
<property name="columnName">CUSTOMERNAME</property>
<property name="displayName">CUSTOMERNAME</property>
</structure>
<structure>
<property name="columnName">CONTACTLASTNAME</property>
<property name="displayName">CONTACTLASTNAME</property>
</structure>
<structure>
<property name="columnName">CONTACTFIRSTNAME</property>
<property
name="displayName">CONTACTFIRSTNAME</property>
</structure>
<structure>
<property name="columnName">PHONE</property>
<property name="displayName">PHONE</property>
</structure>
<structure>
<property name="columnName">ADDRESSLINE1</property>
<property name="displayName">ADDRESSLINE1</property>
</structure>
<structure>
<property name="columnName">ADDRESSLINE2</property>
<property name="displayName">ADDRESSLINE2</property>
</structure>
<structure>
<property name="columnName">CITY</property>
<property name="displayName">CITY</property>
</structure>
<structure>
<property name="columnName">STATE</property>
<property name="displayName">STATE</property>
</structure>
<structure>
<property name="columnName">POSTALCODE</property>
<property name="displayName">POSTALCODE</property>
</structure>
<structure>
<property name="columnName">COUNTRY</property>
<property name="displayName">COUNTRY</property>
</structure>
<structure>
<property
name="columnName">SALESREPEMPLOYEENUMBER</property>
<property
name="displayName">SALESREPEMPLOYEENUMBER</property>
</structure>
<structure>
<property name="columnName">CREDITLIMIT</property>
<property name="displayName">CREDITLIMIT</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">CUSTOMERNUMBER</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">CUSTOMERNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">CONTACTLASTNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">CONTACTFIRSTNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">PHONE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">ADDRESSLINE1</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">ADDRESSLINE2</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">CITY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">STATE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">POSTALCODE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">COUNTRY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">12</property>
<property
name="name">SALESREPEMPLOYEENUMBER</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">CREDITLIMIT</property>
<property name="dataType">float</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">CityStateZip</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">Attention</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">Address</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">Row Number</property>
<property name="dataType">integer</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">CUSTOMERNUMBER</property>
<property name="nativeName">CUSTOMERNUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">CUSTOMERNAME</property>
<property name="nativeName">CUSTOMERNAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">CONTACTLASTNAME</property>
<property name="nativeName">CONTACTLASTNAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">CONTACTFIRSTNAME</property>
<property name="nativeName">CONTACTFIRSTNAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">PHONE</property>
<property name="nativeName">PHONE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">ADDRESSLINE1</property>
<property name="nativeName">ADDRESSLINE1</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">ADDRESSLINE2</property>
<property name="nativeName">ADDRESSLINE2</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">CITY</property>
<property name="nativeName">CITY</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">STATE</property>
<property name="nativeName">STATE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">POSTALCODE</property>
<property name="nativeName">POSTALCODE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">COUNTRY</property>
<property name="nativeName">COUNTRY</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">SALESREPEMPLOYEENUMBER</property>
<property
name="nativeName">SALESREPEMPLOYEENUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">CREDITLIMIT</property>
<property name="nativeName">CREDITLIMIT</property>
<property name="dataType">float</property>
<property name="nativeDataType">8</property>
</structure>
</list-property>
<property name="queryText">select *
from CLASSICMODELS.CUSTOMERS
where CLASSICMODELS.CUSTOMERS.COUNTRY = 'USA'
order by CLASSICMODELS.CUSTOMERS.CUSTOMERNAME asc</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>
<body>
<grid id="6">
<property name="marginTop">0pt</property>
<property name="width">100%</property>
<column id="7">
<property name="width">33.3%</property>
</column>
<column id="8">
<property name="width">33.4%</property>
</column>
<column id="9">
<property name="width">33.3%</property>
</column>
<row id="10">
<cell id="11">
<table id="14">
<property name="marginTop">0pt</property>
<property name="width">100%</property>
<property name="dataSet">Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">Attention</property>
<expression
name="expression">dataSetRow["Attention"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property
name="name">CUSTOMERNAME</property>
<expression
name="expression">dataSetRow["CUSTOMERNAME"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property
name="name">ADDRESSLINE1</property>
<expression
name="expression">dataSetRow["ADDRESSLINE1"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property
name="name">ADDRESSLINE2</property>
<expression
name="expression">dataSetRow["ADDRESSLINE2"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property
name="name">CityStateZip</property>
<expression
name="expression">dataSetRow["CityStateZip"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">Address</property>
<expression
name="expression">dataSetRow["Address"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property
name="name">CUSTOMERNUMBER</property>
<expression
name="expression">dataSetRow["CUSTOMERNUMBER"]</expression >
<property
name="dataType">integer</property>
</structure>
<structure>
<property
name="name">CONTACTLASTNAME</property>
<expression
name="expression">dataSetRow["CONTACTLASTNAME"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property
name="name">CONTACTFIRSTNAME</property>
<expression
name="expression">dataSetRow["CONTACTFIRSTNAME"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">PHONE</property>
<expression
name="expression">dataSetRow["PHONE"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">CITY</property>
<expression
name="expression">dataSetRow["CITY"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">STATE</property>
<expression
name="expression">dataSetRow["STATE"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">POSTALCODE</property>
<expression
name="expression">dataSetRow["POSTALCODE"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">COUNTRY</property>
<expression
name="expression">dataSetRow["COUNTRY"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property
name="name">SALESREPEMPLOYEENUMBER</property>
<expression
name="expression">dataSetRow["SALESREPEMPLOYEENUMBER"]</expression >
<property
name="dataType">integer</property>
</structure>
<structure>
<property
name="name">CREDITLIMIT</property>
<expression
name="expression">dataSetRow["CREDITLIMIT"]</expression >
<property name="dataType">float</property>
</structure>
<structure>
<property name="name">Row Number</property>
<expression
name="expression">dataSetRow["Row Number"]</expression>
<property
name="dataType">integer</property>
</structure>
</list-property>
<property name="pageBreakInterval">50</property>
<list-property name="filter">
<structure>
<property name="operator">eq</property>
<expression name="expr">row["Row
Number"]%3</expression>
<simple-property-list name="value1">
<value>1</value>
</simple-property-list>
</structure>
</list-property>
<column id="21"/>
<header>
<row id="15">
<cell id="16"/>
</row>
</header>
<detail>
<row id="17">
<cell id="18">
<data id="41">
<property
name="fontSize">medium</property>
<property
name="fontWeight">normal</property>
<property
name="fontStyle">normal</property>
<property
name="textUnderline">none</property>
<property
name="resultSetColumn">Attention</property>
</data>
<data id="42">
<property
name="fontSize">medium</property>
<property
name="fontWeight">normal</property>
<property
name="fontStyle">normal</property>
<property
name="textUnderline">none</property>
<property
name="resultSetColumn">CUSTOMERNAME</property>
</data>
<data id="46">
<property
name="fontSize">medium</property>
<property
name="fontWeight">normal</property>
<property
name="fontStyle">normal</property>
<property
name="textUnderline">none</property>
<property
name="resultSetColumn">Address</property>
</data>
<data id="45">
<property
name="fontSize">medium</property>
<property
name="fontWeight">normal</property>
<property
name="fontStyle">normal</property>
<property
name="textUnderline">none</property>
<property
name="paddingTop">1pt</property>
<property
name="paddingBottom">0.25in</property>
<property
name="resultSetColumn">CityStateZip</property>
</data>
</cell>
</row>
</detail>
<footer>
<row id="19">
<cell id="20"/>
</row>
</footer>
</table>
</cell>
<cell id="12">
<table id="22">
<property name="width">100%</property>
<property name="dataSet">Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">Attention</property>
<expression
name="expression">dataSetRow["Attention"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property
name="name">CUSTOMERNAME</property>
<expression
name="expression">dataSetRow["CUSTOMERNAME"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">Address</property>
<expression
name="expression">dataSetRow["Address"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property
name="name">CityStateZip</property>
<expression
name="expression">dataSetRow["CityStateZip"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property
name="name">CUSTOMERNUMBER</property>
<expression
name="expression">dataSetRow["CUSTOMERNUMBER"]</expression >
<property
name="dataType">integer</property>
</structure>
<structure>
<property
name="name">CONTACTLASTNAME</property>
<expression
name="expression">dataSetRow["CONTACTLASTNAME"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property
name="name">CONTACTFIRSTNAME</property>
<expression
name="expression">dataSetRow["CONTACTFIRSTNAME"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">PHONE</property>
<expression
name="expression">dataSetRow["PHONE"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property
name="name">ADDRESSLINE1</property>
<expression
name="expression">dataSetRow["ADDRESSLINE1"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property
name="name">ADDRESSLINE2</property>
<expression
name="expression">dataSetRow["ADDRESSLINE2"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">CITY</property>
<expression
name="expression">dataSetRow["CITY"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">STATE</property>
<expression
name="expression">dataSetRow["STATE"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">POSTALCODE</property>
<expression
name="expression">dataSetRow["POSTALCODE"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">COUNTRY</property>
<expression
name="expression">dataSetRow["COUNTRY"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property
name="name">SALESREPEMPLOYEENUMBER</property>
<expression
name="expression">dataSetRow["SALESREPEMPLOYEENUMBER"]</expression >
<property
name="dataType">integer</property>
</structure>
<structure>
<property
name="name">CREDITLIMIT</property>
<expression
name="expression">dataSetRow["CREDITLIMIT"]</expression >
<property name="dataType">float</property>
</structure>
<structure>
<property name="name">Row Number</property>
<expression
name="expression">dataSetRow["Row Number"]</expression>
<property
name="dataType">integer</property>
</structure>
</list-property>
<property name="pageBreakInterval">50</property>
<list-property name="filter">
<structure>
<property name="operator">eq</property>
<expression name="expr">row["Row
Number"]%3</expression>
<simple-property-list name="value1">
<value>2</value>
</simple-property-list>
</structure>
</list-property>
<column id="29"/>
<header>
<row id="23">
<cell id="24"/>
</row>
</header>
<detail>
<row id="25">
<cell id="26">
<data id="48">
<property
name="fontSize">medium</property>
<property
name="fontWeight">normal</property>
<property
name="fontStyle">normal</property>
<property
name="textUnderline">none</property>
<property
name="resultSetColumn">Attention</property>
</data>
<data id="49">
<property
name="fontSize">medium</property>
<property
name="fontWeight">normal</property>
<property
name="fontStyle">normal</property>
<property
name="textUnderline">none</property>
<property
name="resultSetColumn">CUSTOMERNAME</property>
</data>
<data id="50">
<property
name="fontSize">medium</property>
<property
name="fontWeight">normal</property>
<property
name="fontStyle">normal</property>
<property
name="textUnderline">none</property>
<property
name="resultSetColumn">Address</property>
</data>
<data id="51">
<property
name="fontSize">medium</property>
<property
name="fontWeight">normal</property>
<property
name="fontStyle">normal</property>
<property
name="textUnderline">none</property>
<property
name="paddingTop">1pt</property>
<property
name="paddingBottom">0.25in</property>
<property
name="resultSetColumn">CityStateZip</property>
</data>
</cell>
</row>
</detail>
<footer>
<row id="27">
<cell id="28"/>
</row>
</footer>
</table>
</cell>
<cell id="13">
<table id="30">
<property name="width">100%</property>
<property name="dataSet">Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">Attention</property>
<expression
name="expression">dataSetRow["Attention"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property
name="name">CUSTOMERNAME</property>
<expression
name="expression">dataSetRow["CUSTOMERNAME"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">Address</property>
<expression
name="expression">dataSetRow["Address"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property
name="name">CityStateZip</property>
<expression
name="expression">dataSetRow["CityStateZip"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property
name="name">CUSTOMERNUMBER</property>
<expression
name="expression">dataSetRow["CUSTOMERNUMBER"]</expression >
<property
name="dataType">integer</property>
</structure>
<structure>
<property
name="name">CONTACTLASTNAME</property>
<expression
name="expression">dataSetRow["CONTACTLASTNAME"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property
name="name">CONTACTFIRSTNAME</property>
<expression
name="expression">dataSetRow["CONTACTFIRSTNAME"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">PHONE</property>
<expression
name="expression">dataSetRow["PHONE"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property
name="name">ADDRESSLINE1</property>
<expression
name="expression">dataSetRow["ADDRESSLINE1"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property
name="name">ADDRESSLINE2</property>
<expression
name="expression">dataSetRow["ADDRESSLINE2"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">CITY</property>
<expression
name="expression">dataSetRow["CITY"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">STATE</property>
<expression
name="expression">dataSetRow["STATE"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">POSTALCODE</property>
<expression
name="expression">dataSetRow["POSTALCODE"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">COUNTRY</property>
<expression
name="expression">dataSetRow["COUNTRY"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property
name="name">SALESREPEMPLOYEENUMBER</property>
<expression
name="expression">dataSetRow["SALESREPEMPLOYEENUMBER"]</expression >
<property
name="dataType">integer</property>
</structure>
<structure>
<property
name="name">CREDITLIMIT</property>
<expression
name="expression">dataSetRow["CREDITLIMIT"]</expression >
<property name="dataType">float</property>
</structure>
<structure>
<property name="name">Row Number</property>
<expression
name="expression">dataSetRow["Row Number"]</expression>
<property
name="dataType">integer</property>
</structure>
</list-property>
<property name="pageBreakInterval">50</property>
<list-property name="filter">
<structure>
<property name="operator">eq</property>
<expression name="expr">row["Row
Number"]%3</expression>
<simple-property-list name="value1">
<value>0</value>
</simple-property-list>
</structure>
</list-property>
<column id="37"/>
<header>
<row id="31">
<cell id="32"/>
</row>
</header>
<detail>
<row id="33">
<cell id="34">
<data id="53">
<property
name="fontSize">medium</property>
<property
name="fontWeight">normal</property>
<property
name="fontStyle">normal</property>
<property
name="textUnderline">none</property>
<property
name="resultSetColumn">Attention</property>
</data>
<data id="54">
<property
name="fontSize">medium</property>
<property
name="fontWeight">normal</property>
<property
name="fontStyle">normal</property>
<property
name="textUnderline">none</property>
<property
name="resultSetColumn">CUSTOMERNAME</property>
</data>
<data id="55">
<property
name="fontSize">medium</property>

Report message to a moderator

Re: Grouping Mailing Labels [message #482939 is a reply to message #482745] Fri, 28 August 2009 15:24 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member
I modified your example to include the master table. Can you look at it
and explain if there is a performance issue?

Jason

<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.17"
id="1">
<property name="createdBy">Eclipse BIRT Designer Version
2.3.2.r232_20090202 Build &lt;2.3.2.v20090218-0730></property>
<property name="units">in</property>
<property name="comments">Copyright (c) 2007 &lt;&lt;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>
<data-sources>
<oda-data-source
extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source"
id="38">
<property
name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver </property>
<property name="odaURL">jdbc:classicmodels:sampledb</property>
<property name="odaUser">ClassicModels</property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="Data Set" id="39">
<list-property name="computedColumns">
<structure>
<property name="name">CityStateZip</property>
<expression name="expression">row["CITY"] + ", " +
row["STATE"] + " " + row["POSTALCODE"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">Attention</property>
<expression name="expression">"Attention: " +
row["CONTACTFIRSTNAME"] + " " + row["CONTACTLASTNAME"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">Address</property>
<expression name="expression">if
(row["ADDRESSLINE2"] == null){
row["ADDRESSLINE1"];
}
else{
row["ADDRESSLINE1"] + ", " + row["ADDRESSLINE2"];
}</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">Row Number</property>
<expression
name="expression">row["CUSTOMERNUMBER"]</expression>
<property name="dataType">integer</property>
<property
name="aggregateFunction">RUNNINGCOUNT</property>
</structure>
</list-property>
<list-property name="columnHints">
<structure>
<property name="columnName">CUSTOMERNUMBER</property>
<property name="displayName">CUSTOMERNUMBER</property>
</structure>
<structure>
<property name="columnName">CUSTOMERNAME</property>
<property name="displayName">CUSTOMERNAME</property>
</structure>
<structure>
<property name="columnName">CONTACTLASTNAME</property>
<property name="displayName">CONTACTLASTNAME</property>
</structure>
<structure>
<property name="columnName">CONTACTFIRSTNAME</property>
<property
name="displayName">CONTACTFIRSTNAME</property>
</structure>
<structure>
<property name="columnName">PHONE</property>
<property name="displayName">PHONE</property>
</structure>
<structure>
<property name="columnName">ADDRESSLINE1</property>
<property name="displayName">ADDRESSLINE1</property>
</structure>
<structure>
<property name="columnName">ADDRESSLINE2</property>
<property name="displayName">ADDRESSLINE2</property>
</structure>
<structure>
<property name="columnName">CITY</property>
<property name="displayName">CITY</property>
</structure>
<structure>
<property name="columnName">STATE</property>
<property name="displayName">STATE</property>
</structure>
<structure>
<property name="columnName">POSTALCODE</property>
<property name="displayName">POSTALCODE</property>
</structure>
<structure>
<property name="columnName">COUNTRY</property>
<property name="displayName">COUNTRY</property>
</structure>
<structure>
<property
name="columnName">SALESREPEMPLOYEENUMBER</property>
<property
name="displayName">SALESREPEMPLOYEENUMBER</property>
</structure>
<structure>
<property name="columnName">CREDITLIMIT</property>
<property name="displayName">CREDITLIMIT</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">CUSTOMERNUMBER</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">CUSTOMERNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">CONTACTLASTNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">CONTACTFIRSTNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">PHONE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">ADDRESSLINE1</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">ADDRESSLINE2</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">CITY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">STATE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">POSTALCODE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">COUNTRY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">12</property>
<property
name="name">SALESREPEMPLOYEENUMBER</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">CREDITLIMIT</property>
<property name="dataType">float</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">CityStateZip</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">Attention</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">Address</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">Row Number</property>
<property name="dataType">integer</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<list-property name="parameters">
<structure>
<property name="name">param_1</property>
<property name="nativeName"></property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
<property name="position">1</property>
<expression name="defaultValue">"CA"</expression>
<property name="isOptional">true</property>
<property name="allowNull">true</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">CUSTOMERNUMBER</property>
<property name="nativeName">CUSTOMERNUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">CUSTOMERNAME</property>
<property name="nativeName">CUSTOMERNAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">CONTACTLASTNAME</property>
<property name="nativeName">CONTACTLASTNAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">CONTACTFIRSTNAME</property>
<property name="nativeName">CONTACTFIRSTNAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">PHONE</property>
<property name="nativeName">PHONE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">ADDRESSLINE1</property>
<property name="nativeName">ADDRESSLINE1</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">ADDRESSLINE2</property>
<property name="nativeName">ADDRESSLINE2</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">CITY</property>
<property name="nativeName">CITY</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">STATE</property>
<property name="nativeName">STATE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">POSTALCODE</property>
<property name="nativeName">POSTALCODE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">COUNTRY</property>
<property name="nativeName">COUNTRY</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">SALESREPEMPLOYEENUMBER</property>
<property
name="nativeName">SALESREPEMPLOYEENUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">CREDITLIMIT</property>
<property name="nativeName">CREDITLIMIT</property>
<property name="dataType">float</property>
<property name="nativeDataType">8</property>
</structure>
</list-property>
<property name="queryText">select *
from CLASSICMODELS.CUSTOMERS
where CLASSICMODELS.CUSTOMERS.COUNTRY = 'USA'
and STATE = ?
order by CLASSICMODELS.CUSTOMERS.CUSTOMERNAME asc</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>12</design:nativeDataTypeCode>
<design:precision>50</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:DataSetParameters>
</model:DesignValues>]]></xml-property>
</oda-data-set>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="state" id="57">
<list-property name="columnHints">
<structure>
<property name="columnName">STATE</property>
<property name="displayName">STATE</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">STATE</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">STATE</property>
<property name="nativeName">STATE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<property name="queryText">select CLASSICMODELS.CUSTOMERS.STATE
from customers where country = 'USA'</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>STATE</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>50</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>STATE</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>STATE</design:label>
<design:formattingHints>
<design:displaySize>50</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>
<body>
<table id="58">
<property name="width">100%</property>
<property name="dataSet">state</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">STATE</property>
<property name="displayName">STATE</property>
<expression
name="expression">dataSetRow["STATE"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<column id="67"/>
<header>
<row id="59">
<property name="backgroundColor">#004080</property>
<property name="color">#FFFFFF</property>
<cell id="60">
<label id="70">
<text-property
name="text">STATE</text-property>
</label>
</cell>
</row>
</header>
<group id="72">
<property name="groupName">NewTableGroup1</property>
<property name="interval">none</property>
<property name="sortDirection">asc</property>
<expression name="keyExpr">row["STATE"]</expression>
<structure name="toc">
<expression
name="expressionValue">row["STATE"]</expression>
</structure>
<property name="repeatHeader">true</property>
<property name="hideDetail">false</property>
<property
name="pageBreakAfter">always-excluding-last</property>
<property name="pageBreakBefore">auto</property>
<property name="pageBreakInside">auto</property>
<header>
<row id="73">
<property name="backgroundColor">#004080</property>
<property name="color">#FFFFFF</property>
<cell id="74">
<data id="77">
<property
name="resultSetColumn">STATE</property>
</data>
</cell>
</row>
</header>
<footer>
<row id="75">
<cell id="76"/>
</row>
</footer>
</group>
<detail>
<row id="62">
<cell id="63">
<grid id="6">
<property name="marginTop">0pt</property>
<property name="width">100%</property>
<column id="7">
<property name="width">33.3%</property>
</column>
<column id="8">
<property name="width">33.4%</property>
</column>
<column id="9">
<property name="width">33.3%</property>
</column>
<row id="10">
<cell id="11">
<table id="14">
<property
name="marginTop">0pt</property>
<property
name="width">100%</property>
<property name="dataSet">Data
Set</property>
<list-property
name="paramBindings">
<structure>
<property
name="paramName">param_1</property>
<expression
name="expression">row["STATE"]</expression>
</structure>
</list-property>
<list-property
name="boundDataColumns">
<structure>
<property
name="name">Attention</property>
<expression
name="expression">dataSetRow["Attention"]</expression>
<property
name="dataType">string</property>
</structure>
<structure>
<property
name="name">CUSTOMERNAME</property>
<expression
name="expression">dataSetRow["CUSTOMERNAME"]</expression >
<property
name="dataType">string</property>
</structure>
<structure>
<property
name="name">ADDRESSLINE1</property>
<expression
name="expression">dataSetRow["ADDRESSLINE1"]</expression >
<property
name="dataType">string</property>
</structure>
<structure>
<property
name="name">ADDRESSLINE2</property>
<expression
name="expression">dataSetRow["ADDRESSLINE2"]</expression >
<property
name="dataType">string</property>
</structure>
<structure>
<property
name="name">CityStateZip</property>
<expression
name="expression">dataSetRow["CityStateZip"]</expression >
<property
name="dataType">string</property>
</structure>
<structure>
<property
name="name">Address</property>
<expression
name="expression">dataSetRow["Address"]</expression>
<property
name="dataType">string</property>
</structure>
<structure>
<property
name="name">CUSTOMERNUMBER</property>
<expression
name="expression">dataSetRow["CUSTOMERNUMBER"]</expression >
<property
name="dataType">integer</property>
</structure>
<structure>
<property
name="name">CONTACTLASTNAME</property>
<expression
name="expression">dataSetRow["CONTACTLASTNAME"]</expression >
<property
name="dataType">string</property>
</structure>
<structure>
<property
name="name">CONTACTFIRSTNAME</property>
<expression
name="expression">dataSetRow["CONTACTFIRSTNAME"]</expression >
<property
name="dataType">string</property>
</structure>
<structure>
<property
name="name">PHONE</property>
<expression
name="expression">dataSetRow["PHONE"]</expression>
<property
name="dataType">string</property>
</structure>
<structure>
<property
name="name">CITY</property>
<expression
name="expression">dataSetRow["CITY"]</expression>
<property
name="dataType">string</property>
</structure>
<structure>
<property
name="name">STATE</property>
<expression
name="expression">dataSetRow["STATE"]</expression>
<property
name="dataType">string</property>
</structure>
<structure>
<property
name="name">POSTALCODE</property>
<expression
name="expression">dataSetRow["POSTALCODE"]</expression>
<property
name="dataType">string</property>
</structure>
<structure>
<property
name="name">COUNTRY</property>
<expression
name="expression">dataSetRow["COUNTRY"]</expression>
<property
name="dataType">string</property>
</structure>
<structure>
<property
name="name">SALESREPEMPLOYEENUMBER</property>
<expression
name="expression">dataSetRow["SALESREPEMPLOYEENUMBER"]</expression >
<property
name="dataType">integer</property>
</structure>
<structure>
<property
name="name">CREDITLIMIT</property>
<expression
name="expression">dataSetRow["CREDITLIMIT"]</expression >
<property
name="dataType">float</property>
</structure>
<structure>
<property
name="name">Row Number</property>
<expression
name="expression">dataSetRow["Row Number"]</expression>
<property
name="dataType">integer</property>
</structure>
</list-property>
<property
name="pageBreakInterval">50</property>
<list-property name="filter">
<structure>
<property
name="operator">eq</property>
<expression
name="expr">row["Row Number"]%3</expression>
<simple-property-list
name="value1">
<value>1</value>
</simple-property-list>
</structure>
</list-property>
<column id="21"/>
<header>
<row id="15">
<cell id="16"/>
</row>
</header>
<detail>
<row id="17">
<cell id="18">
<data id="41">
<property
name="fontSize">medium</property>
<property
name="fontWeight">normal</property>
<property
name="fontStyle">normal</property>
<property
name="textUnderline">none</property>
<property
name="resultSetColumn">Attention</property>
</data>
<data id="42">
<property
name="fontSize">medium</property>
<property
name="fontWeight">normal</property>
<property
name="fontStyle">normal</property>
<property
name="textUnderline">none</property>
<property
name="resultSetColumn">CUSTOMERNAME</property>
</data>
<data id="46">
<property
name="fontSize">medium</property>
<property
name="fontWeight">normal</property>
<property
name="fontStyle">normal</property>
<property
name="textUnderline">none</property>
<property
name="resultSetColumn">Address</property>
</data>
<data id="45">
<property
name="fontSize">medium</property>
<property
name="fontWeight">normal</property>
<property
name="fontStyle">normal</property>
<property
name="textUnderline">none</property>
<property
name="paddingTop">1pt</property>
<property
name="paddingBottom">0.25in</property>
<property
name="resultSetColumn">CityStateZip</property>
</data>
</cell>
</row>
</detail>
<footer>
<row id="19">
<cell id="20"/>
</row>
</footer>
</table>
</cell>
<cell id="12">
<table id="22">
<property
name="width">100%</property>
<property name="dataSet">Data
Set</property>
<list-property
name="paramBindings">
<structure>
<property
name="paramName">param_1</property>
<expression
name="expression">row["STATE"]</expression>
</structure>
</list-property>
<list-property
name="boundDataColumns">
<structure>
<property
name="name">Attention</property>
<expression
name="expression">dataSetRow["Attention"]</expression>
<property
name="dataType">string</property>
</structure>
<structure>
<property
name="name">CUSTOMERNAME</property>
<expression
name="expression">dataSetRow["CUSTOMERNAME"]</expression >
<property
name="dataType">string</property>
</structure>
<structure>
<property
name="name">Address</property>
<expression
name="expression">dataSetRow["Address"]</expression>
<property
name="dataType">string</property>
</structure>
<structure>
<property
name="name">CityStateZip</property>
<expression
name="expression">dataSetRow["CityStateZip"]</expression >
<property
name="dataType">string</property>
</structure>
<structure>
<property
name="name">CUSTOMERNUMBER</property>
<expression
name="expression">dataSetRow["CUSTOMERNUMBER"]</expression >
<property
name="dataType">integer</property>
</structure>
<structure>
<property
name="name">CONTACTLASTNAME</property>
<expression
name="expression">dataSetRow["CONTACTLASTNAME"]</expression >
<property
name="dataType">string</property>
</structure>
<structure>
<property
name="name">CONTACTFIRSTNAME</property>
<expression
name="expression">dataSetRow["CONTACTFIRSTNAME"]</expression >
<property
name="dataType">string</property>
</structure>
<structure>
<property
name="name">PHONE</property>
<expression
name="expression">dataSetRow["PHONE"]</expression>
<property
name="dataType">string</property>
</structure>
<structure>
<property
name="name">ADDRESSLINE1</property>
<expression
name="expression">dataSetRow["ADDRESSLINE1"]</expression >
<property
name="dataType">string</property>
</structure>
<structure>
<property
name="name">ADDRESSLINE2</property>
<expression
name="expression">dataSetRow["ADDRESSLINE2"]</expression >
<property
name="dataType">string</property>
</structure>
<structure>
<property
name="name">CITY</property>
<expression
name="expression">dataSetRow["CITY"]</expression>
<property
name="dataType">string</property>
</structure>
<structure>
<property
name="name">STATE</property>
<expression
name="expression">dataSetRow["STATE"]</expression>
<property
name="dataType">string</property>
</structure>
<structure>
<property
name="name">POSTALCODE</property>
<expression
name="expression">dataSetRow["POSTALCODE"]</expression>
<property
name="dataType">string</property>
</structure>
<structure>
<property
name="name">COUNTRY</property>
<expression
name="expression">dataSetRow["COUNTRY"]</expression>
<property
name="dataType">string</property>
</structure>
<structure>
<property
name="name">SALESREPEMPLOYEENUMBER</property>
<expression
name="expression">dataSetRow["SALESREPEMPLOYEENUMBER"]</expression >
<property
name="dataType">integer</property>
</structure>
<structure>
<property
name="name">CREDITLIMIT</property>
<expression
name="expression">dataSetRow["CREDITLIMIT"]</expression >
<property
name="dataType">float</property>
</structure>
<structure>
<property
name="name">Row Number</property>
<expression
name="expression">dataSetRow["Row Number"]</expression>
<property
name="dataType">integer</property>
</structure>
</list-propert

Report message to a moderator

Previous Topic:Error when opening a data source (Birt report)
Next Topic:Cached report...
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Apr 20 02:21:30 GMT 2024

Powered by FUDForum. Page generated in 0.02972 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly