BIRT Report Export (Excel) Error

I am running a report in BIRT Report Viewer. The report is generated and displayed fine. I can even export it to pdf but when i attempt to export the same report to excel I get an error message complaining about problems that occurred during load as per attachment. And the log file its pointing to has a number of entries of the message below:

XML ERROR in Table
REASON: Bad Value
FILE: C:\Users\david.mulenga\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.IE5\VV9PM27Q\Kwacha-Mover.xls
GROUP: Row
TAG: Cell
ATTRIB: Index
VALUE: 2

What could be wrong with my report?

Your usual great help will be much appreciated.

Find more posts tagged with

Comments

mwilliams

Can you try recreating this with the sample database? If you can't do that, try to recreate it with a new report with your data, just to see if it's maybe a glitch in your report. I've never seen an issue like this before, I don't believe.

janderegg

Hi CyberDVD,
There is currently a bug in the product related to multiple fonts defined for one element(a table in your case) which causes this issue when exporting to XLS.
I don't know if it is the same cause in your case but this has been corrected in the commercial version 11SP1 of BIRT which should be released at the end of Q1.
If you have access to the BETA you might want to check the Milestone 4 once it is released as the issue should already been resolved in it.
Hope it helps.
Janderegg

CyberDVD

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="72128" data-time="1294767639" data-date="11 January 2011 - 10:40 AM">
Can you try recreating this with the sample database? If you can't do that, try to recreate it with a new report with your data, just to see if it's maybe a glitch in your report. I've never seen an issue like this before, I don't believe. </blockquote>
 
Hi M Williams, 
 
Thanks for the reply and the pointers. 
I tried recreating the report but with no luck. Actually the previous version of the same report was working fine except it had logic-errors which i corrected in this report. That said, its less likely that its the database that is causing this error. 
 
regards, 
 
David

CyberDVD

<blockquote class='ipsBlockquote' data-author="'janderegg'" data-cid="72180" data-time="1294826550" data-date="12 January 2011 - 03:02 AM">
Hi CyberDVD, 
There is currently a bug in the product related to multiple fonts defined for one element(a table in your case) which causes this issue when exporting to XLS. 
I don't know if it is the same cause in your case but this has been corrected in the commercial version 11SP1 of BIRT which should be released at the end of Q1. 
If you have access to the BETA you might want to check the Milestone 4 once it is released as the issue should already been resolved in it. 
Hope it helps. 
Janderegg </blockquote>
 
 
Hi Janderegg, 
 
Thanks for the reply and the enlightenment. 
 
Suppose this problem is related to the "multiple fonts" bug, is there a workaround? And if so what is it? 
 
regards, 
 
David

janderegg

hi CyberDVD,
I think you should simply try to make sure you have only one font set for all the elements of your report in order to see if it is indeed this bug you have. If it's the case, I think it may work by setting only one font per element. In your case the error is on a table so I would make sure only one font is used in your table.
Hope it helps.
Janderegg

CyberDVD

<blockquote class='ipsBlockquote' data-author="'janderegg'" data-cid="72264" data-time="1294993326" data-date="14 January 2011 - 01:22 AM">
hi CyberDVD, 
I think you should simply try to make sure you have only one font set for all the elements of your report in order to see if it is indeed this bug you have. If it's the case, I think it may work by setting only one font per element. In your case the error is on a table so I would make sure only one font is used in your table. 
Hope it helps. 
Janderegg </blockquote>
 
Hi guys, 
 
Thanks for the help. Really appreciate it. 
 
I have found a workaround to this problem. If I put a label between a text field( bearing the header of the report) and the the table, I am able to export the report to excel just fine. What i don't understand though is how the label seems to be changing the report design. 
 
regards, 
 
David

mwilliams

That is very odd and very buggy sounding. Glad you found something that made it work, but please log a bug for this at http://www.birt-exchange.org/org/resources/bug-reporting/.

Nani goud

Hi all, i too have the same kind of problem. i am not able to find the root cause for thr same. three fields Description,Ship Quantity,total for order# are causing the problem.here i am attaching my report
Thanks in advance.

<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.21" id="1">
<property name="comments">NOTICE

THIS SOFTWARE IS THE PROPERTY OF AND CONTAINS
CONFIDENTIAL INFORMATION OF INFOR AND/OR ITS AFFILIATES
OR SUBSIDIARIES AND SHALL NOT BE DISCLOSED WITHOUT PRIOR
WRITTEN PERMISSION. LICENSED CUSTOMERS MAY COPY AND
ADAPT THIS SOFTWARE FOR THEIR OWN USE IN ACCORDANCE WITH
THE TERMS OF THEIR SOFTWARE LICENSE AGREEMENT.
ALL OTHER RIGHTS RESERVED.

(c) COPYRIGHT 2009 INFOR. ALL RIGHTS RESERVED.
THE WORD AND DESIGN MARKS SET FORTH HEREIN ARE
TRADEMARKS AND/OR REGISTERED TRADEMARKS OF INFOR
AND/OR ITS AFFILIATES AND SUBSIDIARIES. ALL RIGHTS
RESERVED. ALL OTHER TRADEMARKS LISTED HEREIN ARE
THE PROPERTY OF THEIR RESPECTIVE OWNERS.</property>
<property name="createdBy">Eclipse BIRT Designer Version 2.5.2.v20100208 Build <2.5.2.v20100210-0630></property>
<html-property name="description">Creates a blank report with no predefined content.</html-property>
<simple-property-list name="includeResource">
<value>i18n/WM_Packing_List_Custom</value>
</simple-property-list>
<property name="units">in</property>
<text-property name="displayName">Blank Report</text-property>
<property name="iconFile">/templates/blank_report.gif</property>
<property name="layoutPreference">auto layout</property>
<list-property name="libraries">
<structure>
<property name="fileName">lib/WMDatasource.rptlibrary</property>
<property name="namespace">WMDatasource</property>
</structure>
<structure>
<property name="fileName">lib/WMLayout.rptlibrary</property>
<property name="namespace">WMLayout</property>
</structure>
<structure>
<property name="fileName">lib/WMParameter.rptlibrary</property>
<property name="namespace">WMParameter</property>
</structure>
</list-property>
<list-property name="cssStyleSheets">
<structure>
<property name="fileName">css/wmbirt.css</property>
</structure>
</list-property>
<parameters>
<scalar-parameter name="p_uid" id="1381" extends="WMParameter.p_uid">
<text-property name="promptText" key="PL.Title"></text-property>
</scalar-parameter>
<parameter-group name="OrderNumber" id="344">
<text-property name="displayName" key="PL.OrderNumber"></text-property>
<parameters>
<scalar-parameter name="p_OrdStart" id="345">
<text-property name="promptText" key="PL.From"></text-property>
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="distinct">true</property>
<simple-property-list name="defaultValue">
<value type="constant">0</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="p_OrdEnd" id="346">
<text-property name="promptText" key="PL.To"></text-property>
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="distinct">true</property>
<simple-property-list name="defaultValue">
<value type="constant">ZZZZZZZZZZZ</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>
</parameters>
</parameter-group>
<parameter-group name="OrderDate" id="347">
<text-property name="displayName" key="PL.OrderDate"></text-property>
<parameters>
<scalar-parameter name="p_pOrderDateFrom" id="348">
<text-property name="promptText" key="PL.From"></text-property>
<property name="valueType">static</property>
<property name="isRequired">true</property>
<property name="dataType">date</property>
<property name="distinct">true</property>
<property name="paramType">simple</property>
<property name="concealValue">false</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Short Date</property>
<property name="pattern">Short Date</property>
</structure>
</scalar-parameter>
<scalar-parameter name="p_pOrderDateTo" id="349">
<method name="validate"><![CDATA[params["p_pOrderDateTo"] = DateTimeSpan.addDate(params["p_pOrderDateTo"], 0,0,1);
true;]]></method>
<text-property name="promptText" key="PL.To"></text-property>
<property name="valueType">static</property>
<property name="isRequired">true</property>
<property name="dataType">date</property>
<property name="distinct">true</property>
<property name="paramType">simple</property>
<property name="concealValue">false</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Short Date</property>
<property name="pattern">Short Date</property>
</structure>
</scalar-parameter>
</parameters>
</parameter-group>
<parameter-group name="CustomerOrder" id="350">
<text-property name="displayName" key="PL.CustomerOrder"></text-property>
<parameters>
<scalar-parameter name="p_ExtOrdStart" id="351">
<text-property name="promptText" key="PL.From"></text-property>
<property name="valueType">static</property>
<property name="dataType">string</property>
<simple-property-list name="defaultValue">
<value type="constant">0</value>
</simple-property-list>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="p_ExtOrderEnd" id="352">
<text-property name="promptText" key="PL.To"></text-property>
<property name="valueType">static</property>
<property name="dataType">string</property>
<simple-property-list name="defaultValue">
<value type="constant">ZZZZZZZZZZZZZZZ</value>
</simple-property-list>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
</parameters>
</parameter-group>
<scalar-parameter name="p_DATABASE" id="1379" extends="WMDatasource.p_DATABASE"/>
<scalar-parameter name="p_SCHEMA" id="1380" extends="WMDatasource.p_SCHEMA"/>
<scalar-parameter name="__offsetMin" id="1382" extends="WMParameter.__offsetMin"/>
</parameters>
<data-sources>
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="WMDataSource" id="946"
extends="WMDatasource.WMDataSource"/>
</data-sources>
<data-sets>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="PACKING LIST" id="9">
<list-property name="computedColumns">
<structure>
<property name="name">UNNAMED_14</property>
<expression name="expression">result = "";
if( row["UNNAMED_14_SRC"] != null )
{
result = row["UNNAMED_14_SRC"]+ ", ";
}
result;</expression>
<property name="dataType">any</property>
</structure>
<structure>
<property name="name">UNNAMED_26</property>
<expression name="expression">if( row["UNNAMED_26_SRC1"] == null || row["UNNAMED_26_SRC1"] == " " )
{
row["UNNAMED_26_SRC2"];
}
else
{
row["UNNAMED_26_SRC1"];
}</expression>
<property name="dataType">any</property>
</structure>
<structure>
<property name="name">UNNAMED_40</property>
<expression name="expression">if( row["B_ADDRESS1"] != null )
{
row["B_ADDRESS1"];
}
else if( row["B_ADDRESS1"] == " " )
{
row["B_ADDRESS2"];
}
else if( row["B_ADDRESS1"] == " " && row["B_ADDRESS2"] == " " )
{
row["B_ADDRESS3"];
}
else if( row["B_ADDRESS1"] == " " && row["B_ADDRESS2"] == " " && row["B_ADDRESS4"] == " " )
{
row["B_ADDRESS4"];
}</expression>
<property name="dataType">any</property>
</structure>
<structure>
<property name="name">UNNAMED_41</property>
<expression name="expression">if( row["C_ADDRESS1"] == null || row["C_ADDRESS1"] == " " )
{
row["C_ADDRESS2"];
}
else
{
row["C_ADDRESS1"];
}</expression>
<property name="dataType">any</property>
</structure>
<structure>
<property name="name">UNNAMED_46</property>
<expression name="expression">row["UNNAMED_46_SRC"] + ", ";</expression>
<property name="dataType">any</property>
</structure>
<structure>
<property name="name">UNNAMED_51</property>
<expression name="expression">if( row["C_CITY"] != null )
{
row["C_CITY"] + ", ";
}
else
{
row["C_CITY"];
}</expression>
<property name="dataType">any</property>
</structure>
<structure>
<property name="name">UNNAMED_55</property>
<expression name="expression">if( row["UNNAMED_55_SRC1"] == null || row["UNNAMED_55_SRC1"] == " " )
{
row["UNNAMED_55_SRC2"];
}
else
{
row["UNNAMED_55_SRC1"];
}</expression>
<property name="dataType">any</property>
</structure>
</list-property>
<list-property name="columnHints">
<structure>
<property name="columnName">ORDERDATE</property>
<text-property name="displayName">ORDERDATE</text-property>
</structure>
<structure>
<property name="columnName">ORDERKEY</property>
<text-property name="displayName">ORDERKEY</text-property>
</structure>
<structure>
<property name="columnName">STORERKEY</property>
<text-property name="displayName">STORERKEY</text-property>
</structure>
<structure>
<property name="columnName">REFERENCENUM</property>
<text-property name="displayName">REFERENCENUM</text-property>
</structure>
<structure>
<property name="columnName">SKU</property>
<text-property name="displayName">SKU</text-property>
</structure>
<structure>
<property name="columnName">DESCR</property>
<text-property name="displayName">DESCR</text-property>
</structure>
<structure>
<property name="columnName">UNNAMED_7</property>
<text-property name="displayName">UNNAMED_7</text-property>
</structure>
<structure>
<property name="columnName">STDNETWGT</property>
<text-property name="displayName">STDNETWGT</text-property>
</structure>
<structure>
<property name="columnName">CONSIGNEEKEY</property>
<text-property name="displayName">CONSIGNEEKEY</text-property>
</structure>
<structure>
<property name="columnName">C_COMPANY</property>
<text-property name="displayName">C_COMPANY</text-property>
</structure>
<structure>
<property name="columnName">C_ADDRESS1</property>
<text-property name="displayName">C_ADDRESS1</text-property>
</structure>
<structure>
<property name="columnName">C_CITY</property>
<text-property name="displayName">C_CITY</text-property>
</structure>
<structure>
<property name="columnName">C_ZIP</property>
<text-property name="displayName">C_ZIP</text-property>
</structure>
<structure>
<property name="columnName">UNNAMED_14_SRC</property>
<text-property name="displayName">UNNAMED_14_SRC</text-property>
</structure>
<structure>
<property name="columnName">C_STATE</property>
<text-property name="displayName">C_STATE</text-property>
</structure>
<structure>
<property name="columnName">C_COUNTRY</property>
<text-property name="displayName">C_COUNTRY</text-property>
</structure>
<structure>
<property name="columnName">C_ISOCNTRYCODE</property>
<text-property name="displayName">C_ISOCNTRYCODE</text-property>
</structure>
<structure>
<property name="columnName">DOOR</property>
<text-property name="displayName">DOOR</text-property>
</structure>
<structure>
<property name="columnName">ROUTE</property>
<text-property name="displayName">ROUTE</text-property>
</structure>
<structure>
<property name="columnName">STAGE</property>
<text-property name="displayName">STAGE</text-property>
</structure>
<structure>
<property name="columnName">STOP</property>
<text-property name="displayName">STOP</text-property>
</structure>
<structure>
<property name="columnName">COMPANY</property>
<text-property name="displayName">COMPANY</text-property>
</structure>
<structure>
<property name="columnName">ADDRESS1</property>
<text-property name="displayName">ADDRESS1</text-property>
</structure>
<structure>
<property name="columnName">ACTUALSHIPDATE</property>
<text-property name="displayName">ACTUALSHIPDATE</text-property>
</structure>
<structure>
<property name="columnName">EXTERNORDERKEY</property>
<text-property name="displayName">EXTERNORDERKEY</text-property>
</structure>
<structure>
<property name="columnName">UNNAMED_26_SRC1</property>
<text-property name="displayName">UNNAMED_26_SRC1</text-property>
</structure>
<structure>
<property name="columnName">UNNAMED_26_SRC2</property>
<text-property name="displayName">UNNAMED_26_SRC2</text-property>
</structure>
<structure>
<property name="columnName">B_COMPANY</property>
<text-property name="displayName">B_COMPANY</text-property>
</structure>
<structure>
<property name="columnName">B_CITY</property>
<text-property name="displayName">B_CITY</text-property>
</structure>
<structure>
<property name="columnName">B_STATE</property>
<text-property name="displayName">B_STATE</text-property>
</structure>
<structure>
<property name="columnName">B_ZIP</property>
<text-property name="displayName">B_ZIP</text-property>
</structure>
<structure>
<property name="columnName">B_COUNTRY</property>
<text-property name="displayName">B_COUNTRY</text-property>
</structure>
<structure>
<property name="columnName">STATE</property>
<text-property name="displayName">STATE</text-property>
</structure>
<structure>
<property name="columnName">ZIP</property>
<text-property name="displayName">ZIP</text-property>
</structure>
<structure>
<property name="columnName">B_STATE_34</property>
<text-property name="displayName">B_STATE_34</text-property>
</structure>
<structure>
<property name="columnName">B_ZIP_35</property>
<text-property name="displayName">B_ZIP_35</text-property>
</structure>
<structure>
<property name="columnName">UNNAMED_36</property>
<text-property name="displayName">UNNAMED_36</text-property>
</structure>
<structure>
<property name="columnName">UNNAMED_37</property>
<text-property name="displayName">UNNAMED_37</text-property>
</structure>
<structure>
<property name="columnName">BILLTOKEY</property>
<text-property name="displayName">BILLTOKEY</text-property>
</structure>
<structure>
<property name="columnName">COUNTRY</property>
<text-property name="displayName">COUNTRY</text-property>
</structure>
<structure>
<property name="columnName">B_ADDRESS1</property>
<text-property name="displayName">B_ADDRESS1</text-property>
</structure>
<structure>
<property name="columnName">B_ADDRESS2</property>
<text-property name="displayName">B_ADDRESS2</text-property>
</structure>
<structure>
<property name="columnName">B_ADDRESS3</property>
<text-property name="displayName">B_ADDRESS3</text-property>
</structure>
<structure>
<property name="columnName">B_ADDRESS4</property>
<text-property name="displayName">B_ADDRESS4</text-property>
</structure>
<structure>
<property name="columnName">UNNAMED_46_SRC</property>
<text-property name="displayName">UNNAMED_46_SRC</text-property>
</structure>
<structure>
<property name="columnName">B_COUNTRY_47</property>
<text-property name="displayName">B_COUNTRY_47</text-property>
</structure>
<structure>
<property name="columnName">C_ADDRESS2</property>
<text-property name="displayName">C_ADDRESS2</text-property>
</structure>
<structure>
<property name="columnName">C_ADDRESS3</property>
<text-property name="displayName">C_ADDRESS3</text-property>
</structure>
<structure>
<property name="columnName">C_ADDRESS4</property>
<text-property name="displayName">C_ADDRESS4</text-property>
</structure>
<structure>
<property name="columnName">ADDRESS2</property>
<text-property name="displayName">ADDRESS2</text-property>
</structure>
<structure>
<property name="columnName">ADDRESS3</property>
<text-property name="displayName">ADDRESS3</text-property>
</structure>
<structure>
<property name="columnName">ADDRESS4</property>
<text-property name="displayName">ADDRESS4</text-property>
</structure>
<structure>
<property name="columnName">UNNAMED_55_SRC1</property>
<text-property name="displayName">UNNAMED_55_SRC1</text-property>
</structure>
<structure>
<property name="columnName">UNNAMED_55_SRC2</property>
<text-property name="displayName">UNNAMED_55_SRC2</text-property>
</structure>
<structure>
<property name="columnName">ORIGINALQTY</property>
<text-property name="displayName">ORIGINALQTY</text-property>
</structure>
<structure>
<property name="columnName">UNNAMED_57</property>
<text-property name="displayName">UNNAMED_57</text-property>
</structure>
<structure>
<property name="columnName">UNNAMED_58</property>
<text-property name="displayName">UNNAMED_58</text-property>
</structure>
</list-property>
<list-property name="parameters">
<structure>
<property name="name">param_1</property>
<property name="paramName">p_OrdStart</property>
<property name="nativeName"></property>
<property name="dataType">string</property>
<property name="nativeDataType">1</property>
<property name="position">1</property>
<property name="isOptional">false</property>
<property name="allowNull">false</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">param_2</property>
<property name="paramName">p_OrdEnd</property>
<property name="nativeName"></property>
<property name="dataType">string</property>
<property name="nativeDataType">1</property>
<property name="position">2</property>
<property name="isOptional">false</property>
<property name="allowNull">false</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">param_3</property>
<property name="paramName">p_pOrderDateFrom</property>
<property name="nativeName"></property>
<property name="dataType">date</property>
<property name="nativeDataType">1</property>
<property name="position">3</property>
<property name="isOptional">false</property>
<property name="allowNull">false</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">param_4</property>
<property name="paramName">p_pOrderDateTo</property>
<property name="nativeName"></property>
<property name="dataType">date</property>
<property name="nativeDataType">1</property>
<property name="position">4</property>
<property name="isOptional">false</property>
<property name="allowNull">false</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">param_5</property>
<property name="paramName">p_ExtOrdStart</property>
<property name="nativeName"></property>
<property name="dataType">string</property>
<property name="nativeDataType">1</property>
<property name="position">5</property>
<property name="isOptional">false</property>
<property name="allowNull">false</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">param_6</property>
<property name="paramName">p_ExtOrderEnd</property>
<property name="nativeName"></property>
<property name="dataType">string</property>
<property name="nativeDataType">1</property>
<property name="position">6</property>
<property name="isOptional">false</property>
<property name="allowNull">false</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">ORDERDATE</property>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">ORDERKEY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">STORERKEY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">REFERENCENUM</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">SKU</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">DESCR</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">UNNAMED_7</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">STDNETWGT</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">CONSIGNEEKEY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">C_COMPANY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">C_ADDRESS1</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">C_CITY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">C_ZIP</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">UNNAMED_14_SRC</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">C_STATE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">C_COUNTRY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">C_ISOCNTRYCODE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">18</property>
<property name="name">DOOR</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">19</property>
<property name="name">ROUTE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">20</property>
<property name="name">STAGE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">21</property>
<property name="name">STOP</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">22</property>
<property name="name">COMPANY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">23</property>
<property name="name">ADDRESS1</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">24</property>
<property name="name">ACTUALSHIPDATE</property>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="position">25</property>
<property name="name">EXTERNORDERKEY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">26</property>
<property name="name">UNNAMED_26_SRC1</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">27</property>
<property name="name">UNNAMED_26_SRC2</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">28</property>
<property name="name">B_COMPANY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">29</property>
<property name="name">B_CITY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">30</property>
<property name="name">B_STATE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">31</property>
<property name="name">B_ZIP</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">32</property>
<property name="name">B_COUNTRY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">33</property>
<property name="name">STATE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">34</property>
<property name="name">ZIP</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">35</property>
<property name="name">B_STATE_34</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">36</property>
<property name="name">B_ZIP_35</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">37</property>
<property name="name">UNNAMED_36</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">38</property>
<property name="name">UNNAMED_37</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">39</property>
<property name="name">BILLTOKEY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">40</property>
<property name="name">COUNTRY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">41</property>
<property name="name">B_ADDRESS1</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">42</property>
<property name="name">B_ADDRESS2</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">43</property>
<property name="name">B_ADDRESS3</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">44</property>
<property name="name">B_ADDRESS4</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">45</property>
<property name="name">UNNAMED_46_SRC</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">46</property>
<property name="name">B_COUNTRY_47</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">47</property>
<property name="name">C_ADDRESS2</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">48</property>
<property name="name">C_ADDRESS3</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">49</property>
<property name="name">C_ADDRESS4</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">50</property>
<property name="name">ADDRESS2</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">51</property>
<property name="name">ADDRESS3</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">52</property>
<property name="name">ADDRESS4</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">53</property>
<property name="name">UNNAMED_55_SRC1</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">54</property>
<property name="name">UNNAMED_55_SRC2</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">55</property>
<property name="name">ORIGINALQTY</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">56</property>
<property name="name">UNNAMED_57</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">57</property>
<property name="name">UNNAMED_58</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">58</property>
<property name="name">UNNAMED_14</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">59</property>
<property name="name">UNNAMED_26</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">60</property>
<property name="name">UNNAMED_40</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">61</property>
<property name="name">UNNAMED_41</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">62</property>
<property name="name">UNNAMED_46</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">63</property>
<property name="name">UNNAMED_51</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">64</property>
<property name="name">UNNAMED_55</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">WMDataSource</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">ORDERDATE</property>
<property name="nativeName">ORDERDATE</property>
<property name="dataType">date-time</property>
<property name="nativeDataType">93</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">ORDERKEY</property>
<property name="nativeName">ORDERKEY</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">STORERKEY</property>
<property name="nativeName">STORERKEY</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">REFERENCENUM</property>
<property name="nativeName">REFERENCENUM</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">SKU</property>
<property name="nativeName">SKU</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">DESCR</property>
<property name="nativeName">DESCR</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">UNNAMED_7</property>
<property name="nativeName">UNNAMED_7</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">8</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">STDNETWGT</property>
<property name="nativeName">STDNETWGT</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">8</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">CONSIGNEEKEY</property>
<property name="nativeName">CONSIGNEEKEY</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">C_COMPANY</property>
<property name="nativeName">C_COMPANY</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">C_ADDRESS1</property>
<property name="nativeName">C_ADDRESS1</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">C_CITY</property>
<property name="nativeName">C_CITY</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">C_ZIP</property>
<property name="nativeName">C_ZIP</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">UNNAMED_14_SRC</property>
<property name="nativeName">UNNAMED_14_SRC</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">C_STATE&l

mwilliams

Can you reproduce the issue with the sample database or in a report that uses some sample flat file or XML data, so that I can run the report? Thanks!

Nani goud

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="100039" data-time="1336405621" data-date="07 May 2012 - 08:47 AM">
Can you reproduce the issue with the sample database or in a report that uses some sample flat file or XML data, so that I can run the report? Thanks! </blockquote>
 
Hi Guru, 
 
i have attached the screen shot of the report,report file and the opened excel file also for comparison. the fields which are red marked are causing the problem in opening in excel file. here how i find these fields(description,ship qty,total for order#) only causing the problem is when i remove the tags in the generated excel sheet by using the help of errors(i have removed the entries with <cell index="2" />) the fields which are marked missing in the exported excel file an excel file opened. 
 
sorry for the delay in replay. 
and one more thing i don't know the exact way to reproduce the issue with the sample database as you asked, because i am new to the birt reports. 
 
Thanks in advance Guru

mwilliams

The sample database is an option to connect to when creating a new dataSource. You can they write a query against the sample db tables. This database helps because every BIRT install has it, so passing test reports is very easy when everyone has the same data!

If you can't reproduce the issue, let me know. Does your error message look just like the one posted by CyberDVD?

Nani goud

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="100172" data-time="1336593522" data-date="09 May 2012 - 12:58 PM">
The sample database is an option to connect to when creating a new dataSource. You can they write a query against the sample db tables. This database helps because every BIRT install has it, so passing test reports is very easy when everyone has the same data!

If you can't reproduce the issue, let me know. Does your error message look just like the one posted by CyberDVD? </blockquote>
 
Hi Guru, 
 
my Error is same as CyberDVD error. i am not able to create sample database for reproduce the defect. 
i am not able to find the exact root cause. 
thanks in advance

mwilliams

Can you post the log file that it tells you to look at, when the error pops up? Thanks!

Nani goud

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="100305" data-time="1336754245" data-date="11 May 2012 - 09:37 AM">
Can you post the log file that it tells you to look at, when the error pops up? Thanks! </blockquote>
 
 
Hi, 
 
PFA log file generated when the error popup

Nani goud

<blockquote class='ipsBlockquote' data-author="'Nani goud'" data-cid="100334" data-time="1336970465" data-date="13 May 2012 - 09:41 PM">
Hi, 
 
PFA log file generated when the error popup </blockquote>

mwilliams

Can you try using the Tribix XLS emitter instead to see if you still have the error? What is the data that is not showing? Are there any special characters or anything in the data?

http://www.birt-exchange.org/org/devshare/designing-birt-reports/33-tribix--extended-emitters-for-birt/

vijayshankar245

<blockquote class="ipsBlockquote" data-author="mwilliams" data-cid="100597" data-time="1337229165">
<div>
Can you try using the Tribix XLS emitter instead to see if you still have the error? What is the data that is not showing? Are there any special characters or anything in the data? <a data-ipb='nomediaparse' href='http://www.birt-exchange.org/org/devshare/designing-birt-reports/33-tribix--extended-emitters-for-birt/'>http://www.birt-exchange.org/org/devshare/designing-birt-reports/33-tribix--extended-emitters-for-birt/</a>
</div>
</blockquote>
Hi mWilliams
 
The above link you mentioned is not working. Can you please share the code to convert junk values to actual symbols in the string. In our report we are displaying the names from the database and its been exported to excel. but in excel output some of the special characters present in the names field are getting converted to junk values. Is there any way this can be done without emitter?

pricher

Hi,
 
Try this <a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/files/file/339-tribix-extended-emitters-for-birt/'>link</a>.
 
P.

vijayshankar245

<blockquote class="ipsBlockquote" data-author="pricher" data-cid="143045" data-time="1459260765">
<div>
Hi,
 
Try this <a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/files/file/339-tribix-extended-emitters-for-birt/'>link</a>.
 
P.
</div>
</blockquote>
Hi pierre
 
Can you please let me know a solution to remove the junk values without using an emitter.
 
I'm using commercial BIRT 4.4.0.