Project

General

Profile

Defect #550

Excel File error: data may have been lost

Added by Imre Tokai over 11 years ago. Updated over 11 years ago.

Status:
Closed
Priority:
High
Assignee:
Andrei Costache
Start date:
09/13/2012
Due date:
% Done:

100%

Estimated time:
Browser (if web client):

Description

Hello,
When generating a report based on SQL query that brings large resultset -all work as expected;
BUT when filling the WHERE clause of same SQL, attached error occurs File error: data may have been lost

Server: MSSQL, iReport and plugin engine 4.0.0.
If other versions than this can be used nowdays, advise please, as found out some unexpected behaving while ago

Any idea how to fix or similar experience?

Regards

Files

issueExcelJasper.jpg (60.4 KB) issueExcelJasper.jpg Imre Tokai, 09/13/2012 11:39 AM
reportProperties.jpg (16.4 KB) reportProperties.jpg Imre Tokai, 11/27/2012 04:03 PM

History

#1

Updated by Andrei Costache over 11 years ago

  • Assignee set to Andrei Costache

Hi,

As I understand, you are using iReport 4.0.0 and plugin version 3.3, to generate an xls report. Then you open it with Microsoft Excel, yes? What version of Microsoft Excel are you using?

Regards,
Andrei

#2

Updated by Imre Tokai over 11 years ago

Thank you for your response Andrei,

Version: 2003, SP3, part of Office Edition 2003
Work-flow is assumed properly

Any better, newer combination of plugin+iReport(+Excel)? Advise, please.
Any further idea?

Regards

#3

Updated by Andrei Costache over 11 years ago

This could be a POI library issue (in relation to excel); but i am not 100% sure.

Could you please try with a Servoy 6.0.7 and 4.0b1 version of the jasperreports plugin (in this case you can use iReport 4.6.0 for report creation/editing)?

Also, when you generate the report with the plugin, are there any errors in the log? (i suppose your workflow is: create a report in ireport and the runReport on the report jrxml(?), then open the resulted xls in ms excel)

Regards,
Andrei

#4

Updated by Imre Tokai over 11 years ago

Thanks Andrei,

Set up dedicated playground according to your guidelines regarding tools versioning: found out that (complex) query brings empty resultset.
BUT why above warning is there? It prevents printing sections like Title, and brings nothing but an empty sheet.
So it's still there even when upgraded to new version.
No errors in servoy-admin
Note: compiled .jrxml with iReport 4.7.0

Regards

#5

Updated by Andrei Costache over 11 years ago

Hi Imre,

Do you use a .jasper file to provide for the runReport call?
Could you use just a '.jrxml' or also a '.jasper' file, but created/compiled using iReport 4.6.0.

If the problem still persists, please attach a small sample solution (with sample data if needed) and a report, that demonstrates the problem.

Regards,
Andrei

#6

Updated by Andrei Costache over 11 years ago

  • Status changed from New to Feedback

Hi Imre,

Please reopen/update case providing the requested feedback when possible.

Regards,
Andrei

#7

Updated by Imre Tokai over 11 years ago

Thanks Andrei,
In report properties When No Data set Blank Page, see attached please. Warning doesn't appear anymore with this setup.

Regards

#8

Updated by Andrei Costache over 11 years ago

  • Status changed from Feedback to Closed
  • % Done changed from 0 to 100

Marking this as closed; the problem is eliminated using the workaround suggested by Imre.

Also available in: Atom PDF