|
| Re: blank excel [message #555247 is a reply to message #555156] |
Thu, 26 August 2010 04:20   |
|
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 #555460 is a reply to message #555369] |
Thu, 26 August 2010 16:30 |
|
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 #556334 is a reply to message #555685] |
Tue, 31 August 2010 20:22 |
 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 |
|
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 |
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 |
|
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 #557508 is a reply to message #557496] |
Tue, 07 September 2010 21:00 |
|
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.
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.04304 seconds