Skip to main content


Eclipse Community Forums

      Home
Home » Archived » BIRT » blank excel(When the report format is XLS, always the report is completely empty.)
blank excel [message #555156] Wed, 25 August 2010 12:01 Go to next message
Eclipse UserFriend
When the report format is XLS, always the report is completely empty. The server does not report any error or warning in logs, the excel is obtained but when you try to open it with excel, this reports a weird error that says that the file could be broken or it is in an unknown format. I tried to open it in many computers and ms office version as well.

The version of birt that we are using is 2.5.0

Thanks in advance for your time an cooperation!

Juan Holder
Re: blank excel [message #555247 is a reply to message #555156] Thu, 26 August 2010 00:20 Go to previous messageGo to next message
Eclipse UserFriend
What version of Excel are you using? Can you open it in Notepad?

On 8/25/2010 12:01 PM, juanholder@gmail.com wrote:
> When the report format is XLS, always the report is completely empty.
> The server does not report any error or warning in logs, the excel is
> obtained but when you try to open it with excel, this reports a weird
> error that says that the file could be broken or it is in an unknown
> format. I tried to open it in many computers and ms office version as well.
>
> The version of birt that we are using is 2.5.0
>
> Thanks in advance for your time an cooperation!
>
> Juan Holder
Re: blank excel [message #555369 is a reply to message #555247] Thu, 26 August 2010 08:47 Go to previous messageGo to next message
Eclipse UserFriend
I've tried to open it with excel 2000 / 2003 and 2007 with no success. Notepad can show the contents of the file, but it has 0 or 3 bytes of size, and it is blank too. The same report exported in other format like PDF is filled and obtained ok.

Thanks

Juan Holder
Re: blank excel [message #555460 is a reply to message #555369] Thu, 26 August 2010 12:30 Go to previous messageGo to next message
Eclipse UserFriend
Can you post the report?

Jason

On 8/26/2010 8:47 AM, juanholder@gmail.com wrote:
> I've tried to open it with excel 2000 / 2003 and 2007 with no success.
> Notepad can show the contents of the file, but it has 0 or 3 bytes of
> size, and it is blank too. The same report exported in other format like
> PDF is filled and obtained ok.
>
> Thanks
>
> Juan Holder
Re: blank excel [message #555634 is a reply to message #555460] Fri, 27 August 2010 09:09 Go to previous messageGo to next message
Eclipse UserFriend
I'm not allow to attach files.
Do you know how should I proceed to be allowed to?
Re: blank excel [message #555656 is a reply to message #555634] Fri, 27 August 2010 10:01 Go to previous messageGo to next message
Eclipse UserFriend
Can you email it to me at jasonweathersby at windstream dot net?

On 8/27/2010 9:10 AM, juanholder@gmail.com wrote:
> I'm not allow to attach files.
> Do you know how should I proceed to be allowed to?
Re: blank excel [message #555685 is a reply to message #555656] Fri, 27 August 2010 12:00 Go to previous messageGo to next message
Eclipse UserFriend
Thank you very much. I've sent the current report.

regards

JH
Re: blank excel [message #556334 is a reply to message #555685] Tue, 31 August 2010 16:22 Go to previous messageGo to next message
Eclipse UserFriend
Jason,
As you suggested me on the response of the email that carried the report source, I've tried to generate the report removing the visibility and the output unfortunately remains the same blank content.

Nevertheless, If I run the same report in PDF/DOC or HTML the report fills Ok.

Juan Holder

[Updated on: Tue, 31 August 2010 16:23] by Moderator

Re: blank excel [message #556350 is a reply to message #556334] Tue, 31 August 2010 18:05 Go to previous messageGo to next message
Eclipse UserFriend
How are you running the report? Using the webviewer? Do you get
anything in the log file?

On 8/31/2010 4:22 PM, juanholder@gmail.com wrote:
> Jason,
> As you suggested me on the response of the email that carried the report
> source, I've tried to generate the report removing the visibility and
> the output remains the same blank content.
>
> Nevertheless, If I run the same report in PDF/DOC or HTML the report
> fills Ok.
Re: blank excel [message #556579 is a reply to message #556350] Wed, 01 September 2010 17:20 Go to previous messageGo to next message
Eclipse UserFriend
Dear Jason,
I have performed the test you suggested me with the following result:

NOTE: we are using a custom servlet to serve the reports.

The experiment throwed to kind of errors, if the query of the report had almost one result or more, or if the report query had no rows.

* With rows returned by the query:

The obtained report has 0(zero) byte size. and in the log appeared the following exception. (remember in HTML,DOC or PDF all goes well with no errors).

	at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.IndexOutOfBoundsException: Index: 13, Size: 13
	at java.util.ArrayList.RangeCheck(ArrayList.java:547)
	at java.util.ArrayList.get(ArrayList.java:322)
	at org.eclipse.birt.report.engine.emitter.excel.DataCache.addData(DataCache.java:71)
	at org.eclipse.birt.report.engine.emitter.excel.layout.ExcelLayoutEngine.addDatatoCache(ExcelLayoutEngine.java:695)
	at org.eclipse.birt.report.engine.emitter.excel.layout.ExcelLayoutEngine.addData(ExcelLayoutEngine.java:595)
	at org.eclipse.birt.report.engine.emitter.excel.layout.ExcelLayoutEngine.endNormalContainer(ExcelLayoutEngine.java:422)
	at org.eclipse.birt.report.engine.emitter.excel.layout.ExcelLayoutEngine.endCell(ExcelLayoutEngine.java:257)
	at org.eclipse.birt.report.engine.emitter.excel.ExcelEmitter.endCell(ExcelEmitter.java:221)
	at org.eclipse.birt.report.engine.emitter.CompositeContentEmitter.endCell(CompositeContentEmitter.java:146)
	at org.eclipse.birt.report.engine.layout.html.HTMLTableLayoutEmitter.endCell(HTMLTableLayoutEmitter.java:720)
	at org.eclipse.birt.report.engine.layout.html.HTMLTableLayoutEmitter.endCell(HTMLTableLayoutEmitter.java:709)
	at org.eclipse.birt.report.engine.emitter.ContentEmitterUtil.endContent(ContentEmitterUtil.java:114)
	at org.eclipse.birt.report.engine.layout.html.buffer.DummyPageBuffer.endContainer(DummyPageBuffer.java:66)
	at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.end(HTMLStackingLM.java:42)
	at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:136)
	at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.resumeLayout(HTMLInlineStackingLM.java:106)
	at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.layoutNodes(HTMLInlineStackingLM.java:155)
	at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
	at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:135)
	at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:69)
	at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
	at org.eclipse.birt.report.engine.layout.html.HTMLTableBandLM.layoutChildren(HTMLTableBandLM.java:67)
	at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:135)
	at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:69)
	at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
	at org.eclipse.birt.report.engine.layout.html.HTMLGroupLM.layoutChildren(HTMLGroupLM.java:117)
	at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:135)
	at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:69)
	at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
	at org.eclipse.birt.report.engine.layout.html.HTMLTableLM.layoutChildren(HTMLTableLM.java:112)
	at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:135)
	at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:69)
	at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
	at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:135)
	at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.resumeLayout(HTMLInlineStackingLM.java:106)
	at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.layoutNodes(HTMLInlineStackingLM.java:155)
	at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
	at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:135)
	at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:69)
	at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
	at org.eclipse.birt.report.engine.layout.html.HTMLTableLM.layoutChildren(HTMLTableLM.java:112)
	at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:135)
	at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:69)
	at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90)
	at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:99)
	at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:167)
	... 49 more


only this in XLS export.

And when the report query return no rows (empty resultset), no message appeared in the LOG (which is in WARN LEVEL), and the obtained repord is filled with xml content, and a size of 16kbytes. In the content of the body appears our business params, and it is a well formed XML.

this is the xml content of this empty report:


<?xml version="1.0" encoding="UTF-8"?>
<?mso-application progid="Excel.Sheet"?>

<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
	xmlns:o="urn:schemas-microsoft-com:office:office"
	xmlns:x="urn:schemas-microsoft-com:office:excel"
	xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
	xmlns:html="http://www.w3.org/TR/REC-html40">
	<DocumentProperties
		xmlns="urn:schemas-microsoft-com:office:office">
		<Author />
		<Title />
		<Description />
	</DocumentProperties>
	<Styles>
		<Style ss:ID="HyperlinkId" ss:Name="Hyperlink">
			<Font ss:Underline="Single" ss:Color="#0000FF" />
		</Style>
		<Style ss:ID="34">
			<Alignment ss:Horizontal="Left" ss:Vertical="Top"
				ss:WrapText="1" />
			<Borders>
				<Border ss:Position="Bottom" />
				<Border ss:Position="Top" ss:LineStyle="Continuous"
					ss:Weight="1" ss:Color="#000000" />
				<Border ss:Position="Left" />
				<Border ss:Position="Right" />
			</Borders>
			<Font ss:FontName="Arial" ss:Size="5.0" ss:Bold="0"
				ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000" />
		</Style>
		<Style ss:ID="33">
			<Alignment ss:Horizontal="Left" ss:Vertical="Top"
				ss:WrapText="1" />
			<Borders>
				<Border ss:Position="Bottom" />
				<Border ss:Position="Top" ss:LineStyle="Continuous"
					ss:Weight="1" ss:Color="#000000" />
				<Border ss:Position="Left" />
				<Border ss:Position="Right" />
			</Borders>
			<Font ss:FontName="Arial" ss:Size="6.0" ss:Bold="0"
				ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000" />
		</Style>
		<Style ss:ID="36">
			<Alignment ss:Horizontal="Left" ss:Vertical="Top"
				ss:WrapText="1" />
			<Borders>
				<Border ss:Position="Bottom" />
				<Border ss:Position="Top" />
				<Border ss:Position="Left" />
				<Border ss:Position="Right" />
			</Borders>
			<Font ss:FontName="Arial" ss:Size="5.0" ss:Bold="0"
				ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000" />
		</Style>
		<Style ss:ID="29">
			<Alignment ss:Horizontal="Left" ss:Vertical="Top"
				ss:WrapText="1" />
			<Borders>
				<Border ss:Position="Bottom" />
				<Border ss:Position="Top" />
				<Border ss:Position="Left" />
				<Border ss:Position="Right" />
			</Borders>
			<Font ss:FontName="Courier New" ss:Size="8.0" ss:Bold="1"
				ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000" />
			<Interior ss:Color="#c0c0c0" ss:Pattern="Solid" />
		</Style>
		<Style ss:ID="31">
			<Alignment ss:Horizontal="Left" ss:Vertical="Top"
				ss:WrapText="1" />
			<Borders>
				<Border ss:Position="Bottom" ss:LineStyle="Continuous"
					ss:Weight="1" ss:Color="#000000" />
				<Border ss:Position="Top" />
				<Border ss:Position="Left" />
				<Border ss:Position="Right" />
			</Borders>
			<Font ss:FontName="Courier New" ss:Size="6.0" ss:Bold="0"
				ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000" />
		</Style>
		<Style ss:ID="20">
			<Alignment ss:Horizontal="Left" ss:Vertical="Top"
				ss:WrapText="1" />
			<Borders>
				<Border ss:Position="Bottom" />
				<Border ss:Position="Top" />
				<Border ss:Position="Left" />
				<Border ss:Position="Right" />
			</Borders>
			<Font ss:FontName="Arial" ss:Size="6.0" ss:Bold="0"
				ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000" />
		</Style>
		<Style ss:ID="21">
			<Alignment ss:Horizontal="Left" ss:Vertical="Top"
				ss:WrapText="1" />
			<Borders>
				<Border ss:Position="Bottom" />
				<Border ss:Position="Top" />
				<Border ss:Position="Left" />
				<Border ss:Position="Right" />
			</Borders>
			<Font ss:FontName="Arial" ss:Size="7.0" ss:Bold="0"
				ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000" />
		</Style>
		<Style ss:ID="1">
			<NumberFormat ss:Format="yyyy-M-d HH:mm:ss AM/PM" />
		</Style>
		<Style ss:ID="32">
			<Alignment ss:Horizontal="Left" ss:Vertical="Top"
				ss:WrapText="1" />
			<Borders>
				<Border ss:Position="Bottom" />
				<Border ss:Position="Top" />
				<Border ss:Position="Left" />
				<Border ss:Position="Right" />
			</Borders>
			<Font ss:FontName="Arial" ss:Size="8.0" ss:Bold="0"
				ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000" />
		</Style>
		<Style ss:ID="30">
			<Alignment ss:Horizontal="Left" ss:Vertical="Top"
				ss:WrapText="1" />
			<Borders>
				<Border ss:Position="Bottom" ss:LineStyle="Continuous"
					ss:Weight="1" ss:Color="#000000" />
				<Border ss:Position="Top" />
				<Border ss:Position="Left" />
				<Border ss:Position="Right" />
			</Borders>
			<Font ss:FontName="Courier New" ss:Size="7.0" ss:Bold="0"
				ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000" />
		</Style>
		<Style ss:ID="26">
			<Alignment ss:Horizontal="Left" ss:Vertical="Top"
				ss:WrapText="1" />
			<Borders>
				<Border ss:Position="Bottom" ss:LineStyle="Continuous"
					ss:Weight="1" ss:Color="#000000" />
				<Border ss:Position="Top" />
				<Border ss:Position="Left" />
				<Border ss:Position="Right" />
			</Borders>
			<Font ss:FontName="Courier New" ss:Size="8.0" ss:Bold="0"
				ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000" />
		</Style>
		<Style ss:ID="25">
			<Alignment ss:Horizontal="Left" ss:Vertical="Top"
				ss:WrapText="1" />
			<Borders>
				<Border ss:Position="Bottom" ss:LineStyle="Continuous"
					ss:Weight="1" ss:Color="#000000" />
				<Border ss:Position="Top" />
				<Border ss:Position="Left" />
				<Border ss:Position="Right" />
			</Borders>
			<Font ss:FontName="Courier New" ss:Size="8.0" ss:Bold="0"
				ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000" />
		</Style>
		<Style ss:ID="35">
			<Alignment ss:Horizontal="Right" ss:Vertical="Top"
				ss:WrapText="1" />
			<Borders>
				<Border ss:Position="Bottom" />
				<Border ss:Position="Top" ss:LineStyle="Continuous"
					ss:Weight="1" ss:Color="#000000" />
				<Border ss:Position="Left" />
				<Border ss:Position="Right" />
			</Borders>
			<Font ss:FontName="Arial" ss:Size="6.0" ss:Bold="0"
				ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000" />
		</Style>
		<Style ss:ID="27">
			<Alignment ss:Horizontal="Right" ss:Vertical="Top"
				ss:WrapText="1" />
			<Borders>
				<Border ss:Position="Bottom" />
				<Border ss:Position="Top" />
				<Border ss:Position="Left" />
				<Border ss:Position="Right" />
			</Borders>
			<Font ss:FontName="Courier New" ss:Size="7.0" ss:Bold="0"
				ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000" />
		</Style>
		<Style ss:ID="22">
			<Alignment ss:Horizontal="Right" ss:Vertical="Top"
				ss:WrapText="1" />
			<Borders>
				<Border ss:Position="Bottom" />
				<Border ss:Position="Top" />
				<Border ss:Position="Left" />
				<Border ss:Position="Right" />
			</Borders>
			<Font ss:FontName="Arial" ss:Size="6.0" ss:Bold="0"
				ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000" />
		</Style>
		<Style ss:ID="28">
			<Alignment ss:Horizontal="Right" ss:Vertical="Top"
				ss:WrapText="1" />
			<Borders>
				<Border ss:Position="Bottom" ss:LineStyle="Continuous"
					ss:Weight="1" ss:Color="#000000" />
				<Border ss:Position="Top" />
				<Border ss:Position="Left" />
				<Border ss:Position="Right" />
			</Borders>
			<Font ss:FontName="Courier New" ss:Size="7.0" ss:Bold="0"
				ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000" />
		</Style>
		<Style ss:ID="23">
			<Alignment ss:Horizontal="Center" ss:Vertical="Top"
				ss:WrapText="1" />
			<Borders>
				<Border ss:Position="Bottom" />
				<Border ss:Position="Top" />
				<Border ss:Position="Left" />
				<Border ss:Position="Right" />
			</Borders>
			<Font ss:FontName="Arial" ss:Size="9.0" ss:Bold="1"
				ss:Italic="0" ss:StrikeThrough="0" ss:Underline="Single"
				ss:Color="#000000" />
			<Interior ss:Color="#c0c0c0" ss:Pattern="Solid" />
		</Style>
		<Style ss:ID="24">
			<Alignment ss:Horizontal="Center" ss:Vertical="Top"
				ss:WrapText="1" />
			<Borders>
				<Border ss:Position="Bottom" ss:LineStyle="Continuous"
					ss:Weight="1" ss:Color="#000000" />
				<Border ss:Position="Top" />
				<Border ss:Position="Left" />
				<Border ss:Position="Right" />
			</Borders>
			<Font ss:FontName="Arial" ss:Size="6.0" ss:Bold="1"
				ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000" />
		</Style>
	</Styles>
	<Worksheet ss:Name="Sheet1">
		<ss:Table>
			<ss:Column ss:Width="41" />
			<ss:Column ss:Width="104" />
			<ss:Column ss:Width="32" />
			<ss:Column ss:Width="20" />
			<ss:Column ss:Width="10" />
			<ss:Column ss:Width="61" />
			<ss:Column ss:Width="94" />
			<ss:Column ss:Width="32" />
			<ss:Column ss:Width="12" />
			<ss:Column ss:Width="4" />
			<ss:Column ss:Width="16" />
			<ss:Column ss:Width="16" />
			<ss:Column ss:Width="94" />
			<ss:Column ss:Width="69" />
			<ss:Column ss:Width="200" />
			<ss:Column ss:Width="0" />
			<Row ss:AutoFitHeight="0" ss:Height="15.0">
				<Cell ss:Index="1" ss:StyleID="20" ss:MergeAcross="5"
					ss:MergeDown="0">
					<Data ss:Type="String">1</Data>
				</Cell>
				<Cell ss:Index="7" ss:StyleID="21" ss:MergeAcross="6"
					ss:MergeDown="0">
					<Data ss:Type="String" />
				</Cell>
				<Cell ss:Index="14" ss:StyleID="22" ss:MergeAcross="1"
					ss:MergeDown="0">
					<Data ss:Type="String" />
				</Cell>
			</Row>
			<Row ss:AutoFitHeight="0" ss:Height="15.0">
				<Cell ss:Index="1" ss:StyleID="20" ss:MergeAcross="5"
					ss:MergeDown="0">
					<Data ss:Type="String" />
				</Cell>
				<Cell ss:Index="7" ss:StyleID="21" ss:MergeAcross="6"
					ss:MergeDown="0">
					<Data ss:Type="String" />
				</Cell>
				<Cell ss:Index="14" ss:StyleID="22" ss:MergeAcross="1"
					ss:MergeDown="0">
					<Data ss:Type="String" />
				</Cell>
			</Row>
			<Row ss:AutoFitHeight="0" ss:Height="15.0">
				<Cell ss:Index="1" ss:StyleID="20" ss:MergeAcross="5"
					ss:MergeDown="0">
					<Data ss:Type="String" />
				</Cell>
				<Cell ss:Index="7" ss:StyleID="21" ss:MergeAcross="6"
					ss:MergeDown="0">
					<Data ss:Type="String" />
				</Cell>
				<Cell ss:Index="14" ss:StyleID="22" ss:MergeAcross="1"
					ss:MergeDown="0">
					<Data ss:Type="String" />
				</Cell>
			</Row>
			<Row ss:AutoFitHeight="0" ss:Height="15.0">
				<Cell ss:Index="1" ss:StyleID="23" ss:MergeAcross="14"
					ss:MergeDown="0">
					<Data ss:Type="String" />
				</Cell>
			</Row>
			<Row ss:AutoFitHeight="0" ss:Height="15.0">
				<Cell ss:Index="1" ss:StyleID="24" ss:MergeAcross="14"
					ss:MergeDown="0">
					<Data ss:Type="String">( null, null, null )</Data>
				</Cell>
			</Row>
			<Row ss:AutoFitHeight="0" ss:Height="15.0">
				<Cell ss:Index="1" ss:StyleID="25" ss:MergeAcross="1"
					ss:MergeDown="4">
					<Data ss:Type="String">Loan ID</Data>
				</Cell>
				<Cell ss:Index="3" ss:StyleID="26" ss:MergeAcross="2"
					ss:MergeDown="4">
					<Data ss:Type="String" />
				</Cell>
			</Row>
			<Row ss:AutoFitHeight="0" ss:Height="15.0">
				<Cell ss:Index="6" ss:StyleID="27" ss:MergeAcross="3"
					ss:MergeDown="0">
					<Data ss:Type="String">
						OUTSTANDING INCL ARREARS TOTAL
					</Data>
				</Cell>
				<Cell ss:Index="10" ss:StyleID="27" ss:MergeAcross="4"
					ss:MergeDown="0">
					<Data ss:Type="String">
						PENALTY INTEREST UNPAID, STOCK
					</Data>
				</Cell>
				<Cell ss:Index="15" ss:StyleID="27" ss:MergeAcross="0"
					ss:MergeDown="0">
					<Data ss:Type="String">
						PENALTY INTEREST ESTIMATED TOTAL
					</Data>
				</Cell>
			</Row>
			<Row ss:AutoFitHeight="0" ss:Height="15.0">
				<Cell ss:Index="6" ss:StyleID="27" ss:MergeAcross="3"
					ss:MergeDown="0">
					<Data ss:Type="String">At</Data>
				</Cell>
				<Cell ss:Index="10" ss:StyleID="27" ss:MergeAcross="4"
					ss:MergeDown="0">
					<Data ss:Type="String">At</Data>
				</Cell>
				<Cell ss:Index="15" ss:StyleID="27" ss:MergeAcross="0"
					ss:MergeDown="0">
					<Data ss:Type="String">At</Data>
				</Cell>
			</Row>
			<Row ss:AutoFitHeight="0" ss:Height="15.0">
				<Cell ss:Index="6" ss:StyleID="27" ss:MergeAcross="3"
					ss:MergeDown="0">
					<Data ss:Type="String">01.07.2005</Data>
				</Cell>
				<Cell ss:Index="10" ss:StyleID="27" ss:MergeAcross="4"
					ss:MergeDown="0">
					<Data ss:Type="String">01.07.2005</Data>
				</Cell>
				<Cell ss:Index="15" ss:StyleID="27" ss:MergeAcross="0"
					ss:MergeDown="0">
					<Data ss:Type="String">01.07.2005</Data>
				</Cell>
			</Row>
			<Row ss:AutoFitHeight="0" ss:Height="15.0">
				<Cell ss:Index="6" ss:StyleID="28" ss:MergeAcross="3"
					ss:MergeDown="0">
					<Data ss:Type="String" />
				</Cell>
				<Cell ss:Index="10" ss:StyleID="28" ss:MergeAcross="4"
					ss:MergeDown="0">
					<Data ss:Type="String" />
				</Cell>
				<Cell ss:Index="15" ss:StyleID="28" ss:MergeAcross="0"
					ss:MergeDown="0">
					<Data ss:Type="String" />
				</Cell>
			</Row>
			<Row ss:AutoFitHeight="0" ss:Height="15.0">
				<Cell ss:Index="1" ss:StyleID="29" ss:MergeAcross="2"
					ss:MergeDown="0">
					<Data ss:Type="String">GRAND TOTAL</Data>
				</Cell>
				<Cell ss:Index="6" ss:StyleID="27" ss:MergeAcross="3"
					ss:MergeDown="0">
					<Data ss:Type="String">
						OUTSTANDING INCL ARREARS TOTAL
					</Data>
				</Cell>
				<Cell ss:Index="10" ss:StyleID="27" ss:MergeAcross="4"
					ss:MergeDown="0">
					<Data ss:Type="String">
						PENALTY INTEREST UNPAID, STOCK
					</Data>
				</Cell>
				<Cell ss:Index="15" ss:StyleID="27" ss:MergeAcross="0"
					ss:MergeDown="0">
					<Data ss:Type="String">
						PENALTY INTEREST ESTIMATED TOTAL
					</Data>
				</Cell>
			</Row>
			<Row ss:AutoFitHeight="0" ss:Height="15.0">
				<Cell ss:Index="1" ss:StyleID="30" ss:MergeAcross="1"
					ss:MergeDown="2">
					<Data ss:Type="String">Loan ID</Data>
				</Cell>
				<Cell ss:Index="3" ss:StyleID="31" ss:MergeAcross="2"
					ss:MergeDown="2">
					<Data ss:Type="String" />
				</Cell>
				<Cell ss:Index="6" ss:StyleID="27" ss:MergeAcross="3"
					ss:MergeDown="0">
					<Data ss:Type="String">At</Data>
				</Cell>
				<Cell ss:Index="10" ss:StyleID="27" ss:MergeAcross="4"
					ss:MergeDown="0">
					<Data ss:Type="String">At</Data>
				</Cell>
				<Cell ss:Index="15" ss:StyleID="27" ss:MergeAcross="0"
					ss:MergeDown="0">
					<Data ss:Type="String">At</Data>
				</Cell>
			</Row>
			<Row ss:AutoFitHeight="0" ss:Height="15.0">
				<Cell ss:Index="6" ss:StyleID="27" ss:MergeAcross="3"
					ss:MergeDown="0">
					<Data ss:Type="String">01.07.2005</Data>
				</Cell>
				<Cell ss:Index="10" ss:StyleID="27" ss:MergeAcross="4"
					ss:MergeDown="0">
					<Data ss:Type="String">01.07.2005</Data>
				</Cell>
				<Cell ss:Index="15" ss:StyleID="27" ss:MergeAcross="0"
					ss:MergeDown="0">
					<Data ss:Type="String">01.07.2005</Data>
				</Cell>
			</Row>
			<Row ss:AutoFitHeight="0" ss:Height="15.0">
				<Cell ss:Index="6" ss:StyleID="28" ss:MergeAcross="3"
					ss:MergeDown="0">
					<Data ss:Type="String" />
				</Cell>
				<Cell ss:Index="10" ss:StyleID="28" ss:MergeAcross="4"
					ss:MergeDown="0">
					<Data ss:Type="String" />
				</Cell>
				<Cell ss:Index="15" ss:StyleID="28" ss:MergeAcross="0"
					ss:MergeDown="0">
					<Data ss:Type="String" />
				</Cell>
			</Row>
			<Row ss:AutoFitHeight="0" ss:Height="15.0">
				<Cell ss:Index="1" ss:StyleID="32" ss:MergeAcross="14"
					ss:MergeDown="0">
					<Data ss:Type="String" />
				</Cell>
				<Cell ss:Index="2" ss:StyleID="33" ss:MergeAcross="2"
					ss:MergeDown="0">
					<Data ss:Type="String">enterprise V6.0.0.00</Data>
				</Cell>
				<Cell ss:Index="8" ss:StyleID="34" ss:MergeAcross="0"
					ss:MergeDown="0">
					<Data ss:Type="String">Page:</Data>
				</Cell>
				<Cell ss:Index="9" ss:StyleID="34" ss:MergeAcross="1"
					ss:MergeDown="0">
					<Data ss:Type="String">1</Data>
				</Cell>
				<Cell ss:Index="11" ss:StyleID="34" ss:MergeAcross="0"
					ss:MergeDown="0">
					<Data ss:Type="String">/</Data>
				</Cell>
				<Cell ss:Index="12" ss:StyleID="34" ss:MergeAcross="0"
					ss:MergeDown="0">
					<Data ss:Type="String">1</Data>
				</Cell>
				<Cell ss:Index="13" ss:StyleID="35" ss:MergeAcross="2"
					ss:MergeDown="0">
					<Data ss:Type="String">enterpriseVWS</Data>
				</Cell>
			</Row>
			<Row ss:AutoFitHeight="0" ss:Height="15.0">
				<Cell ss:Index="1" ss:StyleID="36" ss:MergeAcross="0"
					ss:MergeDown="0">
					<Data ss:Type="String">Reference :</Data>
				</Cell>
				<Cell ss:Index="2" ss:StyleID="36" ss:MergeAcross="2"
					ss:MergeDown="0">
					<Data ss:Type="String" />
				</Cell>
				<Cell ss:Index="8" ss:StyleID="21" ss:MergeAcross="4"
					ss:MergeDown="0">
					<Data ss:Type="String" />
				</Cell>
				<Cell ss:Index="13" ss:StyleID="22" ss:MergeAcross="2"
					ss:MergeDown="0">
					<Data ss:Type="String">Sep 1, 2010 5:17 PM</Data>
				</Cell>
			</Row>
		</ss:Table>
		<WorksheetOptions
			xmlns="urn:schemas-microsoft-com:office:excel">
			<PageSetup />
		</WorksheetOptions>
	</Worksheet>
</Workbook>


hope this helps!

And thank you very much for your time and cooperation.

Juan Holder
Re: blank excel [message #556783 is a reply to message #556579] Thu, 02 September 2010 10:59 Go to previous messageGo to next message
Eclipse UserFriend
Juan,

Do you get the same issue if you run the report using the viewer? What
about in the designer(straight to xls)?

Jason

On 9/1/2010 5:20 PM, juanholder@gmail.com wrote:
> Dear Jason,
> I have performed the test you suggested me with the following result:
>
> NOTE: we are using a custom servlet to serve the reports.
>
> The experiment throwed to kind of errors, if the query of the report had
> almost one result or more, or if the report query had no rows.
>
> * With rows returned by the query:
>
> The obtained report has 0(zero) byte size. and in the log appeared the
> following exception. (remember in HTML,DOC or PDF all goes well with no
> errors).
>
> at java.lang.Thread.run(Thread.java:619)
> Caused by: java.lang.IndexOutOfBoundsException: Index: 13, Size: 13
> at java.util.ArrayList.RangeCheck(ArrayList.java:547)
> at java.util.ArrayList.get(ArrayList.java:322)
> at
> org.eclipse.birt.report.engine.emitter.excel.DataCache.addDa ta(DataCache.java:71)
>
> at
> org.eclipse.birt.report.engine.emitter.excel.layout.ExcelLay outEngine.addDatatoCache(ExcelLayoutEngine.java:695)
>
> at
> org.eclipse.birt.report.engine.emitter.excel.layout.ExcelLay outEngine.addData(ExcelLayoutEngine.java:595)
>
> at
> org.eclipse.birt.report.engine.emitter.excel.layout.ExcelLay outEngine.endNormalContainer(ExcelLayoutEngine.java:422)
>
> at
> org.eclipse.birt.report.engine.emitter.excel.layout.ExcelLay outEngine.endCell(ExcelLayoutEngine.java:257)
>
> at
> org.eclipse.birt.report.engine.emitter.excel.ExcelEmitter.en dCell(ExcelEmitter.java:221)
>
> at
> org.eclipse.birt.report.engine.emitter.CompositeContentEmitt er.endCell(CompositeContentEmitter.java:146)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLTableLayoutEm itter.endCell(HTMLTableLayoutEmitter.java:720)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLTableLayoutEm itter.endCell(HTMLTableLayoutEmitter.java:709)
>
> at
> org.eclipse.birt.report.engine.emitter.ContentEmitterUtil.en dContent(ContentEmitterUtil.java:114)
>
> at
> org.eclipse.birt.report.engine.layout.html.buffer.DummyPageB uffer.endContainer(DummyPageBuffer.java:66)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.en d(HTMLStackingLM.java:42)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:136)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLInlineStackin gLM.resumeLayout(HTMLInlineStackingLM.java:106)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLInlineStackin gLM.layoutNodes(HTMLInlineStackingLM.java:155)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.la youtChildren(HTMLStackingLM.java:26)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:135)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking LM.layoutNodes(HTMLBlockStackingLM.java:69)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.la youtChildren(HTMLStackingLM.java:26)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLTableBandLM.l ayoutChildren(HTMLTableBandLM.java:67)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:135)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking LM.layoutNodes(HTMLBlockStackingLM.java:69)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.la youtChildren(HTMLStackingLM.java:26)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLGroupLM.layou tChildren(HTMLGroupLM.java:117)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:135)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking LM.layoutNodes(HTMLBlockStackingLM.java:69)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.la youtChildren(HTMLStackingLM.java:26)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLTableLM.layou tChildren(HTMLTableLM.java:112)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:135)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking LM.layoutNodes(HTMLBlockStackingLM.java:69)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.la youtChildren(HTMLStackingLM.java:26)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:135)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLInlineStackin gLM.resumeLayout(HTMLInlineStackingLM.java:106)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLInlineStackin gLM.layoutNodes(HTMLInlineStackingLM.java:155)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.la youtChildren(HTMLStackingLM.java:26)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:135)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking LM.layoutNodes(HTMLBlockStackingLM.java:69)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.la youtChildren(HTMLStackingLM.java:26)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLTableLM.layou tChildren(HTMLTableLM.java:112)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:135)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking LM.layoutNodes(HTMLBlockStackingLM.java:69)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout (HTMLPageLM.java:90)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE ngine.layout(HTMLReportLayoutEngine.java:99)
>
> at
> org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doR un(RunAndRenderTask.java:167)
>
> ... 49 more
>
>
> only this in XLS export.
>
> And when the report query return no rows (empty resultset), no message
> appeared in the LOG (which is in WARN LEVEL), and the obtained repord is
> filled with xml content, and a size of 16kbytes. In the content of the
> body appears our business params, and it is a well formed XML.
>
> this is the xml content of this empty report:
>
>
>
> <?xml version="1.0" encoding="UTF-8"?>
> <?mso-application progid="Excel.Sheet"?>
>
> <Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
> xmlns:o="urn:schemas-microsoft-com:office:office"
> xmlns:x="urn:schemas-microsoft-com:office:excel"
> xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
> xmlns:html="http://www.w3.org/TR/REC-html40">
> <DocumentProperties
> xmlns="urn:schemas-microsoft-com:office:office">
> <Author />
> <Title />
> <Description />
> </DocumentProperties>
> <Styles>
> <Style ss:ID="HyperlinkId" ss:Name="Hyperlink">
> <Font ss:Underline="Single" ss:Color="#0000FF" />
> </Style>
> <Style ss:ID="34">
> <Alignment ss:Horizontal="Left" ss:Vertical="Top"
> ss:WrapText="1" />
> <Borders>
> <Border ss:Position="Bottom" />
> <Border ss:Position="Top" ss:LineStyle="Continuous"
> ss:Weight="1" ss:Color="#000000" />
> <Border ss:Position="Left" />
> <Border ss:Position="Right" />
> </Borders>
> <Font ss:FontName="Arial" ss:Size="5.0" ss:Bold="0"
> ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000" />
> </Style>
> <Style ss:ID="33">
> <Alignment ss:Horizontal="Left" ss:Vertical="Top"
> ss:WrapText="1" />
> <Borders>
> <Border ss:Position="Bottom" />
> <Border ss:Position="Top" ss:LineStyle="Continuous"
> ss:Weight="1" ss:Color="#000000" />
> <Border ss:Position="Left" />
> <Border ss:Position="Right" />
> </Borders>
> <Font ss:FontName="Arial" ss:Size="6.0" ss:Bold="0"
> ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000" />
> </Style>
> <Style ss:ID="36">
> <Alignment ss:Horizontal="Left" ss:Vertical="Top"
> ss:WrapText="1" />
> <Borders>
> <Border ss:Position="Bottom" />
> <Border ss:Position="Top" />
> <Border ss:Position="Left" />
> <Border ss:Position="Right" />
> </Borders>
> <Font ss:FontName="Arial" ss:Size="5.0" ss:Bold="0"
> ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000" />
> </Style>
> <Style ss:ID="29">
> <Alignment ss:Horizontal="Left" ss:Vertical="Top"
> ss:WrapText="1" />
> <Borders>
> <Border ss:Position="Bottom" />
> <Border ss:Position="Top" />
> <Border ss:Position="Left" />
> <Border ss:Position="Right" />
> </Borders>
> <Font ss:FontName="Courier New" ss:Size="8.0" ss:Bold="1"
> ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000" />
> <Interior ss:Color="#c0c0c0" ss:Pattern="Solid" />
> </Style>
> <Style ss:ID="31">
> <Alignment ss:Horizontal="Left" ss:Vertical="Top"
> ss:WrapText="1" />
> <Borders>
> <Border ss:Position="Bottom" ss:LineStyle="Continuous"
> ss:Weight="1" ss:Color="#000000" />
> <Border ss:Position="Top" />
> <Border ss:Position="Left" />
> <Border ss:Position="Right" />
> </Borders>
> <Font ss:FontName="Courier New" ss:Size="6.0" ss:Bold="0"
> ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000" />
> </Style>
> <Style ss:ID="20">
> <Alignment ss:Horizontal="Left" ss:Vertical="Top"
> ss:WrapText="1" />
> <Borders>
> <Border ss:Position="Bottom" />
> <Border ss:Position="Top" />
> <Border ss:Position="Left" />
> <Border ss:Position="Right" />
> </Borders>
> <Font ss:FontName="Arial" ss:Size="6.0" ss:Bold="0"
> ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000" />
> </Style>
> <Style ss:ID="21">
> <Alignment ss:Horizontal="Left" ss:Vertical="Top"
> ss:WrapText="1" />
> <Borders>
> <Border ss:Position="Bottom" />
> <Border ss:Position="Top" />
> <Border ss:Position="Left" />
> <Border ss:Position="Right" />
> </Borders>
> <Font ss:FontName="Arial" ss:Size="7.0" ss:Bold="0"
> ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000" />
> </Style>
> <Style ss:ID="1">
> <NumberFormat ss:Format="yyyy-M-d HH:mm:ss AM/PM" />
> </Style>
> <Style ss:ID="32">
> <Alignment ss:Horizontal="Left" ss:Vertical="Top"
> ss:WrapText="1" />
> <Borders>
> <Border ss:Position="Bottom" />
> <Border ss:Position="Top" />
> <Border ss:Position="Left" />
> <Border ss:Position="Right" />
> </Borders>
> <Font ss:FontName="Arial" ss:Size="8.0" ss:Bold="0"
> ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000" />
> </Style>
> <Style ss:ID="30">
> <Alignment ss:Horizontal="Left" ss:Vertical="Top"
> ss:WrapText="1" />
> <Borders>
> <Border ss:Position="Bottom" ss:LineStyle="Continuous"
> ss:Weight="1" ss:Color="#000000" />
> <Border ss:Position="Top" />
> <Border ss:Position="Left" />
> <Border ss:Position="Right" />
> </Borders>
> <Font ss:FontName="Courier New" ss:Size="7.0" ss:Bold="0"
> ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000" />
> </Style>
> <Style ss:ID="26">
> <Alignment ss:Horizontal="Left" ss:Vertical="Top"
> ss:WrapText="1" />
> <Borders>
> <Border ss:Position="Bottom" ss:LineStyle="Continuous"
> ss:Weight="1" ss:Color="#000000" />
> <Border ss:Position="Top" />
> <Border ss:Position="Left" />
> <Border ss:Position="Right" />
> </Borders>
> <Font ss:FontName="Courier New" ss:Size="8.0" ss:Bold="0"
> ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000" />
> </Style>
> <Style ss:ID="25">
> <Alignment ss:Horizontal="Left" ss:Vertical="Top"
> ss:WrapText="1" />
> <Borders>
> <Border ss:Position="Bottom" ss:LineStyle="Continuous"
> ss:Weight="1" ss:Color="#000000" />
> <Border ss:Position="Top" />
> <Border ss:Position="Left" />
> <Border ss:Position="Right" />
> </Borders>
> <Font ss:FontName="Courier New" ss:Size="8.0" ss:Bold="0"
> ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000" />
> </Style>
> <Style ss:ID="35">
> <Alignment ss:Horizontal="Right" ss:Vertical="Top"
> ss:WrapText="1" />
> <Borders>
> <Border ss:Position="Bottom" />
> <Border ss:Position="Top" ss:LineStyle="Continuous"
> ss:Weight="1" ss:Color="#000000" />
> <Border ss:Position="Left" />
> <Border ss:Position="Right" />
> </Borders>
> <Font ss:FontName="Arial" ss:Size="6.0" ss:Bold="0"
> ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000" />
> </Style>
> <Style ss:ID="27">
> <Alignment ss:Horizontal="Right" ss:Vertical="Top"
> ss:WrapText="1" />
> <Borders>
> <Border ss:Position="Bottom" />
> <Border ss:Position="Top" />
> <Border ss:Position="Left" />
> <Border ss:Position="Right" />
> </Borders>
> <Font ss:FontName="Courier New" ss:Size="7.0" ss:Bold="0"
> ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000" />
> </Style>
> <Style ss:ID="22">
> <Alignment ss:Horizontal="Right" ss:Vertical="Top"
> ss:WrapText="1" />
> <Borders>
> <Border ss:Position="Bottom" />
> <Border ss:Position="Top" />
> <Border ss:Position="Left" />
> <Border ss:Position="Right" />
> </Borders>
> <Font ss:FontName="Arial" ss:Size="6.0" ss:Bold="0"
> ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000" />
> </Style>
> <Style ss:ID="28">
> <Alignment ss:Horizontal="Right" ss:Vertical="Top"
> ss:WrapText="1" />
> <Borders>
> <Border ss:Position="Bottom" ss:LineStyle="Continuous"
> ss:Weight="1" ss:Color="#000000" />
> <Border ss:Position="Top" />
> <Border ss:Position="Left" />
> <Border ss:Position="Right" />
> </Borders>
> <Font ss:FontName="Courier New" ss:Size="7.0" ss:Bold="0"
> ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000" />
> </Style>
> <Style ss:ID="23">
> <Alignment ss:Horizontal="Center" ss:Vertical="Top"
> ss:WrapText="1" />
> <Borders>
> <Border ss:Position="Bottom" />
> <Border ss:Position="Top" />
> <Border ss:Position="Left" />
> <Border ss:Position="Right" />
> </Borders>
> <Font ss:FontName="Arial" ss:Size="9.0" ss:Bold="1"
> ss:Italic="0" ss:StrikeThrough="0" ss:Underline="Single"
> ss:Color="#000000" />
> <Interior ss:Color="#c0c0c0" ss:Pattern="Solid" />
> </Style>
> <Style ss:ID="24">
> <Alignment ss:Horizontal="Center" ss:Vertical="Top"
> ss:WrapText="1" />
> <Borders>
> <Border ss:Position="Bottom" ss:LineStyle="Continuous"
> ss:Weight="1" ss:Color="#000000" />
> <Border ss:Position="Top" />
> <Border ss:Position="Left" />
> <Border ss:Position="Right" />
> </Borders>
> <Font ss:FontName="Arial" ss:Size="6.0" ss:Bold="1"
> ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000" />
> </Style>
> </Styles>
> <Worksheet ss:Name="Sheet1">
> <ss:Table>
> <ss:Column ss:Width="41" />
> <ss:Column ss:Width="104" />
> <ss:Column ss:Width="32" />
> <ss:Column ss:Width="20" />
> <ss:Column ss:Width="10" />
> <ss:Column ss:Width="61" />
> <ss:Column ss:Width="94" />
> <ss:Column ss:Width="32" />
> <ss:Column ss:Width="12" />
> <ss:Column ss:Width="4" />
> <ss:Column ss:Width="16" />
> <ss:Column ss:Width="16" />
> <ss:Column ss:Width="94" />
> <ss:Column ss:Width="69" />
> <ss:Column ss:Width="200" />
> <ss:Column ss:Width="0" />
> <Row ss:AutoFitHeight="0" ss:Height="15.0">
> <Cell ss:Index="1" ss:StyleID="20" ss:MergeAcross="5"
> ss:MergeDown="0">
> <Data ss:Type="String">1</Data>
> </Cell>
> <Cell ss:Index="7" ss:StyleID="21" ss:MergeAcross="6"
> ss:MergeDown="0">
> <Data ss:Type="String" />
> </Cell>
> <Cell ss:Index="14" ss:StyleID="22" ss:MergeAcross="1"
> ss:MergeDown="0">
> <Data ss:Type="String" />
> </Cell>
> </Row>
> <Row ss:AutoFitHeight="0" ss:Height="15.0">
> <Cell ss:Index="1" ss:StyleID="20" ss:MergeAcross="5"
> ss:MergeDown="0">
> <Data ss:Type="String" />
> </Cell>
> <Cell ss:Index="7" ss:StyleID="21" ss:MergeAcross="6"
> ss:MergeDown="0">
> <Data ss:Type="String" />
> </Cell>
> <Cell ss:Index="14" ss:StyleID="22" ss:MergeAcross="1"
> ss:MergeDown="0">
> <Data ss:Type="String" />
> </Cell>
> </Row>
> <Row ss:AutoFitHeight="0" ss:Height="15.0">
> <Cell ss:Index="1" ss:StyleID="20" ss:MergeAcross="5"
> ss:MergeDown="0">
> <Data ss:Type="String" />
> </Cell>
> <Cell ss:Index="7" ss:StyleID="21" ss:MergeAcross="6"
> ss:MergeDown="0">
> <Data ss:Type="String" />
> </Cell>
> <Cell ss:Index="14" ss:StyleID="22" ss:MergeAcross="1"
> ss:MergeDown="0">
> <Data ss:Type="String" />
> </Cell>
> </Row>
> <Row ss:AutoFitHeight="0" ss:Height="15.0">
> <Cell ss:Index="1" ss:StyleID="23" ss:MergeAcross="14"
> ss:MergeDown="0">
> <Data ss:Type="String" />
> </Cell>
> </Row>
> <Row ss:AutoFitHeight="0" ss:Height="15.0">
> <Cell ss:Index="1" ss:StyleID="24" ss:MergeAcross="14"
> ss:MergeDown="0">
> <Data ss:Type="String">( null, null, null )</Data>
> </Cell>
> </Row>
> <Row ss:AutoFitHeight="0" ss:Height="15.0">
> <Cell ss:Index="1" ss:StyleID="25" ss:MergeAcross="1"
> ss:MergeDown="4">
> <Data ss:Type="String">Loan ID</Data>
> </Cell>
> <Cell ss:Index="3" ss:StyleID="26" ss:MergeAcross="2"
> ss:MergeDown="4">
> <Data ss:Type="String" />
> </Cell>
> </Row>
> <Row ss:AutoFitHeight="0" ss:Height="15.0">
> <Cell ss:Index="6" ss:StyleID="27" ss:MergeAcross="3"
> ss:MergeDown="0">
> <Data ss:Type="String">
> OUTSTANDING INCL ARREARS TOTAL
> </Data>
> </Cell>
> <Cell ss:Index="10" ss:StyleID="27" ss:MergeAcross="4"
> ss:MergeDown="0">
> <Data ss:Type="String">
> PENALTY INTEREST UNPAID, STOCK
> </Data>
> </Cell>
> <Cell ss:Index="15" ss:StyleID="27" ss:MergeAcross="0"
> ss:MergeDown="0">
> <Data ss:Type="String">
> PENALTY INTEREST ESTIMATED TOTAL
> </Data>
> </Cell>
> </Row>
> <Row ss:AutoFitHeight="0" ss:Height="15.0">
> <Cell ss:Index="6" ss:StyleID="27" ss:MergeAcross="3"
> ss:MergeDown="0">
> <Data ss:Type="String">At</Data>
> </Cell>
> <Cell ss:Index="10" ss:StyleID="27" ss:MergeAcross="4"
> ss:MergeDown="0">
> <Data ss:Type="String">At</Data>
> </Cell>
> <Cell ss:Index="15" ss:StyleID="27" ss:MergeAcross="0"
> ss:MergeDown="0">
> <Data ss:Type="String">At</Data>
> </Cell>
> </Row>
> <Row ss:AutoFitHeight="0" ss:Height="15.0">
> <Cell ss:Index="6" ss:StyleID="27" ss:MergeAcross="3"
> ss:MergeDown="0">
> <Data ss:Type="String">01.07.2005</Data>
> </Cell>
> <Cell ss:Index="10" ss:StyleID="27" ss:MergeAcross="4"
> ss:MergeDown="0">
> <Data ss:Type="String">01.07.2005</Data>
> </Cell>
> <Cell ss:Index="15" ss:StyleID="27" ss:MergeAcross="0"
> ss:MergeDown="0">
> <Data ss:Type="String">01.07.2005</Data>
> </Cell>
> </Row>
> <Row ss:AutoFitHeight="0" ss:Height="15.0">
> <Cell ss:Index="6" ss:StyleID="28" ss:MergeAcross="3"
> ss:MergeDown="0">
> <Data ss:Type="String" />
> </Cell>
> <Cell ss:Index="10" ss:StyleID="28" ss:MergeAcross="4"
> ss:MergeDown="0">
> <Data ss:Type="String" />
> </Cell>
> <Cell ss:Index="15" ss:StyleID="28" ss:MergeAcross="0"
> ss:MergeDown="0">
> <Data ss:Type="String" />
> </Cell>
> </Row>
> <Row ss:AutoFitHeight="0" ss:Height="15.0">
> <Cell ss:Index="1" ss:StyleID="29" ss:MergeAcross="2"
> ss:MergeDown="0">
> <Data ss:Type="String">GRAND TOTAL</Data>
> </Cell>
> <Cell ss:Index="6" ss:StyleID="27" ss:MergeAcross="3"
> ss:MergeDown="0">
> <Data ss:Type="String">
> OUTSTANDING INCL ARREARS TOTAL
> </Data>
> </Cell>
> <Cell ss:Index="10" ss:StyleID="27" ss:MergeAcross="4"
> ss:MergeDown="0">
> <Data ss:Type="String">
> PENALTY INTEREST UNPAID, STOCK
> </Data>
> </Cell>
> <Cell ss:Index="15" ss:StyleID="27" ss:MergeAcross="0"
> ss:MergeDown="0">
> <Data ss:Type="String">
> PENALTY INTEREST ESTIMATED TOTAL
> </Data>
> </Cell>
> </Row>
> <Row ss:AutoFitHeight="0" ss:Height="15.0">
> <Cell ss:Index="1" ss:StyleID="30" ss:MergeAcross="1"
> ss:MergeDown="2">
> <Data ss:Type="String">Loan ID</Data>
> </Cell>
> <Cell ss:Index="3" ss:StyleID="31" ss:MergeAcross="2"
> ss:MergeDown="2">
> <Data ss:Type="String" />
> </Cell>
> <Cell ss:Index="6" ss:StyleID="27" ss:MergeAcross="3"
> ss:MergeDown="0">
> <Data ss:Type="String">At</Data>
> </Cell>
> <Cell ss:Index="10" ss:StyleID="27" ss:MergeAcross="4"
> ss:MergeDown="0">
> <Data ss:Type="String">At</Data>
> </Cell>
> <Cell ss:Index="15" ss:StyleID="27" ss:MergeAcross="0"
> ss:MergeDown="0">
> <Data ss:Type="String">At</Data>
> </Cell>
> </Row>
> <Row ss:AutoFitHeight="0" ss:Height="15.0">
> <Cell ss:Index="6" ss:StyleID="27" ss:MergeAcross="3"
> ss:MergeDown="0">
> <Data ss:Type="String">01.07.2005</Data>
> </Cell>
> <Cell ss:Index="10" ss:StyleID="27" ss:MergeAcross="4"
> ss:MergeDown="0">
> <Data ss:Type="String">01.07.2005</Data>
> </Cell>
> <Cell ss:Index="15" ss:StyleID="27" ss:MergeAcross="0"
> ss:MergeDown="0">
> <Data ss:Type="String">01.07.2005</Data>
> </Cell>
> </Row>
> <Row ss:AutoFitHeight="0" ss:Height="15.0">
> <Cell ss:Index="6" ss:StyleID="28" ss:MergeAcross="3"
> ss:MergeDown="0">
> <Data ss:Type="String" />
> </Cell>
> <Cell ss:Index="10" ss:StyleID="28" ss:MergeAcross="4"
> ss:MergeDown="0">
> <Data ss:Type="String" />
> </Cell>
> <Cell ss:Index="15" ss:StyleID="28" ss:MergeAcross="0"
> ss:MergeDown="0">
> <Data ss:Type="String" />
> </Cell>
> </Row>
> <Row ss:AutoFitHeight="0" ss:Height="15.0">
> <Cell ss:Index="1" ss:StyleID="32" ss:MergeAcross="14"
> ss:MergeDown="0">
> <Data ss:Type="String" />
> </Cell>
> <Cell ss:Index="2" ss:StyleID="33" ss:MergeAcross="2"
> ss:MergeDown="0">
> <Data ss:Type="String">enterprise V6.0.0.00</Data>
> </Cell>
> <Cell ss:Index="8" ss:StyleID="34" ss:MergeAcross="0"
> ss:MergeDown="0">
> <Data ss:Type="String">Page:</Data>
> </Cell>
> <Cell ss:Index="9" ss:StyleID="34" ss:MergeAcross="1"
> ss:MergeDown="0">
> <Data ss:Type="String">1</Data>
> </Cell>
> <Cell ss:Index="11" ss:StyleID="34" ss:MergeAcross="0"
> ss:MergeDown="0">
> <Data ss:Type="String">/</Data>
> </Cell>
> <Cell ss:Index="12" ss:StyleID="34" ss:MergeAcross="0"
> ss:MergeDown="0">
> <Data ss:Type="String">1</Data>
> </Cell>
> <Cell ss:Index="13" ss:StyleID="35" ss:MergeAcross="2"
> ss:MergeDown="0">
> <Data ss:Type="String">enterpriseVWS</Data>
> </Cell>
> </Row>
> <Row ss:AutoFitHeight="0" ss:Height="15.0">
> <Cell ss:Index="1" ss:StyleID="36" ss:MergeAcross="0"
> ss:MergeDown="0">
> <Data ss:Type="String">Reference :</Data>
> </Cell>
> <Cell ss:Index="2" ss:StyleID="36" ss:MergeAcross="2"
> ss:MergeDown="0">
> <Data ss:Type="String" />
> </Cell>
> <Cell ss:Index="8" ss:StyleID="21" ss:MergeAcross="4"
> ss:MergeDown="0">
> <Data ss:Type="String" />
> </Cell>
> <Cell ss:Index="13" ss:StyleID="22" ss:MergeAcross="2"
> ss:MergeDown="0">
> <Data ss:Type="String">Sep 1, 2010 5:17 PM</Data>
> </Cell>
> </Row>
> </ss:Table>
> <WorksheetOptions
> xmlns="urn:schemas-microsoft-com:office:excel">
> <PageSetup />
> </WorksheetOptions>
> </Worksheet>
> </Workbook>
>
>
>
> hope this helps!
>
> And thank you very much for your time and cooperation.
>
> Juan Holder
Re: blank excel [message #557496 is a reply to message #556783] Tue, 07 September 2010 15:18 Go to previous messageGo to next message
Eclipse UserFriend
Jason,
We tested again from the designer, and the problem remains, I mean, if you preview the report it is OK, but if from the designer you want to export it as XLS the same problem appears, Blank 0 byte excel, or well formed XML with a Table Error.

Thanks for the support.
Re: blank excel [message #557508 is a reply to message #557496] Tue, 07 September 2010 17:00 Go to previous messageGo to next message
Eclipse UserFriend
Juan,

I can not reproduce the issue. Can you open a bug for this?

Jason

On 9/7/2010 3:18 PM, juanholder@gmail.com wrote:
> Jason,
> We tested again from the designer, and the problem remains, I mean, if
> you preview the report it is OK, but if from the designer you want to
> export it as XLS the same problem appears, Blank 0 byte excel, or well
> formed XML with a Table Error.
>
> Thanks for the support.
Re: blank excel [message #559924 is a reply to message #557508] Mon, 20 September 2010 07:59 Go to previous messageGo to next message
Eclipse UserFriend
ok, i've opened a bug linked to this thread.

best regards and thank you for the support.

Juan Holder
Re: blank excel [message #1835628 is a reply to message #559924] Tue, 08 December 2020 23:30 Go to previous message
Eclipse UserFriend
Hi... is this bug has been fixed and what birt version has this been issued to?
Previous Topic:Max File Size pdf
Next Topic:<BR> tags are not resulting in linefeeds in Text element set to Dynamic Text and HTML
Goto Forum:
  


Current Time: Thu Apr 24 07:27:11 EDT 2025

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

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

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly