Eclipse Community Forums: BIRT » Hide Header Row on PDF Output

Help

Home

Home » Archived » BIRT » Hide Header Row on PDF Output

Show: Today's Messages :: Show Polls :: Message Navigator

Hide Header Row on PDF Output [message #485399]

Fri, 11 September 2009 15:37

Raishad

Messages: 77
Registered: July 2009

Member

Hi,

I have a report that can have multiple pages. The header row repeats for
every page when viewing it in the web viewer and that is fine.

But when printing the report, the header is repeated on every page.
I would like the header to only appear once on the first page, and then
hide it on the rest of the pages when displaying the PDF.

Is this possible?

Thanks
Raishad

Report message to a moderator

Re: Hide Header Row on PDF Output [message #485434 is a reply to message #485399]

Fri, 11 September 2009 17:36

Jason Weathersby

Messages: 9167
Registered: July 2009

Senior Member

Raishad,

This possible with 2.5 using page variables.
See attached example.

Jason

<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.20"
id="1">
<property name="createdBy">Eclipse BIRT Designer Version
2.5.0.v20090603 Build <2.5.0.v20090617-0630></property>
<property name="units">in</property>
<method name="onPageStart"><![CDATA[var first =
reportContext.getPageVariable("FIRST");
if( first == 1 ){
reportContext.setPageVariable("FIRST",2);
}]]></method>
<method name="onPageEnd"><![CDATA[var first =
reportContext.getPageVariable("FIRST");
if( first == 0 ){
reportContext.setPageVariable("FIRST",1);
}]]></method>
<property name="iconFile">/templates/blank_report.gif</property>
<property name="bidiLayoutOrientation">ltr</property>
<data-sources>
<oda-data-source
extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source"
id="7">
<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="8">
<list-property name="columnHints">
<structure>
<property name="columnName">ORDERNUMBER</property>
<property name="displayName">ORDERNUMBER</property>
</structure>
<structure>
<property name="columnName">ORDERDATE</property>
<property name="displayName">ORDERDATE</property>
</structure>
<structure>
<property name="columnName">REQUIREDDATE</property>
<property name="displayName">REQUIREDDATE</property>
</structure>
<structure>
<property name="columnName">SHIPPEDDATE</property>
<property name="displayName">SHIPPEDDATE</property>
</structure>
<structure>
<property name="columnName">STATUS</property>
<property name="displayName">STATUS</property>
</structure>
<structure>
<property name="columnName">COMMENTS</property>
<property name="displayName">COMMENTS</property>
</structure>
<structure>
<property name="columnName">CUSTOMERNUMBER</property>
<property name="displayName">CUSTOMERNUMBER</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">ORDERNUMBER</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">ORDERDATE</property>
<property name="dataType">date</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">REQUIREDDATE</property>
<property name="dataType">date</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">SHIPPEDDATE</property>
<property name="dataType">date</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">STATUS</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">COMMENTS</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">CUSTOMERNUMBER</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">ORDERNUMBER</property>
<property name="nativeName">ORDERNUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">ORDERDATE</property>
<property name="nativeName">ORDERDATE</property>
<property name="dataType">date</property>
<property name="nativeDataType">91</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">REQUIREDDATE</property>
<property name="nativeName">REQUIREDDATE</property>
<property name="dataType">date</property>
<property name="nativeDataType">91</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">SHIPPEDDATE</property>
<property name="nativeName">SHIPPEDDATE</property>
<property name="dataType">date</property>
<property name="nativeDataType">91</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">STATUS</property>
<property name="nativeName">STATUS</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">COMMENTS</property>
<property name="nativeName">COMMENTS</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">CUSTOMERNUMBER</property>
<property name="nativeName">CUSTOMERNUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[select *
from orders]]></xml-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>ORDERNUMBER</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>ORDERNUMBER</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>ORDERNUMBER</design:label>
<design:formattingHints>
<design:displaySize>11</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>ORDERDATE</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>91</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>ORDERDATE</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>ORDERDATE</design:label>
<design:formattingHints>
<design:displaySize>10</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>REQUIREDDATE</design:name>
<design:position>3</design:position>
<design:nativeDataTypeCode>91</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>REQUIREDDATE</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>REQUIREDDATE</design:label>
<design:formattingHints>
<design:displaySize>10</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>SHIPPEDDATE</design:name>
<design:position>4</design:position>
<design:nativeDataTypeCode>91</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>SHIPPEDDATE</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>SHIPPEDDATE</design:label>
<design:formattingHints>
<design:displaySize>10</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>STATUS</design:name>
<design:position>5</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>15</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>STATUS</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>STATUS</design:label>
<design:formattingHints>
<design:displaySize>15</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>COMMENTS</design:name>
<design:position>6</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>32700</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>COMMENTS</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>COMMENTS</design:label>
<design:formattingHints>
<design:displaySize>32700</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>CUSTOMERNUMBER</design:name>
<design:position>7</design:position>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>CUSTOMERNUMBER</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>CUSTOMERNUMBER</design:label>
<design:formattingHints>
<design:displaySize>11</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="report" id="4">
<property name="fontFamily">"Verdana"</property>
<property name="fontSize">10pt</property>
</style>
<style name="crosstab" id="5">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
<style name="crosstab-cell" 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>
<style name="table-header" id="55">
<property name="backgroundColor">#6078BF</property>
<property name="fontFamily">"Arial"</property>
<property name="fontSize">small</property>
<property name="fontWeight">bold</property>
<property name="color">#FFFFFF</property>
<property name="paddingTop">0px</property>
<property name="paddingLeft">0px</property>
<property name="paddingBottom">0px</property>
<property name="paddingRight">0px</property>
</style>
<style name="table-footer" id="56">
<property name="backgroundColor">#6078BF</property>
<property name="fontFamily">"Arial"</property>
<property name="fontSize">small</property>
<property name="fontWeight">bold</property>
<property name="color">#FFFFFF</property>
<property name="paddingTop">0px</property>
<property name="paddingLeft">0px</property>
<property name="paddingBottom">0px</property>
<property name="paddingRight">0px</property>
</style>
<style name="table-detail" id="57">
<property name="backgroundColor">#E6ECFF</property>
<property name="fontFamily">"Arial"</property>
<property name="fontSize">x-small</property>
<property name="fontWeight">bold</property>
<property name="color">#000080</property>
<property name="paddingTop">0px</property>
<property name="paddingLeft">0px</property>
<property name="paddingBottom">0px</property>
<property name="paddingRight">0px</property>
</style>
<style name="table-group-header-1" id="58">
<property name="backgroundColor">#809FFF</property>
<property name="fontFamily">"Arial"</property>
<property name="fontSize">small</property>
<property name="fontWeight">bold</property>
<property name="color">#FFFFFF</property>
<property name="paddingTop">0px</property>
<property name="paddingLeft">0px</property>
<property name="paddingBottom">0px</property>
<property name="paddingRight">0px</property>
</style>
<style name="table-group-footer-1" id="59">
<property name="backgroundColor">#809FFF</property>
<property name="fontFamily">"Arial"</property>
<property name="fontSize">small</property>
<property name="fontWeight">bold</property>
<property name="color">#FFFFFF</property>
<property name="paddingTop">0px</property>
<property name="paddingLeft">0px</property>
<property name="paddingBottom">0px</property>
<property name="paddingRight">0px</property>
</style>
<style name="special-header" id="60">
<property name="backgroundColor">#6078BF</property>
<property name="fontFamily">"Arial"</property>
<property name="fontSize">medium</property>
<property name="fontWeight">bold</property>
<property name="color">#FFFFFF</property>
<property name="paddingTop">0px</property>
<property name="paddingLeft">0px</property>
<property name="paddingBottom">0px</property>
<property name="paddingRight">0px</property>
</style>
<style name="crosstab-detail" id="61">
<property name="backgroundColor">#E6ECFF</property>
<property name="fontFamily">"Arial"</property>
<property name="fontSize">x-small</property>
<property name="fontWeight">bold</property>
<property name="color">#000080</property>
<property name="paddingTop">0px</property>
<property name="paddingLeft">0px</property>
<property name="paddingBottom">0px</property>
<property name="paddingRight">0px</property>
</style>
<style name="crosstab-header" id="62">
<property name="backgroundColor">#6078BF</property>
<property name="fontFamily">"Arial"</property>
<property name="fontSize">small</property>
<property name="fontWeight">bold</property>
<property name="color">#FFFFFF</property>
<property name="paddingTop">0px</property>
<property name="paddingLeft">0px</property>
<property name="paddingBottom">0px</property>
<property name="paddingRight">0px</property>
</style>
<style name="mydata" id="63">
<property name="color">orange</property>
</style>
</styles>
<page-setup>
<simple-master-page name="Simple MasterPage" id="2">
<page-header>
<grid id="64">
<column id="65"/>
<column id="66"/>
<row id="67">
<cell id="68">
<auto-text id="75">
<property
name="type">page-variable</property>
<property
name="pageVariable">FIRST</property>
</auto-text>
<label id="73">
<method name="onRender"><![CDATA[if(
reportContext.getPageVariable("FIRST") == 1 ){
this.getStyle().display="true";
}else{
this.getStyle().display="none";
}
]]></method>
<text-property name="text">Should Show
on First Page</text-property>
</label>
</cell>
<cell id="69">
<label id="74">
<text-property name="text">Should show
on All pages</text-property>
</label>
</cell>
</row>
</grid>
</page-header>
<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="9">
<property name="dataSet">Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">ORDERNUMBER</property>
<property name="displayName">ORDERNUMBER</property>
<expression
name="expression">dataSetRow["ORDERNUMBER"]</expression >
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">ORDERDATE</property>
<property name="displayName">ORDERDATE</property>
<expression
name="expression">dataSetRow["ORDERDATE"]</expression>
<property name="dataType">date</property>
</structure>
<structure>
<property name="name">REQUIREDDATE</property>
<property name="displayName">REQUIREDDATE</property>
<expression
name="expression">dataSetRow["REQUIREDDATE"]</expression >
<property name="dataType">date</property>
</structure>
<structure>
<property name="name">SHIPPEDDATE</property>
<property name="displayName">SHIPPEDDATE</property>
<expression
name="expression">dataSetRow["SHIPPEDDATE"]</expression >
<property name="dataType">date</property>
</structure>
<structure>
<property name="name">STATUS</property>
<property name="displayName">STATUS</property>
<expression
name="expression">dataSetRow["STATUS"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">COMMENTS</property>
<property name="displayName">COMMENTS</property>
<expression
name="expression">dataSetRow["COMMENTS"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">CUSTOMERNUMBER</property>
<property name="displayName">CUSTOMERNUMBER</property>
<expression
name="expression">dataSetRow["CUSTOMERNUMBER"]</expression >
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">rwc</property>
<expression name="expression">row.__rownum</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">Column Binding</property>
<expression name="expression">row.__rownum</expression>
<property name="dataType">integer</property>
</structure>
</list-property>
<method name="onPageBreak"><![CDATA[var tst =
reportContext.getPageVariable("FIRST");
if( tst == 2 ){
this.pageBreakInterval = 1;
}else{
this.pageBreakInterval = 2;
}]]></method>
<property name="pageBreakInterval">20</property>
<column id="85"/>
<column id="48"/>
<column id="49"/>
<column id="50"/>
<column id="51"/>
<column id="52"/>
<column id="53"/>
<column id="54"/>
<header>
<row id="10">
<cell id="82"/>
<cell id="11">
<label id="12">
<text-property
name="text">ORDERNUMBER</text-property>
</label>
</cell>
<cell id="13">
<label id="14">
<text-property
name="text">ORDERDATE</text-property>
</label>
</cell>
<cell id="15">
<label id="16">
<text-property
name="text">REQUIREDDATE</text-property>
</label>
</cell>
<cell id="17">
<label id="18">
<text-property
name="text">SHIPPEDDATE</text-property>
</label>
</cell>
<cell id="19">
<label id="20">
<text-property
name="text">STATUS</text-property>
</label>
</cell>
<cell id="21">
<label id="22">
<text-property
name="text">COMMENTS</text-property>
</label>
</cell>
<cell id="23">
<label id="24">
<text-property
name="text">CUSTOMERNUMBER</text-property>
</label>
</cell>
</row>
</header>
<detail>
<row id="25">
<method name="onCreate"><![CDATA[var rowcount =
this.getRowData().getColumnValue("rwc");
if( reportContext.getPageVariable("FIRST") == 0 ){
if( (parseInt(rowcount)+1)%5 == 0 ){
this.getStyle().pageBreakAfter = "Always";
}
}]]></method>
<cell id="83">
<data id="86">
<property name="resultSetColumn">Column
Binding</property>
</data>
</cell>
<cell id="26">
<data id="27">
<property
name="resultSetColumn">ORDERNUMBER</property>
</data>
</cell>
<cell id="28">
<data id="29">
<property
name="resultSetColumn">ORDERDATE</property>
</data>
</cell>
<cell id="30">
<data id="31">
<property
name="resultSetColumn">REQUIREDDATE</property>
</data>
</cell>
<cell id="32">
<data id="33">
<property
name="resultSetColumn">SHIPPEDDATE</property>
</data>
</cell>
<cell id="34">
<data id="35">
<property
name="resultSetColumn">STATUS</property>
</data>
</cell>
<cell id="36">
<data id="37">
<property
name="resultSetColumn">COMMENTS</property>
</data>
</cell>
<cell id="38">
<data id="39">
<property
name="resultSetColumn">CUSTOMERNUMBER</property>
</data>
</cell>
</row>
</detail>
<footer>
<row id="40">
<cell id="84"/>
<cell id="41"/>
<cell id="42"/>
<cell id="43"/>
<cell id="44"/>
<cell id="45"/>
<cell id="46"/>
<cell id="47"/>
</row>
</footer>
</table>
</body>
<property name="pageVariables">
<variable-element name="FIRST">
<expression name="value" type="constant">0</expression>
<property name="type">page</property>
</variable-element>
</property>
</report>

Raishad wrote:
> Hi,
>
> I have a report that can have multiple pages. The header row repeats for
> every page when viewing it in the web viewer and that is fine.
>
> But when printing the report, the header is repeated on every page.
> I would like the header to only appear once on the first page, and then
> hide it on the rest of the pages when displaying the PDF.
>
> Is this possible?
>
> Thanks
> Raishad

Report message to a moderator

Re: Hide Header Row on PDF Output [message #485466 is a reply to message #485434]

Fri, 11 September 2009 20:11

Raishad

Messages: 77
Registered: July 2009

Member

Jason,

Would this be possible with 2.3.1?
I was trying to do something with the row.__rownum and the Visibility
property for the header row, but it seems it is only evaluated once and
not for every page.

Jason Weathersby wrote:
> Raishad,
>
> This possible with 2.5 using page variables.
> See attached example.
>
> Jason
>
> <?xml version="1.0" encoding="UTF-8"?>
> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.20"
> id="1">
> <property name="createdBy">Eclipse BIRT Designer Version
> 2.5.0.v20090603 Build <2.5.0.v20090617-0630></property>
> <property name="units">in</property>
> <method name="onPageStart"><![CDATA[var first =
> reportContext.getPageVariable("FIRST");
> if( first == 1 ){
> reportContext.setPageVariable("FIRST",2);
> }]]></method>
> <method name="onPageEnd"><![CDATA[var first =
> reportContext.getPageVariable("FIRST");
> if( first == 0 ){
> reportContext.setPageVariable("FIRST",1);
> }]]></method>
> <property name="iconFile">/templates/blank_report.gif</property>
> <property name="bidiLayoutOrientation">ltr</property>
> <data-sources>
> <oda-data-source
> extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source"
> id="7">
> <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="8">
> <list-property name="columnHints">
> <structure>
> <property name="columnName">ORDERNUMBER</property>
> <property name="displayName">ORDERNUMBER</property>
> </structure>
> <structure>
> <property name="columnName">ORDERDATE</property>
> <property name="displayName">ORDERDATE</property>
> </structure>
> <structure>
> <property name="columnName">REQUIREDDATE</property>
> <property name="displayName">REQUIREDDATE</property>
> </structure>
> <structure>
> <property name="columnName">SHIPPEDDATE</property>
> <property name="displayName">SHIPPEDDATE</property>
> </structure>
> <structure>
> <property name="columnName">STATUS</property>
> <property name="displayName">STATUS</property>
> </structure>
> <structure>
> <property name="columnName">COMMENTS</property>
> <property name="displayName">COMMENTS</property>
> </structure>
> <structure>
> <property name="columnName">CUSTOMERNUMBER</property>
> <property name="displayName">CUSTOMERNUMBER</property>
> </structure>
> </list-property>
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">ORDERNUMBER</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">ORDERDATE</property>
> <property name="dataType">date</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">REQUIREDDATE</property>
> <property name="dataType">date</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">SHIPPEDDATE</property>
> <property name="dataType">date</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">STATUS</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">COMMENTS</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">CUSTOMERNUMBER</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">ORDERNUMBER</property>
> <property name="nativeName">ORDERNUMBER</property>
> <property name="dataType">integer</property>
> <property name="nativeDataType">4</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">ORDERDATE</property>
> <property name="nativeName">ORDERDATE</property>
> <property name="dataType">date</property>
> <property name="nativeDataType">91</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">REQUIREDDATE</property>
> <property name="nativeName">REQUIREDDATE</property>
> <property name="dataType">date</property>
> <property name="nativeDataType">91</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">SHIPPEDDATE</property>
> <property name="nativeName">SHIPPEDDATE</property>
> <property name="dataType">date</property>
> <property name="nativeDataType">91</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">STATUS</property>
> <property name="nativeName">STATUS</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">COMMENTS</property>
> <property name="nativeName">COMMENTS</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">CUSTOMERNUMBER</property>
> <property name="nativeName">CUSTOMERNUMBER</property>
> <property name="dataType">integer</property>
> <property name="nativeDataType">4</property>
> </structure>
> </list-property>
> <xml-property name="queryText"><![CDATA[select *
> from orders]]></xml-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>ORDERNUMBER</design:name>
> <design:position>1</design:position>
> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
> <design:precision>10</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>ORDERNUMBER</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>ORDERNUMBER</design:label>
> <design:formattingHints>
> <design:displaySize>11</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>ORDERDATE</design:name>
> <design:position>2</design:position>
> <design:nativeDataTypeCode>91</design:nativeDataTypeCode>
> <design:precision>10</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>ORDERDATE</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>ORDERDATE</design:label>
> <design:formattingHints>
> <design:displaySize>10</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>REQUIREDDATE</design:name>
> <design:position>3</design:position>
> <design:nativeDataTypeCode>91</design:nativeDataTypeCode>
> <design:precision>10</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>REQUIREDDATE</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>REQUIREDDATE</design:label>
> <design:formattingHints>
> <design:displaySize>10</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>SHIPPEDDATE</design:name>
> <design:position>4</design:position>
> <design:nativeDataTypeCode>91</design:nativeDataTypeCode>
> <design:precision>10</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>SHIPPEDDATE</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>SHIPPEDDATE</design:label>
> <design:formattingHints>
> <design:displaySize>10</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>STATUS</design:name>
> <design:position>5</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>15</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>STATUS</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>STATUS</design:label>
> <design:formattingHints>
> <design:displaySize>15</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>COMMENTS</design:name>
> <design:position>6</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>32700</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>COMMENTS</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>COMMENTS</design:label>
> <design:formattingHints>
> <design:displaySize>32700</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>CUSTOMERNUMBER</design:name>
> <design:position>7</design:position>
> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
> <design:precision>10</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>CUSTOMERNUMBER</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>CUSTOMERNUMBER</design:label>
> <design:formattingHints>
> <design:displaySize>11</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="report" id="4">
> <property name="fontFamily">"Verdana"</property>
> <property name="fontSize">10pt</property>
> </style>
> <style name="crosstab" id="5">
> <property name="borderBottomColor">#CCCCCC</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">1pt</property>
> <property name="borderLeftColor">#CCCCCC</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">1pt</property>
> <property name="borderRightColor">#CCCCCC</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">1pt</property>
> <property name="borderTopColor">#CCCCCC</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">1pt</property>
> </style>
> <style name="crosstab-cell" 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>
> <style name="table-header" id="55">
> <property name="backgroundColor">#6078BF</property>
> <property name="fontFamily">"Arial"</property>
> <property name="fontSize">small</property>
> <property name="fontWeight">bold</property>
> <property name="color">#FFFFFF</property>
> <property name="paddingTop">0px</property>
> <property name="paddingLeft">0px</property>
> <property name="paddingBottom">0px</property>
> <property name="paddingRight">0px</property>
> </style>
> <style name="table-footer" id="56">
> <property name="backgroundColor">#6078BF</property>
> <property name="fontFamily">"Arial"</property>
> <property name="fontSize">small</property>
> <property name="fontWeight">bold</property>
> <property name="color">#FFFFFF</property>
> <property name="paddingTop">0px</property>
> <property name="paddingLeft">0px</property>
> <property name="paddingBottom">0px</property>
> <property name="paddingRight">0px</property>
> </style>
> <style name="table-detail" id="57">
> <property name="backgroundColor">#E6ECFF</property>
> <property name="fontFamily">"Arial"</property>
> <property name="fontSize">x-small</property>
> <property name="fontWeight">bold</property>
> <property name="color">#000080</property>
> <property name="paddingTop">0px</property>
> <property name="paddingLeft">0px</property>
> <property name="paddingBottom">0px</property>
> <property name="paddingRight">0px</property>
> </style>
> <style name="table-group-header-1" id="58">
> <property name="backgroundColor">#809FFF</property>
> <property name="fontFamily">"Arial"</property>
> <property name="fontSize">small</property>
> <property name="fontWeight">bold</property>
> <property name="color">#FFFFFF</property>
> <property name="paddingTop">0px</property>
> <property name="paddingLeft">0px</property>
> <property name="paddingBottom">0px</property>
> <property name="paddingRight">0px</property>
> </style>
> <style name="table-group-footer-1" id="59">
> <property name="backgroundColor">#809FFF</property>
> <property name="fontFamily">"Arial"</property>
> <property name="fontSize">small</property>
> <property name="fontWeight">bold</property>
> <property name="color">#FFFFFF</property>
> <property name="paddingTop">0px</property>
> <property name="paddingLeft">0px</property>
> <property name="paddingBottom">0px</property>
> <property name="paddingRight">0px</property>
> </style>
> <style name="special-header" id="60">
> <property name="backgroundColor">#6078BF</property>
> <property name="fontFamily">"Arial"</property>
> <property name="fontSize">medium</property>
> <property name="fontWeight">bold</property>
> <property name="color">#FFFFFF</property>
> <property name="paddingTop">0px</property>
> <property name="paddingLeft">0px</property>
> <property name="paddingBottom">0px</property>
> <property name="paddingRight">0px</property>
> </style>
> <style name="crosstab-detail" id="61">
> <property name="backgroundColor">#E6ECFF</property>
> <property name="fontFamily">"Arial"</property>
> <property name="fontSize">x-small</property>
> <property name="fontWeight">bold</property>
> <property name="color">#000080</property>
> <property name="paddingTop">0px</property>
> <property name="paddingLeft">0px</property>
> <property name="paddingBottom">0px</property>
> <property name="paddingRight">0px</property>
> </style>
> <style name="crosstab-header" id="62">
> <property name="backgroundColor">#6078BF</property>
> <property name="fontFamily">"Arial"</property>
> <property name="fontSize">small</property>
> <property name="fontWeight">bold</property>
> <property name="color">#FFFFFF</property>
> <property name="paddingTop">0px</property>
> <property name="paddingLeft">0px</property>
> <property name="paddingBottom">0px</property>
> <property name="paddingRight">0px</property>
> </style>
> <style name="mydata" id="63">
> <property name="color">orange</property>
> </style>
> </styles>
> <page-setup>
> <simple-master-page name="Simple MasterPage" id="2">
> <page-header>
> <grid id="64">
> <column id="65"/>
> <column id="66"/>
> <row id="67">
> <cell id="68">
> <auto-text id="75">
> <property
> name="type">page-variable</property>
> <property
> name="pageVariable">FIRST</property>
> </auto-text>
> <label id="73">
> <method name="onRender"><![CDATA[if(
> reportContext.getPageVariable("FIRST") == 1 ){
> this.getStyle().display="true";
> }else{
> this.getStyle().display="none";
> }
> ]]></method>
> <text-property name="text">Should Show
> on First Page</text-property>
> </label>
> </cell>
> <cell id="69">
> <label id="74">
> <text-property name="text">Should show
> on All pages</text-property>
> </label>
> </cell>
> </row>
> </grid>
> </page-header>
> <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="9">
> <property name="dataSet">Data Set</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">ORDERNUMBER</property>
> <property name="displayName">ORDERNUMBER</property>
> <expression
> name="expression">dataSetRow["ORDERNUMBER"]</expression >
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="name">ORDERDATE</property>
> <property name="displayName">ORDERDATE</property>
> <expression
> name="expression">dataSetRow["ORDERDATE"]</expression>
> <property name="dataType">date</property>
> </structure>
> <structure>
> <property name="name">REQUIREDDATE</property>
> <property name="displayName">REQUIREDDATE</property>
> <expression
> name="expression">dataSetRow["REQUIREDDATE"]</expression >
> <property name="dataType">date</property>
> </structure>
> <structure>
> <property name="name">SHIPPEDDATE</property>
> <property name="displayName">SHIPPEDDATE</property>
> <expression
> name="expression">dataSetRow["SHIPPEDDATE"]</expression >
> <property name="dataType">date</property>
> </structure>
> <structure>
> <property name="name">STATUS</property>
> <property name="displayName">STATUS</property>
> <expression
> name="expression">dataSetRow["STATUS"]</expression>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">COMMENTS</property>
> <property name="displayName">COMMENTS</property>
> <expression
> name="expression">dataSetRow["COMMENTS"]</expression>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">CUSTOMERNUMBER</property>
> <property name="displayName">CUSTOMERNUMBER</property>
> <expression
> name="expression">dataSetRow["CUSTOMERNUMBER"]</expression >
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="name">rwc</property>
> <expression name="expression">row.__rownum</expression>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="name">Column Binding</property>
> <expression name="expression">row.__rownum</expression>
> <property name="dataType">integer</property>
> </structure>
> </list-property>
> <method name="onPageBreak"><![CDATA[var tst =
> reportContext.getPageVariable("FIRST");
> if( tst == 2 ){
> this.pageBreakInterval = 1;
> }else{
> this.pageBreakInterval = 2;
> }]]></method>
> <property name="pageBreakInterval">20</property>
> <column id="85"/>
> <column id="48"/>
> <column id="49"/>
> <column id="50"/>
> <column id="51"/>
> <column id="52"/>
> <column id="53"/>
> <column id="54"/>
> <header>
> <row id="10">
> <cell id="82"/>
> <cell id="11">
> <label id="12">
> <text-property
> name="text">ORDERNUMBER</text-property>
> </label>
> </cell>
> <cell id="13">
> <label id="14">
> <text-property
> name="text">ORDERDATE</text-property>
> </label>
> </cell>
> <cell id="15">
> <label id="16">
> <text-property
> name="text">REQUIREDDATE</text-property>
> </label>
> </cell>
> <cell id="17">
> <label id="18">
> <text-property
> name="text">SHIPPEDDATE</text-property>
> </label>
> </cell>
> <cell id="19">
> <label id="20">
> <text-property
> name="text">STATUS</text-property>
> </label>
> </cell>
> <cell id="21">
> <label id="22">
> <text-property
> name="text">COMMENTS</text-property>
> </label>
> </cell>
> <cell id="23">
> <label id="24">
> <text-property
> name="text">CUSTOMERNUMBER</text-property>
> </label>
> </cell>
> </row>
> </header>
> <detail>
> <row id="25">
> <method name="onCreate"><![CDATA[var rowcount =
> this.getRowData().getColumnValue("rwc");
> if( reportContext.getPageVariable("FIRST") == 0 ){
> if( (parseInt(rowcount)+1)%5 == 0 ){
> this.getStyle().pageBreakAfter = "Always";
> }
> }]]></method>
> <cell id="83">
> <data id="86">
> <property name="resultSetColumn">Column
> Binding</property>
> </data>
> </cell>
> <cell id="26">
> <data id="27">
> <property
> name="resultSetColumn">ORDERNUMBER</property>
> </data>
> </cell>
> <cell id="28">
> <data id="29">
> <property
> name="resultSetColumn">ORDERDATE</property>
> </data>
> </cell>
> <cell id="30">
> <data id="31">
> <property
> name="resultSetColumn">REQUIREDDATE</property>
> </data>
> </cell>
> <cell id="32">
> <data id="33">
> <property
> name="resultSetColumn">SHIPPEDDATE</property>
> </data>
> </cell>
> <cell id="34">
> <data id="35">
> <property
> name="resultSetColumn">STATUS</property>
> </data>
> </cell>
> <cell id="36">
> <data id="37">
> <property
> name="resultSetColumn">COMMENTS</property>
> </data>
> </cell>
> <cell id="38">
> <data id="39">
> <property
> name="resultSetColumn">CUSTOMERNUMBER</property>
> </data>
> </cell>
> </row>
> </detail>
> <footer>
> <row id="40">
> <cell id="84"/>
> <cell id="41"/>
> <cell id="42"/>
> <cell id="43"/>
> <cell id="44"/>
> <cell id="45"/>
> <cell id="46"/>
> <cell id="47"/>
> </row>
> </footer>
> </table>
> </body>
> <property name="pageVariables">
> <variable-element name="FIRST">
> <expression name="value" type="constant">0</expression>
> <property name="type">page</property>
> </variable-element>
> </property>
> </report>
>
>
> Raishad wrote:
>> Hi,
>>
>> I have a report that can have multiple pages. The header row repeats
>> for every page when viewing it in the web viewer and that is fine.
>>
>> But when printing the report, the header is repeated on every page.
>> I would like the header to only appear once on the first page, and
>> then hide it on the rest of the pages when displaying the PDF.
>>
>> Is this possible?
>>
>> Thanks
>> Raishad

Report message to a moderator

Re: Hide Header Row on PDF Output [message #485730 is a reply to message #485466]

Mon, 14 September 2009 16:59

Jason Weathersby

Messages: 9167
Registered: July 2009

Senior Member

Raishad,

Take a look at the onrender script for the image on the header on the
master page in the attached example.

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 <2.3.2.v20090218-0730></property>
<property name="units">in</property>
<property name="iconFile">/templates/blank_report.gif</property>
<property name="bidiLayoutOrientation">ltr</property>
<data-sources>
<oda-data-source
extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source"
id="7">
<property
name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver </property>
<property name="odaURL">jdbc:classicmodels:sampledb</property>
<property name="odaUser">ClassicModels</property>
<property name="OdaConnProfileName"></property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="Data Set" id="8">
<list-property name="columnHints">
<structure>
<property name="columnName">ORDERNUMBER</property>
<property name="displayName">ORDERNUMBER</property>
</structure>
<structure>
<property name="columnName">PRODUCTCODE</property>
<property name="displayName">PRODUCTCODE</property>
</structure>
<structure>
<property name="columnName">QUANTITYORDERED</property>
<property name="displayName">QUANTITYORDERED</property>
</structure>
<structure>
<property name="columnName">PRICEEACH</property>
<property name="displayName">PRICEEACH</property>
</structure>
<structure>
<property name="columnName">ORDERLINENUMBER</property>
<property name="displayName">ORDERLINENUMBER</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">ORDERNUMBER</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">PRODUCTCODE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">QUANTITYORDERED</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">PRICEEACH</property>
<property name="dataType">float</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">ORDERLINENUMBER</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">ORDERNUMBER</property>
<property name="nativeName">ORDERNUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">PRODUCTCODE</property>
<property name="nativeName">PRODUCTCODE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">QUANTITYORDERED</property>
<property name="nativeName">QUANTITYORDERED</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">PRICEEACH</property>
<property name="nativeName">PRICEEACH</property>
<property name="dataType">float</property>
<property name="nativeDataType">8</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">ORDERLINENUMBER</property>
<property name="nativeName">ORDERLINENUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">5</property>
</structure>
</list-property>
<property name="queryText">select *
from orderdetails</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>ORDERNUMBER</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>ORDERNUMBER</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>ORDERNUMBER</design:label>
<design:formattingHints>
<design:displaySize>11</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>PRODUCTCODE</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>15</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>PRODUCTCODE</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>PRODUCTCODE</design:label>
<design:formattingHints>
<design:displaySize>15</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>QUANTITYORDERED</design:name>
<design:position>3</design:position>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>QUANTITYORDERED</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>QUANTITYORDERED</design:label>
<design:formattingHints>
<design:displaySize>11</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>PRICEEACH</design:name>
<design:position>4</design:position>
<design:nativeDataTypeCode>8</design:nativeDataTypeCode>
<design:precision>15</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>PRICEEACH</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>PRICEEACH</design:label>
<design:formattingHints>
<design:displaySize>22</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>ORDERLINENUMBER</design:name>
<design:position>5</design:position>
<design:nativeDataTypeCode>5</design:nativeDataTypeCode>
<design:precision>5</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>ORDERLINENUMBER</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>ORDERLINENUMBER</design:label>
<design:formattingHints>
<design:displaySize>6</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="report" id="4">
<property name="fontFamily">"Verdana"</property>
<property name="fontSize">10pt</property>
</style>
<style name="crosstab" id="5">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
<style name="crosstab-cell" 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">
<property name="topMargin">0.25in</property>
<property name="leftMargin">0.25in</property>
<property name="bottomMargin">0.25in</property>
<property name="rightMargin">0.25in</property>
<page-header>
<grid id="44">
<property name="width">100%</property>
<column id="45"/>
<row id="48">
<cell id="49">
<image id="61">
<property name="height">95px</property>
<property name="width">325px</property>
<method
name="onRender"><![CDATA[if(pageNumber>1){
this.getStyle().display ="none"
}
]]></method>
<property name="source">embed</property>
<property
name="imageName">eclipsecon08_logo.jpg</property>
</image>
</cell>
</row>
<row id="52">
<cell id="53">
<label id="60">
<property
name="textAlign">center</property>
<text-property name="text">Report
header</text-property>
</label>
</cell>
</row>
<row id="56">
<cell id="57"/>
</row>
</grid>
</page-header>
</simple-master-page>
</page-setup>
<body>
<table id="9">
<property name="width">100%</property>
<property name="dataSet">Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">ORDERNUMBER</property>
<property name="displayName">ORDERNUMBER</property>
<expression
name="expression">dataSetRow["ORDERNUMBER"]</expression >
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">PRODUCTCODE</property>
<property name="displayName">PRODUCTCODE</property>
<expression
name="expression">dataSetRow["PRODUCTCODE"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">QUANTITYORDERED</property>
<property name="displayName">QUANTITYORDERED</property>
<expression
name="expression">dataSetRow["QUANTITYORDERED"]</expression >
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">PRICEEACH</property>
<property name="displayName">PRICEEACH</property>
<expression
name="expression">dataSetRow["PRICEEACH"]</expression>
<property name="dataType">float</property>
</structure>
<structure>
<property name="name">ORDERLINENUMBER</property>
<property name="displayName">ORDERLINENUMBER</property>
<expression
name="expression">dataSetRow["ORDERLINENUMBER"]</expression >
<property name="dataType">integer</property>
</structure>
</list-property>
<property name="pageBreakInterval">30</property>
<column id="38"/>
<column id="39"/>
<column id="40"/>
<column id="41"/>
<column id="42"/>
<header>
<row id="10">
<cell id="11">
<label id="12">
<text-property
name="text">ORDERNUMBER</text-property>
</label>
</cell>
<cell id="13">
<label id="14">
<text-property
name="text">PRODUCTCODE</text-property>
</label>
</cell>
<cell id="15">
<label id="16">
<text-property
name="text">QUANTITYORDERED</text-property>
</label>
</cell>
<cell id="17">
<label id="18">
<text-property
name="text">PRICEEACH</text-property>
</label>
</cell>
<cell id="19">
<label id="20">
<text-property
name="text">ORDERLINENUMBER</text-property>
</label>
</cell>
</row>
</header>
<detail>
<row id="21">
<cell id="22">
<data id="23">
<property
name="resultSetColumn">ORDERNUMBER</property>
</data>
</cell>
<cell id="24">
<data id="25">
<property
name="resultSetColumn">PRODUCTCODE</property>
</data>
</cell>
<cell id="26">
<data id="27">
<property
name="resultSetColumn">QUANTITYORDERED</property>
</data>
</cell>
<cell id="28">
<data id="29">
<property
name="resultSetColumn">PRICEEACH</property>
</data>
</cell>
<cell id="30">
<data id="31">
<property
name="resultSetColumn">ORDERLINENUMBER</property>
</data>
</cell>
</row>
</detail>
<footer>
<row id="32">
<cell id="33"/>
<cell id="34"/>
<cell id="35"/>
<cell id="36"/>
<cell id="37"/>
</row>
</footer>
</table>
</body>
<list-property name="images">
<structure>
<property name="name">eclipsecon08_logo.jpg</property>
<property name="data">

/9j/4AAQSkZJRgABAgAAZABkAAD/7AARRHVja3kAAQAEAAAAPAAA/+4ADkFk b2JlAGTAAAAAAf/bAIQA

BgQEBAUEBgUFBgkGBQYJCwgGBggLDAoKCwoKDBAMDAwMDAwQDA4PEA8ODBMT FBQTExwbGxscHx8fHx8f

Hx8fHwEHBwcNDA0YEBAYGhURFRofHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8f Hx8fHx8fHx8fHx8fHx8f

Hx8fHx8fHx8f/8AAEQgAXwFFAwERAAIRAQMRAf/EAKAAAQACAwEBAAAAAAAA AAAAAAABAwQFBgIHAQEB

AQEBAQEAAAAAAAAAAAAAAQIDBAUGEAABAgUBBAkABwYEBgMAAAABAgMAETEE BSFBwRIG8FFhgdEiMhMH

cZFCk9MUJKFSciMVCLGSotLhYoI0FhczsyYRAQACAgIAAwcEAQUAAAAAAAAB EQISIQMxQQTwUWHxIjIT

cYGhQiNSYnJDFP/aAAwDAQACEQMRAD8A+YFutenXH6igLda9OuFAW616dcKA t1r064UBbrXp1woC2Na9

++FAWxrXp1woC3WvTrhQFutenXCgLda9OuFAW616dcKAt1r064UBbrXp1woC 3WvTrhQFutenXCgLda9O

uFAW616dcKAt1r064UBbrXp1woC3WvTrhQFutenXCgLda9OuFAW616dcKAt1 r064UBbrXp1woC3WvTrh

QFutenXCgLda9OuFAW616dcKAt1r064UBbrXp1woC3WvTrhQFutenXCgLda9 OuFAW616dcKAt1r064UB

brXp1woC3WvTrhQFutenXCgLda9OuFCfbE9u+FCwitY66gRWsNQIrWGoKFaw 1Cs5TiULE261T0MQSu2W

J6GIKiCCZzjUQBFaxdQIrWGoEVrDUCK1hqBFaw1AitYagRWsNQIrWGoEVrDU CK1hqBFaw1AitYagRWsN

QIrWGoEVrDUCK1hqBFaw1AitYagRWsNQIrWGoEVrDUCK1hqBFaw1AitYagRW sNQIrWGoEVrDUCK1hqBF

aw1AitYagRWsNQIrWGomWu2GosKK1jpQKSNa98KAprWFApNaxKF9ra8a9AdY 5ZI63EctquUiSSTHmy7K

Gdd8kvJSVLHto2qI1+qMx3wsQ5TK462typLYKyPtEwn1E+STLnLoKEyFEfQT HLLvz97nOUsQ3Nwk6LPf

rGY7848yMpXM5MTk8P8AqG8R6ev1f+puMmwHAtPEk8STQx7o55hpJRWsWgKK 1hQFFawoCitYUBRWsKAo

rWFAUVrCgKK1hQFFawoCitYUBRWsKAorWFAUVrCgKK1hQFFawoCitYUBRWsK AorWFAUVrCgKK1hQFFaw

oCitYUBRWsKAorWFAUVrCgKK1hQFFawoCitYUJ4Ndu+FC8pGuhiWIUkSOh74 WPKmgJ8MxEEKmBqImw2W

KU37on+2OOco+zfH6bBAS8+Bw/Zn19cfN9RaxDM51v7B1JSyRIDWW0xw67Jl 8bzqkFapR6IYlyV2RrEl

iWRc8oZxrlBrm5bbYwj1wbRt33B7nugqTIt1lNJ1jnvF15lNPjcZkMtkGMdj WFXV9dK4Le3RLiWqRMhM

gUEamaWGQpvI4LLv4nKsqtrlhYbubZyXE2sgHWRIoY7+n9Rr/wAZbxbgpEts fUtpJSNdDFsCka6GFgUj

XQwsCka6GFgUjXQwsCka6GFgUjXQwsCka6GFiCBrWFgUjXQwsCka1hYFI1rC xJSNdDCwKRroYWIKRrWF

gUjWsLElI10MLEFI1rCwKRrWFgUjWsLApGtYWBSNawsCka1hYFI1rCwKRrWF iSka6GFgUjXQwsOEToYW

LWrd9/i9ltS+GXFLZPrjlszOUR4rDjb/AF/kOfVDZPyR7xWOv9f5Dn1Q2PyR 70OY+9CSSyuXaIbG8e92

9l8b47F2Vrec48wN8vOXqQ5bY/2lXFyUGinG0+ifb366R4M/U3MxhjtSzMN/ nrNWCwNtmsPkG8zy/cqD

Dd8wOEtroEuJmZTlL6ax547NpqYrJqcopy/57LZR9m1tWHH7i5UG2WkiZUpW gEa1qLljeG4y3xty1jVo

teaedLTFZZxIUbJtv3vb4qBxUxL6SBHKO3KftxuCafO+e+TbzlvKsWTV4xmL a8YF1Z31nq2tpS1I11IC

poNCY1hlOXkxlw6nP210n+2LHNFpQdGdJKJay9x2OWs/l/Zq/pcHyHguYb3m zD2uOfdxV7cXCW7fJoTM

sKUkjjAmNmkdc4rGZmEiYYnO+B5hs+ec1ZZC6dy99bXJbuMipMlPqSkeciZ2 aRnGJnGKhq4fQeRvi3N8

xcl/11N2xZpYuVWr6LtXtJQ23Kby3DpwgKGlY9OHrdKxyibatvrT4mwOZaft +WecLPLZphBWrHhHthfD

XgcKjPXbwy641PrssZ+rGoLt83eadaedYdQpDzSi262oSUlaTwqSodYIj249 kSm0O8/9a4fF2Nq/zjzK

xy/cX7YetrEtLuHwg7XEII4Y8k+smZnTHalmWj5u5Vx2GtLPIY3O2ubx18tb bb1sSlaFtgKKXEEnhmFa

ax06fU7TMTGsps1WDwuSzuVYxWMaU/eXJk2igAGqlKOxKRqTHbPuxxi5W3aO fH3IjFycbec82zOXSr23

Gk2zjlulycuEvzSga6Ex5P8A15+MYcFuV5u5XynK+ZdxWSA91KQ408g8TbrS vS4gmUwZR6envjsi4LY+

Fw1xl7ssNK9ttA4nnVahI+jaTsjWfZTeGO0s5605JadLC8hdLWnRTqEgtz/y EnujG+Tcxh72oubdpWRV

a49xV0hakoYXKRXxSqDLaY6Rnxy5zHNQ3d1g+XsXwNZi/dN0tIUpm2APCD1k hW6OX5cp8HScMY8ZY2W5

faZxwymNuTeWB0WSJLRrLzd/YI1j281KZYcXHg9ctcutZpq6Up9TKmSkJAAI PEDX6oZ9tHXhs1qLFwZl

vGXM23FPoYc2y4lBMx16GYjX5OLZ15pn32Kxtlf5G0ecdWbNtLragpKePiCP LIg6/wAz9kZjsmYanGIm

YeMvi8faWinre7L7nuobDcxMJKVT4pbeNB7pdcXHsmZTLGIhqVK0NY6Ww3IZ 5PbCU3F7dOOEDjUyhKUJ

JGoPECTLsjlOeTpWPvV8xYMYsMXDL35iyuk8TLhEjQHX6QdIuHZaZ4UvYwuN t8W3kszcOtNXJlbsMgFx

Q/ePECO2JPbN1CxhERcqM5hmrO1YyFm8q5x11o24oSUlWvlV9Ri4dl8SmeFc x4L2MLjbfFt5LM3DrTVy

ZW7DIBcUP3jxAjtiT2zdQsYREXKjN4VqztWMhZPKuMddaNuKElJVr5VfUYuH ZfEpnhXMeC6xwtgMOcvl

X3WrRauBptkArUQSJzMxUGJl2zdQuOEVcoy+EsWsS1lsbcLes3FcCkOgBaTM jWQG0SpDDsm6kywirhpS

qYNY6xLmlRrWFiZ67d8LFlgEue7Nn3pcPqdDUq9Z1jFsZyzCwkz/AEae+6T4 wti/j/Cp5tYPlsky6vf4

j9YXCy/j/DP5XYZf5pw9veWyEW717bpdBdqguAGYKjHLumYwmvc1E/F9C+TX vitfyLkG+YbXOOZZPtBx

bDjAt+H2klHthR4+GX7Y+d0R2aRrVLcW0fM/Ofx/YfHOY5W5fscnx5VaHmje Ka9tDyFIM+IKBTojYIs9

ee0ZZUuWXCv+3hLb3yDZm4t0pW1a3C2VF4LPHwgaIn+6TE9T9jGE8vmOYTd5 LmjMXN+x7l25e3BuCu4C

VcYdUCDM7JSjpjHEcMzKpOIShQlZp4U0T+bTIT1010jWvw/lm303mFkD+2bH I/LhIGcP8r3gR/8AI7rx

zjzV/l/Z0/q5b4ktkj5G5YV+USki+bPuC5CiNFa8E9Y69sfRPCYzywvlRhK/ lnmsm1S5+vXqbgIn5U7J

6Rz64+mOP5bmeXeYVHt/22ZBIbDAOc1Slz3hVraP8InVH+X9jLwaX4sXdN/I XL67aZc/ONpUUmR9tflc

nLZwEx7e/GPxz+iYw8/KBaT8kcxBgzSLxRkNAFkAr1/jnF9LP0R+h5uyyvNX xRz0i0uOaHbzAZ+3YTbu

3TCS7brCKHRLmkyTqAR1mPNHX2dfGPOKzUuY58+Ohy5j7LOYzJt5jl3JK4LW +bEiFyJCVgaahJkR1EGU

d+nv2mpisoSnQ/AabQ5PmN98OFbOJdKfYID4QpQ4y1P7eg4Ts74x66ZrH9Wo aQ3HwcU6W3MOo1/mWu3r

mIsfm/2sxSv5M50wHMacI3h2bppvE2n5NS7zgLi0p4fbmpBM9AZxfT9eWEzf mWxuVXFf+LZ1bE/zIQun

qkGjLfHfPxh6uv7ZcWhYM6x0hxdByUppXM9oF/8AOUA/vBtUoz2eDfV9zD5s ccPMeQ92fEHZCf7oA4f9

MoYeCdn3S3/KKuLlbOh7/tkoWQT+97R4u/RMYz8YdOv7ZU8m3r1vy9nbplXC 6whK0E7ClKiIZ+J1zUS2

q2GOYTieYbBMrhm4YRfMioCXE8U/4K/wxmJrhutqyhzPO6//ANVfjq9r/wCl EdOvwce37pafirWOrm9l

wSNYtjZ4fBKyCV3d07+UxbJ/n3S9Jy+ymdTHPLKnTHC+fI5q5kZyS2bazQWs dZJ4LdJ0KtAJnq0GkZxi

jszvw8G1+RFBNth0on7Hsq9uVKI3SjOHm33eQlY/9ZPKcql4ezPr95M5f6oT 9x/Q+RFBNthktz9j2Ve3

KlEbpQwk7vIQsH4zdU5VLw9mfX7yZy/1Q/sf9a7C3rGO5UC8+Pexl45w2ltw 8TkiTxKnMSGkxt+uJl48

LjNY8+Ceardp7lm1uMK8hWFtSONhAPFxEy4lEmZIKtQeucXCeTsj6ePBx6Xd DWO8S4JLtaxbRPu67d8L

VjMXyWuPiZS9OUvc4tJfwlMZtJi1pyrWv6Nn6nP2+eFpr8Q5VrX9Gz9Tn7fP CzX4q15OTvuNsIbWkgpK

eMSI1B9UQ1+L6i58l/G/NqbO656xt1acw2iEtf1bGgFLyRT3ET0+iR7DLSPB +HPCfo+34rTC5+zvxl/4

vc2PLmIub3IOlATkr8ABpIUFK4Egg+YCWgEZ17LvKv0XKJmHzzlnm2+5dzFn msZbW7V9ZL42yQuSgRwr

QrzelSSQYZRExVOMRTvsjzb/AG88x5FzPZzFZXE5i6PuZG1tAHGHXZeZSVJM pq2mSZxxxjPHiKlqalw/

OvNPJuSytujlPADG4i0YDCU3M1PPL41KLzhSs6kKA1UaR067jx5SYbLMfIWE f+GrPktFosZZjJG9X5P0

vtlS1aK4+Pi8/VGdfr2XyaTkPmbH4Dm3DZq9s0flcfcofeLCVKd4Ugz4ApYB Osa7JvGYWIa/njmrHZ7n

zPZyztE/k8jdKfYFwkpd4SAPOErIB06443URFQ1T7V8X3vLY/t7vHOYbBxzF LzakuNWKi24kq9rhcTxK

1IrKesTCMt4mOJpMvBFjzr8U8oBzJco4+/yHMJQpFrcZOQaY4wQVSB1MjsHe I9U4dmfGUxGPwTZ8susi

89eO3dyo3D7zpefWv7a1K4lTl1mPZhFQRD6LcZH4Jy8rt20y2BulHiftLThe Znt4ComX1D6I8v8Amx44

klrue+fMRkcDjuVuW7R6x5cxa1PIVcqCrh95XF53JTCR51aT2xerqmMpyy+6 UloOS+dsjylzCzmLFIWp

sFt9hcwl1pfqQqX0TB2GPR29cZ41LdO0vch8DZi4VknmMziH3j7lxj7QNLZ4 zqfbKuKQJ+j6BHlxjux4

4lnhyHOmU5Uu7q3Tyxjnsdj7Zn21G4WFvPucRUXXJEyMjKU49HVtH3Tcltdy 5zQ/g75boQXrZ4BNwyTK

YFCD1iOmUW7YZ6tk/c/HLzhuQL5ji8yrVsJCZnZrxS7lRmJlqdGku8qw1lze 4htdqy0pCrZCzxKBQkAl

WpnxEExry5Ymebhv73mDk7OFNzlmbqyvkpCXV23CUrlSoV/h3xiLh0nLHLxY ua5tsP6R/RMHbuMWRM33

nZe45rM0JrKs+zSLEc3KZZxVQxsJzDaWGEy9i8h1T1+gJZUkJKQeFQ85Kgdu wRZjlMcqiYOUOalYG+Wp

5Ljli8JPNJkVAj0qSCQJ7K0iZY2deessbmTMMZTO3V/bpcQy97fClwAKHC2l BmAVCqeuNYcM5zc2wS8d

a7I6Wyhbxka9OuJY7O95u5JvLG2srqyvfYtQAhpvhQmcpTMnRPvjjUu854zF Oezt5yy621/Rba5YWCff

L5BBGnDLzr7Y1jfm55Tj5NixzHhcjhWMXnkvtrsv+1vGAFHhpwqB7NKRJip4 ajKJipY3MfMtndY+3w2K

acaxloeLjdl7ji9dVS/iJhEJnnxUeDJt+Y8LkcKxi88l9tdlpa3jACjwU4VA 9mlIVU8LGUTFSxuYuZbO

5x9vh8U041jLQ8XG7L3HF66ql/ETCITPO4qPBl2/MmByGBZxGdbfaNpL8vdW 4BMgJDiB+qmsSY5WMomK

lVkeZMTbYFWDwaHiw8v3Lq6uJBSjMUA/hEWI5Jyiqhz4eIBrHWJckl4616dc WxPvGe3fCxhl2tenXHOw

Lta9OuFieMqJlM9NsLEqUgE8SiewbzFse0uJOkpCDeLu+VXcdkrFVjcpH5lC Skg1W31jtTHPLF11cbzL

hH8TfLbUP5SjNC9hBoY82UU8ueFS0ighVRGWHiSRQRVQpIOpjE5LEPDi0hMt kcssm6a8tm5uAw1pPVxY

+ynafCMYYTnlSvpWN54urTkJ/ktFu0Mc7dpvfzB4vdStKUJCRrw8P8sbI+jP TG0ZR5RTGTnXbg8SpEyj

tCxCtTtaxbVPvkT1MQpKric58UEpBdRrMK+v/hFtXv8AMNiei/8AMPCIlJVc Mmc0r/zD/bFKQXrXWbbn

+cf7YWchdstZtO/eJ/2RDl696w1m0996n8OLZykvY3WbL/3qfw4HKfexYnNh /wC+R+FC05SbjFazt7j7

9H4ULOUm4xGs7e4+/R+DCysvb5n5jDif6a5+/R+DCysvb5pNziNf01z9+j8G FlZe3zDc4jX9Nc9v89H4

MLKy9vmgv4fX9Nc/fo/BhZWXt8z38Pr+mufv0fgwsrL2+YX8Pr+mufv0fgws rL2+Z7+H1/TXP36PwYWV

l7fML+H1/TXP36PwYWVl7fM9/D6/prn79H4MLKy9vmF/D6/prn79H4MLKy9v m8PPY0tqDLD6HNJKW6la

a7UhtH+MLItQXBrXp1wtoLta9OuFh7vm274WMcqrXv3xgOIAk6n6d8LEqcJn qZdXjCxBVWvfvhYsbUSq

QnONNRLZWl4u2cStlZS6gghwVBg7Y5OvbzmJzln+TzKQ059m4A0n1/8AL/hG MsbaywtyWa5Ru7JanLVQ

u7WqVtmZl9EcMsMoeXLrpz65oJSoFJFQdDHnnJKUOPpG2Oc5Kq/LXtx6U+03 tcWJfUKmNYdGWfwhqmdb

2rFq2UNAzOq1mqj1mPodfXGEVCSuKpTr0640gVVr374AVVr374AVVr374AVV r374AVVr374AVVr374AV

Vr374AVVr374AVVr374AVVr374AVVr374AVVr374AVVr374AVVr374AVVr37 4AVVr374AVVr374AVVr3

74AVVr374AVVr374AVVr374AVVr374AVVr374AVVr374AVVr374AVVr374AV Vr374Bxeb7W+Axi7Wuyu

+IgXa12V3wAu1rsrvgHuFRIHESZSHjAXKfDU0pJK/tK6uyLYlFzKdYttxLNT e8KAJmZ1MV0jNcjJOIB4

VqT9BlEb3VXF027P3Ehf8QnCeWZr3MVTrKJ8CAn6ABEjGI8mZlS7cTnWLbnM qlO1rs6GM2yF2tdld8AL

ta7K74AXa12V3wAu1rsrvgBdrXZXfAC7Wuyu+AF2tdld8ALta7K74AXa12V3 wAu1rsrvgBdrXZXfAC7W

uyu+AF2tdld8ALta7K74AXa12V3wAu1rsrvgBdrXZXfAC7Wuyu+AF2tdld8A Lta7K74AXa12V3wAu1rs

rvgBdrXZXfAC7Wuyu+AF2tdld8ALta7K74AXa12V3wAu1rsrvgHu+b7W+AxC 56q7K74yBc9Vdld8AKyZ

gcWzoYC0u+0FBJPuGqursi2Ki56q7K74lj0HDM1lpXfFiR7VcklR12dDF2W0 m5OtenXC1sVcnXU9++Fl

vC3zrXp1xLS3lTh81dld8SxBc9Vdld8EC56q7K74AXPVXZXfAC56q7K74AXP VXZXfAC56q7K74AXPVXZ

XfAC56q7K74AXPVXZXfAC56q7K74AXPVXZXfAC56q7K74AXPVXZXfAC56q7K 74AXPVXZXfAC56q7K74A

XPVXZXfAC56q7K74AXPVXZXfAC56q7K74AXPVXZXfAC56q7K74AXPVXZXfAC 56q7K74AXPVXZXfAC56q

7K74AXPVXZXfAC56q7K74AXPVXZXfAT7nm+1vpBVRQ7rOXb5h4w1lAod1nLt 8w8YayJCHwTKu3UeMKkQ

UO6zl2+YeMNZAod1nLt8w8YayHA9rTt8w8YayBQ7rOXb5h4w1kCh3Wcu3zDx hrIFDus5dvmHjDWQKHdZ

y7fMPGGsgUO6zl2+YeMNZAod1nLt8w8YayBQ7rOXb5h4w1kCh3Wcu3zDxhrI FDus5dvmHjDWQKHdZy7f

MPGGsgUO6zl2+YeMNZAod1nLt8w8YayBQ7rOXb5h4w1kCh3Wcu3zDxhrIFDu s5dvmHjDWQKHdZy7fMPG

GsgUO6zl2+YeMNZAod1nLt8w8YayBQ7rOXb5h4w1kCh3Wcu3zDxhrIFDus5d vmHjDWQKHdZy7fMPGGsg

UO6zl2+YeMNZAod1nLt8w8YayBQ7rOXb5h4w1kCh3Wcu3zDxhrIFDus5dvmH jDWQKHdZy7fMPGGsgUO6

zl2+YeMNZAod1nLt8w8YayBQ7rOXb5h4w1kCh3Wcu3zDxhrIFDus5dvmHjDW QKHdZy7fMPGGshwPT7f4
h4w1kf/Z
</property>
</structure>
</list-property>
</report>

Raishad Maharaj wrote:
> Jason,
>
> Would this be possible with 2.3.1?
> I was trying to do something with the row.__rownum and the Visibility
> property for the header row, but it seems it is only evaluated once and
> not for every page.
>
>
> Jason Weathersby wrote:
>> Raishad,
>>
>> This possible with 2.5 using page variables.
>> See attached example.
>>
>> Jason
>>
>> <?xml version="1.0" encoding="UTF-8"?>
>> <report xmlns="http://www.eclipse.org/birt/2005/design"
>> version="3.2.20" id="1">
>> <property name="createdBy">Eclipse BIRT Designer Version
>> 2.5.0.v20090603 Build <2.5.0.v20090617-0630></property>
>> <property name="units">in</property>
>> <method name="onPageStart"><![CDATA[var first =
>> reportContext.getPageVariable("FIRST");
>> if( first == 1 ){
>> reportContext.setPageVariable("FIRST",2);
>> }]]></method>
>> <method name="onPageEnd"><![CDATA[var first =
>> reportContext.getPageVariable("FIRST");
>> if( first == 0 ){
>> reportContext.setPageVariable("FIRST",1);
>> }]]></method>
>> <property name="iconFile">/templates/blank_report.gif</property>
>> <property name="bidiLayoutOrientation">ltr</property>
>> <data-sources>
>> <oda-data-source
>> extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source"
>> id="7">
>> <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="8">
>> <list-property name="columnHints">
>> <structure>
>> <property name="columnName">ORDERNUMBER</property>
>> <property name="displayName">ORDERNUMBER</property>
>> </structure>
>> <structure>
>> <property name="columnName">ORDERDATE</property>
>> <property name="displayName">ORDERDATE</property>
>> </structure>
>> <structure>
>> <property name="columnName">REQUIREDDATE</property>
>> <property name="displayName">REQUIREDDATE</property>
>> </structure>
>> <structure>
>> <property name="columnName">SHIPPEDDATE</property>
>> <property name="displayName">SHIPPEDDATE</property>
>> </structure>
>> <structure>
>> <property name="columnName">STATUS</property>
>> <property name="displayName">STATUS</property>
>> </structure>
>> <structure>
>> <property name="columnName">COMMENTS</property>
>> <property name="displayName">COMMENTS</property>
>> </structure>
>> <structure>
>> <property name="columnName">CUSTOMERNUMBER</property>
>> <property
>> name="displayName">CUSTOMERNUMBER</property>
>> </structure>
>> </list-property>
>> <structure name="cachedMetaData">
>> <list-property name="resultSet">
>> <structure>
>> <property name="position">1</property>
>> <property name="name">ORDERNUMBER</property>
>> <property name="dataType">integer</property>
>> </structure>
>> <structure>
>> <property name="position">2</property>
>> <property name="name">ORDERDATE</property>
>> <property name="dataType">date</property>
>> </structure>
>> <structure>
>> <property name="position">3</property>
>> <property name="name">REQUIREDDATE</property>
>> <property name="dataType">date</property>
>> </structure>
>> <structure>
>> <property name="position">4</property>
>> <property name="name">SHIPPEDDATE</property>
>> <property name="dataType">date</property>
>> </structure>
>> <structure>
>> <property name="position">5</property>
>> <property name="name">STATUS</property>
>> <property name="dataType">string</property>
>> </structure>
>> <structure>
>> <property name="position">6</property>
>> <property name="name">COMMENTS</property>
>> <property name="dataType">string</property>
>> </structure>
>> <structure>
>> <property name="position">7</property>
>> <property name="name">CUSTOMERNUMBER</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">ORDERNUMBER</property>
>> <property name="nativeName">ORDERNUMBER</property>
>> <property name="dataType">integer</property>
>> <property name="nativeDataType">4</property>
>> </structure>
>> <structure>
>> <property name="position">2</property>
>> <property name="name">ORDERDATE</property>
>> <property name="nativeName">ORDERDATE</property>
>> <property name="dataType">date</property>
>> <property name="nativeDataType">91</property>
>> </structure>
>> <structure>
>> <property name="position">3</property>
>> <property name="name">REQUIREDDATE</property>
>> <property name="nativeName">REQUIREDDATE</property>
>> <property name="dataType">date</property>
>> <property name="nativeDataType">91</property>
>> </structure>
>> <structure>
>> <property name="position">4</property>
>> <property name="name">SHIPPEDDATE</property>
>> <property name="nativeName">SHIPPEDDATE</property>
>> <property name="dataType">date</property>
>> <property name="nativeDataType">91</property>
>> </structure>
>> <structure>
>> <property name="position">5</property>
>> <property name="name">STATUS</property>
>> <property name="nativeName">STATUS</property>
>> <property name="dataType">string</property>
>> <property name="nativeDataType">12</property>
>> </structure>
>> <structure>
>> <property name="position">6</property>
>> <property name="name">COMMENTS</property>
>> <property name="nativeName">COMMENTS</property>
>> <property name="dataType">string</property>
>> <property name="nativeDataType">12</property>
>> </structure>
>> <structure>
>> <property name="position">7</property>
>> <property name="name">CUSTOMERNUMBER</property>
>> <property name="nativeName">CUSTOMERNUMBER</property>
>> <property name="dataType">integer</property>
>> <property name="nativeDataType">4</property>
>> </structure>
>> </list-property>
>> <xml-property name="queryText"><![CDATA[select *
>> from orders]]></xml-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>ORDERNUMBER</design:name>
>> <design:position>1</design:position>
>> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
>> <design:precision>10</design:precision>
>> <design:scale>0</design:scale>
>> <design:nullability>Nullable</design:nullability>
>> <design:uiHints>
>> <design:displayName>ORDERNUMBER</design:displayName>
>> </design:uiHints>
>> </design:attributes>
>> <design:usageHints>
>> <design:label>ORDERNUMBER</design:label>
>> <design:formattingHints>
>> <design:displaySize>11</design:displaySize>
>> </design:formattingHints>
>> </design:usageHints>
>> </design:resultColumnDefinitions>
>> <design:resultColumnDefinitions>
>> <design:attributes>
>> <design:name>ORDERDATE</design:name>
>> <design:position>2</design:position>
>> <design:nativeDataTypeCode>91</design:nativeDataTypeCode>
>> <design:precision>10</design:precision>
>> <design:scale>0</design:scale>
>> <design:nullability>Nullable</design:nullability>
>> <design:uiHints>
>> <design:displayName>ORDERDATE</design:displayName>
>> </design:uiHints>
>> </design:attributes>
>> <design:usageHints>
>> <design:label>ORDERDATE</design:label>
>> <design:formattingHints>
>> <design:displaySize>10</design:displaySize>
>> </design:formattingHints>
>> </design:usageHints>
>> </design:resultColumnDefinitions>
>> <design:resultColumnDefinitions>
>> <design:attributes>
>> <design:name>REQUIREDDATE</design:name>
>> <design:position>3</design:position>
>> <design:nativeDataTypeCode>91</design:nativeDataTypeCode>
>> <design:precision>10</design:precision>
>> <design:scale>0</design:scale>
>> <design:nullability>Nullable</design:nullability>
>> <design:uiHints>
>> <design:displayName>REQUIREDDATE</design:displayName>
>> </design:uiHints>
>> </design:attributes>
>> <design:usageHints>
>> <design:label>REQUIREDDATE</design:label>
>> <design:formattingHints>
>> <design:displaySize>10</design:displaySize>
>> </design:formattingHints>
>> </design:usageHints>
>> </design:resultColumnDefinitions>
>> <design:resultColumnDefinitions>
>> <design:attributes>
>> <design:name>SHIPPEDDATE</design:name>
>> <design:position>4</design:position>
>> <design:nativeDataTypeCode>91</design:nativeDataTypeCode>
>> <design:precision>10</design:precision>
>> <design:scale>0</design:scale>
>> <design:nullability>Nullable</design:nullability>
>> <design:uiHints>
>> <design:displayName>SHIPPEDDATE</design:displayName>
>> </design:uiHints>
>> </design:attributes>
>> <design:usageHints>
>> <design:label>SHIPPEDDATE</design:label>
>> <design:formattingHints>
>> <design:displaySize>10</design:displaySize>
>> </design:formattingHints>
>> </design:usageHints>
>> </design:resultColumnDefinitions>
>> <design:resultColumnDefinitions>
>> <design:attributes>
>> <design:name>STATUS</design:name>
>> <design:position>5</design:position>
>> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>> <design:precision>15</design:precision>
>> <design:scale>0</design:scale>
>> <design:nullability>Nullable</design:nullability>
>> <design:uiHints>
>> <design:displayName>STATUS</design:displayName>
>> </design:uiHints>
>> </design:attributes>
>> <design:usageHints>
>> <design:label>STATUS</design:label>
>> <design:formattingHints>
>> <design:displaySize>15</design:displaySize>
>> </design:formattingHints>
>> </design:usageHints>
>> </design:resultColumnDefinitions>
>> <design:resultColumnDefinitions>
>> <design:attributes>
>> <design:name>COMMENTS</design:name>
>> <design:position>6</design:position>
>> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>> <design:precision>32700</design:precision>
>> <design:scale>0</design:scale>
>> <design:nullability>Nullable</design:nullability>
>> <design:uiHints>
>> <design:displayName>COMMENTS</design:displayName>
>> </design:uiHints>
>> </design:attributes>
>> <design:usageHints>
>> <design:label>COMMENTS</design:label>
>> <design:formattingHints>
>> <design:displaySize>32700</design:displaySize>
>> </design:formattingHints>
>> </design:usageHints>
>> </design:resultColumnDefinitions>
>> <design:resultColumnDefinitions>
>> <design:attributes>
>> <design:name>CUSTOMERNUMBER</design:name>
>> <design:position>7</design:position>
>> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
>> <design:precision>10</design:precision>
>> <design:scale>0</design:scale>
>> <design:nullability>Nullable</design:nullability>
>> <design:uiHints>
>> <design:displayName>CUSTOMERNUMBER</design:displayName>
>> </design:uiHints>
>> </design:attributes>
>> <design:usageHints>
>> <design:label>CUSTOMERNUMBER</design:label>
>> <design:formattingHints>
>> <design:displaySize>11</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="report" id="4">
>> <property name="fontFamily">"Verdana"</property>
>> <property name="fontSize">10pt</property>
>> </style>
>> <style name="crosstab" id="5">
>> <property name="borderBottomColor">#CCCCCC</property>
>> <property name="borderBottomStyle">solid</property>
>> <property name="borderBottomWidth">1pt</property>
>> <property name="borderLeftColor">#CCCCCC</property>
>> <property name="borderLeftStyle">solid</property>
>> <property name="borderLeftWidth">1pt</property>
>> <property name="borderRightColor">#CCCCCC</property>
>> <property name="borderRightStyle">solid</property>
>> <property name="borderRightWidth">1pt</property>
>> <property name="borderTopColor">#CCCCCC</property>
>> <property name="borderTopStyle">solid</property>
>> <property name="borderTopWidth">1pt</property>
>> </style>
>> <style name="crosstab-cell" id="6">
>> <property name="borderBottomColor">#CCCCCC</property>
>> <property name="borderBottomStyle">solid</property>
>> <property name="borderBottomWidth">1pt</property>
>> <property name="borderLeftColor">#CCCCCC</property>
>> <

Report message to a moderator

Re: Hide Header Row on PDF Output [message #485953 is a reply to message #485730]

Tue, 15 September 2009 15:50

Raishad

Messages: 77
Registered: July 2009

Member

Jason,

That seems to work for the html output, but it seems when I output to
PDF - that script is only being run once for the first page. It doesn't
seem to be firing for each page.
Is there any way to change that?

Thanks for all your help so far,
Raishad

Jason Weathersby wrote:
> Raishad,
>
> Take a look at the onrender script for the image on the header on the
> master page in the attached example.
>
> 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 <2.3.2.v20090218-0730></property>
> <property name="units">in</property>
> <property name="iconFile">/templates/blank_report.gif</property>
> <property name="bidiLayoutOrientation">ltr</property>
> <data-sources>
> <oda-data-source
> extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source"
> id="7">
> <property
> name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver </property>
>
> <property name="odaURL">jdbc:classicmodels:sampledb</property>
> <property name="odaUser">ClassicModels</property>
> <property name="OdaConnProfileName"></property>
> </oda-data-source>
> </data-sources>
> <data-sets>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
> name="Data Set" id="8">
> <list-property name="columnHints">
> <structure>
> <property name="columnName">ORDERNUMBER</property>
> <property name="displayName">ORDERNUMBER</property>
> </structure>
> <structure>
> <property name="columnName">PRODUCTCODE</property>
> <property name="displayName">PRODUCTCODE</property>
> </structure>
> <structure>
> <property name="columnName">QUANTITYORDERED</property>
> <property name="displayName">QUANTITYORDERED</property>
> </structure>
> <structure>
> <property name="columnName">PRICEEACH</property>
> <property name="displayName">PRICEEACH</property>
> </structure>
> <structure>
> <property name="columnName">ORDERLINENUMBER</property>
> <property name="displayName">ORDERLINENUMBER</property>
> </structure>
> </list-property>
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">ORDERNUMBER</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">PRODUCTCODE</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">QUANTITYORDERED</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">PRICEEACH</property>
> <property name="dataType">float</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">ORDERLINENUMBER</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">ORDERNUMBER</property>
> <property name="nativeName">ORDERNUMBER</property>
> <property name="dataType">integer</property>
> <property name="nativeDataType">4</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">PRODUCTCODE</property>
> <property name="nativeName">PRODUCTCODE</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">QUANTITYORDERED</property>
> <property name="nativeName">QUANTITYORDERED</property>
> <property name="dataType">integer</property>
> <property name="nativeDataType">4</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">PRICEEACH</property>
> <property name="nativeName">PRICEEACH</property>
> <property name="dataType">float</property>
> <property name="nativeDataType">8</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">ORDERLINENUMBER</property>
> <property name="nativeName">ORDERLINENUMBER</property>
> <property name="dataType">integer</property>
> <property name="nativeDataType">5</property>
> </structure>
> </list-property>
> <property name="queryText">select *
> from orderdetails</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>ORDERNUMBER</design:name>
> <design:position>1</design:position>
> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
> <design:precision>10</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>ORDERNUMBER</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>ORDERNUMBER</design:label>
> <design:formattingHints>
> <design:displaySize>11</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>PRODUCTCODE</design:name>
> <design:position>2</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>15</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>PRODUCTCODE</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>PRODUCTCODE</design:label>
> <design:formattingHints>
> <design:displaySize>15</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>QUANTITYORDERED</design:name>
> <design:position>3</design:position>
> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
> <design:precision>10</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>QUANTITYORDERED</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>QUANTITYORDERED</design:label>
> <design:formattingHints>
> <design:displaySize>11</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>PRICEEACH</design:name>
> <design:position>4</design:position>
> <design:nativeDataTypeCode>8</design:nativeDataTypeCode>
> <design:precision>15</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>PRICEEACH</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>PRICEEACH</design:label>
> <design:formattingHints>
> <design:displaySize>22</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>ORDERLINENUMBER</design:name>
> <design:position>5</design:position>
> <design:nativeDataTypeCode>5</design:nativeDataTypeCode>
> <design:precision>5</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>ORDERLINENUMBER</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>ORDERLINENUMBER</design:label>
> <design:formattingHints>
> <design:displaySize>6</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="report" id="4">
> <property name="fontFamily">"Verdana"</property>
> <property name="fontSize">10pt</property>
> </style>
> <style name="crosstab" id="5">
> <property name="borderBottomColor">#CCCCCC</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">1pt</property>
> <property name="borderLeftColor">#CCCCCC</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">1pt</property>
> <property name="borderRightColor">#CCCCCC</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">1pt</property>
> <property name="borderTopColor">#CCCCCC</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">1pt</property>
> </style>
> <style name="crosstab-cell" 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">
> <property name="topMargin">0.25in</property>
> <property name="leftMargin">0.25in</property>
> <property name="bottomMargin">0.25in</property>
> <property name="rightMargin">0.25in</property>
> <page-header>
> <grid id="44">
> <property name="width">100%</property>
> <column id="45"/>
> <row id="48">
> <cell id="49">
> <image id="61">
> <property name="height">95px</property>
> <property name="width">325px</property>
> <method
> name="onRender"><![CDATA[if(pageNumber>1){
> this.getStyle().display ="none"
> }
> ]]></method>
> <property name="source">embed</property>
> <property
> name="imageName">eclipsecon08_logo.jpg</property>
> </image>
> </cell>
> </row>
> <row id="52">
> <cell id="53">
> <label id="60">
> <property
> name="textAlign">center</property>
> <text-property name="text">Report
> header</text-property>
> </label>
> </cell>
> </row>
> <row id="56">
> <cell id="57"/>
> </row>
> </grid>
> </page-header>
> </simple-master-page>
> </page-setup>
> <body>
> <table id="9">
> <property name="width">100%</property>
> <property name="dataSet">Data Set</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">ORDERNUMBER</property>
> <property name="displayName">ORDERNUMBER</property>
> <expression
> name="expression">dataSetRow["ORDERNUMBER"]</expression >
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="name">PRODUCTCODE</property>
> <property name="displayName">PRODUCTCODE</property>
> <expression
> name="expression">dataSetRow["PRODUCTCODE"]</expression >
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">QUANTITYORDERED</property>
> <property name="displayName">QUANTITYORDERED</property>
> <expression
> name="expression">dataSetRow["QUANTITYORDERED"]</expression >
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="name">PRICEEACH</property>
> <property name="displayName">PRICEEACH</property>
> <expression
> name="expression">dataSetRow["PRICEEACH"]</expression>
> <property name="dataType">float</property>
> </structure>
> <structure>
> <property name="name">ORDERLINENUMBER</property>
> <property name="displayName">ORDERLINENUMBER</property>
> <expression
> name="expression">dataSetRow["ORDERLINENUMBER"]</expression >
> <property name="dataType">integer</property>
> </structure>
> </list-property>
> <property name="pageBreakInterval">30</property>
> <column id="38"/>
> <column id="39"/>
> <column id="40"/>
> <column id="41"/>
> <column id="42"/>
> <header>
> <row id="10">
> <cell id="11">
> <label id="12">
> <text-property
> name="text">ORDERNUMBER</text-property>
> </label>
> </cell>
> <cell id="13">
> <label id="14">
> <text-property
> name="text">PRODUCTCODE</text-property>
> </label>
> </cell>
> <cell id="15">
> <label id="16">
> <text-property
> name="text">QUANTITYORDERED</text-property>
> </label>
> </cell>
> <cell id="17">
> <label id="18">
> <text-property
> name="text">PRICEEACH</text-property>
> </label>
> </cell>
> <cell id="19">
> <label id="20">
> <text-property
> name="text">ORDERLINENUMBER</text-property>
> </label>
> </cell>
> </row>
> </header>
> <detail>
> <row id="21">
> <cell id="22">
> <data id="23">
> <property
> name="resultSetColumn">ORDERNUMBER</property>
> </data>
> </cell>
> <cell id="24">
> <data id="25">
> <property
> name="resultSetColumn">PRODUCTCODE</property>
> </data>
> </cell>
> <cell id="26">
> <data id="27">
> <property
> name="resultSetColumn">QUANTITYORDERED</property>
> </data>
> </cell>
> <cell id="28">
> <data id="29">
> <property
> name="resultSetColumn">PRICEEACH</property>
> </data>
> </cell>
> <cell id="30">
> <data id="31">
> <property
> name="resultSetColumn">ORDERLINENUMBER</property>
> </data>
> </cell>
> </row>
> </detail>
> <footer>
> <row id="32">
> <cell id="33"/>
> <cell id="34"/>
> <cell id="35"/>
> <cell id="36"/>
> <cell id="37"/>
> </row>
> </footer>
> </table>
> </body>
> <list-property name="images">
> <structure>
> <property name="name">eclipsecon08_logo.jpg</property>
> <property name="data">
>
> /9j/4AAQSkZJRgABAgAAZABkAAD/7AARRHVja3kAAQAEAAAAPAAA/+4ADkFk b2JlAGTAAAAAAf/bAIQA
>
>
> BgQEBAUEBgUFBgkGBQYJCwgGBggLDAoKCwoKDBAMDAwMDAwQDA4PEA8ODBMT FBQTExwbGxscHx8fHx8f
>
>
> Hx8fHwEHBwcNDA0YEBAYGhURFRofHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8f Hx8fHx8fHx8fHx8fHx8f
>
>
> Hx8fHx8fHx8f/8AAEQgAXwFFAwERAAIRAQMRAf/EAKAAAQACAwEBAAAAAAAA AAAAAAABAwQFBgIHAQEB
>
>
> AQEBAQEAAAAAAAAAAAAAAQIDBAUGEAABAgUBBAkABwYEBgMAAAABAgMAETEE BSFBwRIG8FFhgdEiMhMH
>
>
> cZFCk9MUJKFSciMVCLGSotLhYoI0FhczsyYRAQACAgIAAwcEAQUAAAAAAAAB EQISIQMxQQTwUWHxIjIT
>
>
> cYGhQiNSYnJDFP/aAAwDAQACEQMRAD8A+YFutenXH6igLda9OuFAW616dcKA t1r064UBbrXp1woC2Na9
>
>
> ++FAWxrXp1woC3WvTrhQFutenXCgLda9OuFAW616dcKAt1r064UBbrXp1woC 3WvTrhQFutenXCgLda9O
>
>
> uFAW616dcKAt1r064UBbrXp1woC3WvTrhQFutenXCgLda9OuFAW616dcKAt1 r064UBbrXp1woC3WvTrh
>
>
> QFutenXCgLda9OuFAW616dcKAt1r064UBbrXp1woC3WvTrhQFutenXCgLda9 OuFAW616dcKAt1r064UB
>
>
> brXp1woC3WvTrhQFutenXCgLda9OuFCfbE9u+FCwitY66gRWsNQIrWGoKFaw 1Cs5TiULE261T0MQSu2W
>
>
> J6GIKiCCZzjUQBFaxdQIrWGoEVrDUCK1hqBFaw1AitYagRWsNQIrWGoEVrDU CK1hqBFaw1AitYagRWsN
>
>
> QIrWGoEVrDUCK1hqBFaw1AitYagRWsNQIrWGoEVrDUCK1hqBFaw1AitYagRW sNQIrWGoEVrDUCK1hqBF
>
>
> aw1AitYagRWsNQIrWGomWu2GosKK1jpQKSNa98KAprWFApNaxKF9ra8a9AdY 5ZI63EctquUiSSTHmy7K
>
>
> Gdd8kvJSVLHto2qI1+qMx3wsQ5TK462typLYKyPtEwn1E+STLnLoKEyFEfQT HLLvz97nOUsQ3Nwk6LPf
>
>
> rGY7848yMpXM5MTk8P8AqG8R6ev1f+puMmwHAtPEk8STQx7o55hpJRWsWgKK 1hQFFawoCitYUBRWsKAo
>
>
> rWFAUVrCgKK1hQFFawoCitYUBRWsKAorWFAUVrCgKK1hQFFawoCitYUBRWsK AorWFAUVrCgKK1hQFFaw
>
>
> oCitYUBRWsKAorWFAUVrCgKK1hQFFawoCitYUJ4Ndu+FC8pGuhiWIUkSOh74 WPKmgJ8MxEEKmBqImw2W
>
>
> KU37on+2OOco+zfH6bBAS8+Bw/Zn19cfN9RaxDM51v7B1JSyRIDWW0xw67Jl 8bzqkFapR6IYlyV2RrEl
>
>
> iWRc8oZxrlBrm5bbYwj1wbRt33B7nugqTIt1lNJ1jnvF15lNPjcZkMtkGMdj WFXV9dK4Le3RLiWqRMhM
>
>
> gUEamaWGQpvI4LLv4nKsqtrlhYbubZyXE2sgHWRIoY7+n9Rr/wAZbxbgpEts fUtpJSNdDFsCka6GFgUj
>
>
> XQwsCka6GFgUjXQwsCka6GFgUjXQwsCka6GFiCBrWFgUjXQwsCka1hYFI1rC xJSNdDCwKRroYWIKRrWF
>
>
> gUjWsLElI10MLEFI1rCwKRrWFgUjWsLApGtYWBSNawsCka1hYFI1rCwKRrWF iSka6GFgUjXQwsOEToYW
>
>
> LWrd9/i9ltS+GXFLZPrjlszOUR4rDjb/AF/kOfVDZPyR7xWOv9f5Dn1Q2PyR 70OY+9CSSyuXaIbG8e92
>
>
> 9l8b47F2Vrec48wN8vOXqQ5bY/2lXFyUGinG0+ifb366R4M/U3MxhjtSzMN/ nrNWCwNtmsPkG8zy/cqD
>
>
> Dd8wOEtroEuJmZTlL6ax547NpqYrJqcopy/57LZR9m1tWHH7i5UG2WkiZUpW gEa1qLljeG4y3xty1jVo
>
>
> teaedLTFZZxIUbJtv3vb4qBxUxL6SBHKO3KftxuCafO+e+TbzlvKsWTV4xmL a8YF1Z31nq2tpS1I11IC
>
>
> poNCY1hlOXkxlw6nP210n+2LHNFpQdGdJKJay9x2OWs/l/Zq/pcHyHguYb3m zD2uOfdxV7cXCW7fJoTM
>
>
> sKUkjjAmNmkdc4rGZmEiYYnO+B5hs+ec1ZZC6dy99bXJbuMipMlPqSkeciZ2 aRnGJnGKhq4fQeRvi3N8
>
>
> xcl/11N2xZpYuVWr6LtXtJQ23Kby3DpwgKGlY9OHrdKxyibatvrT4mwOZaft +WecLPLZphBWrHhHthfD
>
>
> XgcKjPXbwy641PrssZ+rGoLt83eadaedYdQpDzSi262oSUlaTwqSodYIj249 kSm0O8/9a4fF2Nq/zjzK
>
>
> xy/cX7YetrEtLuHwg7XEII4Y8k+smZnTHalmWj5u5Vx2GtLPIY3O2ubx18tb bb1sSlaFtgKKXEEnhmFa
>
>
> ax06fU7TMTGsps1WDwuSzuVYxWMaU/eXJk2igAGqlKOxKRqTHbPuxxi5W3aO fH3IjFycbec82zOXSr23
>
>
> Gk2zjlulycuEvzSga6Ex5P8A15+MYcFuV5u5XynK+ZdxWSA91KQ408g8TbrS vS4gmUwZR6envjsi4LY+
>
>
> Fw1xl7ssNK9ttA4nnVahI+jaTsjWfZTeGO0s5605JadLC8hdLWnRTqEgtz/y EnujG+Tcxh72oubdpWRV
>
>
> a49xV0hakoYXKRXxSqDLaY6Rnxy5zHNQ3d1g+XsXwNZi/dN0tIUpm2APCD1k hW6OX5cp8HScMY8ZY2W5
>
>
> faZxwymNuTeWB0WSJLRrLzd/YI1j281KZYcXHg9ctcutZpq6Up9TKmSkJAAI PEDX6oZ9tHXhs1qLFwZl
>
>
> vGXM23FPoYc2y4lBMx16GYjX5OLZ15pn32Kxtlf5G0ecdWbNtLragpKePiCP LIg6/wAz9kZjsmYanGIm
>
>
> YeMvi8faWinre7L7nuobDcxMJKVT4pbeNB7pdcXHsmZTLGIhqVK0NY6Ww3IZ 5PbCU3F7dOOEDjUyhKUJ
>
>
> JGoPECTLsjlOeTpWPvV8xYMYsMXDL35iyuk8TLhEjQHX6QdIuHZaZ4UvYwuN t8W3kszcOtNXJlbsMgFx
>
>
> Q/ePECO2JPbN1CxhERcqM5hmrO1YyFm8q5x11o24oSUlWvlV9Ri4dl8SmeFc x4L2MLjbfFt5LM3DrTVy
>
>
> ZW7DIBcUP3jxAjtiT2zdQsYREXKjN4VqztWMhZPKuMddaNuKElJVr5VfUYuH ZfEpnhXMeC6xwtgMOcvl
>
>
> X3WrRauBptkArUQSJzMxUGJl2zdQuOEVcoy+EsWsS1lsbcLes3FcCkOgBaTM jWQG0SpDDsm6kywirhpS
>
>
> qYNY6xLmlRrWFiZ67d8LFlgEue7Nn3pcPqdDUq9Z1jFsZyzCwkz/AEae+6T4 wti/j/Cp5tYPlsky6vf4
>
>
> j9YXCy/j/DP5XYZf5pw9veWyEW717bpdBdqguAGYKjHLumYwmvc1E/F9C+TX vitfyLkG+YbXOOZZPtBx
>
>
> bDjAt+H2klHthR4+GX7Y+d0R2aRrVLcW0fM/Ofx/YfHOY5W5fscnx5VaHmje Ka9tDyFIM+IKBTojYIs9
>
>
> ee0ZZUuWXCv+3hLb3yDZm4t0pW1a3C2VF4LPHwgaIn+6TE9T9jGE8vmOYTd5 LmjMXN+x7l25e3BuCu4C
>
>
> VcYdUCDM7JSjpjHEcMzKpOIShQlZp4U0T+bTIT1010jWvw/lm303mFkD+2bH I/LhIGcP8r3gR/8AI7rx
>
>
> zjzV/l/Z0/q5b4ktkj5G5YV+USki+bPuC5CiNFa8E9Y69sfRPCYzywvlRhK/ lnmsm1S5+vXqbgIn5U7J
>
>
> 6Rz64+mOP5bmeXeYVHt/22ZBIbDAOc1Slz3hVraP8InVH+X9jLwaX4sXdN/I XL67aZc/ONpUUmR9tflc
>
>
> nLZwEx7e/GPxz+iYw8/KBaT8kcxBgzSLxRkNAFkAr1/jnF9LP0R+h5uyyvNX xRz0i0uOaHbzAZ+3YTbu
>
>
> 3TCS7brCKHRLmkyTqAR1mPNHX2dfGPOKzUuY58+Ohy5j7LOYzJt5jl3JK4LW +bEiFyJCVgaahJkR1EGU
>
>
> d+nv2mpisoSnQ/AabQ5PmN98OFbOJdKfYID4QpQ4y1P7eg4Ts74x66ZrH9Wo aQ3HwcU6W3MOo1/mWu3r
>
>
> mIsfm/2sxSv5M50wHMacI3h2bppvE2n5NS7zgLi0p4fbmpBM9AZxfT9eWEzf mWxuVXFf+LZ1bE/zIQun
>
>
> qkGjLfHfPxh6uv7ZcWhYM6x0hxdByUppXM9oF/8AOUA/vBtUoz2eDfV9zD5s ccPMeQ92fEHZCf7oA4f9
>
>
> MoYeCdn3S3/KKuLlbOh7/tkoWQT+97R4u/RMYz8YdOv7ZU8m3r1vy9nbplXC 6whK0E7ClKiIZ+J1zUS2
>
>
> q2GOYTieYbBMrhm4YRfMioCXE8U/4K/wxmJrhutqyhzPO6//ANVfjq9r/wCl EdOvwce37pafirWOrm9l
>
>
> wSNYtjZ4fBKyCV3d07+UxbJ/n3S9Jy+ymdTHPLKnTHC+fI5q5kZyS2bazQWs dZJ4LdJ0KtAJnq0GkZxi
>
>
> jszvw8G1+RFBNth0on7Hsq9uVKI3SjOHm33eQlY/9ZPKcql4ezPr95M5f6oT 9x/Q+RFBNthktz9j2Ve3
>
>
> KlEbpQwk7vIQsH4zdU5VLw9mfX7yZy/1Q/sf9a7C3rGO5UC8+Pexl45w2ltw 8TkiTxKnMSGkxt+uJl48
>
>
> LjNY8+Ceardp7lm1uMK8hWFtSONhAPFxEy4lEmZIKtQeucXCeTsj6ePBx6Xd DWO8S4JLtaxbRPu67d8L
>
>
> VjMXyWuPiZS9OUvc4tJfwlMZtJi1pyrWv6Nn6nP2+eFpr8Q5VrX9Gz9Tn7fP CzX4q15OTvuNsIbWkgpK
>
>
> eMSI1B9UQ1+L6i58l/G/NqbO656xt1acw2iEtf1bGgFLyRT3ET0+iR7DLSPB +HPCfo+34rTC5+zvxl/4
>
>
> vc2PLmIub3IOlATkr8ABpIUFK4Egg+YCWgEZ17LvKv0XKJmHzzlnm2+5dzFn msZbW7V9ZL42yQuSgRwr
>
>
> QrzelSSQYZRExVOMRTvsjzb/AG88x5FzPZzFZXE5i6PuZG1tAHGHXZeZSVJM pq2mSZxxxjPHiKlqalw/
>
>
> OvNPJuSytujlPADG4i0YDCU3M1PPL41KLzhSs6kKA1UaR067jx5SYbLMfIWE f+GrPktFosZZjJG9X5P0
>
>
> vtlS1aK4+Pi8/VGdfr2XyaTkPmbH4Dm3DZq9s0flcfcofeLCVKd4Ugz4ApYB Osa7JvGYWIa/njmrHZ7n
>
>
> zPZyztE/k8jdKfYFwkpd4SAPOErIB06443URFQ1T7V8X3vLY/t7vHOYbBxzF LzakuNWKi24kq9rhcTxK
>
>
> 1IrKesTCMt4mOJpMvBFjzr8U8oBzJco4+/yHMJQpFrcZOQaY4wQVSB1MjsHe I9U4dmfGUxGPwTZ8susi
>
>
> 89eO3dyo3D7zpefWv7a1K4lTl1mPZhFQRD6LcZH4Jy8rt20y2BulHiftLThe Znt4ComX1D6I8v8Amx44
>
>
> klrue+fMRkcDjuVuW7R6x5cxa1PIVcqCrh95XF53JTCR51aT2xerqmMpyy+6 UloOS+dsjylzCzmLFIWp
>
>
> sFt9hcwl1pfqQqX0TB2GPR29cZ41LdO0vch8DZi4VknmMziH3j7lxj7QNLZ4 zqfbKuKQJ+j6BHlxjux4
>
>
> 4lnhyHOmU5Uu7q3Tyxjnsdj7Zn21G4WFvPucRUXXJEyMjKU49HVtH3Tcltdy 5zQ/g75boQXrZ4BNwyTK
>
>
> YFCD1iOmUW7YZ6tk/c/HLzhuQL5ji8yrVsJCZnZrxS7lRmJlqdGku8qw1lze 4htdqy0pCrZCzxKBQkAl
>
>
> WpnxEExry5Ymebhv73mDk7OFNzlmbqyvkpCXV23CUrlSoV/h3xiLh0nLHLxY ua5tsP6R/RMHbuMWRM33
>
>
> nZe45rM0JrKs+zSLEc3KZZxVQxsJzDaWGEy9i8h1T1+gJZUkJKQeFQ85Kgdu wRZjlMcqiYOUOalYG+Wp
>
>
> 5Ljli8JPNJkVAj0qSCQJ7K0iZY2deessbmTMMZTO3V/bpcQy97fClwAKHC2l BmAVCqeuNYcM5zc2wS8d
>
>
> a7I6Wyhbxka9OuJY7O95u5JvLG2srqyvfYtQAhpvhQmcpTMnRPvjjUu854zF Oezt5yy621/Rba5YWCff
>
>
> L5BBGnDLzr7Y1jfm55Tj5NixzHhcjhWMXnkvtrsv+1vGAFHhpwqB7NKRJip4 ajKJipY3MfMtndY+3w2K
>
>
> acaxloeLjdl7ji9dVS/iJhEJnnxUeDJt+Y8LkcKxi88l9tdlpa3jACjwU4VA 9mlIVU8LGUTFSxuYuZbO
>
>
> 5x9vh8U041jLQ8XG7L3HF66ql/ETCITPO4qPBl2/MmByGBZxGdbfaNpL8vdW 4BMgJDiB+qmsSY5WMomK
>
>
> lVkeZMTbYFWDwaHiw8v3Lq6uJBSjMUA/hEWI5Jyiqhz4eIBrHWJckl4616dc WxPvGe3fCxhl2tenXHOw
>
>
> Lta9OuFieMqJlM9NsLEqUgE8SiewbzFse0uJOkpCDeLu+VXcdkrFVjcpH5lC Skg1W31jtTHPLF11cbzL
>
>
> hH8TfLbUP5SjNC9hBoY82UU8ueFS0ighVRGWHiSRQRVQpIOpjE5LEPDi0hMt kcssm6a8tm5uAw1pPVxY
>
>
> +ynafCMYYTnlSvpWN54urTkJ/ktFu0Mc7dpvfzB4vdStKUJCRrw8P8sbI+jP TG0ZR5RTGTnXbg8SpEyj
>
>
> tCxCtTtaxbVPvkT1MQpKric58UEpBdRrMK+v/hFtXv8AMNiei/8AMPCIlJVc Mmc0r/zD/bFKQXrXWbbn
>
>
> +cf7YWchdstZtO/eJ/2RDl696w1m0996n8OLZykvY3WbL/3qfw4HKfexYnNh /wC+R+FC05SbjFazt7j7
>
>
> 9H4ULOUm4xGs7e4+/R+DCysvb5n5jDif6a5+/R+DCysvb5pNziNf01z9+j8G FlZe3zDc4jX9Nc9v89H4
>
>
> MLKy9vmgv4fX9Nc/fo/BhZWXt8z38Pr+mufv0fgwsrL2+YX8Pr+mufv0fgws rL2+Z7+H1/TXP36PwYWV
>
>
> l7fML+H1/TXP36PwYWVl7fM9/D6/prn79H4MLKy9vmF/D6/prn79H4MLKy9v m8PPY0tqDLD6HNJKW6la
>
>
> a7UhtH+MLItQXBrXp1wtoLta9OuFh7vm274WMcqrXv3xgOIAk6n6d8LEqcJn qZdXjCxBVWvfvhYsbUSq
>
>
> QnONNRLZWl4u2cStlZS6gghwVBg7Y5OvbzmJzln+TzKQ059m4A0n1/8AL/hG MsbaywtyWa5Ru7JanLVQ
>
>
> u7WqVtmZl9EcMsMoeXLrpz65oJSoFJFQdDHnnJKUOPpG2Oc5Kq/LXtx6U+03 tcWJfUKmNYdGWfwhqmdb
>
>
> 2rFq2UNAzOq1mqj1mPodfXGEVCSuKpTr0640gVVr374AVVr374AVVr374AVV r374AVVr374AVVr374AV
>
>
> Vr374AVVr374AVVr374AVVr374AVVr374AVVr374AVVr374AVVr374AVVr37 4AVVr374AVVr374AVVr3
>
>
> 74AVVr374AVVr374AVVr374AVVr374AVVr374AVVr374AVVr374AVVr374AV Vr374Bxeb7W+Axi7Wuyu
>
>
> +IgXa12V3wAu1rsrvgHuFRIHESZSHjAXKfDU0pJK/tK6uyLYlFzKdYttxLNT e8KAJmZ1MV0jNcjJOIB4
>
>
> VqT9BlEb3VXF027P3Ehf8QnCeWZr3MVTrKJ8CAn6ABEjGI8mZlS7cTnWLbnM qlO1rs6GM2yF2tdld8AL
>
>
> ta7K74AXa12V3wAu1rsrvgBdrXZXfAC7Wuyu+AF2tdld8ALta7K74AXa12V3 wAu1rsrvgBdrXZXfAC7W
>
>
> uyu+AF2tdld8ALta7K74AXa12V3wAu1rsrvgBdrXZXfAC7Wuyu+AF2tdld8A Lta7K74AXa12V3wAu1rs
>
>
> rvgBdrXZXfAC7Wuyu+AF2tdld8ALta7K74AXa12V3wAu1rsrvgHu+b7W+AxC 56q7K74yBc9Vdld8AKyZ
>
>
> gcWzoYC0u+0FBJPuGqursi2Ki56q7K74lj0HDM1lpXfFiR7VcklR12dDF2W0 m5OtenXC1sVcnXU9++Fl
>
>
> vC3zrXp1xLS3lTh81dld8SxBc9Vdld8EC56q7K74AXPVXZXfAC56q7K74AXP VXZXfAC56q7K74AXPVXZ
>
>
> XfAC56q7K74AXPVXZXfAC56q7K74AXPVXZXfAC56q7K74AXPVXZXfAC56q7K 74AXPVXZXfAC56q7K74A
>
>
> XPVXZXfAC56q7K74AXPVXZXfAC56q7K74AXPVXZXfAC56q7K74AXPVXZXfAC 56q7K74AXPVXZXfAC56q
>
>
> 7K74AXPVXZXfAC56q7K74AXPVXZXfAT7nm+1vpBVRQ7rOXb5h4w1lAod1nLt 8w8YayJCHwTKu3UeMKkQ
>
>
> UO6zl2+YeMNZAod1nLt8w8YayHA9rTt8w8YayBQ7rOXb5h4w1kCh3Wcu3zDx hrIFDus5dvmHjDWQKHdZ
>
>
> y7fMPGGsgUO6zl2+YeMNZAod1nLt8w8YayBQ7rOXb5h4w1kCh3Wcu3zDxhrI FDus5dvmHjDWQKHdZy7f
>
>
> MPGGsgUO6zl2+YeMNZAod1nLt8w8YayBQ7rOXb5h4w1kCh3Wcu3zDxhrIFDu s5dvmHjDWQKHdZy7fMPG
>
>
> GsgUO6zl2+YeMNZAod1nLt8w8YayBQ7rOXb5h4w1kCh3Wcu3zDxhrIFDus5d vmHjDWQKHdZy7fMPGGsg
>
>
> UO6zl2+YeMNZAod1nLt8w8YayBQ7rOXb5h4w1kCh3Wcu3zDxhrIFDus5dvmH jDWQKHdZy7fMPGGsgUO6
>
>
> zl2+YeMNZAod1nLt8w8YayBQ7rOXb5h4w1kCh3Wcu3zDxhrIFDus5dvmHjDW QKHdZy7fMPGGshwPT7f4
>
> h4w1kf/Z
> </property>
> </structure>
> </list-property>
> </report>
>
> Raishad Maharaj wrote:
>> Jason,
>>
>> Would this be possible with 2.3.1?
>> I was trying to do something with the row.__rownum and the Visibility
>> property for the header row, but it seems it is only evaluated once
>> and not for every page.
>>
>>
>> Jason Weathersby wrote:
>>> Raishad,
>>>
>>> This possible with 2.5 using page variables.
>>> See attached example.
>>>
>>> Jason
>>>
>>> <?xml version="1.0" encoding="UTF-8"?>
>>> <report xmlns="http://www.eclipse.org/birt/2005/design"
>>> version="3.2.20" id="1">
>>> <property name="createdBy">Eclipse BIRT Designer Version
>>> 2.5.0.v20090603 Build <2.5.0.v20090617-0630></property>
>>> <property name="units">in</property>
>>> <method name="onPageStart"><![CDATA[var first =
>>> reportContext.getPageVariable("FIRST");
>>> if( first == 1 ){
>>> reportContext.setPageVariable("FIRST",2);
>>> }]]></method>
>>> <method name="onPageEnd"><![CDATA[var first =
>>> reportContext.getPageVariable("FIRST");
>>> if( first == 0 ){
>>> reportContext.setPageVariable("FIRST",1);
>>> }]]></method>
>>> <property name="iconFile">/templates/blank_report.gif</property>
>>> <property name="bidiLayoutOrientation">ltr</property>
>>> <data-sources>
>>> <oda-data-source
>>> extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data
>>> Source" id="7">
>>> <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="8">
>>> <list-property name="columnHints">
>>> <structure>
>>> <property name="columnName">ORDERNUMBER</property>
>>> <property name="displayName">ORDERNUMBER</property>
>>> </structure>
>>> <structure>
>>> <property name="columnName">ORDERDATE</property>
>>> <property name="displayName">ORDERDATE</property>
>>> </structure>
>>> <structure>
>>> <property name="columnName">REQUIREDDATE</property>
>>> <property name="displayName">REQUIREDDATE</property>
>>> </structure>
>>> <structure>
>>> <property name="columnName">SHIPPEDDATE</property>
>>> <property name="displayName">SHIPPEDDATE</property>
>>> </structure>
>>> <structure>
>>> <property name="columnName">STATUS</property>
>>> <property name="displayName">STATUS</property>
>>> </structure>
>>> <structure>
>>> <property name="columnName">COMMENTS</property>
>>> <property name="displayName">COMMENTS</property>
>>> </structure>
>>> <structure>
>>> <property
>>> name="columnName">CUSTOMERNUMBER</property>
>>> <property
>>> name="displayName">CUSTOMERNUMBER</property>
>>> </structure>
>>> </list-property>
>>> <structure name="cachedMetaData">
>>> <list-property name="resultSet">
>>> <structure>
>>> <property name="position">1</property>
>>> <property name="name">ORDERNUMBER</property>
>>> <property name="dataType">integer</property>
>>> </structure>
>>> <structure>
>>> <property name="position">2</property>
>>> <property name="name">ORDERDATE</property>
>>> <property name="dataType">date</property>
>>> </structure>
>>> <structure>
>>> <property name="position">3</property>
>>> <property name="name">REQUIREDDATE</property>
>>> <property name="dataType">date</property>
>>> </structure>
>>> <structure>
>>> <property name="position">4</property>
>>> <property name="name">SHIPPEDDATE</property>
>>> <property name="dataType">date</property>
>>> </structure>
>>> <structure>
>>> <property name="position">5</property>
>>> <property name="name">STATUS</property>
>>> <property name="dataType">string</property>
>>> </structure>
>>> <structure>
>>> <property name="position">6</property>
>>> <property name="name">COMMENTS</property>
>>> <property name="dataType">string</property>
>>> </structure>
>>> <structure>
>>> <property name="position">7</property>
>>> <property name="name">CUSTOMERNUMBER</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">ORDERNUMBER</property>
>>> <property name="nativeName">ORDERNUMBER</property>
>>> <property name="dataType">integer</property>
>>> <property name="nativeDataType">4</property>
>>> </structure>
>>> <structure>
>>> <property name="position">2</property>
>>> <property name="name">ORDERDATE</property>
>>> <property name="nativeName">ORDERDATE</property>
>>> <property name="dataType">date</property>
>>> <property name="nativeDataType">91</property>
>>> </structure>
>>> <structure>
>>> <property name="position">3</property>
>>> <property name="name">REQUIREDDATE</property>
>>> <property name="nativeName">REQUIREDDATE</property>
>>> <property name="dataType">date</property>
>>> <property name="nativeDataType">91</property>
>>> </structure>
>>> <structure>
>>> <property name="position">4</property>
>>> <property name="name">SHIPPEDDATE</property>
>>> <property name="nativeName">SHIPPEDDATE</property>
>>> <property name="dataType">date</property>
>>> <property name="nativeDataType">91</property>
>>> </structure>
>>> <structure>
>>> <property name="position">5</property>
>>> <property name="name">STATUS</property>
>>> <property name="nativeName">STATUS</property>
>>> <property name="dataType">string</property>
>>> <property name="nativeDataType">12</property>
>>> </structure>
>>> <structure>
>>> <property name="position">6</property>
>>> <property name="name">COMMENTS</property>
>>> <property name="nativeName">COMMENTS</property>
>>> <property name="dataType">string</property>
>>> <property name="nativeDataType">12</property>
>>> </structure>
>>> <structure>
>>> <property name="position">7</property>
>>> <property name="name">CUSTOMERNUMBER</property>
>>> <property
>>> name="nativeName">CUSTOMERNUMBER</property>
>>> <property name="dataType">integer</property>
>>> <property name="nativeDataType">4</property>
>>> </structure>
>>> </list-property>
>>> <xml-property name="queryText"><![CDATA[select *
>>> from orders]]></xml-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>ORDERNUMBER</design:name>
>>> <design:position>1</design:position>
>>> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
>>> <design:precision>10</design:precision>
>>> <design:scale>0</design:scale>
>>> <design:nullability>Nullable</design:nullability>
>>> <design:uiHints>
>>> <design:displayName>ORDERNUMBER</design:displayName>
>>> </design:uiHints>
>>> </design:attributes>
>>> <design:usageHints>
>>> <design:label>ORDERNUMBER</design:label>
>>> <design:formattingHints>
>>> <design:displaySize>11</design:displaySize>
>>> </design:formattingHints>
>>> </design:usageHints>
>>> </design:resultColumnDefinitions>
>>> <design:resultColumnDefinitions>
>>> <design:attributes>
>>> <design:name>ORDERDATE</design:name>
>>> <design:position>2</design:position>
>>> <design:nativeDataTypeCode>91</design:nativeDataTypeCode>
>>> <design:precision>10</design:precision>
>>> <design:scale>0</design:scale>
>>> <design:nullability>Nullable</design:nullability>
>>> <design:uiHints>
>>> <design:displayName>ORDERDATE</design:displayName>
>>> </design:uiHints>
>>> </design:attributes>
>>> <design:usageHints>
>>> <design:label>ORDERDATE</design:label>
>>> <design:formattingHints>
>>> <design:displaySize>10</design:displaySize>
>>> </design:formattingHints>
>>> </design:usageHints>
>>> </design:resultColumnDefinitions>
>>> <design:resultColumnDefinitions>
>>> <design:attributes>
>>> <design:name>REQUIREDDATE</design:name>
>>> <design:position>3</design:position>
>>> <design:nativeDataTypeCode>91</design:nativeDataTypeCode>
>>> <design:precision>10</design:precision>
>>> <design:scale>0</design:scale>
>>> <design:nullability>Nullable</design:nullability>
>>> <design:uiHints>
>>> <design:displayName>REQUIREDDATE</design:displayName>
>>> </design:uiHints>
>>> </design:attributes>
>>> <design:usageHints>
>>> <design:label>REQUIREDDATE</design:label>
>>> <design:formattingHints>
>>> <design:displaySize>10</design:displaySize>
>>> </design:formattingHints>
>>> </design:usageHints>
>>> </design:resultColumnDefinitions>
>>> <design:resultColumnDefinitions>
>>> <design:attributes>
>>> <design:name>SHIPPEDDATE</design:name>
>>> <design:position>4</design:position>
>>> <design:nativeDataTypeCode>91</design:nativeDataTypeCode>
>>> <design:precision>10</design:precision>
>>> <design:scale>0</design:scale>
>>> <design:nullability>Nullable</design:nullability>
>>> <design:uiHints>
>>> <design:displayName>SHIPPEDDATE</design:displayName>
>>> </design:uiHints>
>>> </design:attributes>
>>> <design:usageHints>
>>> <design:label>SHIPPEDDATE</design:label>
>>> <design:formattingHints>
>>> <design:displaySize>10</design:displaySize>
>>> </design:formattingHints>
>>> </design:usageHints>
>>> </design:resultColumnDefinitions>
>>> <design:resultColumnDefinitions>
>>> <design:attributes>
>>> <design:name>STATUS</design:name>
>>> <design:position>5</design:position>
>>> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>>> <design:precision>15</design:precision>
>>> <design:scale>0</design:scale>
>>> <design:nullability>N

Report message to a moderator

Re: Hide Header Row on PDF Output [message #485957 is a reply to message #485953]

Tue, 15 September 2009 16:53

Jason Weathersby

Messages: 9167
Registered: July 2009

Senior Member

Raishad,

How are you running it? If you are using a runandrender task it will
only fire once. If you use the viewer and and export to pdf it will
work. If you want to use the api you use a run task to create a report
document and then do a render task on the report document and it should
work.

Jason

Raishad Maharaj wrote:
> Jason,
>
> That seems to work for the html output, but it seems when I output to
> PDF - that script is only being run once for the first page. It doesn't
> seem to be firing for each page.
> Is there any way to change that?
>
> Thanks for all your help so far,
> Raishad
>
> Jason Weathersby wrote:
>> Raishad,
>>
>> Take a look at the onrender script for the image on the header on the
>> master page in the attached example.
>>
>> 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 <2.3.2.v20090218-0730></property>
>> <property name="units">in</property>
>> <property name="iconFile">/templates/blank_report.gif</property>
>> <property name="bidiLayoutOrientation">ltr</property>
>> <data-sources>
>> <oda-data-source
>> extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source"
>> id="7">
>> <property
>> name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver </property>
>>
>> <property
>> name="odaURL">jdbc:classicmodels:sampledb</property>
>> <property name="odaUser">ClassicModels</property>
>> <property name="OdaConnProfileName"></property>
>> </oda-data-source>
>> </data-sources>
>> <data-sets>
>> <oda-data-set
>> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
>> name="Data Set" id="8">
>> <list-property name="columnHints">
>> <structure>
>> <property name="columnName">ORDERNUMBER</property>
>> <property name="displayName">ORDERNUMBER</property>
>> </structure>
>> <structure>
>> <property name="columnName">PRODUCTCODE</property>
>> <property name="displayName">PRODUCTCODE</property>
>> </structure>
>> <structure>
>> <property
>> name="columnName">QUANTITYORDERED</property>
>> <property
>> name="displayName">QUANTITYORDERED</property>
>> </structure>
>> <structure>
>> <property name="columnName">PRICEEACH</property>
>> <property name="displayName">PRICEEACH</property>
>> </structure>
>> <structure>
>> <property
>> name="columnName">ORDERLINENUMBER</property>
>> <property
>> name="displayName">ORDERLINENUMBER</property>
>> </structure>
>> </list-property>
>> <structure name="cachedMetaData">
>> <list-property name="resultSet">
>> <structure>
>> <property name="position">1</property>
>> <property name="name">ORDERNUMBER</property>
>> <property name="dataType">integer</property>
>> </structure>
>> <structure>
>> <property name="position">2</property>
>> <property name="name">PRODUCTCODE</property>
>> <property name="dataType">string</property>
>> </structure>
>> <structure>
>> <property name="position">3</property>
>> <property name="name">QUANTITYORDERED</property>
>> <property name="dataType">integer</property>
>> </structure>
>> <structure>
>> <property name="position">4</property>
>> <property name="name">PRICEEACH</property>
>> <property name="dataType">float</property>
>> </structure>
>> <structure>
>> <property name="position">5</property>
>> <property name="name">ORDERLINENUMBER</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">ORDERNUMBER</property>
>> <property name="nativeName">ORDERNUMBER</property>
>> <property name="dataType">integer</property>
>> <property name="nativeDataType">4</property>
>> </structure>
>> <structure>
>> <property name="position">2</property>
>> <property name="name">PRODUCTCODE</property>
>> <property name="nativeName">PRODUCTCODE</property>
>> <property name="dataType">string</property>
>> <property name="nativeDataType">12</property>
>> </structure>
>> <structure>
>> <property name="position">3</property>
>> <property name="name">QUANTITYORDERED</property>
>> <property
>> name="nativeName">QUANTITYORDERED</property>
>> <property name="dataType">integer</property>
>> <property name="nativeDataType">4</property>
>> </structure>
>> <structure>
>> <property name="position">4</property>
>> <property name="name">PRICEEACH</property>
>> <property name="nativeName">PRICEEACH</property>
>> <property name="dataType">float</property>
>> <property name="nativeDataType">8</property>
>> </structure>
>> <structure>
>> <property name="position">5</property>
>> <property name="name">ORDERLINENUMBER</property>
>> <property
>> name="nativeName">ORDERLINENUMBER</property>
>> <property name="dataType">integer</property>
>> <property name="nativeDataType">5</property>
>> </structure>
>> </list-property>
>> <property name="queryText">select *
>> from orderdetails</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>ORDERNUMBER</design:name>
>> <design:position>1</design:position>
>> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
>> <design:precision>10</design:precision>
>> <design:scale>0</design:scale>
>> <design:nullability>Nullable</design:nullability>
>> <design:uiHints>
>> <design:displayName>ORDERNUMBER</design:displayName>
>> </design:uiHints>
>> </design:attributes>
>> <design:usageHints>
>> <design:label>ORDERNUMBER</design:label>
>> <design:formattingHints>
>> <design:displaySize>11</design:displaySize>
>> </design:formattingHints>
>> </design:usageHints>
>> </design:resultColumnDefinitions>
>> <design:resultColumnDefinitions>
>> <design:attributes>
>> <design:name>PRODUCTCODE</design:name>
>> <design:position>2</design:position>
>> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>> <design:precision>15</design:precision>
>> <design:scale>0</design:scale>
>> <design:nullability>Nullable</design:nullability>
>> <design:uiHints>
>> <design:displayName>PRODUCTCODE</design:displayName>
>> </design:uiHints>
>> </design:attributes>
>> <design:usageHints>
>> <design:label>PRODUCTCODE</design:label>
>> <design:formattingHints>
>> <design:displaySize>15</design:displaySize>
>> </design:formattingHints>
>> </design:usageHints>
>> </design:resultColumnDefinitions>
>> <design:resultColumnDefinitions>
>> <design:attributes>
>> <design:name>QUANTITYORDERED</design:name>
>> <design:position>3</design:position>
>> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
>> <design:precision>10</design:precision>
>> <design:scale>0</design:scale>
>> <design:nullability>Nullable</design:nullability>
>> <design:uiHints>
>> <design:displayName>QUANTITYORDERED</design:displayName>
>> </design:uiHints>
>> </design:attributes>
>> <design:usageHints>
>> <design:label>QUANTITYORDERED</design:label>
>> <design:formattingHints>
>> <design:displaySize>11</design:displaySize>
>> </design:formattingHints>
>> </design:usageHints>
>> </design:resultColumnDefinitions>
>> <design:resultColumnDefinitions>
>> <design:attributes>
>> <design:name>PRICEEACH</design:name>
>> <design:position>4</design:position>
>> <design:nativeDataTypeCode>8</design:nativeDataTypeCode>
>> <design:precision>15</design:precision>
>> <design:scale>0</design:scale>
>> <design:nullability>Nullable</design:nullability>
>> <design:uiHints>
>> <design:displayName>PRICEEACH</design:displayName>
>> </design:uiHints>
>> </design:attributes>
>> <design:usageHints>
>> <design:label>PRICEEACH</design:label>
>> <design:formattingHints>
>> <design:displaySize>22</design:displaySize>
>> </design:formattingHints>
>> </design:usageHints>
>> </design:resultColumnDefinitions>
>> <design:resultColumnDefinitions>
>> <design:attributes>
>> <design:name>ORDERLINENUMBER</design:name>
>> <design:position>5</design:position>
>> <design:nativeDataTypeCode>5</design:nativeDataTypeCode>
>> <design:precision>5</design:precision>
>> <design:scale>0</design:scale>
>> <design:nullability>Nullable</design:nullability>
>> <design:uiHints>
>> <design:displayName>ORDERLINENUMBER</design:displayName>
>> </design:uiHints>
>> </design:attributes>
>> <design:usageHints>
>> <design:label>ORDERLINENUMBER</design:label>
>> <design:formattingHints>
>> <design:displaySize>6</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="report" id="4">
>> <property name="fontFamily">"Verdana"</property>
>> <property name="fontSize">10pt</property>
>> </style>
>> <style name="crosstab" id="5">
>> <property name="borderBottomColor">#CCCCCC</property>
>> <property name="borderBottomStyle">solid</property>
>> <property name="borderBottomWidth">1pt</property>
>> <property name="borderLeftColor">#CCCCCC</property>
>> <property name="borderLeftStyle">solid</property>
>> <property name="borderLeftWidth">1pt</property>
>> <property name="borderRightColor">#CCCCCC</property>
>> <property name="borderRightStyle">solid</property>
>> <property name="borderRightWidth">1pt</property>
>> <property name="borderTopColor">#CCCCCC</property>
>> <property name="borderTopStyle">solid</property>
>> <property name="borderTopWidth">1pt</property>
>> </style>
>> <style name="crosstab-cell" 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">
>> <property name="topMargin">0.25in</property>
>> <property name="leftMargin">0.25in</property>
>> <property name="bottomMargin">0.25in</property>
>> <property name="rightMargin">0.25in</property>
>> <page-header>
>> <grid id="44">
>> <property name="width">100%</property>
>> <column id="45"/>
>> <row id="48">
>> <cell id="49">
>> <image id="61">
>> <property name="height">95px</property>
>> <property name="width">325px</property>
>> <method
>> name="onRender"><![CDATA[if(pageNumber>1){
>> this.getStyle().display ="none"
>> }
>> ]]></method>
>> <property name="source">embed</property>
>> <property
>> name="imageName">eclipsecon08_logo.jpg</property>
>> </image>
>> </cell>
>> </row>
>> <row id="52">
>> <cell id="53">
>> <label id="60">
>> <property
>> name="textAlign">center</property>
>> <text-property name="text">Report
>> header</text-property>
>> </label>
>> </cell>
>> </row>
>> <row id="56">
>> <cell id="57"/>
>> </row>
>> </grid>
>> </page-header>
>> </simple-master-page>
>> </page-setup>
>> <body>
>> <table id="9">
>> <property name="width">100%</property>
>> <property name="dataSet">Data Set</property>
>> <list-property name="boundDataColumns">
>> <structure>
>> <property name="name">ORDERNUMBER</property>
>> <property name="displayName">ORDERNUMBER</property>
>> <expression
>> name="expression">dataSetRow["ORDERNUMBER"]</expression >
>> <property name="dataType">integer</property>
>> </structure>
>> <structure>
>> <property name="name">PRODUCTCODE</property>
>> <property name="displayName">PRODUCTCODE</property>
>> <expression
>> name="expression">dataSetRow["PRODUCTCODE"]</expression >
>> <property name="dataType">string</property>
>> </structure>
>> <structure>
>> <property name="name">QUANTITYORDERED</property>
>> <property
>> name="displayName">QUANTITYORDERED</property>
>> <expression
>> name="expression">dataSetRow["QUANTITYORDERED"]</expression >
>> <property name="dataType">integer</property>
>> </structure>
>> <structure>
>> <property name="name">PRICEEACH</property>
>> <property name="displayName">PRICEEACH</property>
>> <expression
>> name="expression">dataSetRow["PRICEEACH"]</expression>
>> <property name="dataType">float</property>
>> </structure>
>> <structure>
>> <property name="name">ORDERLINENUMBER</property>
>> <property
>> name="displayName">ORDERLINENUMBER</property>
>> <expression
>> name="expression">dataSetRow["ORDERLINENUMBER"]</expression >
>> <property name="dataType">integer</property>
>> </structure>
>> </list-property>
>> <property name="pageBreakInterval">30</property>
>> <column id="38"/>
>> <column id="39"/>
>> <column id="40"/>
>> <column id="41"/>
>> <column id="42"/>
>> <header>
>> <row id="10">
>> <cell id="11">
>> <label id="12">
>> <text-property
>> name="text">ORDERNUMBER</text-property>
>> </label>
>> </cell>
>> <cell id="13">
>> <label id="14">
>> <text-property
>> name="text">PRODUCTCODE</text-property>
>> </label>
>> </cell>
>> <cell id="15">
>> <label id="16">
>> <text-property
>> name="text">QUANTITYORDERED</text-property>
>> </label>
>> </cell>
>> <cell id="17">
>> <label id="18">
>> <text-property
>> name="text">PRICEEACH</text-property>
>> </label>
>> </cell>
>> <cell id="19">
>> <label id="20">
>> <text-property
>> name="text">ORDERLINENUMBER</text-property>
>> </label>
>> </cell>
>> </row>
>> </header>
>> <detail>
>> <row id="21">
>> <cell id="22">
>> <data id="23">
>> <property
>> name="resultSetColumn">ORDERNUMBER</property>
>> </data>
>> </cell>
>> <cell id="24">
>> <data id="25">
>> <property
>> name="resultSetColumn">PRODUCTCODE</property>
>> </data>
>> </cell>
>> <cell id="26">
>> <data id="27">
>> <property
>> name="resultSetColumn">QUANTITYORDERED</property>
>> </data>
>> </cell>
>> <cell id="28">
>> <data id="29">
>> <property
>> name="resultSetColumn">PRICEEACH</property>
>> </data>
>> </cell>
>> <cell id="30">
>> <data id="31">
>> <property
>> name="resultSetColumn">ORDERLINENUMBER</property>
>> </data>
>> </cell>
>> </row>
>> </detail>
>> <footer>
>> <row id="32">
>> <cell id="33"/>
>> <cell id="34"/>
>> <cell id="35"/>
>> <cell id="36"/>
>> <cell id="37"/>
>> </row>
>> </footer>
>> </table>
>> </body>
>> <list-property name="images">
>> <structure>
>> <property name="name">eclipsecon08_logo.jpg</property>
>> <property name="data">
>>
>> /9j/4AAQSkZJRgABAgAAZABkAAD/7AARRHVja3kAAQAEAAAAPAAA/+4ADkFk b2JlAGTAAAAAAf/bAIQA
>>
>>
>> BgQEBAUEBgUFBgkGBQYJCwgGBggLDAoKCwoKDBAMDAwMDAwQDA4PEA8ODBMT FBQTExwbGxscHx8fHx8f
>>
>>
>> Hx8fHwEHBwcNDA0YEBAYGhURFRofHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8f Hx8fHx8fHx8fHx8fHx8f
>>
>>
>> Hx8fHx8fHx8f/8AAEQgAXwFFAwERAAIRAQMRAf/EAKAAAQACAwEBAAAAAAAA AAAAAAABAwQFBgIHAQEB
>>
>>
>> AQEBAQEAAAAAAAAAAAAAAQIDBAUGEAABAgUBBAkABwYEBgMAAAABAgMAETEE BSFBwRIG8FFhgdEiMhMH
>>
>>
>> cZFCk9MUJKFSciMVCLGSotLhYoI0FhczsyYRAQACAgIAAwcEAQUAAAAAAAAB EQISIQMxQQTwUWHxIjIT
>>
>>
>> cYGhQiNSYnJDFP/aAAwDAQACEQMRAD8A+YFutenXH6igLda9OuFAW616dcKA t1r064UBbrXp1woC2Na9
>>
>>
>> ++FAWxrXp1woC3WvTrhQFutenXCgLda9OuFAW616dcKAt1r064UBbrXp1woC 3WvTrhQFutenXCgLda9O
>>
>>
>> uFAW616dcKAt1r064UBbrXp1woC3WvTrhQFutenXCgLda9OuFAW616dcKAt1 r064UBbrXp1woC3WvTrh
>>
>>
>> QFutenXCgLda9OuFAW616dcKAt1r064UBbrXp1woC3WvTrhQFutenXCgLda9 OuFAW616dcKAt1r064UB
>>
>>
>> brXp1woC3WvTrhQFutenXCgLda9OuFCfbE9u+FCwitY66gRWsNQIrWGoKFaw 1Cs5TiULE261T0MQSu2W
>>
>>
>> J6GIKiCCZzjUQBFaxdQIrWGoEVrDUCK1hqBFaw1AitYagRWsNQIrWGoEVrDU CK1hqBFaw1AitYagRWsN
>>
>>
>> QIrWGoEVrDUCK1hqBFaw1AitYagRWsNQIrWGoEVrDUCK1hqBFaw1AitYagRW sNQIrWGoEVrDUCK1hqBF
>>
>>
>> aw1AitYagRWsNQIrWGomWu2GosKK1jpQKSNa98KAprWFApNaxKF9ra8a9AdY 5ZI63EctquUiSSTHmy7K
>>
>>
>> Gdd8kvJSVLHto2qI1+qMx3wsQ5TK462typLYKyPtEwn1E+STLnLoKEyFEfQT HLLvz97nOUsQ3Nwk6LPf
>>
>>
>> rGY7848yMpXM5MTk8P8AqG8R6ev1f+puMmwHAtPEk8STQx7o55hpJRWsWgKK 1hQFFawoCitYUBRWsKAo
>>
>>
>> rWFAUVrCgKK1hQFFawoCitYUBRWsKAorWFAUVrCgKK1hQFFawoCitYUBRWsK AorWFAUVrCgKK1hQFFaw
>>
>>
>> oCitYUBRWsKAorWFAUVrCgKK1hQFFawoCitYUJ4Ndu+FC8pGuhiWIUkSOh74 WPKmgJ8MxEEKmBqImw2W
>>
>>
>> KU37on+2OOco+zfH6bBAS8+Bw/Zn19cfN9RaxDM51v7B1JSyRIDWW0xw67Jl 8bzqkFapR6IYlyV2RrEl
>>
>>
>> iWRc8oZxrlBrm5bbYwj1wbRt33B7nugqTIt1lNJ1jnvF15lNPjcZkMtkGMdj WFXV9dK4Le3RLiWqRMhM
>>
>>
>> gUEamaWGQpvI4LLv4nKsqtrlhYbubZyXE2sgHWRIoY7+n9Rr/wAZbxbgpEts fUtpJSNdDFsCka6GFgUj
>>
>>
>> XQwsCka6GFgUjXQwsCka6GFgUjXQwsCka6GFiCBrWFgUjXQwsCka1hYFI1rC xJSNdDCwKRroYWIKRrWF
>>
>>
>> gUjWsLElI10MLEFI1rCwKRrWFgUjWsLApGtYWBSNawsCka1hYFI1rCwKRrWF iSka6GFgUjXQwsOEToYW
>>
>>
>> LWrd9/i9ltS+GXFLZPrjlszOUR4rDjb/AF/kOfVDZPyR7xWOv9f5Dn1Q2PyR 70OY+9CSSyuXaIbG8e92
>>
>>
>> 9l8b47F2Vrec48wN8vOXqQ5bY/2lXFyUGinG0+ifb366R4M/U3MxhjtSzMN/ nrNWCwNtmsPkG8zy/cqD
>>
>>
>> Dd8wOEtroEuJmZTlL6ax547NpqYrJqcopy/57LZR9m1tWHH7i5UG2WkiZUpW gEa1qLljeG4y3xty1jVo
>>
>>
>> teaedLTFZZxIUbJtv3vb4qBxUxL6SBHKO3KftxuCafO+e+TbzlvKsWTV4xmL a8YF1Z31nq2tpS1I11IC
>>
>>
>> poNCY1hlOXkxlw6nP210n+2LHNFpQdGdJKJay9x2OWs/l/Zq/pcHyHguYb3m zD2uOfdxV7cXCW7fJoTM
>>
>>
>> sKUkjjAmNmkdc4rGZmEiYYnO+B5hs+ec1ZZC6dy99bXJbuMipMlPqSkeciZ2 aRnGJnGKhq4fQeRvi3N8
>>
>>
>> xcl/11N2xZpYuVWr6LtXtJQ23Kby3DpwgKGlY9OHrdKxyibatvrT4mwOZaft +WecLPLZphBWrHhHthfD
>>
>>
>> XgcKjPXbwy641PrssZ+rGoLt83eadaedYdQpDzSi262oSUlaTwqSodYIj249 kSm0O8/9a4fF2Nq/zjzK
>>
>>
>> xy/cX7YetrEtLuHwg7XEII4Y8k+smZnTHalmWj5u5Vx2GtLPIY3O2ubx18tb bb1sSlaFtgKKXEEnhmFa
>>
>>
>> ax06fU7TMTGsps1WDwuSzuVYxWMaU/eXJk2igAGqlKOxKRqTHbPuxxi5W3aO fH3IjFycbec82zOXSr23
>>
>>
>> Gk2zjlulycuEvzSga6Ex5P8A15+MYcFuV5u5XynK+ZdxWSA91KQ408g8TbrS vS4gmUwZR6envjsi4LY+
>>
>>
>> Fw1xl7ssNK9ttA4nnVahI+jaTsjWfZTeGO0s5605JadLC8hdLWnRTqEgtz/y EnujG+Tcxh72oubdpWRV
>>
>>
>> a49xV0hakoYXKRXxSqDLaY6Rnxy5zHNQ3d1g+XsXwNZi/dN0tIUpm2APCD1k hW6OX5cp8HScMY8ZY2W5
>>
>>
>> faZxwymNuTeWB0WSJLRrLzd/YI1j281KZYcXHg9ctcutZpq6Up9TKmSkJAAI PEDX6oZ9tHXhs1qLFwZl
>>
>>
>> vGXM23FPoYc2y4lBMx16GYjX5OLZ15pn32Kxtlf5G0ecdWbNtLragpKePiCP LIg6/wAz9kZjsmYanGIm
>>
>>
>> YeMvi8faWinre7L7nuobDcxMJKVT4pbeNB7pdcXHsmZTLGIhqVK0NY6Ww3IZ 5PbCU3F7dOOEDjUyhKUJ
>>
>>
>> JGoPECTLsjlOeTpWPvV8xYMYsMXDL35iyuk8TLhEjQHX6QdIuHZaZ4UvYwuN t8W3kszcOtNXJlbsMgFx
>>
>>
>> Q/ePECO2JPbN1CxhERcqM5hmrO1YyFm8q5x11o24oSUlWvlV9Ri4dl8SmeFc x4L2MLjbfFt5LM3DrTVy
>>
>>
>> ZW7DIBcUP3jxAjtiT2zdQsYREXKjN4VqztWMhZPKuMddaNuKElJVr5VfUYuH ZfEpnhXMeC6xwtgMOcvl
>>
>>
>> X3WrRauBptkArUQSJzMxUGJl2zdQuOEVcoy+EsWsS1lsbcLes3FcCkOgBaTM jWQG0SpDDsm6kywirhpS
>>
>>
>> qYNY6xLmlRrWFiZ67d8LFlgEue7Nn3pcPqdDUq9Z1jFsZyzCwkz/AEae+6T4 wti/j/Cp5tYPlsky6vf4
>>
>>
>> j9YXCy/j/DP5XYZf5pw9veWyEW717bpdBdqguAGYKjHLumYwmvc1E/F9C+TX vitfyLkG+YbXOOZZPtBx
>>
>>
>> bDjAt+H2klHthR4+GX7Y+d0R2aRrVLcW0fM/Ofx/YfHOY5W5fscnx5VaHmje Ka9tDyFIM+IKBTojYIs9
>>
>>
>> ee0ZZUuWXCv+3hLb3yDZm4t0pW1a3C2VF4LPHwgaIn+6TE9T9jGE8vmOYTd5 LmjMXN+x7l25e3BuCu4C
>>
>>
>> VcYdUCDM7JSjpjHEcMzKpOIShQlZp4U0T+bTIT1010jWvw/lm303mFkD+2bH I/LhIGcP8r3gR/8AI7rx
>>
>>
>> zjzV/l/Z0/q5b4ktkj5G5YV+USki+bPuC5CiNFa8E9Y69sfRPCYzywvlRhK/ lnmsm1S5+vXqbgIn5U7J
>>
>>
>> 6Rz64+mOP5bmeXeYVHt/22ZBIbDAOc1Slz3hVraP8InVH+X9jLwaX4sXdN/I XL67aZc/ONpUUmR9tflc
>>
>>
>> nLZwEx7e/GPxz+iYw8/KBaT8kcxBgzSLxRkNAFkAr1/jnF9LP0R+h5uyyvNX xRz0i0uOaHbzAZ+3YTbu
>>
>>
>> 3TCS7brCKHRLmkyTqAR1mPNHX2dfGPOKzUuY58+Ohy5j7LOYzJt5jl3JK4LW +bEiFyJCVgaahJkR1EGU
>>
>>
>> d+nv2mpisoSnQ/AabQ5PmN98OFbOJdKfYID4QpQ4y1P7eg4Ts74x66ZrH9Wo aQ3HwcU6W3MOo1/mWu3r
>>
>>
>> mIsfm/2sxSv5M50wHMacI3h2bppvE2n5NS7zgLi0p4fbmpBM9AZxfT9eWEzf mWxuVXFf+LZ1bE/zIQun
>>
>>
>> qkGjLfHfPxh6uv7ZcWhYM6x0hxdByUppXM9oF/8AOUA/vBtUoz2eDfV9zD5s ccPMeQ92fEHZCf7oA4f9
>>
>>
>> MoYeCdn3S3/KKuLlbOh7/tkoWQT+97R4u/RMYz8YdOv7ZU8m3r1vy9nbplXC 6whK0E7ClKiIZ+J1zUS2
>>
>>
>> q2GOYTieYbBMrhm4YRfMioCXE8U/4K/wxmJrhutqyhzPO6//ANVfjq9r/wCl EdOvwce37pafirWOrm9l
>>
>>
>> wSNYtjZ4fBKyCV3d07+UxbJ/n3S9Jy+ymdTHPLKnTHC+fI5q5kZyS2bazQWs dZJ4LdJ0KtAJnq0GkZxi
>>
>>
>> jszvw8G1+RFBNth0on7Hsq9uVKI3SjOHm33eQlY/9ZPKcql4ezPr95M5f6oT 9x/Q+RFBNthktz9j2Ve3
>>
>>
>> KlEbpQwk7vIQsH4zdU5VLw9mfX7yZy/1Q/sf9a7C3rGO5UC8+Pexl45w2ltw 8TkiTxKnMSGkxt+uJl48
>>
>>
>> LjNY8+Ceardp7lm1uMK8hWFtSONhAPFxEy4lEmZIKtQeucXCeTsj6ePBx6Xd DWO8S4JLtaxbRPu67d8L
>>
>>
>> VjMXyWuPiZS9OUvc4tJfwlMZtJi1pyrWv6Nn6nP2+eFpr8Q5VrX9Gz9Tn7fP CzX4q15OTvuNsIbWkgpK
>>
>>
>> eMSI1B9UQ1+L6i58l/G/NqbO656xt1acw2iEtf1bGgFLyRT3ET0+iR7DLSPB +HPCfo+34rTC5+zvxl/4
>>
>>
>> vc2PLmIub3IOlATkr8ABpIUFK4Egg+YCWgEZ17LvKv0XKJmHzzlnm2+5dzFn msZbW7V9ZL42yQuSgRwr
>>
>>
>> QrzelSSQYZRExVOMRTvsjzb/AG88x5FzPZzFZXE5i6PuZG1tAHGHXZeZSVJM pq2mSZxxxjPHiKlqalw/
>>
>>
>> OvNPJuSytujlPADG4i0YDCU3M1PPL41KLzhSs6kKA1UaR067jx5SYbLMfIWE f+GrPktFosZZjJG9X5P0
>>
>>
>> vtlS1aK4+Pi8/VGdfr2XyaTkPmbH4Dm3DZq9s0flcfcofeLCVKd4Ugz4ApYB Osa7JvGYWIa/njmrHZ7n
>>
>>
>> zPZyztE/k8jdKfYFwkpd4SAPOErIB06443URFQ1T7V8X3vLY/t7vHOYbBxzF LzakuNWKi24kq9rhcTxK
>>
>>
>> 1IrKesTCMt4mOJpMvBFjzr8U8oBzJco4+/yHMJQpFrcZOQaY4wQVSB1MjsHe I9U4dmfGUxGPwTZ8susi
>>
>>
>> 89eO3dyo3D7zpefWv7a1K4lTl1mPZhFQRD6LcZH4Jy8rt20y2BulHiftLThe Znt4ComX1D6I8v8Amx44
>>
>>
>> klrue+fMRkcDjuVuW7R6x5cxa1PIVcqCrh95XF53JTCR51aT2xerqmMpyy+6 UloOS+dsjylzCzmLFIWp
>>
>>
>> sFt9hcwl1pfqQqX0TB2GPR29cZ41LdO0vch8DZi4VknmMziH3j7lxj7QNLZ4 zqfbKuKQJ+j6BHlxjux4
>>
>>
>> 4lnhyHOmU5Uu7q3Tyxjnsdj7Zn21G4WFvPucRUXXJEyMjKU49HVtH3Tcltdy 5zQ/g75boQXrZ4BNwyTK
>>
>>
>> YFCD1iOmUW7YZ6tk/c/HLzhuQL5ji8yrVsJCZnZrxS7lRmJlqdGku8qw1lze 4htdqy0pCrZCzxKBQkAl
>>
>>
>> WpnxEExry5Ymebhv73mDk7OFNzlmbqyvkpCXV23CUrlSoV/h3xiLh0nLHLxY ua5tsP6R/RMHbuMWRM33
>>
>>
>> nZe45rM0JrKs+zSLEc3KZZxVQxsJzDaWGEy9i8h1T1+gJZUkJKQeFQ85Kgdu wRZjlMcqiYOUOalYG+Wp
>>
>>
>> 5Ljli8JPNJkVAj0qSCQJ7K0iZY2deessbmTMMZTO3V/bpcQy97fClwAKHC2l BmAVCqeuNYcM5zc2wS8d
>>
>>
>> a7I6Wyhbxka9OuJY7O95u5JvLG2srqyvfYtQAhpvhQmcpTMnRPvjjUu854zF Oezt5yy621/Rba5YWCff
>>
>>
>> L5BBGnDLzr7Y1jfm55Tj5NixzHhcjhWMXnkvtrsv+1vGAFHhpwqB7NKRJip4 ajKJipY3MfMtndY+3w2K
>>
>>
>> acaxloeLjdl7ji9dVS/iJhEJnnxUeDJt+Y8LkcKxi88l9tdlpa3jACjwU4VA 9mlIVU8LGUTFSxuYuZbO
>>
>>
>> 5x9vh8U041jLQ8XG7L3HF66ql/ETCITPO4qPBl2/MmByGBZxGdbfaNpL8vdW 4BMgJDiB+qmsSY5WMomK
>>
>>
>> lVkeZMTbYFWDwaHiw8v3Lq6uJBSjMUA/hEWI5Jyiqhz4eIBrHWJckl4616dc WxPvGe3fCxhl2tenXHOw
>>
>>
>> Lta9OuFieMqJlM9NsLEqUgE8SiewbzFse0uJOkpCDeLu+VXcdkrFVjcpH5lC Skg1W31jtTHPLF11cbzL
>>
>>
>> hH8TfLbUP5SjNC9hBoY82UU8ueFS0ighVRGWHiSRQRVQpIOpjE5LEPDi0hMt kcssm6a8tm5uAw1pPVxY
>>
>>
>> +ynafCMYYTnlSvpWN54urTkJ/ktFu0Mc7dpvfzB4vdStKUJCRrw8P8sbI+jP TG0ZR5RTGTnXbg8SpEyj
>>
>>
>> tCxCtTtaxbVPvkT1MQpKric58UEpBdRrMK+v/hFtXv8AMNiei/8AMPCIlJVc Mmc0r/zD/bFKQXrXWbbn
>>
>>
>> +cf7YWchdstZtO/eJ/2RDl696w1m0996n8OLZykvY3WbL/3qfw4HKfexYnNh /wC+R+FC05SbjFazt7j7
>>
>>
>> 9H4ULOUm4xGs7e4+/R+DCysvb5n5jDif6a5+/R+DCysvb5pNziNf01z9+j8G FlZe3zDc4jX9Nc9v89H4
>>
>>
>> MLKy9vmgv4fX9Nc/fo/BhZWXt8z38Pr+mufv0fgwsrL2+YX8Pr+mufv0fgws rL2+Z7+H1/TXP36PwYWV
>>
>>
>> l7fML+H1/TXP36PwYWVl7fM9/D6/prn79H4MLKy9vmF/D6/prn79H4MLKy9v m8PPY0tqDLD6HNJKW6la
>>
>>
>> a7UhtH+MLItQXBrXp1wtoLta9OuFh7vm274WMcqrXv3xgOIAk6n6d8LEqcJn qZdXjCxBVWvfvhYsbUSq
>>
>>
>> QnONNRLZWl4u2cStlZS6gghwVBg7Y5OvbzmJzln+TzKQ059m4A0n1/8AL/hG MsbaywtyWa5Ru7JanLVQ
>>
>>
>> u7WqVtmZl9EcMsMoeXLrpz65oJSoFJFQdDHnnJKUOPpG2Oc5Kq/LXtx6U+03 tcWJfUKmNYdGWfwhqmdb
>>
>>
>> 2rFq2UNAzOq1mqj1mPodfXGEVCSuKpTr0640gVVr374AVVr374AVVr374AVV r374AVVr374AVVr374AV
>>
>>
>> Vr374AVVr374AVVr374AVVr374AVVr374AVVr374AVVr374AVVr374AVVr37 4AVVr374AVVr374AVVr3
>>
>>
>> 74AVVr374AVVr374AVVr374AVVr374AVVr374AVVr374AVVr374AVVr374AV Vr374Bxeb7W+Axi7Wuyu
>>
>>
>> +IgXa12V3wAu1rsrvgHuFRIHESZSHjAXKfDU0pJK/tK6uyLYlFzKdYttxLNT e8KAJmZ1MV0jNcjJOIB4
>>
>>
>> VqT9BlEb3VXF027P3Ehf8QnCeWZr3MVTrKJ8CAn6ABEjGI8mZlS7cTnWLbnM qlO1rs6GM2yF2tdld8AL
>>
>>
>> ta7K74AXa12V3wAu1rsrvgBdrXZXfAC7Wuyu+AF2tdld8ALta7K74AXa12V3 wAu1rsrvgBdrXZXfAC7W
>>
>>
>> uyu+AF2tdld8ALta7K74AXa12V3wAu1rsrvgBdrXZXfAC7Wuyu+AF2tdld8A Lta7K74AXa12V3wAu1rs
>>
>>
>> rvgBdrXZXfAC7Wuyu+AF2tdld8ALta7K74AXa12V3wAu1rsrvgHu+b7W+AxC 56q7K74yBc9Vdld8AKyZ
>>
>>
>> gcWzoYC0u+0FBJPuGqursi2Ki56q7K74lj0HDM1lpXfFiR7VcklR12dDF2W0 m5OtenXC1sVcnXU9++Fl
>>
>>
>> vC3zrXp1xLS3lTh81dld8SxBc9Vdld8EC56q7K74AXPVXZXfAC56q7K74AXP VXZXfAC56q7K74AXPVXZ
>>
>>
>> XfAC56q7K74AXPVXZXfAC56q7K74AXPVXZXfAC56q7K74AXPVXZXfAC56q7K 74AXPVXZXfAC56q7K74A
>>
>>
>> XPVXZXfAC56q7K74AXPVXZXfAC56q7K74AXPVXZXfAC56q7K74AXPVXZXfAC 56q7K74AXPVXZXfAC56q
>>
>>
>> 7K74AXPVXZXfAC56q7K74AXPVXZXfAT7nm+1vpBVRQ7rOXb5h4w1lAod1nLt 8w8YayJCHwTKu3UeMKkQ
>>
>>
>> UO6zl2+YeMNZAod1nLt8w8YayHA9rTt8w8YayBQ7rOXb5h4w1kCh3Wcu3zDx hrIFDus5dvmHjDWQKHdZ
>>
>>
>> y7fMPGGsgUO6zl2+YeMNZAod1nLt8w8YayBQ7rOXb5h4w1kCh3Wcu3zDxhrI FDus5dvmHjDWQKHdZy7f
>>
>>
>> MPGGsgUO6zl2+YeMNZAod1nLt8w8YayBQ7rOXb5h4w1kCh3Wcu3zDxhrIFDu s5dvmHjDWQKHdZy7fMPG
>>
>>
>> GsgUO6zl2+YeMNZAod1nLt8w8YayBQ7rOXb5h4w1kCh3Wcu3zDxhrIFDus5d vmHjDWQKHdZy7fMPGGsg
>>
>>
>> UO6zl2+YeMNZAod1nLt8w8YayBQ7rOXb5h4w1kCh3Wcu3zDxhrIFDus5dvmH jDWQKHdZy7fMPGGsgUO6
>>
>>
>> zl2+YeMNZAod1nLt8w8YayBQ7rOXb5h4w1kCh3Wcu3zDxhrIFDus5dvmHjDW QKHdZy7fMPGGshwPT7f4
>>
>> h4w1kf/Z
>> </property>
>> </structure>
>> </list-property>
>> </report>
>>
>> Raishad Maharaj wrote:
>>> Jason,
>>>
>>> Would this be possible with 2.3.1?
>>> I was trying to do something with the row.__rownum and the Visibility
>>> property for the header row, but it seems it is only evaluated once
>>> and not for every page.
>>>
>>>
>>> Jason Weathersby wrote:
>>>> Raishad,
>>>>
>>>> This possible with 2.5 using page variables.
>>>> See attached example.
>>>>
>>>> Jason
>>>>
>>>> <?xml version="1.0" encoding="UTF-8"?>
>>>> <report xmlns="http://www.eclipse.org/birt/2005/design"
>>>> version="3.2.20" id="1">
>>>> <property name="createdBy">Eclipse BIRT Designer Version
>>>> 2.5.0.v20090603 Build <2.5.0.v20090617-0630></property>
>>>> <property name="units">in</property>
>>>> <method name="onPageStart"><![CDATA[var first =
>>>> reportContext.getPageVariable("FIRST");
>>>> if( first == 1 ){
>>>> reportContext.setPageVariable("FIRST",2);
>>>> }]]></method>
>>>> <method name="onPageEnd"><![CDATA[var first =
>>>> reportContext.getPageVariable("FIRST");
>>>> if( first == 0 ){
>>>> reportContext.setPageVariable("FIRST",1);
>>>> }]]></method>
>>>> <property name="iconFile">/templates/blank_report.gif</property>
>>>> <property name="bidiLayoutOrientation">ltr</property>
>>>> <data-sources>
>>>> <oda-data-source
>>>> extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data
>>>> Source" id="7">
>>>> <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="8">
>>>> <list-property name="columnHints">
>>>> <structure>
>>>> <property name="columnName">ORDERNUMBER</property>
>>>> <property name="displayName">ORDERNUMBER</property>
>>>> </structure>
>>>> <structure>
>>>> <property name="columnName">ORDERDATE</property>
>>>> <property name="displayName">ORDERDATE</property>
>>>> </structure>
>>>> <structure>
>>>> <property name="columnName">REQUIREDDATE</property>
>>>> <property
>>>> name="displayName">REQUIREDDATE</property>
>>>> </structure>
>>>> <structure>
>>>> <property name="columnName">SHIPPEDDATE</property>
>>>> <property name="displayName">SHIPPEDDATE</property>
>>>> </structure>
>>>> <structure>
>>>> <property name="columnName">STATUS</property>
>>>> <property name="displayName">STATUS</property>
>>>> </structure>
>>>> <structure>
>>>> <property name="columnName">COMMENTS</property>
>>>> <property name="displayName">COMMENTS</property>
>>>> </structure>
>>>> <structure>
>>>> <property
>>>> name="columnName">CUSTOMERNUMBER</property>
>>>> <property
>>>> name="displayName">CUSTOMERNUMBER</property>
>>>> </structure>
>>>> </list-property>
>>>> <structure name="cachedMetaData">
>>>> <list-property name="resultSet">
>>>> <structure>
>>>> <property name="position">1</property>
>>>> <property name="name">ORDERNUMBER</property>
>>>> <property name="dataType">integer</property>
>>>> </structure>
>>>> <structure>
>>>> <property name="position">2</property>
>>>> <property name="name">ORDERDATE</property>
>>>> <property name="dataType">date</property>
>>>> </structure>
>>>> <structure>
>>>> <property name="position">3</property>
>>>> <property name="name">REQUIREDDATE</property>
>>>> <property name="dataType">date</property>
>>>> </structure>
>>>> <structure>
>>>> <property name="position">4</property>
>>>> <property name="name">SHIPPEDDATE</property>
>>>> <property name="dataType">date</property>
>>>> </structure>
>>>> <structure>
>>>> <property name="position">5</property>
>>>> <property name="name">STATUS</property>
>>>> <property name="dataType">string</property>
>>>> </structure>
>>>> <structure>
>>>> <property name="position">6</property>
>>>> <property name="name">COMMENTS</property>
>>>> <property name="dataType">string</property>
>>>> </structure>
>>>> <structure>
>>>> <property name="position">7</property>
>>>> <property name="name">CUSTOMERNUMBER</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">ORDERNUMBER</property>
>>>> <property name="nativeName">ORDERNUMBER</property>
>>>> <property name="dataType">integer</property>
>>>> <property name="nativeDataType">4</property>
>>>> </structure>
>>>> <structure>
>>>> <property name="position">2</property>
>>>> <property name="name">ORDERDATE</property>
>>>> <property name="nativeName">ORDERDATE</property>
>>>> <property name="dataType">date</property>
>>>> <property name="nativeDataType">91</property>
>>>> </structure>
>>>> <structure>
>>>> <property name="position">3</property>
>>>> <property name="name">REQUIREDDATE</property>
>>>> <property name="nativeName">REQUIREDDATE</property>
>>>> <property name="dataType">date</property>
>>>> <property name="nativeDataType">91</property>
>>>> </structure>
>>>> <structure>
>>>> <property name="position">4</property>
>>>> <property name="name">SHIPPEDDATE</property>
>>>> <property name="nativeName">SHIPPEDDATE</property>
>>>> <property name="dataType">date</property>
>>>> <property name="nativeDataType">91</property>
>>>> </structure>
>>>> <structure>
>>>> <property name="position">5</property>
>>>> <property name="name">STATUS</property>
>>>> <property name="nativeName">STATUS</property>
>>>> <property name="dataType">string</property>
>>>> <property name="nativeDataType">12</property>
>>>> </structure>
>>>> <structure>
>>>> <property name="position">6</property>
>>>> <property name="name">COMMENTS</property>
>>>> <property name="nativeName">COMMENTS</property>
>>>> <property name="dataType">string</property>
>>>> <property name="nativeDataType">12</property>
>>>> </structure>
>>>> <structure>
>>>> <property name="position">7</property>
>>>> <property name="name">CUSTOMERNUMBER</property>
>>>> <property
>>>> name="nativeName">CUSTOMERNUMBER</property>
>>>> <property name="dataType">integer</property>
>>>> <property name="nativeDataType">4</property>
>>>> </structure>
>>>> </list-property>
>>>> <xml-property name="queryText"><![CDATA[select *
>>>> from orders]]></xml-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>ORDERNUMBER</design:name>
>>>> <design:position>1</design:position>
>>>> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
>>>> <design:precision>10</design:precision>
>>>> <design:scale>0</design:scale>
>>>> <design:nullability>Nullable</design:nullability>
>>>> <design:uiHints>
>>>> <design:displayName>ORDERNUMBER</design:displayName>
>>>> </design:uiHints>
>>>> </design:attributes>
>>>> <design:usageHints>
>>>> <design:label>ORDERNUMBER</design:label>
>>>> <design:formattingHints>
>>>> <design:displaySize>11</design:displaySize>
>>>> </design:formattingHints>
>>>> </design:usageHints>
>>>> </design:resultColumnDefinitions>
>>>> <design:resultColumnDefinitions>
>>>> <design:attributes>
>>>> <design:name>ORDERDATE</design:name>
>>>> <design:position>2</design:position>
>>>> <design:nativeDataTypeCode>91</design:nativeD

Report message to a moderator

Re: Hide Header Row on PDF Output [message #486230 is a reply to message #485957]

Wed, 16 September 2009 19:57

Raishad

Messages: 77
Registered: July 2009

Member

Jason,

I am running the report from the viewer and exporting to PDF.
One thing that I didn't make clear was that I am wanting to modify the
Header Row on the table.

Because I just tried the script on a header item like you had in your
original example and exported to a pdf from the viewer and it worked!
So is there a way to make that script work to hide the header row on the
table, or maybe another method?

Thanks

Jason Weathersby wrote:
> Raishad,
>
> How are you running it? If you are using a runandrender task it will
> only fire once. If you use the viewer and and export to pdf it will
> work. If you want to use the api you use a run task to create a report
> document and then do a render task on the report document and it should
> work.
>
> Jason
>
> Raishad Maharaj wrote:
>> Jason,
>>
>> That seems to work for the html output, but it seems when I output to
>> PDF - that script is only being run once for the first page. It
>> doesn't seem to be firing for each page.
>> Is there any way to change that?
>>
>> Thanks for all your help so far,
>> Raishad
>>
>> Jason Weathersby wrote:
>>> Raishad,
>>>
>>> Take a look at the onrender script for the image on the header on the
>>> master page in the attached example.
>>>
>>> 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 <2.3.2.v20090218-0730></property>
>>> <property name="units">in</property>
>>> <property name="iconFile">/templates/blank_report.gif</property>
>>> <property name="bidiLayoutOrientation">ltr</property>
>>> <data-sources>
>>> <oda-data-source
>>> extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data
>>> Source" id="7">
>>> <property
>>> name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver </property>
>>>
>>> <property
>>> name="odaURL">jdbc:classicmodels:sampledb</property>
>>> <property name="odaUser">ClassicModels</property>
>>> <property name="OdaConnProfileName"></property>
>>> </oda-data-source>
>>> </data-sources>
>>> <data-sets>
>>> <oda-data-set
>>> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
>>> name="Data Set" id="8">
>>> <list-property name="columnHints">
>>> <structure>
>>> <property name="columnName">ORDERNUMBER</property>
>>> <property name="displayName">ORDERNUMBER</property>
>>> </structure>
>>> <structure>
>>> <property name="columnName">PRODUCTCODE</property>
>>> <property name="displayName">PRODUCTCODE</property>
>>> </structure>
>>> <structure>
>>> <property
>>> name="columnName">QUANTITYORDERED</property>
>>> <property
>>> name="displayName">QUANTITYORDERED</property>
>>> </structure>
>>> <structure>
>>> <property name="columnName">PRICEEACH</property>
>>> <property name="displayName">PRICEEACH</property>
>>> </structure>
>>> <structure>
>>> <property
>>> name="columnName">ORDERLINENUMBER</property>
>>> <property
>>> name="displayName">ORDERLINENUMBER</property>
>>> </structure>
>>> </list-property>
>>> <structure name="cachedMetaData">
>>> <list-property name="resultSet">
>>> <structure>
>>> <property name="position">1</property>
>>> <property name="name">ORDERNUMBER</property>
>>> <property name="dataType">integer</property>
>>> </structure>
>>> <structure>
>>> <property name="position">2</property>
>>> <property name="name">PRODUCTCODE</property>
>>> <property name="dataType">string</property>
>>> </structure>
>>> <structure>
>>> <property name="position">3</property>
>>> <property name="name">QUANTITYORDERED</property>
>>> <property name="dataType">integer</property>
>>> </structure>
>>> <structure>
>>> <property name="position">4</property>
>>> <property name="name">PRICEEACH</property>
>>> <property name="dataType">float</property>
>>> </structure>
>>> <structure>
>>> <property name="position">5</property>
>>> <property name="name">ORDERLINENUMBER</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">ORDERNUMBER</property>
>>> <property name="nativeName">ORDERNUMBER</property>
>>> <property name="dataType">integer</property>
>>> <property name="nativeDataType">4</property>
>>> </structure>
>>> <structure>
>>> <property name="position">2</property>
>>> <property name="name">PRODUCTCODE</property>
>>> <property name="nativeName">PRODUCTCODE</property>
>>> <property name="dataType">string</property>
>>> <property name="nativeDataType">12</property>
>>> </structure>
>>> <structure>
>>> <property name="position">3</property>
>>> <property name="name">QUANTITYORDERED</property>
>>> <property
>>> name="nativeName">QUANTITYORDERED</property>
>>> <property name="dataType">integer</property>
>>> <property name="nativeDataType">4</property>
>>> </structure>
>>> <structure>
>>> <property name="position">4</property>
>>> <property name="name">PRICEEACH</property>
>>> <property name="nativeName">PRICEEACH</property>
>>> <property name="dataType">float</property>
>>> <property name="nativeDataType">8</property>
>>> </structure>
>>> <structure>
>>> <property name="position">5</property>
>>> <property name="name">ORDERLINENUMBER</property>
>>> <property
>>> name="nativeName">ORDERLINENUMBER</property>
>>> <property name="dataType">integer</property>
>>> <property name="nativeDataType">5</property>
>>> </structure>
>>> </list-property>
>>> <property name="queryText">select *
>>> from orderdetails</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>ORDERNUMBER</design:name>
>>> <design:position>1</design:position>
>>> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
>>> <design:precision>10</design:precision>
>>> <design:scale>0</design:scale>
>>> <design:nullability>Nullable</design:nullability>
>>> <design:uiHints>
>>> <design:displayName>ORDERNUMBER</design:displayName>
>>> </design:uiHints>
>>> </design:attributes>
>>> <design:usageHints>
>>> <design:label>ORDERNUMBER</design:label>
>>> <design:formattingHints>
>>> <design:displaySize>11</design:displaySize>
>>> </design:formattingHints>
>>> </design:usageHints>
>>> </design:resultColumnDefinitions>
>>> <design:resultColumnDefinitions>
>>> <design:attributes>
>>> <design:name>PRODUCTCODE</design:name>
>>> <design:position>2</design:position>
>>> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>>> <design:precision>15</design:precision>
>>> <design:scale>0</design:scale>
>>> <design:nullability>Nullable</design:nullability>
>>> <design:uiHints>
>>> <design:displayName>PRODUCTCODE</design:displayName>
>>> </design:uiHints>
>>> </design:attributes>
>>> <design:usageHints>
>>> <design:label>PRODUCTCODE</design:label>
>>> <design:formattingHints>
>>> <design:displaySize>15</design:displaySize>
>>> </design:formattingHints>
>>> </design:usageHints>
>>> </design:resultColumnDefinitions>
>>> <design:resultColumnDefinitions>
>>> <design:attributes>
>>> <design:name>QUANTITYORDERED</design:name>
>>> <design:position>3</design:position>
>>> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
>>> <design:precision>10</design:precision>
>>> <design:scale>0</design:scale>
>>> <design:nullability>Nullable</design:nullability>
>>> <design:uiHints>
>>> <design:displayName>QUANTITYORDERED</design:displayName>
>>> </design:uiHints>
>>> </design:attributes>
>>> <design:usageHints>
>>> <design:label>QUANTITYORDERED</design:label>
>>> <design:formattingHints>
>>> <design:displaySize>11</design:displaySize>
>>> </design:formattingHints>
>>> </design:usageHints>
>>> </design:resultColumnDefinitions>
>>> <design:resultColumnDefinitions>
>>> <design:attributes>
>>> <design:name>PRICEEACH</design:name>
>>> <design:position>4</design:position>
>>> <design:nativeDataTypeCode>8</design:nativeDataTypeCode>
>>> <design:precision>15</design:precision>
>>> <design:scale>0</design:scale>
>>> <design:nullability>Nullable</design:nullability>
>>> <design:uiHints>
>>> <design:displayName>PRICEEACH</design:displayName>
>>> </design:uiHints>
>>> </design:attributes>
>>> <design:usageHints>
>>> <design:label>PRICEEACH</design:label>
>>> <design:formattingHints>
>>> <design:displaySize>22</design:displaySize>
>>> </design:formattingHints>
>>> </design:usageHints>
>>> </design:resultColumnDefinitions>
>>> <design:resultColumnDefinitions>
>>> <design:attributes>
>>> <design:name>ORDERLINENUMBER</design:name>
>>> <design:position>5</design:position>
>>> <design:nativeDataTypeCode>5</design:nativeDataTypeCode>
>>> <design:precision>5</design:precision>
>>> <design:scale>0</design:scale>
>>> <design:nullability>Nullable</design:nullability>
>>> <design:uiHints>
>>> <design:displayName>ORDERLINENUMBER</design:displayName>
>>> </design:uiHints>
>>> </design:attributes>
>>> <design:usageHints>
>>> <design:label>ORDERLINENUMBER</design:label>
>>> <design:formattingHints>
>>> <design:displaySize>6</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="report" id="4">
>>> <property name="fontFamily">"Verdana"</property>
>>> <property name="fontSize">10pt</property>
>>> </style>
>>> <style name="crosstab" id="5">
>>> <property name="borderBottomColor">#CCCCCC</property>
>>> <property name="borderBottomStyle">solid</property>
>>> <property name="borderBottomWidth">1pt</property>
>>> <property name="borderLeftColor">#CCCCCC</property>
>>> <property name="borderLeftStyle">solid</property>
>>> <property name="borderLeftWidth">1pt</property>
>>> <property name="borderRightColor">#CCCCCC</property>
>>> <property name="borderRightStyle">solid</property>
>>> <property name="borderRightWidth">1pt</property>
>>> <property name="borderTopColor">#CCCCCC</property>
>>> <property name="borderTopStyle">solid</property>
>>> <property name="borderTopWidth">1pt</property>
>>> </style>
>>> <style name="crosstab-cell" 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">
>>> <property name="topMargin">0.25in</property>
>>> <property name="leftMargin">0.25in</property>
>>> <property name="bottomMargin">0.25in</property>
>>> <property name="rightMargin">0.25in</property>
>>> <page-header>
>>> <grid id="44">
>>> <property name="width">100%</property>
>>> <column id="45"/>
>>> <row id="48">
>>> <cell id="49">
>>> <image id="61">
>>> <property name="height">95px</property>
>>> <property name="width">325px</property>
>>> <method
>>> name="onRender"><![CDATA[if(pageNumber>1){
>>> this.getStyle().display ="none"
>>> }
>>> ]]></method>
>>> <property name="source">embed</property>
>>> <property
>>> name="imageName">eclipsecon08_logo.jpg</property>
>>> </image>
>>> </cell>
>>> </row>
>>> <row id="52">
>>> <cell id="53">
>>> <label id="60">
>>> <property
>>> name="textAlign">center</property>
>>> <text-property name="text">Report
>>> header</text-property>
>>> </label>
>>> </cell>
>>> </row>
>>> <row id="56">
>>> <cell id="57"/>
>>> </row>
>>> </grid>
>>> </page-header>
>>> </simple-master-page>
>>> </page-setup>
>>> <body>
>>> <table id="9">
>>> <property name="width">100%</property>
>>> <property name="dataSet">Data Set</property>
>>> <list-property name="boundDataColumns">
>>> <structure>
>>> <property name="name">ORDERNUMBER</property>
>>> <property name="displayName">ORDERNUMBER</property>
>>> <expression
>>> name="expression">dataSetRow["ORDERNUMBER"]</expression >
>>> <property name="dataType">integer</property>
>>> </structure>
>>> <structure>
>>> <property name="name">PRODUCTCODE</property>
>>> <property name="displayName">PRODUCTCODE</property>
>>> <expression
>>> name="expression">dataSetRow["PRODUCTCODE"]</expression >
>>> <property name="dataType">string</property>
>>> </structure>
>>> <structure>
>>> <property name="name">QUANTITYORDERED</property>
>>> <property
>>> name="displayName">QUANTITYORDERED</property>
>>> <expression
>>> name="expression">dataSetRow["QUANTITYORDERED"]</expression >
>>> <property name="dataType">integer</property>
>>> </structure>
>>> <structure>
>>> <property name="name">PRICEEACH</property>
>>> <property name="displayName">PRICEEACH</property>
>>> <expression
>>> name="expression">dataSetRow["PRICEEACH"]</expression>
>>> <property name="dataType">float</property>
>>> </structure>
>>> <structure>
>>> <property name="name">ORDERLINENUMBER</property>
>>> <property
>>> name="displayName">ORDERLINENUMBER</property>
>>> <expression
>>> name="expression">dataSetRow["ORDERLINENUMBER"]</expression >
>>> <property name="dataType">integer</property>
>>> </structure>
>>> </list-property>
>>> <property name="pageBreakInterval">30</property>
>>> <column id="38"/>
>>> <column id="39"/>
>>> <column id="40"/>
>>> <column id="41"/>
>>> <column id="42"/>
>>> <header>
>>> <row id="10">
>>> <cell id="11">
>>> <label id="12">
>>> <text-property
>>> name="text">ORDERNUMBER</text-property>
>>> </label>
>>> </cell>
>>> <cell id="13">
>>> <label id="14">
>>> <text-property
>>> name="text">PRODUCTCODE</text-property>
>>> </label>
>>> </cell>
>>> <cell id="15">
>>> <label id="16">
>>> <text-property
>>> name="text">QUANTITYORDERED</text-property>
>>> </label>
>>> </cell>
>>> <cell id="17">
>>> <label id="18">
>>> <text-property
>>> name="text">PRICEEACH</text-property>
>>> </label>
>>> </cell>
>>> <cell id="19">
>>> <label id="20">
>>> <text-property
>>> name="text">ORDERLINENUMBER</text-property>
>>> </label>
>>> </cell>
>>> </row>
>>> </header>
>>> <detail>
>>> <row id="21">
>>> <cell id="22">
>>> <data id="23">
>>> <property
>>> name="resultSetColumn">ORDERNUMBER</property>
>>> </data>
>>> </cell>
>>> <cell id="24">
>>> <data id="25">
>>> <property
>>> name="resultSetColumn">PRODUCTCODE</property>
>>> </data>
>>> </cell>
>>> <cell id="26">
>>> <data id="27">
>>> <property
>>> name="resultSetColumn">QUANTITYORDERED</property>
>>> </data>
>>> </cell>
>>> <cell id="28">
>>> <data id="29">
>>> <property
>>> name="resultSetColumn">PRICEEACH</property>
>>> </data>
>>> </cell>
>>> <cell id="30">
>>> <data id="31">
>>> <property
>>> name="resultSetColumn">ORDERLINENUMBER</property>
>>> </data>
>>> </cell>
>>> </row>
>>> </detail>
>>> <footer>
>>> <row id="32">
>>> <cell id="33"/>
>>> <cell id="34"/>
>>> <cell id="35"/>
>>> <cell id="36"/>
>>> <cell id="37"/>
>>> </row>
>>> </footer>
>>> </table>
>>> </body>
>>> <list-property name="images">
>>> <structure>
>>> <property name="name">eclipsecon08_logo.jpg</property>
>>> <property name="data">
>>>
>>> /9j/4AAQSkZJRgABAgAAZABkAAD/7AARRHVja3kAAQAEAAAAPAAA/+4ADkFk b2JlAGTAAAAAAf/bAIQA
>>>
>>>
>>> BgQEBAUEBgUFBgkGBQYJCwgGBggLDAoKCwoKDBAMDAwMDAwQDA4PEA8ODBMT FBQTExwbGxscHx8fHx8f
>>>
>>>
>>> Hx8fHwEHBwcNDA0YEBAYGhURFRofHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8f Hx8fHx8fHx8fHx8fHx8f
>>>
>>>
>>> Hx8fHx8fHx8f/8AAEQgAXwFFAwERAAIRAQMRAf/EAKAAAQACAwEBAAAAAAAA AAAAAAABAwQFBgIHAQEB
>>>
>>>
>>> AQEBAQEAAAAAAAAAAAAAAQIDBAUGEAABAgUBBAkABwYEBgMAAAABAgMAETEE BSFBwRIG8FFhgdEiMhMH
>>>
>>>
>>> cZFCk9MUJKFSciMVCLGSotLhYoI0FhczsyYRAQACAgIAAwcEAQUAAAAAAAAB EQISIQMxQQTwUWHxIjIT
>>>
>>>
>>> cYGhQiNSYnJDFP/aAAwDAQACEQMRAD8A+YFutenXH6igLda9OuFAW616dcKA t1r064UBbrXp1woC2Na9
>>>
>>>
>>> ++FAWxrXp1woC3WvTrhQFutenXCgLda9OuFAW616dcKAt1r064UBbrXp1woC 3WvTrhQFutenXCgLda9O
>>>
>>>
>>> uFAW616dcKAt1r064UBbrXp1woC3WvTrhQFutenXCgLda9OuFAW616dcKAt1 r064UBbrXp1woC3WvTrh
>>>
>>>
>>> QFutenXCgLda9OuFAW616dcKAt1r064UBbrXp1woC3WvTrhQFutenXCgLda9 OuFAW616dcKAt1r064UB
>>>
>>>
>>> brXp1woC3WvTrhQFutenXCgLda9OuFCfbE9u+FCwitY66gRWsNQIrWGoKFaw 1Cs5TiULE261T0MQSu2W
>>>
>>>
>>> J6GIKiCCZzjUQBFaxdQIrWGoEVrDUCK1hqBFaw1AitYagRWsNQIrWGoEVrDU CK1hqBFaw1AitYagRWsN
>>>
>>>
>>> QIrWGoEVrDUCK1hqBFaw1AitYagRWsNQIrWGoEVrDUCK1hqBFaw1AitYagRW sNQIrWGoEVrDUCK1hqBF
>>>
>>>
>>> aw1AitYagRWsNQIrWGomWu2GosKK1jpQKSNa98KAprWFApNaxKF9ra8a9AdY 5ZI63EctquUiSSTHmy7K
>>>
>>>
>>> Gdd8kvJSVLHto2qI1+qMx3wsQ5TK462typLYKyPtEwn1E+STLnLoKEyFEfQT HLLvz97nOUsQ3Nwk6LPf
>>>
>>>
>>> rGY7848yMpXM5MTk8P8AqG8R6ev1f+puMmwHAtPEk8STQx7o55hpJRWsWgKK 1hQFFawoCitYUBRWsKAo
>>>
>>>
>>> rWFAUVrCgKK1hQFFawoCitYUBRWsKAorWFAUVrCgKK1hQFFawoCitYUBRWsK AorWFAUVrCgKK1hQFFaw
>>>
>>>
>>> oCitYUBRWsKAorWFAUVrCgKK1hQFFawoCitYUJ4Ndu+FC8pGuhiWIUkSOh74 WPKmgJ8MxEEKmBqImw2W
>>>
>>>
>>> KU37on+2OOco+zfH6bBAS8+Bw/Zn19cfN9RaxDM51v7B1JSyRIDWW0xw67Jl 8bzqkFapR6IYlyV2RrEl
>>>
>>>
>>> iWRc8oZxrlBrm5bbYwj1wbRt33B7nugqTIt1lNJ1jnvF15lNPjcZkMtkGMdj WFXV9dK4Le3RLiWqRMhM
>>>
>>>
>>> gUEamaWGQpvI4LLv4nKsqtrlhYbubZyXE2sgHWRIoY7+n9Rr/wAZbxbgpEts fUtpJSNdDFsCka6GFgUj
>>>
>>>
>>> XQwsCka6GFgUjXQwsCka6GFgUjXQwsCka6GFiCBrWFgUjXQwsCka1hYFI1rC xJSNdDCwKRroYWIKRrWF
>>>
>>>
>>> gUjWsLElI10MLEFI1rCwKRrWFgUjWsLApGtYWBSNawsCka1hYFI1rCwKRrWF iSka6GFgUjXQwsOEToYW
>>>
>>>
>>> LWrd9/i9ltS+GXFLZPrjlszOUR4rDjb/AF/kOfVDZPyR7xWOv9f5Dn1Q2PyR 70OY+9CSSyuXaIbG8e92
>>>
>>>
>>> 9l8b47F2Vrec48wN8vOXqQ5bY/2lXFyUGinG0+ifb366R4M/U3MxhjtSzMN/ nrNWCwNtmsPkG8zy/cqD
>>>
>>>
>>> Dd8wOEtroEuJmZTlL6ax547NpqYrJqcopy/57LZR9m1tWHH7i5UG2WkiZUpW gEa1qLljeG4y3xty1jVo
>>>
>>>
>>> teaedLTFZZxIUbJtv3vb4qBxUxL6SBHKO3KftxuCafO+e+TbzlvKsWTV4xmL a8YF1Z31nq2tpS1I11IC
>>>
>>>
>>> poNCY1hlOXkxlw6nP210n+2LHNFpQdGdJKJay9x2OWs/l/Zq/pcHyHguYb3m zD2uOfdxV7cXCW7fJoTM
>>>
>>>
>>> sKUkjjAmNmkdc4rGZmEiYYnO+B5hs+ec1ZZC6dy99bXJbuMipMlPqSkeciZ2 aRnGJnGKhq4fQeRvi3N8
>>>
>>>
>>> xcl/11N2xZpYuVWr6LtXtJQ23Kby3DpwgKGlY9OHrdKxyibatvrT4mwOZaft +WecLPLZphBWrHhHthfD
>>>
>>>
>>> XgcKjPXbwy641PrssZ+rGoLt83eadaedYdQpDzSi262oSUlaTwqSodYIj249 kSm0O8/9a4fF2Nq/zjzK
>>>
>>>
>>> xy/cX7YetrEtLuHwg7XEII4Y8k+smZnTHalmWj5u5Vx2GtLPIY3O2ubx18tb bb1sSlaFtgKKXEEnhmFa
>>>
>>>
>>> ax06fU7TMTGsps1WDwuSzuVYxWMaU/eXJk2igAGqlKOxKRqTHbPuxxi5W3aO fH3IjFycbec82zOXSr23
>>>
>>>
>>> Gk2zjlulycuEvzSga6Ex5P8A15+MYcFuV5u5XynK+ZdxWSA91KQ408g8TbrS vS4gmUwZR6envjsi4LY+
>>>
>>>
>>> Fw1xl7ssNK9ttA4nnVahI+jaTsjWfZTeGO0s5605JadLC8hdLWnRTqEgtz/y EnujG+Tcxh72oubdpWRV
>>>
>>>
>>> a49xV0hakoYXKRXxSqDLaY6Rnxy5zHNQ3d1g+XsXwNZi/dN0tIUpm2APCD1k hW6OX5cp8HScMY8ZY2W5
>>>
>>>
>>> faZxwymNuTeWB0WSJLRrLzd/YI1j281KZYcXHg9ctcutZpq6Up9TKmSkJAAI PEDX6oZ9tHXhs1qLFwZl
>>>
>>>
>>> vGXM23FPoYc2y4lBMx16GYjX5OLZ15pn32Kxtlf5G0ecdWbNtLragpKePiCP LIg6/wAz9kZjsmYanGIm
>>>
>>>
>>> YeMvi8faWinre7L7nuobDcxMJKVT4pbeNB7pdcXHsmZTLGIhqVK0NY6Ww3IZ 5PbCU3F7dOOEDjUyhKUJ
>>>
>>>
>>> JGoPECTLsjlOeTpWPvV8xYMYsMXDL35iyuk8TLhEjQHX6QdIuHZaZ4UvYwuN t8W3kszcOtNXJlbsMgFx
>>>
>>>
>>> Q/ePECO2JPbN1CxhERcqM5hmrO1YyFm8q5x11o24oSUlWvlV9Ri4dl8SmeFc x4L2MLjbfFt5LM3DrTVy
>>>
>>>
>>> ZW7DIBcUP3jxAjtiT2zdQsYREXKjN4VqztWMhZPKuMddaNuKElJVr5VfUYuH ZfEpnhXMeC6xwtgMOcvl
>>>
>>>
>>> X3WrRauBptkArUQSJzMxUGJl2zdQuOEVcoy+EsWsS1lsbcLes3FcCkOgBaTM jWQG0SpDDsm6kywirhpS
>>>
>>>
>>> qYNY6xLmlRrWFiZ67d8LFlgEue7Nn3pcPqdDUq9Z1jFsZyzCwkz/AEae+6T4 wti/j/Cp5tYPlsky6vf4
>>>
>>>
>>> j9YXCy/j/DP5XYZf5pw9veWyEW717bpdBdqguAGYKjHLumYwmvc1E/F9C+TX vitfyLkG+YbXOOZZPtBx
>>>
>>>
>>> bDjAt+H2klHthR4+GX7Y+d0R2aRrVLcW0fM/Ofx/YfHOY5W5fscnx5VaHmje Ka9tDyFIM+IKBTojYIs9
>>>
>>>
>>> ee0ZZUuWXCv+3hLb3yDZm4t0pW1a3C2VF4LPHwgaIn+6TE9T9jGE8vmOYTd5 LmjMXN+x7l25e3BuCu4C
>>>
>>>
>>> VcYdUCDM7JSjpjHEcMzKpOIShQlZp4U0T+bTIT1010jWvw/lm303mFkD+2bH I/LhIGcP8r3gR/8AI7rx
>>>
>>>
>>> zjzV/l/Z0/q5b4ktkj5G5YV+USki+bPuC5CiNFa8E9Y69sfRPCYzywvlRhK/ lnmsm1S5+vXqbgIn5U7J
>>>
>>>
>>> 6Rz64+mOP5bmeXeYVHt/22ZBIbDAOc1Slz3hVraP8InVH+X9jLwaX4sXdN/I XL67aZc/ONpUUmR9tflc
>>>
>>>
>>> nLZwEx7e/GPxz+iYw8/KBaT8kcxBgzSLxRkNAFkAr1/jnF9LP0R+h5uyyvNX xRz0i0uOaHbzAZ+3YTbu
>>>
>>>
>>> 3TCS7brCKHRLmkyTqAR1mPNHX2dfGPOKzUuY58+Ohy5j7LOYzJt5jl3JK4LW +bEiFyJCVgaahJkR1EGU
>>>
>>>
>>> d+nv2mpisoSnQ/AabQ5PmN98OFbOJdKfYID4QpQ4y1P7eg4Ts74x66ZrH9Wo aQ3HwcU6W3MOo1/mWu3r
>>>
>>>
>>> mIsfm/2sxSv5M50wHMacI3h2bppvE2n5NS7zgLi0p4fbmpBM9AZxfT9eWEzf mWxuVXFf+LZ1bE/zIQun
>>>
>>>
>>> qkGjLfHfPxh6uv7ZcWhYM6x0hxdByUppXM9oF/8AOUA/vBtUoz2eDfV9zD5s ccPMeQ92fEHZCf7oA4f9
>>>
>>>
>>> MoYeCdn3S3/KKuLlbOh7/tkoWQT+97R4u/RMYz8YdOv7ZU8m3r1vy9nbplXC 6whK0E7ClKiIZ+J1zUS2
>>>
>>>
>>> q2GOYTieYbBMrhm4YRfMioCXE8U/4K/wxmJrhutqyhzPO6//ANVfjq9r/wCl EdOvwce37pafirWOrm9l
>>>
>>>
>>> wSNYtjZ4fBKyCV3d07+UxbJ/n3S9Jy+ymdTHPLKnTHC+fI5q5kZyS2bazQWs dZJ4LdJ0KtAJnq0GkZxi
>>>
>>>
>>> jszvw8G1+RFBNth0on7Hsq9uVKI3SjOHm33eQlY/9ZPKcql4ezPr95M5f6oT 9x/Q+RFBNthktz9j2Ve3
>>>
>>>
>>> KlEbpQwk7vIQsH4zdU5VLw9mfX7yZy/1Q/sf9a7C3rGO5UC8+Pexl45w2ltw 8TkiTxKnMSGkxt+uJl48
>>>
>>>
>>> LjNY8+Ceardp7lm1uMK8hWFtSONhAPFxEy4lEmZIKtQeucXCeTsj6ePBx6Xd DWO8S4JLtaxbRPu67d8L
>>>
>>>
>>> VjMXyWuPiZS9OUvc4tJfwlMZtJi1pyrWv6Nn6nP2+eFpr8Q5VrX9Gz9Tn7fP CzX4q15OTvuNsIbWkgpK
>>>
>>>
>>> eMSI1B9UQ1+L6i58l/G/NqbO656xt1acw2iEtf1bGgFLyRT3ET0+iR7DLSPB +HPCfo+34rTC5+zvxl/4
>>>
>>>
>>> vc2PLmIub3IOlATkr8ABpIUFK4Egg+YCWgEZ17LvKv0XKJmHzzlnm2+5dzFn msZbW7V9ZL42yQuSgRwr
>>>
>>>
>>> QrzelSSQYZRExVOMRTvsjzb/AG88x5FzPZzFZXE5i6PuZG1tAHGHXZeZSVJM pq2mSZxxxjPHiKlqalw/
>>>
>>>
>>> OvNPJuSytujlPADG4i0YDCU3M1PPL41KLzhSs6kKA1UaR067jx5SYbLMfIWE f+GrPktFosZZjJG9X5P0
>>>
>>>
>>> vtlS1aK4+Pi8/VGdfr2XyaTkPmbH4Dm3DZq9s0flcfcofeLCVKd4Ugz4ApYB Osa7JvGYWIa/njmrHZ7n
>>>
>>>
>>> zPZyztE/k8jdKfYFwkpd4SAPOErIB06443URFQ1T7V8X3vLY/t7vHOYbBxzF LzakuNWKi24kq9rhcTxK
>>>
>>>
>>> 1IrKesTCMt4mOJpMvBFjzr8U8oBzJco4+/yHMJQpFrcZOQaY4wQVSB1MjsHe I9U4dmfGUxGPwTZ8susi
>>>
>>>
>>> 89eO3dyo3D7zpefWv7a1K4lTl1mPZhFQRD6LcZH4Jy8rt20y2BulHiftLThe Znt4ComX1D6I8v8Amx44
>>>
>>>
>>> klrue+fMRkcDjuVuW7R6x5cxa1PIVcqCrh95XF53JTCR51aT2xerqmMpyy+6 UloOS+dsjylzCzmLFIWp
>>>
>>>
>>> sFt9hcwl1pfqQqX0TB2GPR29cZ41LdO0vch8DZi4VknmMziH3j7lxj7QNLZ4 zqfbKuKQJ+j6BHlxjux4
>>>
>>>
>>> 4lnhyHOmU5Uu7q3Tyxjnsdj7Zn21G4WFvPucRUXXJEyMjKU49HVtH3Tcltdy 5zQ/g75boQXrZ4BNwyTK
>>>
>>>
>>> YFCD1iOmUW7YZ6tk/c/HLzhuQL5ji8yrVsJCZnZrxS7lRmJlqdGku8qw1lze 4htdqy0pCrZCzxKBQkAl
>>>
>>>
>>> WpnxEExry5Ymebhv73mDk7OFNzlmbqyvkpCXV23CUrlSoV/h3xiLh0nLHLxY ua5tsP6R/RMHbuMWRM33
>>>
>>>
>>> nZe45rM0JrKs+zSLEc3KZZxVQxsJzDaWGEy9i8h1T1+gJZUkJKQeFQ85Kgdu wRZjlMcqiYOUOalYG+Wp
>>>
>>>
>>> 5Ljli8JPNJkVAj0qSCQJ7K0iZY2deessbmTMMZTO3V/bpcQy97fClwAKHC2l BmAVCqeuNYcM5zc2wS8d
>>>
>>>
>>> a7I6Wyhbxka9OuJY7O95u5JvLG2srqyvfYtQAhpvhQmcpTMnRPvjjUu854zF Oezt5yy621/Rba5YWCff
>>>
>>>
>>> L5BBGnDLzr7Y1jfm55Tj5NixzHhcjhWMXnkvtrsv+1vGAFHhpwqB7NKRJip4 ajKJipY3MfMtndY+3w2K
>>>
>>>
>>> acaxloeLjdl7ji9dVS/iJhEJnnxUeDJt+Y8LkcKxi88l9tdlpa3jACjwU4VA 9mlIVU8LGUTFSxuYuZbO
>>>
>>>
>>> 5x9vh8U041jLQ8XG7L3HF66ql/ETCITPO4qPBl2/MmByGBZxGdbfaNpL8vdW 4BMgJDiB+qmsSY5WMomK
>>>
>>>
>>> lVkeZMTbYFWDwaHiw8v3Lq6uJBSjMUA/hEWI5Jyiqhz4eIBrHWJckl4616dc WxPvGe3fCxhl2tenXHOw
>>>
>>>
>>> Lta9OuFieMqJlM9NsLEqUgE8SiewbzFse0uJOkpCDeLu+VXcdkrFVjcpH5lC Skg1W31jtTHPLF11cbzL
>>>
>>>
>>> hH8TfLbUP5SjNC9hBoY82UU8ueFS0ighVRGWHiSRQRVQpIOpjE5LEPDi0hMt kcssm6a8tm5uAw1pPVxY
>>>
>>>
>>> +ynafCMYYTnlSvpWN54urTkJ/ktFu0Mc7dpvfzB4vdStKUJCRrw8P8sbI+jP TG0ZR5RTGTnXbg8SpEyj
>>>
>>>
>>> tCxCtTtaxbVPvkT1MQpKric58UEpBdRrMK+v/hFtXv8AMNiei/8AMPCIlJVc Mmc0r/zD/bFKQXrXWbbn
>>>
>>>
>>> +cf7YWchdstZtO/eJ/2RDl696w1m0996n8OLZykvY3WbL/3qfw4HKfexYnNh /wC+R+FC05SbjFazt7j7
>>>
>>>
>>> 9H4ULOUm4xGs7e4+/R+DCysvb5n5jDif6a5+/R+DCysvb5pNziNf01z9+j8G FlZe3zDc4jX9Nc9v89H4
>>>
>>>
>>> MLKy9vmgv4fX9Nc/fo/BhZWXt8z38Pr+mufv0fgwsrL2+YX8Pr+mufv0fgws rL2+Z7+H1/TXP36PwYWV
>>>
>>>
>>> l7fML+H1/TXP36PwYWVl7fM9/D6/prn79H4MLKy9vmF/D6/prn79H4MLKy9v m8PPY0tqDLD6HNJKW6la
>>>
>>>
>>> a7UhtH+MLItQXBrXp1wtoLta9OuFh7vm274WMcqrXv3xgOIAk6n6d8LEqcJn qZdXjCxBVWvfvhYsbUSq
>>>
>>>
>>> QnONNRLZWl4u2cStlZS6gghwVBg7Y5OvbzmJzln+TzKQ059m4A0n1/8AL/hG MsbaywtyWa5Ru7JanLVQ
>>>
>>>
>>> u7WqVtmZl9EcMsMoeXLrpz65oJSoFJFQdDHnnJKUOPpG2Oc5Kq/LXtx6U+03 tcWJfUKmNYdGWfwhqmdb
>>>
>>>
>>> 2rFq2UNAzOq1mqj1mPodfXGEVCSuKpTr0640gVVr374AVVr374AVVr374AVV r374AVVr374AVVr374AV
>>>
>>>
>>> Vr374AVVr374AVVr374AVVr374AVVr374AVVr374AVVr374AVVr374AVVr37 4AVVr374AVVr374AVVr3
>>>
>>>
>>> 74AVVr374AVVr374AVVr374AVVr374AVVr374AVVr374AVVr374AVVr374AV Vr374Bxeb7W+Axi7Wuyu
>>>
>>>
>>> +IgXa12V3wAu1rsrvgHuFRIHESZSHjAXKfDU0pJK/tK6uyLYlFzKdYttxLNT e8KAJmZ1MV0jNcjJOIB4
>>>
>>>
>>> VqT9BlEb3VXF027P3Ehf8QnCeWZr3MVTrKJ8CAn6ABEjGI8mZlS7cTnWLbnM qlO1rs6GM2yF2tdld8AL
>>>
>>>
>>> ta7K74AXa12V3wAu1rsrvgBdrXZXfAC7Wuyu+AF2tdld8ALta7K74AXa12V3 wAu1rsrvgBdrXZXfAC7W
>>>
>>>
>>> uyu+AF2tdld8ALta7K74AXa12V3wAu1rsrvgBdrXZXfAC7Wuyu+AF2tdld8A Lta7K74AXa12V3wAu1rs
>>>
>>>
>>> rvgBdrXZXfAC7Wuyu+AF2tdld8ALta7K74AXa12V3wAu1rsrvgHu+b7W+AxC 56q7K74yBc9Vdld8AKyZ
>>>
>>>
>>> gcWzoYC0u+0FBJPuGqursi2Ki56q7K74lj0HDM1lpXfFiR7VcklR12dDF2W0 m5OtenXC1sVcnXU9++Fl
>>>
>>>
>>> vC3zrXp1xLS3lTh81dld8SxBc9Vdld8EC56q7K74AXPVXZXfAC56q7K74AXP VXZXfAC56q7K74AXPVXZ
>>>
>>>
>>> XfAC56q7K74AXPVXZXfAC56q7K74AXPVXZXfAC56q7K74AXPVXZXfAC56q7K 74AXPVXZXfAC56q7K74A
>>>
>>>
>>> XPVXZXfAC56q7K74AXPVXZXfAC56q7K74AXPVXZXfAC56q7K74AXPVXZXfAC 56q7K74AXPVXZXfAC56q
>>>
>>>
>>> 7K74AXPVXZXfAC56q7K74AXPVXZXfAT7nm+1vpBVRQ7rOXb5h4w1lAod1nLt 8w8YayJCHwTKu3UeMKkQ
>>>
>>>
>>> UO6zl2+YeMNZAod1nLt8w8YayHA9rTt8w8YayBQ7rOXb5h4w1kCh3Wcu3zDx hrIFDus5dvmHjDWQKHdZ
>>>
>>>
>>> y7fMPGGsgUO6zl2+YeMNZAod1nLt8w8YayBQ7rOXb5h4w1kCh3Wcu3zDxhrI FDus5dvmHjDWQKHdZy7f
>>>
>>>
>>> MPGGsgUO6zl2+YeMNZAod1nLt8w8YayBQ7rOXb5h4w1kCh3Wcu3zDxhrIFDu s5dvmHjDWQKHdZy7fMPG
>>>
>>>
>>> GsgUO6zl2+YeMNZAod1nLt8w8YayBQ7rOXb5h4w1kCh3Wcu3zDxhrIFDus5d vmHjDWQKHdZy7fMPGGsg
>>>
>>>
>>> UO6zl2+YeMNZAod1nLt8w8YayBQ7rOXb5h4w1kCh3Wcu3zDxhrIFDus5dvmH jDWQKHdZy7fMPGGsgUO6
>>>
>>>
>>> zl2+YeMNZAod1nLt8w8YayBQ7rOXb5h4w1kCh3Wcu3zDxhrIFDus5dvmHjDW QKHdZy7fMPGGshwPT7f4
>>>
>>> h4w1kf/Z
>>> </property>
>>> </structure>
>>> </list-property>
>>> </report>
>>>
>>> Raishad Maharaj wrote:
>>>> Jason,
>>>>
>>>> Would this be possible with 2.3.1?
>>>> I was trying to do something with the row.__rownum and the
>>>> Visibility property for the header row, but it seems it is only
>>>> evaluated once and not for every page.
>>>>
>>>>
>>>> Jason Weathersby wrote:
>>>>> Raishad,
>>>>>
>>>>> This possible with 2.5 using page variables.
>>>>> See attached example.
>>>>>
>>>>> Jason
>>>>>
>>>>> <?xml version="1.0" encoding="UTF-8"?>
>>>>> <report xmlns="http://www.eclipse.org/birt/2005/design"
>>>>> version="3.2.20" id="1">
>>>>> <property name="createdBy">Eclipse BIRT Designer Version
>>>>> 2.5.0.v20090603 Build <2.5.0.v20090617-0630></property>
>>>>> <property name="units">in</property>
>>>>> <method name="onPageStart"><![CDATA[var first =
>>>>> reportContext.getPageVariable("FIRST");
>>>>> if( first == 1 ){
>>>>> reportContext.setPageVariable("FIRST",2);
>>>>> }]]></method>
>>>>> <method name="onPageEnd"><![CDATA[var first =
>>>>> reportContext.getPageVariable("FIRST");
>>>>> if( first == 0 ){
>>>>> reportContext.setPageVariable("FIRST",1);
>>>>> }]]></method>
>>>>> <property name="iconFile">/templates/blank_report.gif</property>
>>>>> <property name="bidiLayoutOrientation">ltr</property>
>>>>> <data-sources>
>>>>> <oda-data-source
>>>>> extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data
>>>>> Source" id="7">
>>>>> <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="8">
>>>>> <list-property name="columnHints">
>>>>> <structure>
>>>>> <property name="columnName">ORDERNUMBER</property>
>>>>> <property
>>>>> name="displayName">ORDERNUMBER</property>
>>>>> </structure>
>>>>> <structure>
>>>>> <property name="columnName">ORDERDATE</property>
>>>>> <property name="displayName">ORDERDATE</property>
>>>>> </structure>
>>>>> <structure>
>>>>> <property
>>>>> name="columnName">REQUIREDDATE</property>
>>>>> <property
>>>>> name="displayName">REQUIREDDATE</property>
>>>>> </structure>
>>>>> <structure>
>>>>> <property name="columnName">SHIPPEDDATE</property>
>>>>> <property
>>>>> name="displayName">SHIPPEDDATE</property>
>>>>> </structure>
>>>>> <structure>
>>>>> <property name="columnName">STATUS</property>
>>>>> <property name="displayName">STATUS</property>
>>>>> </structure>
>>>>> <structure>
>>>>> <property name="columnName">COMMENTS</property>
>>>>> <property name="displayName">COMMENTS</property>
>>>>> </structure>
>>>>> <structure>
>>>>> <property
>>>>> name="columnName">CUSTOMERNUMBER</property>
>>>>> <property
>>>>> name="displayName">CUSTOMERNUMBER</property>
>>>>> </structure>
>>>>> </list-property>
>>>>> <structure name="cachedMetaData">
>>>>> <list-property name="resultSet">
>>>>> <structure>
>>>>> <property name="position">1</property>
>>>>> <property name="name">ORDERNUMBER</property>
>>>>> <property name="dataType">integer</property>
>>>>> </structure>
>>>>> <structure>
>>>>> <property name="position">2</property>
>>>>> <property name="name">ORDERDATE</property>
>>>>> <property name="dataType">date</property>
>>>>> </structure>
>>>>> <structure>
>>>>> <property name="position">3</property>
>>>>> <property name="name">REQUIREDDATE</property>
>>>>> <property name="dataType">date</property>
>>>>> </structure>
>>>>> <structure>
>>>>> <property name="position">4</property>
>>>>> <property name="name">SHIPPEDDATE</property>
>>>>> <property name="dataType">date</property>
>>>>> </structure>
>>>>> <structure>
>>>>> <property name="position">5</property>
>>>>> <property name="name">STATUS</property>
>>>>> <property name="dataType">string</property>
>>>>> </structure>
>>>>> <structure>
>>>>> <property name="position">6</property>
>>>>> <property name="name">COMMENTS</property>
>>>>> <property name="dataType">string</property>
>>>>> </structure>
>>>>> <structure>
>>>>> <property name="position">7</property>
>>>>> <property
>>>>> name="name">CUSTOMERNUMBER</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">ORDERNUMBER</property>
>>>>> <property name="nativeName">ORDERNUMBER</property>
>>>>> <property name="dataType">integer</property>
>>>>> <property name="nativeDataType">4</property>
>>>>> </structure>
>>>>> <structure>
>>>>> <property name="position">2</property>
>>>>> <property name="name">ORDERDATE</property>
>>>>> <property name="nativeName">ORDERDATE</property>
>>>>> <property name="dataType">date</property>
>>>>> <property name="nativeDataType">91</property>
>>>>> </structure>
>>>>> <structure>
>>>>> <property name="position">3</property>
>>>>> <property name="name">REQUIREDDATE</property>
>>>>> <property
>>>>> name="nativeName">REQUIREDDATE</property>
>>>>> <property name="dataType">date</property>
>>>>> <property name="nativeDataType">91</property>
>>>>> </structure>
>>>>> <structure>
>>>>> <property name="position">4</property>
>>>>> <property name="name">SHIPPEDDATE</property>
>>>>> <property name="nativeName">SHIPPEDDATE</property>
>>>>> <property name="dataType">date</property>
>>>>> <property name="nativeDataType">91</property>
>>>>> </structure>
>>>>> <structure>
>>>>> <property name="position">5</property>
>>>>> <property name="name">STATUS</property>
>>>>> <property name="nativeName">STATUS</property>
>>>>> <property name="dataTy

Report message to a moderator

Re: Hide Header Row on PDF Output [message #486476 is a reply to message #486230]

Thu, 17 September 2009 18:54

Jason Weathersby

Messages: 9167
Registered: July 2009

Senior Member

Raishad,

You can always make the header from a detail row and just use the
visibility expression to hide it after the first instance. Take a look
at the modified example.

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 <2.3.2.v20090218-0730></property>
<property name="units">in</property>
<property name="iconFile">/templates/blank_report.gif</property>
<property name="bidiLayoutOrientation">ltr</property>
<data-sources>
<oda-data-source
extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source"
id="7">
<property
name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver </property>
<property name="odaURL">jdbc:classicmodels:sampledb</property>
<property name="odaUser">ClassicModels</property>
<property name="OdaConnProfileName"></property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="Data Set" id="8">
<list-property name="columnHints">
<structure>
<property name="columnName">ORDERNUMBER</property>
<property name="displayName">ORDERNUMBER</property>
</structure>
<structure>
<property name="columnName">PRODUCTCODE</property>
<property name="displayName">PRODUCTCODE</property>
</structure>
<structure>
<property name="columnName">QUANTITYORDERED</property>
<property name="displayName">QUANTITYORDERED</property>
</structure>
<structure>
<property name="columnName">PRICEEACH</property>
<property name="displayName">PRICEEACH</property>
</structure>
<structure>
<property name="columnName">ORDERLINENUMBER</property>
<property name="displayName">ORDERLINENUMBER</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">ORDERNUMBER</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">PRODUCTCODE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">QUANTITYORDERED</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">PRICEEACH</property>
<property name="dataType">float</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">ORDERLINENUMBER</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">ORDERNUMBER</property>
<property name="nativeName">ORDERNUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">PRODUCTCODE</property>
<property name="nativeName">PRODUCTCODE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">QUANTITYORDERED</property>
<property name="nativeName">QUANTITYORDERED</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">PRICEEACH</property>
<property name="nativeName">PRICEEACH</property>
<property name="dataType">float</property>
<property name="nativeDataType">8</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">ORDERLINENUMBER</property>
<property name="nativeName">ORDERLINENUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">5</property>
</structure>
</list-property>
<property name="queryText">select *
from orderdetails</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>ORDERNUMBER</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>ORDERNUMBER</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>ORDERNUMBER</design:label>
<design:formattingHints>
<design:displaySize>11</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>PRODUCTCODE</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>15</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>PRODUCTCODE</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>PRODUCTCODE</design:label>
<design:formattingHints>
<design:displaySize>15</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>QUANTITYORDERED</design:name>
<design:position>3</design:position>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>QUANTITYORDERED</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>QUANTITYORDERED</design:label>
<design:formattingHints>
<design:displaySize>11</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>PRICEEACH</design:name>
<design:position>4</design:position>
<design:nativeDataTypeCode>8</design:nativeDataTypeCode>
<design:precision>15</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>PRICEEACH</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>PRICEEACH</design:label>
<design:formattingHints>
<design:displaySize>22</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>ORDERLINENUMBER</design:name>
<design:position>5</design:position>
<design:nativeDataTypeCode>5</design:nativeDataTypeCode>
<design:precision>5</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>ORDERLINENUMBER</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>ORDERLINENUMBER</design:label>
<design:formattingHints>
<design:displaySize>6</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="report" id="4">
<property name="fontFamily">"Verdana"</property>
<property name="fontSize">10pt</property>
</style>
<style name="crosstab" id="5">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
<style name="crosstab-cell" 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">
<property name="topMargin">0.25in</property>
<property name="leftMargin">0.25in</property>
<property name="bottomMargin">0.25in</property>
<property name="rightMargin">0.25in</property>
<page-header>
<grid id="44">
<property name="width">100%</property>
<column id="45"/>
<row id="48">
<cell id="49">
<image id="61">
<property name="height">95px</property>
<property name="width">325px</property>
<method
name="onRender"><![CDATA[if(pageNumber>1){
this.getStyle().display ="none"
}
]]></method>
<property name="source">embed</property>
<property
name="imageName">eclipsecon08_logo.jpg</property>
</image>
</cell>
</row>
<row id="52">
<cell id="53">
<label id="60">
<property
name="textAlign">center</property>
<text-property name="text">Report
header</text-property>
</label>
</cell>
</row>
<row id="56">
<cell id="57"/>
</row>
</grid>
</page-header>
</simple-master-page>
</page-setup>
<body>
<table id="9">
<property name="width">100%</property>
<property name="dataSet">Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">ORDERNUMBER</property>
<property name="displayName">ORDERNUMBER</property>
<expression
name="expression">dataSetRow["ORDERNUMBER"]</expression >
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">PRODUCTCODE</property>
<property name="displayName">PRODUCTCODE</property>
<expression
name="expression">dataSetRow["PRODUCTCODE"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">QUANTITYORDERED</property>
<property name="displayName">QUANTITYORDERED</property>
<expression
name="expression">dataSetRow["QUANTITYORDERED"]</expression >
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">PRICEEACH</property>
<property name="displayName">PRICEEACH</property>
<expression
name="expression">dataSetRow["PRICEEACH"]</expression>
<property name="dataType">float</property>
</structure>
<structure>
<property name="name">ORDERLINENUMBER</property>
<property name="displayName">ORDERLINENUMBER</property>
<expression
name="expression">dataSetRow["ORDERLINENUMBER"]</expression >
<property name="dataType">integer</property>
</structure>
</list-property>
<method name="onPrepare"><![CDATA[tableheadervis =
0;]]></method>
<property name="pageBreakInterval">30</property>
<column id="38"/>
<column id="39"/>
<column id="40"/>
<column id="41"/>
<column id="42"/>
<header>
<row id="10">
<method name="onRender"><![CDATA[
]]></method>
<property name="backgroundColor">#8080FF</property>
<cell id="11">
<label id="12">
<text-property
name="text">ORDERNUMBER</text-property>
</label>
</cell>
<cell id="13">
<label id="14">
<text-property
name="text">PRODUCTCODE</text-property>
</label>
</cell>
<cell id="15">
<label id="16">
<text-property
name="text">QUANTITYORDERED</text-property>
</label>
</cell>
<cell id="17">
<label id="18">
<text-property
name="text">PRICEEACH</text-property>
</label>
</cell>
<cell id="19">
<label id="20">
<text-property
name="text">ORDERLINENUMBER</text-property>
</label>
</cell>
</row>
</header>
<detail>
<row id="62">
<property name="backgroundColor">#FF8080</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression
name="valueExpr">row.__rownum>0</expression>
</structure>
</list-property>
<cell id="63">
<label id="68">
<text-property
name="text">ORDERNUMBER</text-property>
</label>
</cell>
<cell id="64">
<label id="69">
<text-property
name="text">PRODUCTCODE</text-property>
</label>
</cell>
<cell id="65">
<label id="70">
<text-property
name="text">QUANTITYORDERED</text-property>
</label>
</cell>
<cell id="66"/>
<cell id="67"/>
</row>
<row id="21">
<cell id="22">
<data id="23">
<property
name="resultSetColumn">ORDERNUMBER</property>
</data>
</cell>
<cell id="24">
<data id="25">
<property
name="resultSetColumn">PRODUCTCODE</property>
</data>
</cell>
<cell id="26">
<data id="27">
<property
name="resultSetColumn">QUANTITYORDERED</property>
</data>
</cell>
<cell id="28">
<data id="29">
<property
name="resultSetColumn">PRICEEACH</property>
</data>
</cell>
<cell id="30">
<data id="31">
<property
name="resultSetColumn">ORDERLINENUMBER</property>
</data>
</cell>
</row>
</detail>
<footer>
<row id="32">
<cell id="33"/>
<cell id="34"/>
<cell id="35"/>
<cell id="36"/>
<cell id="37"/>
</row>
</footer>
</table>
</body>
<list-property name="images">
<structure>
<property name="name">eclipsecon08_logo.jpg</property>
<property name="data">

/9j/4AAQSkZJRgABAgAAZABkAAD/7AARRHVja3kAAQAEAAAAPAAA/+4ADkFk b2JlAGTAAAAAAf/bAIQA

BgQEBAUEBgUFBgkGBQYJCwgGBggLDAoKCwoKDBAMDAwMDAwQDA4PEA8ODBMT FBQTExwbGxscHx8fHx8f

Hx8fHwEHBwcNDA0YEBAYGhURFRofHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8f Hx8fHx8fHx8fHx8fHx8f

Hx8fHx8fHx8f/8AAEQgAXwFFAwERAAIRAQMRAf/EAKAAAQACAwEBAAAAAAAA AAAAAAABAwQFBgIHAQEB

AQEBAQEAAAAAAAAAAAAAAQIDBAUGEAABAgUBBAkABwYEBgMAAAABAgMAETEE BSFBwRIG8FFhgdEiMhMH

cZFCk9MUJKFSciMVCLGSotLhYoI0FhczsyYRAQACAgIAAwcEAQUAAAAAAAAB EQISIQMxQQTwUWHxIjIT

cYGhQiNSYnJDFP/aAAwDAQACEQMRAD8A+YFutenXH6igLda9OuFAW616dcKA t1r064UBbrXp1woC2Na9

++FAWxrXp1woC3WvTrhQFutenXCgLda9OuFAW616dcKAt1r064UBbrXp1woC 3WvTrhQFutenXCgLda9O

uFAW616dcKAt1r064UBbrXp1woC3WvTrhQFutenXCgLda9OuFAW616dcKAt1 r064UBbrXp1woC3WvTrh

QFutenXCgLda9OuFAW616dcKAt1r064UBbrXp1woC3WvTrhQFutenXCgLda9 OuFAW616dcKAt1r064UB

brXp1woC3WvTrhQFutenXCgLda9OuFCfbE9u+FCwitY66gRWsNQIrWGoKFaw 1Cs5TiULE261T0MQSu2W

J6GIKiCCZzjUQBFaxdQIrWGoEVrDUCK1hqBFaw1AitYagRWsNQIrWGoEVrDU CK1hqBFaw1AitYagRWsN

QIrWGoEVrDUCK1hqBFaw1AitYagRWsNQIrWGoEVrDUCK1hqBFaw1AitYagRW sNQIrWGoEVrDUCK1hqBF

aw1AitYagRWsNQIrWGomWu2GosKK1jpQKSNa98KAprWFApNaxKF9ra8a9AdY 5ZI63EctquUiSSTHmy7K

Gdd8kvJSVLHto2qI1+qMx3wsQ5TK462typLYKyPtEwn1E+STLnLoKEyFEfQT HLLvz97nOUsQ3Nwk6LPf

rGY7848yMpXM5MTk8P8AqG8R6ev1f+puMmwHAtPEk8STQx7o55hpJRWsWgKK 1hQFFawoCitYUBRWsKAo

rWFAUVrCgKK1hQFFawoCitYUBRWsKAorWFAUVrCgKK1hQFFawoCitYUBRWsK AorWFAUVrCgKK1hQFFaw

oCitYUBRWsKAorWFAUVrCgKK1hQFFawoCitYUJ4Ndu+FC8pGuhiWIUkSOh74 WPKmgJ8MxEEKmBqImw2W

KU37on+2OOco+zfH6bBAS8+Bw/Zn19cfN9RaxDM51v7B1JSyRIDWW0xw67Jl 8bzqkFapR6IYlyV2RrEl

iWRc8oZxrlBrm5bbYwj1wbRt33B7nugqTIt1lNJ1jnvF15lNPjcZkMtkGMdj WFXV9dK4Le3RLiWqRMhM

gUEamaWGQpvI4LLv4nKsqtrlhYbubZyXE2sgHWRIoY7+n9Rr/wAZbxbgpEts fUtpJSNdDFsCka6GFgUj

XQwsCka6GFgUjXQwsCka6GFgUjXQwsCka6GFiCBrWFgUjXQwsCka1hYFI1rC xJSNdDCwKRroYWIKRrWF

gUjWsLElI10MLEFI1rCwKRrWFgUjWsLApGtYWBSNawsCka1hYFI1rCwKRrWF iSka6GFgUjXQwsOEToYW

LWrd9/i9ltS+GXFLZPrjlszOUR4rDjb/AF/kOfVDZPyR7xWOv9f5Dn1Q2PyR 70OY+9CSSyuXaIbG8e92

9l8b47F2Vrec48wN8vOXqQ5bY/2lXFyUGinG0+ifb366R4M/U3MxhjtSzMN/ nrNWCwNtmsPkG8zy/cqD

Dd8wOEtroEuJmZTlL6ax547NpqYrJqcopy/57LZR9m1tWHH7i5UG2WkiZUpW gEa1qLljeG4y3xty1jVo

teaedLTFZZxIUbJtv3vb4qBxUxL6SBHKO3KftxuCafO+e+TbzlvKsWTV4xmL a8YF1Z31nq2tpS1I11IC

poNCY1hlOXkxlw6nP210n+2LHNFpQdGdJKJay9x2OWs/l/Zq/pcHyHguYb3m zD2uOfdxV7cXCW7fJoTM

sKUkjjAmNmkdc4rGZmEiYYnO+B5hs+ec1ZZC6dy99bXJbuMipMlPqSkeciZ2 aRnGJnGKhq4fQeRvi3N8

xcl/11N2xZpYuVWr6LtXtJQ23Kby3DpwgKGlY9OHrdKxyibatvrT4mwOZaft +WecLPLZphBWrHhHthfD

XgcKjPXbwy641PrssZ+rGoLt83eadaedYdQpDzSi262oSUlaTwqSodYIj249 kSm0O8/9a4fF2Nq/zjzK

xy/cX7YetrEtLuHwg7XEII4Y8k+smZnTHalmWj5u5Vx2GtLPIY3O2ubx18tb bb1sSlaFtgKKXEEnhmFa

ax06fU7TMTGsps1WDwuSzuVYxWMaU/eXJk2igAGqlKOxKRqTHbPuxxi5W3aO fH3IjFycbec82zOXSr23

Gk2zjlulycuEvzSga6Ex5P8A15+MYcFuV5u5XynK+ZdxWSA91KQ408g8TbrS vS4gmUwZR6envjsi4LY+

Fw1xl7ssNK9ttA4nnVahI+jaTsjWfZTeGO0s5605JadLC8hdLWnRTqEgtz/y EnujG+Tcxh72oubdpWRV

a49xV0hakoYXKRXxSqDLaY6Rnxy5zHNQ3d1g+XsXwNZi/dN0tIUpm2APCD1k hW6OX5cp8HScMY8ZY2W5

faZxwymNuTeWB0WSJLRrLzd/YI1j281KZYcXHg9ctcutZpq6Up9TKmSkJAAI PEDX6oZ9tHXhs1qLFwZl

vGXM23FPoYc2y4lBMx16GYjX5OLZ15pn32Kxtlf5G0ecdWbNtLragpKePiCP LIg6/wAz9kZjsmYanGIm

YeMvi8faWinre7L7nuobDcxMJKVT4pbeNB7pdcXHsmZTLGIhqVK0NY6Ww3IZ 5PbCU3F7dOOEDjUyhKUJ

JGoPECTLsjlOeTpWPvV8xYMYsMXDL35iyuk8TLhEjQHX6QdIuHZaZ4UvYwuN t8W3kszcOtNXJlbsMgFx

Q/ePECO2JPbN1CxhERcqM5hmrO1YyFm8q5x11o24oSUlWvlV9Ri4dl8SmeFc x4L2MLjbfFt5LM3DrTVy

ZW7DIBcUP3jxAjtiT2zdQsYREXKjN4VqztWMhZPKuMddaNuKElJVr5VfUYuH ZfEpnhXMeC6xwtgMOcvl

X3WrRauBptkArUQSJzMxUGJl2zdQuOEVcoy+EsWsS1lsbcLes3FcCkOgBaTM jWQG0SpDDsm6kywirhpS

qYNY6xLmlRrWFiZ67d8LFlgEue7Nn3pcPqdDUq9Z1jFsZyzCwkz/AEae+6T4 wti/j/Cp5tYPlsky6vf4

j9YXCy/j/DP5XYZf5pw9veWyEW717bpdBdqguAGYKjHLumYwmvc1E/F9C+TX vitfyLkG+YbXOOZZPtBx

bDjAt+H2klHthR4+GX7Y+d0R2aRrVLcW0fM/Ofx/YfHOY5W5fscnx5VaHmje Ka9tDyFIM+IKBTojYIs9

ee0ZZUuWXCv+3hLb3yDZm4t0pW1a3C2VF4LPHwgaIn+6TE9T9jGE8vmOYTd5 LmjMXN+x7l25e3BuCu4C

VcYdUCDM7JSjpjHEcMzKpOIShQlZp4U0T+bTIT1010jWvw/lm303mFkD+2bH I/LhIGcP8r3gR/8AI7rx

zjzV/l/Z0/q5b4ktkj5G5YV+USki+bPuC5CiNFa8E9Y69sfRPCYzywvlRhK/ lnmsm1S5+vXqbgIn5U7J

6Rz64+mOP5bmeXeYVHt/22ZBIbDAOc1Slz3hVraP8InVH+X9jLwaX4sXdN/I XL67aZc/ONpUUmR9tflc

nLZwEx7e/GPxz+iYw8/KBaT8kcxBgzSLxRkNAFkAr1/jnF9LP0R+h5uyyvNX xRz0i0uOaHbzAZ+3YTbu

3TCS7brCKHRLmkyTqAR1mPNHX2dfGPOKzUuY58+Ohy5j7LOYzJt5jl3JK4LW +bEiFyJCVgaahJkR1EGU

d+nv2mpisoSnQ/AabQ5PmN98OFbOJdKfYID4QpQ4y1P7eg4Ts74x66ZrH9Wo aQ3HwcU6W3MOo1/mWu3r

mIsfm/2sxSv5M50wHMacI3h2bppvE2n5NS7zgLi0p4fbmpBM9AZxfT9eWEzf mWxuVXFf+LZ1bE/zIQun

qkGjLfHfPxh6uv7ZcWhYM6x0hxdByUppXM9oF/8AOUA/vBtUoz2eDfV9zD5s ccPMeQ92fEHZCf7oA4f9

MoYeCdn3S3/KKuLlbOh7/tkoWQT+97R4u/RMYz8YdOv7ZU8m3r1vy9nbplXC 6whK0E7ClKiIZ+J1zUS2

q2GOYTieYbBMrhm4YRfMioCXE8U/4K/wxmJrhutqyhzPO6//ANVfjq9r/wCl EdOvwce37pafirWOrm9l

wSNYtjZ4fBKyCV3d07+UxbJ/n3S9Jy+ymdTHPLKnTHC+fI5q5kZyS2bazQWs dZJ4LdJ0KtAJnq0GkZxi

jszvw8G1+RFBNth0on7Hsq9uVKI3SjOHm33eQlY/9ZPKcql4ezPr95M5f6oT 9x/Q+RFBNthktz9j2Ve3

KlEbpQwk7vIQsH4zdU5VLw9mfX7yZy/1Q/sf9a7C3rGO5UC8+Pexl45w2ltw 8TkiTxKnMSGkxt+uJl48

LjNY8+Ceardp7lm1uMK8hWFtSONhAPFxEy4lEmZIKtQeucXCeTsj6ePBx6Xd DWO8S4JLtaxbRPu67d8L

VjMXyWuPiZS9OUvc4tJfwlMZtJi1pyrWv6Nn6nP2+eFpr8Q5VrX9Gz9Tn7fP CzX4q15OTvuNsIbWkgpK

eMSI1B9UQ1+L6i58l/G/NqbO656xt1acw2iEtf1bGgFLyRT3ET0+iR7DLSPB +HPCfo+34rTC5+zvxl/4

vc2PLmIub3IOlATkr8ABpIUFK4Egg+YCWgEZ17LvKv0XKJmHzzlnm2+5dzFn msZbW7V9ZL42yQuSgRwr

QrzelSSQYZRExVOMRTvsjzb/AG88x5FzPZzFZXE5i6PuZG1tAHGHXZeZSVJM pq2mSZxxxjPHiKlqalw/

OvNPJuSytujlPADG4i0YDCU3M1PPL41KLzhSs6kKA1UaR067jx5SYbLMfIWE f+GrPktFosZZjJG9X5P0

vtlS1aK4+Pi8/VGdfr2XyaTkPmbH4Dm3DZq9s0flcfcofeLCVKd4Ugz4ApYB Osa7JvGYWIa/njmrHZ7n

zPZyztE/k8jdKfYFwkpd4SAPOErIB06443URFQ1T7V8X3vLY/t7vHOYbBxzF LzakuNWKi24kq9rhcTxK

1IrKesTCMt4mOJpMvBFjzr8U8oBzJco4+/yHMJQpFrcZOQaY4wQVSB1MjsHe I9U4dmfGUxGPwTZ8susi

89eO3dyo3D7zpefWv7a1K4lTl1mPZhFQRD6LcZH4Jy8rt20y2BulHiftLThe Znt4ComX1D6I8v8Amx44

klrue+fMRkcDjuVuW7R6x5cxa1PIVcqCrh95XF53JTCR51aT2xerqmMpyy+6 UloOS+dsjylzCzmLFIWp

sFt9hcwl1pfqQqX0TB2GPR29cZ41LdO0vch8DZi4VknmMziH3j7lxj7QNLZ4 zqfbKuKQJ+j6BHlxjux4

4lnhyHOmU5Uu7q3Tyxjnsdj7Zn21G4WFvPucRUXXJEyMjKU49HVtH3Tcltdy 5zQ/g75boQXrZ4BNwyTK

YFCD1iOmUW7YZ6tk/c/HLzhuQL5ji8yrVsJCZnZrxS7lRmJlqdGku8qw1lze 4htdqy0pCrZCzxKBQkAl

WpnxEExry5Ymebhv73mDk7OFNzlmbqyvkpCXV23CUrlSoV/h3xiLh0nLHLxY ua5tsP6R/RMHbuMWRM33

nZe45rM0JrKs+zSLEc3KZZxVQxsJzDaWGEy9i8h1T1+gJZUkJKQeFQ85Kgdu wRZjlMcqiYOUOalYG+Wp

5Ljli8JPNJkVAj0qSCQJ7K0iZY2deessbmTMMZTO3V/bpcQy97fClwAKHC2l BmAVCqeuNYcM5zc2wS8d

a7I6Wyhbxka9OuJY7O95u5JvLG2srqyvfYtQAhpvhQmcpTMnRPvjjUu854zF Oezt5yy621/Rba5YWCff

L5BBGnDLzr7Y1jfm55Tj5NixzHhcjhWMXnkvtrsv+1vGAFHhpwqB7NKRJip4 ajKJipY3MfMtndY+3w2K

acaxloeLjdl7ji9dVS/iJhEJnnxUeDJt+Y8LkcKxi88l9tdlpa3jACjwU4VA 9mlIVU8LGUTFSxuYuZbO

5x9vh8U041jLQ8XG7L3HF66ql/ETCITPO4qPBl2/MmByGBZxGdbfaNpL8vdW 4BMgJDiB+qmsSY5WMomK

lVkeZMTbYFWDwaHiw8v3Lq6uJBSjMUA/hEWI5Jyiqhz4eIBrHWJckl4616dc WxPvGe3fCxhl2tenXHOw

Lta9OuFieMqJlM9NsLEqUgE8SiewbzFse0uJOkpCDeLu+VXcdkrFVjcpH5lC Skg1W31jtTHPLF11cbzL

hH8TfLbUP5SjNC9hBoY82UU8ueFS0ighVRGWHiSRQRVQpIOpjE5LEPDi0hMt kcssm6a8tm5uAw1pPVxY

+ynafCMYYTnlSvpWN54urTkJ/ktFu0Mc7dpvfzB4vdStKUJCRrw8P8sbI+jP TG0ZR5RTGTnXbg8SpEyj

tCxCtTtaxbVPvkT1MQpKric58UEpBdRrMK+v/hFtXv8AMNiei/8AMPCIlJVc Mmc0r/zD/bFKQXrXWbbn

+cf7YWchdstZtO/eJ/2RDl696w1m0996n8OLZykvY3WbL/3qfw4HKfexYnNh /wC+R+FC05SbjFazt7j7

9H4ULOUm4xGs7e4+/R+DCysvb5n5jDif6a5+/R+DCysvb5pNziNf01z9+j8G FlZe3zDc4jX9Nc9v89H4

MLKy9vmgv4fX9Nc/fo/BhZWXt8z38Pr+mufv0fgwsrL2+YX8Pr+mufv0fgws rL2+Z7+H1/TXP36PwYWV

l7fML+H1/TXP36PwYWVl7fM9/D6/prn79H4MLKy9vmF/D6/prn79H4MLKy9v m8PPY0tqDLD6HNJKW6la

a7UhtH+MLItQXBrXp1wtoLta9OuFh7vm274WMcqrXv3xgOIAk6n6d8LEqcJn qZdXjCxBVWvfvhYsbUSq

QnONNRLZWl4u2cStlZS6gghwVBg7Y5OvbzmJzln+TzKQ059m4A0n1/8AL/hG MsbaywtyWa5Ru7JanLVQ

u7WqVtmZl9EcMsMoeXLrpz65oJSoFJFQdDHnnJKUOPpG2Oc5Kq/LXtx6U+03 tcWJfUKmNYdGWfwhqmdb

2rFq2UNAzOq1mqj1mPodfXGEVCSuKpTr0640gVVr374AVVr374AVVr374AVV r374AVVr374AVVr374AV

Vr374AVVr374AVVr374AVVr374AVVr374AVVr374AVVr374AVVr374AVVr37 4AVVr374AVVr374AVVr3

74AVVr374AVVr374AVVr374AVVr374AVVr374AVVr374AVVr374AVVr374AV Vr374Bxeb7W+Axi7Wuyu

+IgXa12V3wAu1rsrvgHuFRIHESZSHjAXKfDU0pJK/tK6uyLYlFzKdYttxLNT e8KAJmZ1MV0jNcjJOIB4

VqT9BlEb3VXF027P3Ehf8QnCeWZr3MVTrKJ8CAn6ABEjGI8mZlS7cTnWLbnM qlO1rs6GM2yF2tdld8AL

ta7K74AXa12V3wAu1rsrvgBdrXZXfAC7Wuyu+AF2tdld8ALta7K74AXa12V3 wAu1rsrvgBdrXZXfAC7W

uyu+AF2tdld8ALta7K74AXa12V3wAu1rsrvgBdrXZXfAC7Wuyu+AF2tdld8A Lta7K74AXa12V3wAu1rs

rvgBdrXZXfAC7Wuyu+AF2tdld8ALta7K74AXa12V3wAu1rsrvgHu+b7W+AxC 56q7K74yBc9Vdld8AKyZ

gcWzoYC0u+0FBJPuGqursi2Ki56q7K74lj0HDM1lpXfFiR7VcklR12dDF2W0 m5OtenXC1sVcnXU9++Fl

vC3zrXp1xLS3lTh81dld8SxBc9Vdld8EC56q7K74AXPVXZXfAC56q7K74AXP VXZXfAC56q7K74AXPVXZ

XfAC56q7K74AXPVXZXfAC56q7K74AXPVXZXfAC56q7K74AXPVXZXfAC56q7K 74AXPVXZXfAC56q7K74A

XPVXZXfAC56q7K74AXPVXZXfAC56q7K74AXPVXZXfAC56q7K74AXPVXZXfAC 56q7K74AXPVXZXfAC56q

7K74AXPVXZXfAC56q7K74AXPVXZXfAT7nm+1vpBVRQ7rOXb5h4w1lAod1nLt 8w8YayJCHwTKu3UeMKkQ

UO6zl2+YeMNZAod1nLt8w8YayHA9rTt8w8YayBQ7rOXb5h4w1kCh3Wcu3zDx hrIFDus5dvmHjDWQKHdZ

y7fMPGGsgUO6zl2+YeMNZAod1nLt8w8YayBQ7rOXb5h4w1kCh3Wcu3zDxhrI FDus5dvmHjDWQKHdZy7f

MPGGsgUO6zl2+YeMNZAod1nLt8w8YayBQ7rOXb5h4w1kCh3Wcu3zDxhrIFDu s5dvmHjDWQKHdZy7fMPG

GsgUO6zl2+YeMNZAod1nLt8w8YayBQ7rOXb5h4w1kCh3Wcu3zDxhrIFDus5d vmHjDWQKHdZy7fMPGGsg

UO6zl2+YeMNZAod1nLt8w8YayBQ7rOXb5h4w1kCh3Wcu3zDxhrIFDus5dvmH jDWQKHdZy7fMPGGsgUO6

zl2+YeMNZAod1nLt8w8YayBQ7rOXb5h4w1kCh3Wcu3zDxhrIFDus5dvmHjDW QKHdZy7fMPGGshwPT7f4
h4w1kf/Z
</property>
</structure>
</list-property>
</report>

Raishad Maharaj wrote:
> Jason,
>
> I am running the report from the viewer and exporting to PDF.
> One thing that I didn't make clear was that I am wanting to modify the
> Header Row on the table.
>
> Because I just tried the script on a header item like you had in your
> original example and exported to a pdf from the viewer and it worked!
> So is there a way to make that script work to hide the header row on the
> table, or maybe another method?
>
> Thanks
>
>
> Jason Weathersby wrote:
>> Raishad,
>>
>> How are you running it? If you are using a runandrender task it will
>> only fire once. If you use the viewer and and export to pdf it will
>> work. If you want to use the api you use a run task to create a
>> report document and then do a render task on the report document and
>> it should work.
>>
>> Jason
>>
>> Raishad Maharaj wrote:
>>> Jason,
>>>
>>> That seems to work for the html output, but it seems when I output to
>>> PDF - that script is only being run once for the first page. It
>>> doesn't seem to be firing for each page.
>>> Is there any way to change that?
>>>
>>> Thanks for all your help so far,
>>> Raishad
>>>
>>> Jason Weathersby wrote:
>>>> Raishad,
>>>>
>>>> Take a look at the onrender script for the image on the header on
>>>> the master page in the attached example.
>>>>
>>>> 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 <2.3.2.v20090218-0730></property>
>>>> <property name="units">in</property>
>>>> <property name="iconFile">/templates/blank_report.gif</property>
>>>> <property name="bidiLayoutOrientation">ltr</property>
>>>> <data-sources>
>>>> <oda-data-source
>>>> extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data
>>>> Source" id="7">
>>>> <property
>>>> name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver </property>
>>>>
>>>> <property
>>>> name="odaURL">jdbc:classicmodels:sampledb</property>
>>>> <property name="odaUser">ClassicModels</property>
>>>> <property name="OdaConnProfileName"></property>
>>>> </oda-data-source>
>>>> </data-sources>
>>>> <data-sets>
>>>> <oda-data-set
>>>> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
>>>> name="Data Set" id="8">
>>>> <list-property name="columnHints">
>>>> <structure>
>>>> <property name="columnName">ORDERNUMBER</property>
>>>> <property name="displayName">ORDERNUMBER</property>
>>>> </structure>
>>>> <structure>
>>>> <property name="columnName">PRODUCTCODE</property>
>>>> <property name="displayName">PRODUCTCODE</property>
>>>> </structure>
>>>> <structure>
>>>> <property
>>>> name="columnName">QUANTITYORDERED</property>
>>>> <property
>>>> name="displayName">QUANTITYORDERED</property>
>>>> </structure>
>>>> <structure>
>>>> <property name="columnName">PRICEEACH</property>
>>>> <property name="displayName">PRICEEACH</property>
>>>> </structure>
>>>> <structure>
>>>> <property
>>>> name="columnName">ORDERLINENUMBER</property>
>>>> <property
>>>> name="displayName">ORDERLINENUMBER</property>
>>>> </structure>
>>>> </list-property>
>>>> <structure name="cachedMetaData">
>>>> <list-property name="resultSet">
>>>> <structure>
>>>> <property name="position">1</property>
>>>> <property name="name">ORDERNUMBER</property>
>>>> <property name="dataType">integer</property>
>>>> </structure>
>>>> <structure>
>>>> <property name="position">2</property>
>>>> <property name="name">PRODUCTCODE</property>
>>>> <property name="dataType">string</property>
>>>> </structure>
>>>> <structure>
>>>> <property name="position">3</property>
>>>> <property
>>>> name="name">QUANTITYORDERED</property>
>>>> <property name="dataType">integer</property>
>>>> </structure>
>>>> <structure>
>>>> <property name="position">4</property>
>>>> <property name="name">PRICEEACH</property>
>>>> <property name="dataType">float</property>
>>>> </structure>
>>>> <structure>
>>>> <property name="position">5</property>
>>>> <property
>>>> name="name">ORDERLINENUMBER</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">ORDERNUMBER</property>
>>>> <property name="nativeName">ORDERNUMBER</property>
>>>> <property name="dataType">integer</property>
>>>> <property name="nativeDataType">4</property>
>>>> </structure>
>>>> <structure>
>>>> <property name="position">2</property>
>>>> <property name="name">PRODUCTCODE</property>
>>>> <property name="nativeName">PRODUCTCODE</property>
>>>> <property name="dataType">string</property>
>>>> <property name="nativeDataType">12</property>
>>>> </structure>
>>>> <structure>
>>>> <property name="position">3</property>
>>>> <property name="name">QUANTITYORDERED</property>
>>>> <property
>>>> name="nativeName">QUANTITYORDERED</property>
>>>> <property name="dataType">integer</property>
>>>> <property name="nativeDataType">4</property>
>>>> </structure>
>>>> <structure>
>>>> <property name="position">4</property>
>>>> <property name="name">PRICEEACH</property>
>>>> <property name="nativeName">PRICEEACH</property>
>>>> <property name="dataType">float</property>
>>>> <property name="nativeDataType">8</property>
>>>> </structure>
>>>> <structure>
>>>> <property name="position">5</property>
>>>> <property name="name">ORDERLINENUMBER</property>
>>>> <property
>>>> name="nativeName">ORDERLINENUMBER</property>
>>>> <property name="dataType">integer</property>
>>>> <property name="nativeDataType">5</property>
>>>> </structure>
>>>> </list-property>
>>>> <property name="queryText">select *
>>>> from orderdetails</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>ORDERNUMBER</design:name>
>>>> <design:position>1</design:position>
>>>> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
>>>> <design:precision>10</design:precision>
>>>> <design:scale>0</design:scale>
>>>> <design:nullability>Nullable</design:nullability>
>>>> <design:uiHints>
>>>> <design:displayName>ORDERNUMBER</design:displayName>
>>>> </design:uiHints>
>>>> </design:attributes>
>>>> <design:usageHints>
>>>> <design:label>ORDERNUMBER</design:label>
>>>> <design:formattingHints>
>>>> <design:displaySize>11</design:displaySize>
>>>> </design:formattingHints>
>>>> </design:usageHints>
>>>> </design:resultColumnDefinitions>
>>>> <design:resultColumnDefinitions>
>>>> <design:attributes>
>>>> <design:name>PRODUCTCODE</design:name>
>>>> <design:position>2</design:position>
>>>> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>>>> <design:precision>15</design:precision>
>>>> <design:scale>0</design:scale>
>>>> <design:nullability>Nullable</design:nullability>
>>>> <design:uiHints>
>>>> <design:displayName>PRODUCTCODE</design:displayName>
>>>> </design:uiHints>
>>>> </design:attributes>
>>>> <design:usageHints>
>>>> <design:label>PRODUCTCODE</design:label>
>>>> <design:formattingHints>
>>>> <design:displaySize>15</design:displaySize>
>>>> </design:formattingHints>
>>>> </design:usageHints>
>>>> </design:resultColumnDefinitions>
>>>> <design:resultColumnDefinitions>
>>>> <design:attributes>
>>>> <design:name>QUANTITYORDERED</design:name>
>>>> <design:position>3</design:position>
>>>> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
>>>> <design:precision>10</design:precision>
>>>> <design:scale>0</design:scale>
>>>> <design:nullability>Nullable</design:nullability>
>>>> <design:uiHints>
>>>> <design:displayName>QUANTITYORDERED</design:displayName>
>>>> </design:uiHints>
>>>> </design:attributes>
>>>> <design:usageHints>
>>>> <design:label>QUANTITYORDERED</design:label>
>>>> <design:formattingHints>
>>>> <design:displaySize>11</design:displaySize>
>>>> </design:formattingHints>
>>>> </design:usageHints>
>>>> </design:resultColumnDefinitions>
>>>> <design:resultColumnDefinitions>
>>>> <design:attributes>
>>>> <design:name>PRICEEACH</design:name>
>>>> <design:position>4</design:position>
>>>> <design:nativeDataTypeCode>8</design:nativeDataTypeCode>
>>>> <design:precision>15</design:precision>
>>>> <design:scale>0</design:scale>
>>>> <design:nullability>Nullable</design:nullability>
>>>> <design:uiHints>
>>>> <design:displayName>PRICEEACH</design:displayName>
>>>> </design:uiHints>
>>>> </design:attributes>
>>>> <design:usageHints>
>>>> <design:label>PRICEEACH</design:label>
>>>> <design:formattingHints>
>>>> <design:displaySize>22</design:displaySize>
>>>> </design:formattingHints>
>>>> </design:usageHints>
>>>> </design:resultColumnDefinitions>
>>>> <design:resultColumnDefinitions>
>>>> <design:attributes>
>>>> <design:name>ORDERLINENUMBER</design:name>
>>>> <design:position>5</design:position>
>>>> <design:nativeDataTypeCode>5</design:nativeDataTypeCode>
>>>> <design:precision>5</design:precision>
>>>> <design:scale>0</design:scale>
>>>> <design:nullability>Nullable</design:nullability>
>>>> <design:uiHints>
>>>> <design:displayName>ORDERLINENUMBER</design:displayName>
>>>> </design:uiHints>
>>>> </design:attributes>
>>>> <design:usageHints>
>>>> <design:label>ORDERLINENUMBER</design:label>
>>>> <design:formattingHints>
>>>> <design:displaySize>6</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="report" id="4">
>>>> <property name="fontFamily">"Verdana"</property>
>>>> <property name="fontSize">10pt</property>
>>>> </style>
>>>> <style name="crosstab" id="5">
>>>> <property name="borderBottomColor">#CCCCCC</property>
>>>> <property name="borderBottomStyle">solid</property>
>>>> <property name="borderBottomWidth">1pt</property>
>>>> <property name="borderLeftColor">#CCCCCC</property>
>>>> <property name="borderLeftStyle">solid</property>
>>>> <property name="borderLeftWidth">1pt</property>
>>>> <property name="borderRightColor">#CCCCCC</property>
>>>> <property name="borderRightStyle">solid</property>
>>>> <property name="borderRightWidth">1pt</property>
>>>> <property name="borderTopColor">#CCCCCC</property>
>>>> <property name="borderTopStyle">solid</property>
>>>> <property name="borderTopWidth">1pt</property>
>>>> </style>
>>>> <style name="crosstab-cell" id="6">
>>>> <property name="borderBottomColor">#CCCCCC</property>
>>>> <property name="borderBottomStyle">solid</property>
>>>> <property name="borderBottomWidth">1pt</property>
>>>> <property name="borderLeftColor">#CCCCCC</property>
>>>>

Report message to a moderator

Previous Topic:	embedding charts/images in report
Next Topic:	Deploying BIRT Report Engine for a PDE plugin?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 25 21:37:33 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter