Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » blank excel(When the report format is XLS, always the report is completely empty.)
blank excel [message #555156] Wed, 25 August 2010 16:01 Go to next message
Juan Holder is currently offline Juan Holder
Messages: 14
Registered: August 2010
Junior Member
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 04:20 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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 12:47 Go to previous messageGo to next message
Juan Holder is currently offline Juan Holder
Messages: 14
Registered: August 2010
Junior Member
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 16:30 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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 13:09 Go to previous messageGo to next message
Juan Holder is currently offline Juan Holder
Messages: 14
Registered: August 2010
Junior Member
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 14:01 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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 16:00 Go to previous messageGo to next message
Juan Holder is currently offline Juan Holder
Messages: 14
Registered: August 2010
Junior Member
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 20:22 Go to previous messageGo to next message
Juan Holder is currently offline Juan Holder
Messages: 14
Registered: August 2010
Junior Member
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 20:23]

Report message to a moderator

Re: blank excel [message #556350 is a reply to message #556334] Tue, 31 August 2010 22:05 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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 21:20 Go to previous messageGo to next message
Juan Holder is currently offline Juan Holder
Messages: 14
Registered: August 2010
Junior Member
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 14:59 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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 19:18 Go to previous messageGo to next message
Juan Holder is currently offline Juan Holder
Messages: 14
Registered: August 2010
Junior Member
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 21:00 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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 11:59 Go to previous message
Juan Holder is currently offline Juan Holder
Messages: 14
Registered: August 2010
Junior Member
ok, i've opened a bug linked to this thread.

best regards and thank you for the support.

Juan Holder
Previous Topic:Pagebreak if not enough space left
Next Topic:How do debug AssertionError cannot be cast to Exception?
Goto Forum:
  


Current Time: Thu Oct 23 09:43:31 GMT 2014

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

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