Unable to save Jasper Report in xls format

Classic Servoy
1

Hi,

I created a jasper report and generated it through my servoy application. Through the jasper viewer I am able to save the report in any format, including xls, when running the application on my machine.

However, when I run the same application on the server I am not able to save the report in xls format. I am still able to save in any of the other available formats, except for xls. I get the file save dialog as usual, which closes on giving a file name and pressing save. However the file is no where to be found!

Does anyone have an idea as to why this only affects xls format?

Thanks in advance!

Regards
Hareendra

2

Is there an error message?

3

There’s no error message. Like I explained. The file save happens like normal, it just never saves.

4

Do you have sufficient rights?

5

Yes, because I’m able to save in any other format

6

What version of the Servoy Jasper plugin do you use?
What version of Servoy do you use it with?
What is the version of your server os?

7

I have the same problem after upgrading the jasperreports.jar to v3.1.4 and afterwards also after upgrade to jasperreports-3.5.0.jar.
I filed a case concerning this problem at 25-03 but up to now no reaction.

A second problem I discovered : when setting the report-script-language to Javascript the report won’t run or throws an error when called from Servoy.

I-report 3.5.0 runs well in both cases.

8

I can confirm that an xls file is not created when running the servoy plugin from the server. It does work fine in developer.
I think it must be something to do with the server not knowing where to place the file - something different anyway compared to developer.
I will raise the issue on the Google code site for the servoy plugin (since I added that piece of functionality). :?

9

It (XLS-file creation) does not work fine in developer in my case. RTF, TXT, PDF, etc. work fine.

10

Perhaps you could raise this as an issue on the Google code site

for Servoy jasper plugin?
I already did it for the server only case.

11

UPDATE:
On the server:
I did some more testing and found that if the report is sent to the viewer and then the user selects XLS then the output is NOT created.
However when I sent the report to the Servoy plugin with an output type of xls then it DOES produce the XLS file in the specified directory.
So this seems an issue more to do with the version of the Jasper Reports than the servoy plugin.

Check again that the string to specify the output file type is “xls”. :)

12

Hi

I tried the way you suggested by giving the extension xls in the coding itself. It does not work even in developer. It gives the message “Undefined Format”.
It saved ok for pdf and html formats. Additionally, you have to give the save path in the coding.
Any ideas? :?

Regards
Hareendra

13

Interesting.
Still, it would be nice of you to tell us your configuration.

14

Hi,
Here’s how I called the report from servoy;

plugins.jasperPluginRMI.jasperReport(controller.getServerName(),‘test_report.jrxml’,null,‘view’,_params)

_params is a java.util.HashMap() which has the parameters.

According to the way you suggested I tried;

plugins.jasperPluginRMI.jasperReport(controller.getServerName(),‘test_report.jrxml’,‘d:/test_report.xls’,‘xls’,_params)

This is when I get Undefined Format error.

But when I try either pdf or html instead of xls it works!

Regards,
Hareendra

15

Hi again,

By the way the servoy jasper plugin version used on the server is 3.0.0

Regards
Hareendra

16

The latest release of the servoy jasper plugin is actually 2.1.5 which you can get from the google code page:

I think the version you are quoting is the jasper reports jar file version.

The older plugin did not handle “xls” but did handle “excel” as the report type.
The undefined format would be declared in an older version.

Try downloading the latest and retry.
The latest now has a property to tell you the plugin version. :)

Tom

17

Hi,
I downloaded the latest plugin as you suggested and then tried, but ended up getting the same “undefined format” error. So I used the ‘excel’ extension instead of ‘xls’ and then it worked. I was able to download in xls format from the server. However the excel that got saved was blank!!!

So i’m back to square one.

Regards
Hareendra

18

From version 2.1.4 the plugin has a property to return the version number.
I tested with version 2.1.4 and have no problem.

19

Hi Thomas,

Yes, I followed the earlier link you posted and downloaded the latest plugin.

But still all I’m able to download is a blank xls file.

Regards,
Hareendra

20

Well at least you have a file :P
Seriously though, have you checked that your Jasper report produces the correct info?

If you prefer send me a PM and I can take a look at the Jasper Report to see if there are issues there.

Regards,
Tom