First few pages are empty in report

Hi 
 
We are using BIRT 2.5 for developing reports. My report structure contains an outer table and inside the footer of this table, the main table/list is present. This type of outer table is used for customizing the data values for the purpose of Export Data feature. 
 
The issue here is, when i generate the report in viewer, if the report is supposed to contain 15 pages, it is generated with some 25 pages out of which first few pages remains empty and after the empty pages, the data is presented. The number of empty pages is dependent on the number of data being generated. Larger the data, more number of empty pages. 
 
I am not able to attach the report in this forum so am pasting the xml code here.This connects to the sample db. This outer most table is unavoidable in our cases as customizing the values for Export Data feature is an essential functionality for our usage. 
 
 
<?xml version="1.0" encoding="UTF-8"?> 
<report xmlns="<a class='bbc_url' href='http://www.eclipse.org/birt/2005/design'>http://www.eclipse.org/birt/2005/design"</a> 
 
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> 
<property name="comments">Copyright (c) 2007 <<Your 
 
Company Name here>></property> 
<html-property name="description">Creates a blank report 
 
with no predefined content.</html-property> 
<text-property name="displayName">Blank 
 
Report</text-property> 
<property 
 
name="iconFile">/templates/blank_report.gif</property> 
<property name="layoutPreference">auto layout</property> 
<parameters> 
<scalar-parameter name="NewParameter" id="8"> 
<property name="valueType">dynamic</property> 
<property name="isRequired">false</property> 
<property name="dataSetName">Data Set</property> 
<expression 
 
name="valueExpr">dataSetRow["CUSTOMERNUMBER"]</expression> 
<property name="dataType">string</property> 
<simple-property-list name="defaultValue"> 
<value type="constant">(All Customers)</value> 
</simple-property-list> 
<property name="paramType">simple</property> 
<property name="controlType">list-box</property> 
<property name="mustMatch">true</property> 
<property name="fixedOrder">true</property> 
<property name="distinct">true</property> 
<structure name="format"> 
<property 
 
name="category">Unformatted</property> 
</structure> 
</scalar-parameter> 
</parameters> 
<data-sources> 
<oda-data-source 
 
extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data 
 
Source" id="6"> 
<property 
 
name="odaDriverClass">org.eclipse.birt.report.data.oda.sampled 
 
b.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.JdbcSelectD 
 
ataSet" name="Data Set" id="7"> 
<list-property name="columnHints"> 
<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">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">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 
 
customernumber 
from customers]]></xml-property> 
<xml-property name="designerValues"><![CDATA[<?xml 
 
version="1.0" encoding="UTF-8"?> 
<model:DesignValues 
 
xmlns:design="<a class='bbc_url' href='http://www.eclipse.org/datatools/connectivity/od'>http://www.eclipse.org/datatools/connectivity/od</a> 
 
a/design" 
 
xmlns:model="<a class='bbc_url' href='http://www.eclipse.org/birt/report/model/adapter/'>http://www.eclipse.org/birt/report/model/adapter/</a> 
 
odaModel"> 
<Version>1.0</Version> 
<design:ResultSets derivedMetaData="true"> 
<design:resultSetDefinitions> 
<design:resultSetColumns> 
<design:resultColumnDefinitions> 
<design:attributes> 
<design:name>CUSTOMERNUMBER</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>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> 
<oda-data-set 
 
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectD 
 
ataSet" name="reportdataset" id="10"> 
<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> 
<method name="beforeOpen"><![CDATA[if( 
 
params["NewParameter"].value != "(All Customers)" ){ 
 
this.queryText = this.queryText + " where customernumber = " + 
 
params["NewParameter"].value 
}]]></method> 
<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> 
</oda-data-set> 
</data-sets> 
<styles> 
<style name="crosstab" id="4"> 
<property 
 
name="borderBottomColor">#CCCCCC</property> 
<property 
 
name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1pt</property> 
<property 
 
name="borderLeftColor">#CCCCCC</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1pt</property> 
<property 
 
name="borderRightColor">#CCCCCC</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1pt</property> 
<property name="borderTopColor">#CCCCCC</property> 
<property name="borderTopStyle">solid</property> 
<property name="borderTopWidth">1pt</property> 
</style> 
<style name="crosstab-cell" id="5"> 
<property 
 
name="borderBottomColor">#CCCCCC</property> 
<property 
 
name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1pt</property> 
<property 
 
name="borderLeftColor">#CCCCCC</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1pt</property> 
<property 
 
name="borderRightColor">#CCCCCC</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1pt</property> 
<property name="borderTopColor">#CCCCCC</property> 
<property name="borderTopStyle">solid</property> 
<property name="borderTopWidth">1pt</property> 
</style> 
<style name="detail" id="92"> 
<property 
 
name="backgroundColor">#BACAE2</property> 
<property name="fontFamily">"Arial"</property> 
<property name="fontSize">small</property> 
<property name="paddingTop">0px</property> 
<property name="paddingLeft">0px</property> 
<property name="paddingBottom">0px</property> 
<property name="paddingRight">0px</property> 
</style> 
<style name="headerfooter" id="93"> 
<property 
 
name="backgroundColor">#004080</property> 
<property name="fontFamily">"Arial"</property> 
<property name="fontSize">small</property> 
<property name="fontWeight">bold</property> 
<property name="color">#FFFFFF</property> 
</style> 
<style name="groupheader" id="94"> 
<property 
 
name="backgroundColor">#0080FF</property> 
<property name="fontFamily">"Arial"</property> 
<property name="fontSize">small</property> 
<property name="fontWeight">bold</property> 
<property name="color">#FFFFFF</property> 
</style> 
</styles> 
<page-setup> 
<simple-master-page name="Simple MasterPage" id="2"> 
<property name="topMargin">1in</property> 
<property name="leftMargin">1.25in</property> 
<property name="bottomMargin">1in</property> 
<property name="rightMargin">1.25in</property> 
</simple-master-page> 
</page-setup> 
<body> 
<table id="95"> 
<property name="dataSet">reportdataset</property> 
<list-property name="boundDataColumns"> 
<structure> 
<property 
 
name="name">ORDERNUMBER</property> 
<expression 
 
name="expression">dataSetRow["ORDERNUMBER"]</expression> 
<property 
 
name="dataType">integer</property> 
</structure> 
<structure> 
<property name="name">ORDERDATE</property> 
<expression 
 
name="expression">dataSetRow["ORDERDATE"]</expression> 
<property name="dataType">date</property> 
</structure> 
<structure> 
<property 
 
name="name">REQUIREDDATE</property> 
<expression 
 
name="expression">dataSetRow["REQUIREDDATE"]</expression> 
<property name="dataType">date</property> 
</structure> 
<structure> 
<property 
 
name="name">SHIPPEDDATE</property> 
<expression 
 
name="expression">dataSetRow["SHIPPEDDATE"]</expression> 
<property name="dataType">date</property> 
</structure> 
<structure> 
<property name="name">STATUS</property> 
<expression 
 
name="expression">dataSetRow["STATUS"]</expression> 
<property 
 
name="dataType">string</property> 
</structure> 
<structure> 
<property name="name">COMMENTS</property> 
<expression 
 
name="expression">dataSetRow["COMMENTS"]</expression> 
<property 
 
name="dataType">string</property> 
</structure> 
<structure> 
<property 
 
name="name">CUSTOMERNUMBER</property> 
<expression 
 
name="expression">dataSetRow["CUSTOMERNUMBER"]</expression> 
<property 
 
name="dataType">integer</property> 
</structure> 
</list-property> 
<column id="102"/> 
<header> 
<row id="96"> 
<cell id="97"/> 
</row> 
</header> 
<detail> 
<row id="98"> 
<cell id="99"/> 
</row> 
</detail> 
<footer> 
<row id="100"> 
<cell id="101"> 
<table id="45"> 
<property 
 
name="width">100%</property> 
<property 
 
name="dataSet">reportdataset</property> 
<list-property 
 
name="boundDataColumns"> 
<structure> 
<property 
 
name="name">ORDERNUMBER</property> 
<expression 
 
name="expression">dataSetRow["ORDERNUMBER"]</expression> 
<property 
 
name="dataType">integer</property> 
</structure> 
<structure> 
<property 
 
name="name">ORDERDATE</property> 
<expression 
 
name="expression">dataSetRow["ORDERDATE"]</expression> 
<property 
 
name="dataType">date</property> 
</structure> 
<structure> 
<property 
 
name="name">REQUIREDDATE</property> 
<expression 
 
name="expression">dataSetRow["REQUIREDDATE"]</expression> 
<property 
 
name="dataType">date</property> 
</structure> 
<structure> 
<property 
 
name="name">SHIPPEDDATE</property> 
<expression 
 
name="expression">dataSetRow["SHIPPEDDATE"]</expression> 
<property 
 
name="dataType">date</property> 
</structure> 
<structure> 
<property 
 
name="name">STATUS</property> 
<expression 
 
name="expression">dataSetRow["STATUS"]</expression> 
<property 
 
name="dataType">string</property> 
</structure> 
<structure> 
<property 
 
name="name">COMMENTS</property> 
<expression 
 
name="expression">dataSetRow["COMMENTS"]</expression> 
<property 
 
name="dataType">string</property> 
</structure> 
<structure> 
<property 
 
name="name">CUSTOMERNUMBER</property> 
<expression 
 
name="expression">dataSetRow["CUSTOMERNUMBER"]</expression> 
<property 
 
name="dataType">integer</property> 
</structure> 
</list-property> 
<property 
 
name="pageBreakInterval">50</property> 
<column id="84"/> 
<column id="85"/> 
<column id="88"/> 
<column id="89"/> 
<column id="90"/> 
<header> 
<row id="46"> 
<property 
 
name="style">headerfooter</property> 
<cell id="47"> 
<label id="48"> 
<text-property 
 
name="text">ORDERNUMBER</text-property> 
</label> 
</cell> 
<cell id="49"> 
<label id="50"> 
<text-property 
 
name="text">ORDERDATE</text-property> 
</label> 
</cell> 
<cell id="55"> 
<label id="56"> 
<text-property 
 
name="text">STATUS</text-property> 
</label> 
</cell> 
<cell id="57"> 
<label id="58"> 
<text-property 
 
name="text">COMMENTS</text-property> 
</label> 
</cell> 
<cell id="59"> 
<label id="60"> 
<text-property 
 
name="text">CUSTOMERNUMBER</text-property> 
</label> 
</cell> 
</row> 
</header> 
<detail> 
<row id="61"> 
<property 
 
name="style">detail</property> 
<cell id="62"> 
<data id="63"> 
<property 
 
name="resultSetColumn">ORDERNUMBER</property> 
</data> 
</cell> 
<cell id="64"> 
<data id="65"> 
<property 
 
name="resultSetColumn">ORDERDATE</property> 
</data> 
</cell> 
<cell id="70"> 
<data id="71"> 
<property 
 
name="resultSetColumn">STATUS</property> 
</data> 
</cell> 
<cell id="72"> 
<data id="73"> 
<property 
 
name="resultSetColumn">COMMENTS</property> 
</data> 
</cell> 
<cell id="74"> 
<data id="75"> 
<property 
 
name="resultSetColumn">CUSTOMERNUMBER</property> 
</data> 
</cell> 
</row> 
</detail> 
<footer> 
<row id="76"> 
<property 
 
name="style">headerfooter</property> 
<cell id="77"/> 
<cell id="78"/> 
<cell id="81"/> 
<cell id="82"/> 
<cell id="83"/> 
</row> 
</footer> 
</table> 
</cell> 
</row> 
</footer> 
</table> 
</body> 
</report> 
 
 
I tried to delete the empty header and detail section in the outer table (as we are using only the footer) and it worked. But the problem is all the data from the report is not getting exported to CSV. only the first and the last page data is being exported. so deleting the header and detail did not work out. 
Any other solution to get rid of these empty pages? Please advice. 
 
Thank you 
 
Warm Regards 
Kanya

Find more posts tagged with

Comments

mwilliams

Hi Kanya,

I was going to suggest deleting the empty detail row until I saw at the bottom of your post that you have done that. So, if you don't delete the detail row, all of the data is being exported to CSV, but if you do, you only get the first and last page of the data?

IN_BIRTY

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="68844" data-time="1285677630" data-date="28 September 2010 - 05:40 AM">
Hi Kanya, 
 
I was going to suggest deleting the empty detail row until I saw at the bottom of your post that you have done that. So, if you don't delete the detail row, all of the data is being exported to CSV, but if you do, you only get the first and last page of the data? </blockquote>
 
 
 
Yes. That's absolutely correct. Deleting the empty header and detail affect the Export data functionality.

Hans_vd

What happens when you set the height of the header and detail rows to zero, instead of removing them?

IN_BIRTY

Setting up the height to zero did not work unfortunately.

But i ve made it to work thro another solution which I came across somewhere in this discussion forum. I kept the page interval for the table as 0 and the blank pages went off ! The export data is also working fine now.

Thank you all for your valuable assistance.

Regards
Kanya

mwilliams

Kanya,

Glad you got something to work for you. Let us know whenever you have questions!