I have just made the first 3.0.0 alpha version available for this
plugin.
This update allows Jasper Reports to be run on a foundSet.
- There is full access to record data, calculations, relations.
- Filters that are in place will be applied automatically.
- Subreports can run on a related foundSet
- data can be calculated in global methods
Furthermore, the minimum requirements have changed:
- Java 1.5 (was 1.4.2)
- Servoy 4.1 (was 3.5)
Samples of reports and solutions are not available yet, maybe there
are some volunteers?
> I have just made the first 3.0.0 alpha version available for this
> plugin.
> This update allows Jasper Reports to be run on a foundSet.
> - There is full access to record data, calculations, relations.
> - Filters that are in place will be applied automatically.
> - Subreports can run on a related foundSet
> - data can be calculated in global methods
> Furthermore, the minimum requirements have changed:
> - Java 1.5 (was 1.4.2)
> - Servoy 4.1 (was 3.5)
> Samples of reports and solutions are not available yet, maybe there
> are some volunteers?
Fields are used like this:
<textFieldExpression class="java.lang.Integer"><![CDATA[$F
{companies_to_employees.employeeid}]]></textFieldExpression>
<textFieldExpression class="java.lang.String"><![CDATA[$F
{global_func(company_id, company_name)}]]></textFieldExpression>
The 3.0.0a1 download also bundles the latest JasperReports engine
(3.5.2) which contains fixes for issues when running the Servoy
JasperReports plugin icw the Servoy WebClient.
Please retest any issue you were experiencing with the 2.1.x version
of the plugin or issues with that version with a manually upgraded
JasperReport engine (to version 3.5.0).
I decided to test the 3.0.0a1 with Servoy 3.5.9 in case it could solve
a problem that I had and I wanted to see if it could work.
I am NOT using the foundset capabilities I only want to test if it is
compatible with the reports that I already have under Servoy 3.5.9 and
with using reports created by iReport 3.5.2 (that is these reports
need the jasperreports-3.5.2.jar engine to work).
Here are my results:
1. I had to include the itext-2.1.0.jar in the jnlp file otherwise I
could not get any file to be saved in any out put format such as pdf.
2. All my reports render fine in the Smart Client on the Jasper
Viewer. From this viewer I can then select save as and select the file
type.
Saving the viewer file to one of the selected output format works for
all type EXCEPT the XLS (excel) types.
3. If I use my Servoy application and send the plugin the output file
format I desire as well as the file pathname then NOTHING gets output.
Perhaps there is a different parameter order than the plugin version
2.1.5 (I did not change any of my servoy code to do this test). I will
check on the parameter order in my next test round.
So I think that there might have to be a little rewording of the
prerequisites of the Servoy version for this plugin - if it works for
my 3.5.9 application perhaps it can be used for others who want to use
the iReport 3.5.2 but like me found it does not work with the servoy
plugin 2.1.5
I'm doing tests with the foundset parameter but I believe that it is the same with the old way:
About your point 2. Just like the iText.jar needed to be updated to 2.1.0 (used by jasper 3.5.x), to use Excel format you need to update jakarta POI located in plugins/jakarta-poi to the one included in iReport 3.5.2 (poi-3.2-FINAL-20081019.jar in your JasperSoft/iReport-nb-3.5.2/ireport/modules/ext folder).
It works!
But then when you do that, the standard Servoy "Export > "To Excel file" function doesn't work anymore. Looks like to fix this, Servoy will have to update the library in the core to poi 3.2 (currently the Export function uses 3.0) and fix the calls. We need Excel export to function as well as Excel reporting using Jasper!
About your point 3.
For the "xls" it is related to point 2 before and POI version. But for the other formats, I have found out that there was an File - "Access is denied" exception when the plugin tries to write to my reports folder, it shouldn' be when being admin of my PC I have all the access rights to this folder anyway. I don't know where I am supposed to give the plugin access rights so there must be something broken here.
Rob, any thoughts?
----- Mail Original -----
De: "TomParry" <TomParry.h...@gmail.com>
Ą: "servoy-jasperreports-plugin" <servoy-jasperreports-plugin@googlegroups.com>
Envoyé: Samedi 13 Juin 2009 21h21:00 GMT -05:00 USA/Canada - États de l'Est
Objet: [servoy-jasperreports-plugin:20] Re: First 3.0.0 alpha available
I decided to test the 3.0.0a1 with Servoy 3.5.9 in case it could solve
a problem that I had and I wanted to see if it could work.
I am NOT using the foundset capabilities I only want to test if it is
compatible with the reports that I already have under Servoy 3.5.9 and
with using reports created by iReport 3.5.2 (that is these reports
need the jasperreports-3.5.2.jar engine to work).
Here are my results:
1. I had to include the itext-2.1.0.jar in the jnlp file otherwise I
could not get any file to be saved in any out put format such as pdf.
2. All my reports render fine in the Smart Client on the Jasper
Viewer. From this viewer I can then select save as and select the file
type.
Saving the viewer file to one of the selected output format works for
all type EXCEPT the XLS (excel) types.
3. If I use my Servoy application and send the plugin the output file
format I desire as well as the file pathname then NOTHING gets output.
Perhaps there is a different parameter order than the plugin version
2.1.5 (I did not change any of my servoy code to do this test). I will
check on the parameter order in my next test round.
So I think that there might have to be a little rewording of the
prerequisites of the Servoy version for this plugin - if it works for
my 3.5.9 application perhaps it can be used for others who want to use
the iReport 3.5.2 but like me found it does not work with the servoy
plugin 2.1.5
to use Excel format you need to update jakarta POI located in plugins/
jakarta-poi to the one included in iReport 3.5.2 (poi-3.2-
FINAL-20081019.jar in your JasperSoft/iReport-nb-3.5.2/ireport/modules/
ext folder).
> It works!
NOT! Not in 3.5.9 anyway. I even include jxl-2.6.jar and there was
only a file created with 0 bytes length!
I had tried the poi in my second round of testing to no avail - and
then I saw your message and copied the same file from the iReport lib
(ext as you said) just in case my download was not the same.
This is the same behaviour as was reported ages ago and the fix was
thought to have been put in by JasperSoft but it appears not yet.
I do not have the same access denied error as you do for my files -
they are all created ok (using 3.5.9 of course!).
to use Excel format you need to update jakarta POI located in plugins/
jakarta-poi to the one included in iReport 3.5.2 (poi-3.2-
FINAL-20081019.jar in your JasperSoft/iReport-nb-3.5.2/ireport/modules/
ext folder).
> It works!
NOT! Not in 3.5.9 anyway. I even include jxl-2.6.jar and there was
only a file created with 0 bytes length!
I had tried the poi in my second round of testing to no avail - and
then I saw your message and copied the same file from the iReport lib
(ext as you said) just in case my download was not the same.
This is the same behaviour as was reported ages ago and the fix was
thought to have been put in by JasperSoft but it appears not yet.
I do not have the same access denied error as you do for my files -
they are all created ok (using 3.5.9 of course!).
sorry to hear that it does not work for you. It works here with Servoy 4.1.3
Patrick
----- Mail Original -----
De: "TomParry" <TomParry.h...@gmail.com>
Ą: "servoy-jasperreports-plugin" <servoy-jasperreports-plugin@googlegroups.com>
Envoyé: Dimanche 14 Juin 2009 17h59:40 GMT -05:00 USA/Canada - États de l'Est
Objet: [servoy-jasperreports-plugin:/] Re: First 3.0.0 alpha available
Patrick
> About your point 2.
to use Excel format you need to update jakarta POI located in plugins/
jakarta-poi to the one included in iReport 3.5.2 (poi-3.2-
FINAL-20081019.jar in your JasperSoft/iReport-nb-3.5.2/ireport/modules/
ext folder).
> It works!
NOT! Not in 3.5.9 anyway. I even include jxl-2.6.jar and there was
only a file created with 0 bytes length!
I had tried the poi in my second round of testing to no avail - and
then I saw your message and copied the same file from the iReport lib
(ext as you said) just in case my download was not the same.
This is the same behaviour as was reported ages ago and the fix was
thought to have been put in by JasperSoft but it appears not yet.
I do not have the same access denied error as you do for my files -
they are all created ok (using 3.5.9 of course!).
> to use Excel format you need to update jakarta POI located in plugins/
> jakarta-poi to the one included in iReport 3.5.2 (poi-3.2-
> FINAL-20081019.jar in your JasperSoft/iReport-nb-3.5.2/ireport/modules/
> ext folder).
> > It works!
> NOT! Not in 3.5.9 anyway. I even include jxl-2.6.jar and there was
> only a file created with 0 bytes length!
> I had tried the poi in my second round of testing to no avail - and
> then I saw your message and copied the same file from the iReport lib
> (ext as you said) just in case my download was not the same.
> This is the same behaviour as was reported ages ago and the fix was
> thought to have been put in by JasperSoft but it appears not yet.
> I do not have the same access denied error as you do for my files -
> they are all created ok (using 3.5.9 of course!).
I start the server using the standard server.bat (3.5.9 on winxp). I
do not get ANY log file errors nor any stack trace. The bat file does
have the -DSTACKTRACE=true in the command line.
Do not forget that this is a plugin 2.1.5 issue as well - I really do
not think that JasperSoft fixed their problem - or maybe not in this
release of the JasperSoft 3.5.2
Behavioural difference.
Noticed that when using the viewer to save the file as a xls (single
or multi-sheet) that a file is created with 0 size. When I request the
plugin to output directly to the file type xls there is not even an
empty file!
I tried this with the 3.0.0a1 plugin as well as my own buidl of 2.1.5
with my own minor enhancements and get the same result.
Should I try to NOT install the servoy provided excel output in case
there is a jar version issue?
Tom
On Jun 15, 5:34 am, andrei_costache <andreicostache1...@gmail.com>
wrote:
> Are you getting any stack-trace related to this error? If yes, could
> you please post it?
> Regards,
> Andrei
> On Jun 15, 1:00 am, TomParry <TomParry.h...@gmail.com> wrote:
> > Patrick
> > > About your point 2.
> > to use Excel format you need to update jakarta POI located in plugins/
> > jakarta-poi to the one included in iReport 3.5.2 (poi-3.2-
> > FINAL-20081019.jar in your JasperSoft/iReport-nb-3.5.2/ireport/modules/
> > ext folder).
> > > It works!
> > NOT! Not in 3.5.9 anyway. I even include jxl-2.6.jar and there was
> > only a file created with 0 bytes length!
> > I had tried the poi in my second round of testing to no avail - and
> > then I saw your message and copied the same file from the iReport lib
> > (ext as you said) just in case my download was not the same.
> > This is the same behaviour as was reported ages ago and the fix was
> > thought to have been put in by JasperSoft but it appears not yet.
> > I do not have the same access denied error as you do for my files -
> > they are all created ok (using 3.5.9 of course!).
Success! This is for the Servoy 3.5.9 version:
I finally got the output to xls to work.
When I removed the /plugins/excelxport.jar and /plugins/
excelxport.jar.jnlp files and restarted the server my application
could not finish the startup process at all.
So I put them back then edited the /plugin/excelxport.jar.jnlp file to
specify the same poi in: /plugins/jakarta-poi/poi-3.2-
FINAL-20081019.jar
and restarted the server. Now all references to the poi have the same
target version. This is similar to the advice given by Patrick - I
just did not change the excelxport jnlp file at all prior to this not
expecting a collision - I had only changed the file in the jakarta-poi
directory.
In the smart client the jasper viewer save as to single sheet xls as
well as multi-sheet xls now works.
Perhaps Patricj could test this in the Servoy 4.x?
However the output directly via the plugin still does not produce a
file at all. Something else wrong there.
Tom
On Jun 15, 11:51 am, TomParry <TomParry.h...@gmail.com> wrote:
> I start the server using the standard server.bat (3.5.9 on winxp). I
> do not get ANY log file errors nor any stack trace. The bat file does
> have the -DSTACKTRACE=true in the command line.
> Do not forget that this is a plugin 2.1.5 issue as well - I really do
> not think that JasperSoft fixed their problem - or maybe not in this
> release of the JasperSoft 3.5.2
> Behavioural difference.
> Noticed that when using the viewer to save the file as a xls (single
> or multi-sheet) that a file is created with 0 size. When I request the
> plugin to output directly to the file type xls there is not even an
> empty file!
> I tried this with the 3.0.0a1 plugin as well as my own buidl of 2.1.5
> with my own minor enhancements and get the same result.
> Should I try to NOT install the servoy provided excel output in case
> there is a jar version issue?
> Tom
> On Jun 15, 5:34 am, andrei_costache <andreicostache1...@gmail.com>
> wrote:
> > Hi Tom,
> > Are you getting any stack-trace related to this error? If yes, could
> > you please post it?
> > Regards,
> > Andrei
> > On Jun 15, 1:00 am, TomParry <TomParry.h...@gmail.com> wrote:
> > > Patrick
> > > > About your point 2.
> > > to use Excel format you need to update jakarta POI located in plugins/
> > > jakarta-poi to the one included in iReport 3.5.2 (poi-3.2-
> > > FINAL-20081019.jar in your JasperSoft/iReport-nb-3.5.2/ireport/modules/
> > > ext folder).
> > > > It works!
> > > NOT! Not in 3.5.9 anyway. I even include jxl-2.6.jar and there was
> > > only a file created with 0 bytes length!
> > > I had tried the poi in my second round of testing to no avail - and
> > > then I saw your message and copied the same file from the iReport lib
> > > (ext as you said) just in case my download was not the same.
> > > This is the same behaviour as was reported ages ago and the fix was
> > > thought to have been put in by JasperSoft but it appears not yet.
> > > I do not have the same access denied error as you do for my files -
> > > they are all created ok (using 3.5.9 of course!).
I thought I did mention that I completely replaced the /plugins/jakarta-poi/ POI jar with the new one, which leads to other problems: mainly not being able to export again with the regular Servoy export. Sorry, if I forgot mentioning it.
Then again, it's true that having 2 different version of the same library is bound to give you problems!
Anyway now it remains to Servoy to update the export plugin to the new version. We need both functionalities!
For the rest, I have the same results here: output using the "view" option is fine, output with direct format is not working.
Patrick
----- Mail Original -----
De: "TomParry" <TomParry.h...@gmail.com>
Ą: "servoy-jasperreports-plugin" <servoy-jasperreports-plugin@googlegroups.com>
Envoyé: Lundi 15 Juin 2009 12h58:52 GMT -05:00 USA/Canada - États de l'Est
Objet: [servoy-jasperreports-plugin:27] Re: First 3.0.0 alpha available
Success! This is for the Servoy 3.5.9 version:
I finally got the output to xls to work.
When I removed the /plugins/excelxport.jar and /plugins/
excelxport.jar.jnlp files and restarted the server my application
could not finish the startup process at all.
So I put them back then edited the /plugin/excelxport.jar.jnlp file to
specify the same poi in: /plugins/jakarta-poi/poi-3.2-
FINAL-20081019.jar
and restarted the server. Now all references to the poi have the same
target version. This is similar to the advice given by Patrick - I
just did not change the excelxport jnlp file at all prior to this not
expecting a collision - I had only changed the file in the jakarta-poi
directory.
In the smart client the jasper viewer save as to single sheet xls as
well as multi-sheet xls now works.
Perhaps Patricj could test this in the Servoy 4.x?
However the output directly via the plugin still does not produce a
file at all. Something else wrong there.
Tom
On Jun 15, 11:51 am, TomParry <TomParry.h...@gmail.com> wrote:
> I start the server using the standard server.bat (3.5.9 on winxp). I
> do not get ANY log file errors nor any stack trace. The bat file does
> have the -DSTACKTRACE=true in the command line.
> Do not forget that this is a plugin 2.1.5 issue as well - I really do
> not think that JasperSoft fixed their problem - or maybe not in this
> release of the JasperSoft 3.5.2
> Behavioural difference.
> Noticed that when using the viewer to save the file as a xls (single
> or multi-sheet) that a file is created with 0 size. When I request the
> plugin to output directly to the file type xls there is not even an
> empty file!
> I tried this with the 3.0.0a1 plugin as well as my own buidl of 2.1.5
> with my own minor enhancements and get the same result.
> Should I try to NOT install the servoy provided excel output in case
> there is a jar version issue?
> Tom
> On Jun 15, 5:34 am, andrei_costache <andreicostache1...@gmail.com>
> wrote:
> > Hi Tom,
> > Are you getting any stack-trace related to this error? If yes, could
> > you please post it?
> > Regards,
> > Andrei
> > On Jun 15, 1:00 am, TomParry <TomParry.h...@gmail.com> wrote:
> > > Patrick
> > > > About your point 2.
> > > to use Excel format you need to update jakarta POI located in plugins/
> > > jakarta-poi to the one included in iReport 3.5.2 (poi-3.2-
> > > FINAL-20081019.jar in your JasperSoft/iReport-nb-3.5.2/ireport/modules/
> > > ext folder).
> > > > It works!
> > > NOT! Not in 3.5.9 anyway. I even include jxl-2.6.jar and there was
> > > only a file created with 0 bytes length!
> > > I had tried the poi in my second round of testing to no avail - and
> > > then I saw your message and copied the same file from the iReport lib
> > > (ext as you said) just in case my download was not the same.
> > > This is the same behaviour as was reported ages ago and the fix was
> > > thought to have been put in by JasperSoft but it appears not yet.
> > > I do not have the same access denied error as you do for my files -
> > > they are all created ok (using 3.5.9 of course!).
For Tom -> could you please explain a bit what you mean here: "However
the output directly via the plugin still does not produce a
file at all. Something else wrong there" ? (do you mean directly via
the Servoy Jasper Report plugin?).
For Patrick -> the issue with the 2 functionalities needed will be
fixed in the next public release of Servoy;
-> by "output with direct format is not working"
you mean the same thing that Tom is mentioning above, yes?
For Tom -> could you please explain a bit what you mean here: "However
the output directly via the plugin still does not produce a
file at all. Something else wrong there" ? (do you mean directly via
the Servoy Jasper Report plugin?).
For Patrick -> the issue with the 2 functionalities needed will be
fixed in the next public release of Servoy;
-> by "output with direct format is not working"
you mean the same thing that Tom is mentioning above, yes?
Good to hear that the fix will be included in the next release. Will that be "Tano" 4.2 or will there be maintenance release before that?
And yes, I have the same thing as Robert: no output at all when using any other options than "view", no xls, no pdf etc... A difference is that I noticed that I have an AccessDenied thrown by the plugin when trying to write the output in my jasper folder (but I don't how this happens, it was not giving any access problems with previous version and I am admin of my PC!)
Patrick
----- Mail Original -----
De: "andreicostache1986" <andreicostache1...@gmail.com>
Ą: "servoy-jasperreports-plugin" <servoy-jasperreports-plugin@googlegroups.com>
Envoyé: Mardi 16 Juin 2009 04h41:29 GMT -05:00 USA/Canada - États de l'Est
Objet: [servoy-jasperreports-plugin:29] Re: First 3.0.0 alpha available
Hello!
For Tom -> could you please explain a bit what you mean here: "However
the output directly via the plugin still does not produce a
file at all. Something else wrong there" ? (do you mean directly via
the Servoy Jasper Report plugin?).
For Patrick -> the issue with the 2 functionalities needed will be
fixed in the next public release of Servoy;
-> by "output with direct format is not working"
you mean the same thing that Tom is mentioning above, yes?
The fixes will included in Servoy 3.5.10 and 4.1.4.
Concerning the output problems, I managed to get pdf output just by
replacing the old itext jar, in the pdf_output folder of the plugins
directory, with iText-2.1.0.
> Good to hear that the fix will be included in the next release. Will that be "Tano" 4.2 or will there be maintenance release before that?
> And yes, I have the same thing as Robert: no output at all when using any other options than "view", no xls, no pdf etc...
> A difference is that I noticed that I have an AccessDenied thrown by the plugin when trying to write the output in my jasper folder (but I don't how this happens, it was not giving any access problems with previous version and I am admin of my PC!)
For Andrei,
To clarify the no put using the "direct" route means use the plugin
to specify an output file path and file type. For example, specify a
temp file using the plugin.file.createTempFile and a file output type
of "pdf" should dump the pdf output to the file specified. No output
file is created (not even a file with zero bytes).
Yes I do download the lates tiText-2.1.0.jar in the jnlp. I also
looked for the use of iText anywhere else in the Servoy folders and if
any found replaced them also (I cannot remember if there is another
place).
Perhap's Patrick's access denied error is that he specifies a file on
the client machine that does have restricted access rights when the
plugin executes on the client? Perhaps he could specify a file that is
in a known (none-user) directory?
Andrei please tell us your interface when getting the successful pdf
output to file.
For Andrei,
To clarify the no put using the "direct" route means use the plugin
to specify an output file path and file type. For example, specify a
temp file using the plugin.file.createTempFile and a file output type
of "pdf" should dump the pdf output to the file specified. No output
file is created (not even a file with zero bytes).
Yes I do download the lates tiText-2.1.0.jar in the jnlp. I also
looked for the use of iText anywhere else in the Servoy folders and if
any found replaced them also (I cannot remember if there is another
place).
Perhap's Patrick's access denied error is that he specifies a file on
the client machine that does have restricted access rights when the
plugin executes on the client? Perhaps he could specify a file that is
in a known (none-user) directory?
Andrei please tell us your interface when getting the successful pdf
output to file.
I think I also use the same "way" to achieve direct output, as you
indicated; I am giving a code sample of what I understood from you as
being direct output (please correct me if I am wrong). This code
sample works for me and gives correct pdf output; this code works in
Servoy 3.5.9:
I am not sure I understand what you mean by "interface when getting
the successful pdf output to file". Do you mean my plug-in interface
(or something else)?
I think I also use the same "way" to achieve direct output, as you
indicated; I am giving a code sample of what I understood from you as
being direct output (please correct me if I am wrong). This code
sample works for me and gives correct pdf output; this code works in
Servoy 3.5.9:
I am not sure I understand what you mean by "interface when getting
the successful pdf output to file". Do you mean my plug-in interface
(or something else)?
Here is my code snippet to call for output directly:
var serverName = controller.getServerName();
var reportName = 'classic_tom_test3_params.jrxml';//but really filled
in by user from a FID - get same result if ends in .jasper - ie no
compile
var varOutput = globals.PITC_jasper_export_file;//filled from a FID
where user sets the filename from a selector dialog so in smart client
it is on the client machine
var outputFormat = globals.PITC_jasper_export_type;//default = 'view'
but set up by user to 'pdf' etc
var locale = null;
try {
var result = plugins.jasperPluginRMI.jasperReport(serverName,
reportName, varOutput, outputFormat, reportParameters, locale );
} catch (e) {
msg = "PITC_printJasperReport: DEBUG: Exception from plugin: "
if (e == undefined) {
msg += "exception 'e' is undefined";
}
else if (e.message == undefined){
msg += "exception message is undefined";
}
else {
msg += "message: <" + e.message + ">";
}
I am expecting a byte array to be returned when output is to a file
but instead I get an exception sometimes where the exception is
undefined. Other times I get nothing in logs and NO file created.
Mike Sedita tested this also in 4.x and with effort on the jugglng of
jar files he has success in getting the Jasper viewer up and running.
See his post here on the forum for the jnlp file that he came up with
eventually.
Issue is printing from the Jasper Viewer on MAC.
q1. is this same on the windows platform?
q2. is there a missing jar to be downloaded for printing when in the
smart client?
