Excel - Birt table size doesn't fit the page excel size

Hello everyone!

I'm using Birt 3.7.0 as a Eclipse plugin
Context:
I have a table (Width 100%) on my Birt report. When i export it to Excel (Run -> View Report -> as XLS) everything goes fine (apparently). I have the Master Page set to "US Legal" type.

The problem shows up when i'm going to print that xls. Last column always stays on another page. I need the report to be shown in one page only. I tried setting "Orientation" to Landscape, but nothing happened, when i export the report, the table just resizes according the new format and the last column is left aside again.

Any solution?

Thank you all in advance!

Find more posts tagged with

Comments

kclark

Can you post your rptdesign using the sample db for me to look at?

mandfred

Thanks kclark!
I can't attach the file, "Error This upload failed". I tried as .xml, but same error, and as .rar seems it's not allowed

i can paste the XML here, if you want

kclark

Could you post the xml please? Thanks!

mandfred

<blockquote class='ipsBlockquote' data-author="'kclark'" data-cid="112136" data-time="1354807038" data-date="06 December 2012 - 08:17 AM"><p>
Could you post the xml please? Thanks!<br /></p></blockquote>
<br />
sure! of course<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.22" id="1">
<property name="comments">Copyright (c) 2007 <<Your Company Name here>></property>
<property name="createdBy">Eclipse BIRT Designer Version 3.7.0.v20110602 Build <3.7.0.v20110607-1526></property>
<html-property name="description">Creates a grouped report with a chart giving a visual representation of each group data.</html-property>
<property name="units">in</property>
<text-property name="displayName">Chart & Listing</text-property>
<property name="iconFile">/templates/chart_listing.gif</property>
<property name="cheatSheet">org.eclipse.birt.report.designer.ui.cheatsheet.chartlisting</property>
<property name="layoutPreference">auto layout</property>
<parameters>
<scalar-parameter name="pStartDate" id="60">
<property name="hidden">false</property>
<text-property name="promptText">Start Date</text-property>
<property name="valueType">static</property>
<property name="isRequired">true</property>
<property name="dataType">date</property>
<property name="distinct">true</property>
<simple-property-list name="defaultValue">
<value type="constant">2005-01-01</value>
</simple-property-list>
<property name="paramType">simple</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="pEndDate" id="61">
<property name="hidden">false</property>
<text-property name="promptText">End Date</text-property>
<property name="valueType">static</property>
<property name="dataType">date</property>
<property name="distinct">true</property>
<simple-property-list name="defaultValue">
<value type="constant">2005-05-31</value>
</simple-property-list>
<property name="paramType">simple</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="pDateInterval" id="62">
<property name="hidden">true</property>
<property name="valueType">static</property>
<property name="isRequired">true</property>
<property name="dataType">string</property>
<property name="distinct">true</property>
<simple-property-list name="defaultValue">
<value type="constant">D</value>
</simple-property-list>
<list-property name="selectionList">
<structure>
<property name="value">m</property>
<property name="label">Minute</property>
</structure>
<structure>
<property name="value">H</property>
<property name="label">Hour</property>
</structure>
<structure>
<property name="value">D</property>
<property name="label">Day</property>
</structure>
<structure>
<property name="value">W</property>
<property name="label">Week</property>
</structure>
<structure>
<property name="value">M</property>
<property name="label">Month</property>
</structure>
<structure>
<property name="value">Y</property>
<property name="label">Year</property>
</structure>
</list-property>
<property name="paramType">simple</property>
<property name="controlType">list-box</property>
<property name="mustMatch">false</property>
<property name="fixedOrder">true</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="pEmployee" id="84">
<text-property name="promptText">Employee</text-property>
<property name="valueType">dynamic</property>
<property name="isRequired">false</property>
<property name="dataSetName">Employees</property>
<expression name="valueExpr">dataSetRow["EMPLOYEENUMBER"]</expression>
<expression name="labelExpr">dataSetRow["EMPLOYEE"]</expression>
<expression name="sortByColumn">dataSetRow["EMPLOYEE"]</expression>
<property name="sortDirection">asc</property>
<property name="dataType">integer</property>
<property name="distinct">true</property>
<simple-property-list name="defaultValue">
<value type="constant">1165</value>
</simple-property-list>
<property name="paramType">simple</property>
<property name="controlType">list-box</property>
<property name="mustMatch">false</property>
<property name="fixedOrder">false</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
</parameters>
<data-sources>
<script-data-source name="Date Ranger Source" id="42"/>
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source" id="82">
<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>
<script-data-set name="Date Ranger Data" id="59">
<list-property name="resultSetHints">
<structure>
<property name="position">1</property>
<property name="name">DateTimeRange</property>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">DateRange</property>
<property name="dataType">date</property>
</structure>
</list-property>
<list-property name="columnHints">
<structure>
<property name="columnName">DateTimeRange</property>
</structure>
<structure>
<property name="columnName">DateRange</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">DateTimeRange</property>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">DateRange</property>
<property name="dataType">date</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Date Ranger Source</property>
<method name="open"><![CDATA[var startDate = params["pStartDate"].value;
var endDate = params["pEndDate"].value;
var dateInterval = params["pDateInterval"].value;

// ************************************************************
// DO NOT MODIFY BELOW THIS LINE

importPackage(Packages.java.util);
importPackage(Packages.java.text);

dateRangeStart = Calendar.getInstance();
dateRangeStart.setTime(startDate);
dateRangeEnd = Calendar.getInstance();
dateRangeEnd.setTime(endDate);

dateRangeIntervalType = Calendar.DATE;
switch (dateInterval.charAt(0)) {
case 'S':
case 's':
dateRangeIntervalType = Calendar.SECOND;
break;
case 'm':
dateRangeIntervalType = Calendar.MINUTE;
break;
case 'H':
case 'h':
dateRangeIntervalType = Calendar.HOUR_OF_DAY;
break;
case 'D':
case 'd':
dateRangeIntervalType = Calendar.DATE;
break;
case 'W':
case 'w':
dateRangeIntervalType = Calendar.WEEK_OF_YEAR;
break;
case 'M':
dateRangeIntervalType = Calendar.MONTH;
break;
case 'Y':
case 'y':
dateRangeIntervalType = Calendar.YEAR;
break;
default:
dateRangeIntervalType = Calendar.DATE;
break;
}

dateRangeFormatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");]]></method>
<method name="fetch"><![CDATA[var dateVal;
if (dateRangeStart.compareTo(dateRangeEnd) <= 0) {
dateVal = dateRangeFormatter.format(dateRangeStart.getTime());
dateRangeStart.add(dateRangeIntervalType, 1);
row["DateTimeRange"] = dateVal;
row["DateRange"] = dateVal;
return true;
} else {
return false;
}]]></method>
</script-data-set>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Main Data Set" id="83">
<list-property name="columnHints">
<structure>
<property name="columnName">EMPLOYEENUMBER</property>
<text-property name="displayName">EMPLOYEENUMBER</text-property>
</structure>
<structure>
<property name="columnName">EMPLOYEE</property>
<text-property name="displayName">EMPLOYEE</text-property>
</structure>
<structure>
<property name="columnName">ORDERDATE</property>
<text-property name="displayName">ORDERDATE</text-property>
</structure>
<structure>
<property name="columnName">PRICE</property>
<text-property name="displayName">PRICE</text-property>
</structure>
</list-property>
<list-property name="parameters">
<structure>
<property name="name">param_1</property>
<property name="paramName">pEmployee</property>
<property name="nativeName"></property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
<property name="position">1</property>
<property name="isOptional">true</property>
<property name="allowNull">true</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">param_2</property>
<property name="paramName">pStartDate</property>
<property name="nativeName"></property>
<property name="dataType">date</property>
<property name="nativeDataType">91</property>
<property name="position">2</property>
<property name="isOptional">true</property>
<property name="allowNull">true</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">param_3</property>
<property name="paramName">pEndDate</property>
<property name="nativeName"></property>
<property name="dataType">date</property>
<property name="nativeDataType">91</property>
<property name="position">3</property>
<property name="isOptional">true</property>
<property name="allowNull">true</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">EMPLOYEENUMBER</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">EMPLOYEE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">ORDERDATE</property>
<property name="dataType">date</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">PRICE</property>
<property name="dataType">float</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">EMPLOYEENUMBER</property>
<property name="nativeName">EMPLOYEENUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">EMPLOYEE</property>
<property name="nativeName">EMPLOYEE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</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">4</property>
<property name="name">PRICE</property>
<property name="nativeName">PRICE</property>
<property name="dataType">float</property>
<property name="nativeDataType">8</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[select e.employeenumber, e.firstName || ' ' || e.lastname as employee,
o.orderdate, od.priceeach * od.quantityordered as price
from employees e, customers c, orders o, orderdetails od
where e.employeenumber = c.salesrepemployeenumber
and c.customernumber = o.customernumber
and o.ordernumber = od.ordernumber
and e.employeenumber = ?
and o.orderdate >= ?
and o.orderdate <= ?
]]></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:DataSetParameters>
<design:parameterDefinitions>
<design:inOutMode>In</design:inOutMode>
<design:attributes>
<design:name></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:attributes>
<design:inputAttributes>
<design:elementAttributes>
<design:optional>true</design:optional>
</design:elementAttributes>
</design:inputAttributes>
</design:parameterDefinitions>
<design:parameterDefinitions>
<design:inOutMode>In</design:inOutMode>
<design:attributes>
<design:name></design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>91</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:inputAttributes>
<design:elementAttributes>
<design:optional>true</design:optional>
</design:elementAttributes>
</design:inputAttributes>
</design:parameterDefinitions>
<design:parameterDefinitions>
<design:inOutMode>In</design:inOutMode>
<design:attributes>
<design:name></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:attributes>
<design:inputAttributes>
<design:elementAttributes>
<design:optional>true</design:optional>
</design:elementAttributes>
</design:inputAttributes>
</design:parameterDefinitions>
</design:DataSetParameters>
</model:DesignValues>]]></xml-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Employees" id="85">
<list-property name="columnHints">
<structure>
<property name="columnName">EMPLOYEE</property>
<text-property name="displayName">EMPLOYEE</text-property>
</structure>
<structure>
<property name="columnName">EMPLOYEENUMBER</property>
<text-property name="displayName">EMPLOYEENUMBER</text-property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">EMPLOYEE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">EMPLOYEENUMBER</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">EMPLOYEE</property>
<property name="nativeName">EMPLOYEE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">EMPLOYEENUMBER</property>
<property name="nativeName">EMPLOYEENUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[select firstname || ' ' || lastname as employee, employeenumber
from employees]]></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>EMPLOYEE</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>101</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>EMPLOYEE</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>EMPLOYEE</design:label>
<design:formattingHints>
<design:displaySize>101</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>EMPLOYEENUMBER</design:name>
<design:position>2</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>EMPLOYEENUMBER</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>EMPLOYEENUMBER</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>
<joint-data-set name="Chart Data Set" id="88">
<list-property name="parameters">
<structure>
<property name="name">Main Data Set::param_1</property>
<property name="dataType">integer</property>
<property name="position">1</property>
<property name="isOptional">true</property>
<property name="allowNull">true</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">Main Data Set::param_2</property>
<property name="dataType">date</property>
<property name="position">2</property>
<property name="isOptional">true</property>
<property name="allowNull">true</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">Main Data Set::param_3</property>
<property name="dataType">date</property>
<property name="position">3</property>
<property name="isOptional">true</property>
<property name="allowNull">true</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">Date Ranger Data::DateTimeRange</property>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">Date Ranger Data::DateRange</property>
<property name="dataType">date</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">Main Data Set::EMPLOYEENUMBER</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">Main Data Set::EMPLOYEE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">Main Data Set::ORDERDATE</property>
<property name="dataType">date</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">Main Data Set::PRICE</property>
<property name="dataType">float</property>
</structure>
</list-property>
</structure>
<simple-property-list name="dataSets">
<value>Date Ranger Data</value>
<value>Main Data Set</value>
</simple-property-list>
<list-property name="joinConditions">
<structure>
<property name="joinType">left-out</property>
<property name="joinOperator">eq</property>
<property name="leftDataSet">Date Ranger Data</property>
<property name="rightDataSet">Main Data Set</property>
<expression name="leftExpression">dataSetRow["DateRange"]</expression>
<expression name="rightExpression">dataSetRow["ORDERDATE"]</expression>
</structure>
</list-property>
</joint-data-set>
</data-sets>
<styles>
<style name="crosstab" id="37">
<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="38">
<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="type">us-legal</property>
<property name="topMargin">0.25in</property>
<property name="leftMargin">0.25in</property>
<property name="bottomMargin">0.25px</property>
<property name="rightMargin">0.25in</property>
</simple-master-page>
</page-setup>
<body>
<table id="91">
<property name="width">100%</property>
<property name="dataSet">Main Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">EMPLOYEENUMBER</property>
<text-property name="displayName">EMPLOYEENUMBER</text-property>
<expression name="expression" type="javascript">dataSetRow["EMPLOYEENUMBER"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">EMPLOYEE</property>
<text-property name="displayName">EMPLOYEE</text-property>
<expression name="expression" type="javascript">dataSetRow["EMPLOYEE"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">ORDERDATE</property>
<text-property name="displayName">ORDERDATE</text-property>
<expression name="expression" type="javascript">dataSetRow["ORDERDATE"]</expression>
<property name="dataType">date</property>
</structure>
<structure>
<property name="name">PRICE</property>
<text-property name="displayName">PRICE</text-property>
<expression name="expression" type="javascript">dataSetRow["PRICE"]</expression>
<property name="dataType">float</property>
</structure>
</list-property>
<column id="115"/>
<column id="116"/>
<column id="117"/>
<column id="118"/>
<header>
<row id="92">
<cell id="93">
<label id="94">
<text-property name="text">EMPLOYEENUMBER</text-property>
</label>
</cell>
<cell id="95">
<label id="96">
<text-property name="text">EMPLOYEE</text-property>
</label>
</cell>
<cell id="97">
<label id="98">
<text-property name="text">ORDERDATE</text-property>
</label>
</cell>
<cell id="99">
<label id="100">
<text-property name="text">PRICE</text-property>
</label>
</cell>
</row>
</header>
<detail>
<row id="101">
<cell id="102">
<data id="103">
<property name="resultSetColumn">EMPLOYEENUMBER</property>
</data>
</cell>
<cell id="104">
<data id="105">
<property name="resultSetColumn">EMPLOYEE</property>
</data>
</cell>
<cell id="106">
<data id="107">
<property name="resultSetColumn">ORDERDATE</property>
</data>
</cell>
<cell id="108">
<data id="109">
<property name="resultSetColumn">PRICE</property>
</data>
</cell>
</row>
</detail>
<footer>
<row id="110">
<cell id="111"/>
<cell id="112"/>
<cell id="113"/>
<cell id="114"/>
</row>
</footer>
</table>
</body>
</report>
</pre>

mandfred

FYI: I've just downloaded Birt last release, and happens the same

kclark

Thanks for the xml! I changed the orientation to Landscape in excel and everything worked fine for me. What XLS emitter are you using? If it's the default you may want to look at tribix xls emitter.

mandfred

no please, thank you for your answers!

When i view the in excel, i don't need to change the orientation. I set it on Birt, and then it propagates to excel. So when i open the report in excel, it is already shown as landscape (as it was prior set in Birt).

Anyway, i'll do a research, i know nothing about "emitter". Thank you kclark for give me a path! i'll be back later

mandfred

i installed tribix xml emitter. This is what it did: http://screencast.com/t/bWCH9Fnm
As you can see, the last column is in other page. So my problem still persists

any idea?

Yaytay

<blockquote class='ipsBlockquote' data-author="'mandfred'" data-cid="112151" data-time="1354817823" data-date="06 December 2012 - 11:17 AM"><p>
i installed tribix xml emitter. This is what it did: <a class='bbc_url' href='http://screencast.com/t/bWCH9Fnm'>http://screencast.com/t/bWCH9Fnm</a><br />
As you can see, the last column is in other page. So my problem still persists<br />
<br />
any idea?<br /></p></blockquote>
Try the SpudSoft emitter.<br />
<br />
It looks as though one of two things is happening: <br />
1. Excel uses funny units for the widths of columns, it might be that the translation from BIRT units to Excel units is resulting in things being slightly bigger.<br />
2. The emitters might be auto-sizing your columns to fit the content, and that's pushing things out.<br />
<br />
You might also have difficulty with relative measurements, widths of 100% don't mean anything to Excel and are particularly prone to interpretation by emitters: for example, the SpudSoft emitters completely ignores any percentage measurements.<br />
<br />
To achieve what you want with the SpudSoft emitter explicitly set the width of each column to an absolute measurement (which will normally be done by the UI if you drag to change the width f one column).<br />
<br />
Jim<br />
<br />
(edited to correct iOS auto-corrections)

mandfred

Thanks for answer Yaytay!
Yes, it could be any of those two, even both.

Anyway, i put every item into a Grid element, and then set Grid width to 90%. That was enough for me, fixed my situation.

it's likely I need to use some emitter from now on, because my next job will be to export charts to excel.
So I'll try SpudSoft and come with comments if there are any

Thank you again Yaytay