Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 325738

Summary: When the report format is XLS, always the report is completely empty.
Product: z_Archived Reporter: Juan Holder <juanholder>
Component: BIRTAssignee: Birt-Report-inbox <Birt-Report-inbox>
Status: REOPENED --- QA Contact: Xiaoying Gu <bluesoldier>
Severity: major    
Priority: P3 CC: bluesoldier, jouyang
Version: unspecified   
Target Milestone: ---   
Hardware: PC   
OS: Windows 7   
Whiteboard: Obsolete
Attachments:
Description Flags
rar containing the report design
none
this is the output of the current rptdesign
none
Attach containg rpt design, excell with errors and pdf OK
none
patch for excel emitter.
none
resulting test with the excel emmiter patch none

Description Juan Holder CLA 2010-09-20 07:57:25 EDT
Build Identifier: 20090619-0625

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

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.

Forum Discussion Link: http://www.eclipse.org/forums/index.php?t=msg&goto=555156&S=11e1e7d32a359df141f826974cb06b1d#msg_555156




Reproducible: Always

Steps to Reproduce:
1.Invoke the report from a custom servlet.
2.save the xls document.
3.open the excel document that could be 0 byte sized or sized but with a "Table Error"
Comment 1 Xiaoying Gu CLA 2010-09-25 03:12:35 EDT
Hi,

Could yo please attache your report design for me to reproduce this issue?
And you also have this issue in the designer, right?
Comment 2 Xiaoying Gu CLA 2010-11-01 23:18:15 EDT
According to the comments in birt-exchange forum, the issue exists with the specific report design.

Set as worksforme for now.
If a report design can be attached for reproducing this issue, please feel free to reopen.
Comment 3 Juan Holder CLA 2010-11-08 08:16:26 EST
Created attachment 182603 [details]
rar containing the report design
Comment 4 Juan Holder CLA 2010-11-08 08:17:56 EST
Reopening with the attached report design.

regards.
Comment 5 Xiaoying Gu CLA 2010-11-09 03:54:11 EST
(In reply to comment #4)
> Reopening with the attached report design.
> 
> regards.

Could you attache report document generated from you report?

It's hard to reproduce the issue directly from your report since it's using the outside db.
Comment 6 Juan Holder CLA 2010-12-03 16:26:13 EST
Could you get some advance in this issue? 

Best Regards.

Eng.Juan Holder
Comment 7 Juan Holder CLA 2010-12-29 11:45:19 EST
Created attachment 185882 [details]
this is the output of the current rptdesign

pls find attached the output in xls format of the current report design.

best regards.
Comment 8 Juan Holder CLA 2011-01-07 08:11:55 EST
Happy new year BIRT Team! could you see something about this? 

very best regards!

JH
Comment 9 Juan Holder CLA 2011-01-13 07:33:26 EST
BIRT Team,
          Do you have any news on this issue? Please let me know if you need something else in order to solve que current situation.

          Very best regards!

JH
Comment 10 Jun Ouyang CLA 2011-01-13 22:51:18 EST
Jh,

Sorry for replying late.
Xiaoying is on vacation now. The files you attached only contain xls file. We need a report design which contains only portable data source. thanks.
Comment 11 Juan Holder CLA 2011-01-17 09:33:23 EST
Dear Jun,
         thanks for your reply, the rptdesign is posted above the excel output, what do you mean about portable datasource?

regards

JH
Comment 12 Juan Holder CLA 2011-01-17 09:55:11 EST
Dear Jun,
         thanks for your reply, the rptdesign is posted above the excel output, what do you mean about portable datasource?

regards

JH
Comment 13 Juan Holder CLA 2011-01-21 14:02:15 EST
BIRT Team,
          Do you have any news on this issue?

regards!

JH
Comment 14 Juan Holder CLA 2011-01-31 21:42:36 EST
BIRT Team,
          Do you have any news on this issue?

regards!

JH
Comment 15 Jun Ouyang CLA 2011-01-31 21:46:41 EST
Jh,

The data source in the design is "srvvirt-dbdev:1521:dms2" which can't be connected. Can you attach the report document?
Comment 16 Juan Holder CLA 2011-02-13 17:46:28 EST
Created attachment 188859 [details]
Attach containg rpt design, excell with errors and pdf OK

as you requested I am attaching the rptdesign with it's own excel output.

regards

JH
Comment 17 Juan Holder CLA 2011-02-27 23:50:10 EST
Hello guys, any advance on this? thank you very much.

JH
Comment 18 Jun Ouyang CLA 2011-02-27 23:54:26 EST
Jh,

Please attach report document. Report document can be generated by 
1. right click on report design
2. click report->generate document
Comment 19 Juan Holder CLA 2011-03-28 09:55:44 EDT
sorry about the delay of this response.

Could you please tell me what exactly do we need to send to you in order to see this issue, I understand what you asked for in last comment, nevertheless we sent many things, that we've been asked for and we've got no advance on it.

thank you very much.

JH
Comment 20 Jun Ouyang CLA 2011-03-28 21:38:49 EDT
Created attachment 192057 [details]
patch for excel emitter.

Because your design uses a data source we can't access, so we can't run the design and reproduce the problem. But given a report document, we don't need to access the database.

Anyway, it looks like a problem fixed before. I attach a patch for excel plugin, Please try it.
Comment 21 Juan Holder CLA 2011-03-28 22:47:50 EDT
thank you, I'll try this patch, in which folder must I put it?
Comment 22 Jun Ouyang CLA 2011-03-28 23:34:26 EDT
In %eclipse_hoem%/plugins, there is a plugin called org.eclipse.birt.report.engine.emitter.prototype.excel.****.jar, you need to remove it and replace it with the attached one. Please backup the original one but don't keep it in plugins folder.
Comment 23 Juan Holder CLA 2011-03-28 23:42:43 EDT
Understood Jun!

This application is a Web ARchive, and I have the pluggins folder deployed, where I have all the emmiters, with the same name as you mentioned, tomorrow I will perform the tests with this new path.

thanks in advance, and I will send you our results.

JH
Comment 24 Juan Holder CLA 2011-05-10 11:14:19 EDT
Created attachment 195230 [details]
resulting test with the excel emmiter patch

This is the result of the test, patching the birt platform with the given .jar file.  The error remains the same aparently.
Comment 25 Juan Holder CLA 2011-05-10 11:21:12 EDT
Dear Jun and team,

We performed the tests with the given emitter with no success.

The approach was performed with different tomcat environments, out of the box, avoiding the catching of old emitter jars that could be stored in the work/tmp directory.

But the problem remains.

I've attached the rpt pdf OK and excel with failure, with a screenshot also.

best regards!

J
Comment 26 Juan Holder CLA 2011-06-13 16:30:31 EDT
Hello guys,

Have you had any news on this? thanks in advance!

JH