JasperReports Plug In Now Available

Classic Servoy
1

JasperReports is one of the most widely-accepted open source tools used worldwide to design and deploy powerful reports. (Think CrystalReports - but open source). The NEW Servoy Jasper Plugin can help you to extend the JasperReports functionality to your Servoy solutions.

Due to the positive response from the first Servoy JasperReports Training and Plugin sessions given in the US and Europe, Servoy will be offering an ONLINE version of the Servoy JasperReports Training.

Until February 28, you can pre-order the Servoy JasperReports Flash Tutorial Series and save $500 US off the regular price! After February 28, the Servoy JasperReports Training Bundle – including the on-line tutorials, the Servoy JasperReports Plugin and unlimited deployment license – will be $2000 US.

To pre-order the special Servoy JasperReports Training Bundle today, please visit the Servoy Store https://secure.servoy.com/

You can also contact Aaron Archer, our newest Business Development Team Member in the USA at aarcher@servoy.com if you have questions and/or want help to place your order.

2

Maybe my question is a little bit late …

But can we have a flash movie as a demonstration (not a tutorial) about this plug-in?

3

MSibai:
Maybe my question is a little bit late …

But can we have a flash movie as a demonstration (not a tutorial) about this plug-in?

Good point - it would be very interesting to see a demo of what the capabilities of Jasper Reports are in Servoy before committing $2k

Gordon

4

As of Servoy 4.0, the plugin is open sourced. Visit the project page at: Google Code Archive - Long-term storage for Google Code Project Hosting. for the latest version, to register issues and feature requests or to download the source and contribute to the project.

Regards,

Paul

5

Could you make downloads of the JasperReports Plugin based on newer versions of Jasper Reports available on the download pages.
The current version of Jasper is 3.7.1 and that version also uses newer versions of related modules (iText, POI)
So in that case it would keep versions of the plugin together with the version of Jasper.

Now I have situation that the plugin is based on Jasper 3.6 while I had to update Jasper to 3.7.1 because of a bug in Jasper, but now it looks like my report isn’t working anymore when running from Servoy.
If you keep the download available for each new version, maybe it can avoid compatability problems.
Maybe a recompile of the plugin with the modules based on Jasper 3.7.1 could solve problems like this

6

From the post before yours:

Visit the project page at: http://code.google.com/p/servoy-jasperreports-plugin for the latest version, to register issues and feature requests

7

see my post on this thread: viewtopic.php?p=72890#p72890

Rob

8

Nothing happend in this thread since 1,5 years!
What about deleting this useless posting? ;-)

9

I have a question, how can I pass a parameter to the iReport? I want a report transaction, but I want to take account transactions that are selected in Servo Combobox.

I do so.

var o = new Object ();
o.pcustomerid = forms.main.transacao_to_conta.id_conta;
plugins.jasperPluginRMI.runReport (‘servoy_money’, ‘contaTrans.jrxml’, null, ‘view’, {Pcustomerid: forms.main.transacao_to_conta.id_conta});

parameter created in iReport, but do not know if I missed something in the configuration

10

This should work, Of course the parameter in iReport must be named as pcustomerid and created with the same variable type

var o = {pcustomerid : forms.main.transacao_to_conta.id_conta};
plugins.jasperPluginRMI.runReport ('servoy_money', 'contaTrans.jrxml', null, 'view', o)
11

In Servoy the parameter is an Object? in iReport it has to be an object too, there’s more on the purchase incompatibility with the id?

12

Brasil, you are sending an object with parameters, each property in the object is the parameter that iReport receives. From you sample I guess id_conta is an integer or a UUID.

13

is an integer id_conta

14

iReport parameter in the Value Expression defaul option I have to put something?

15

Set the property Parameter Class to java.lang.Integer

16

Thanks jasantana
All that you passed I had already set up, had an error in the SQL query that after I insert more data I got indentificar

17

I have viewed the Servoy webinar on Jasper Reports (2018 I believe)…

It was not clear how you link JasperSoft Reporting Design Tool to the Servoy Project/Data during design.

Hoping you can point me in the right direction.

Daryl()

18

Hi Daryl(),

That is actually really easy nowadays thanks to the boys and girls behind the JasperSoft plugin. If you have the plugin in your plugins folder you can run a report like this:

Preview (shows an onscreen preview in smart client and downloads a pdf in NG-Client):

plugins.jasperPluginRMI.runReport(datasource, 'myReport.jrxml', '', plugins.jasperPluginRMI.OUTPUT_FORMAT.VIEW, [])

The datasource can be a foundset, a dataset or a viewset. A viewset is very convenient when you need data from multiple tables. Define fields in your report that match the name of your data.

To output to a printer (SmartClient only) just change the output and if you want to print to a specific printer change the output options:

plugins.jasperPluginRMI.runReport(reportDataSource, report, 'EPSON ET-2720', plugins.jasperPluginRMI.OUTPUT_FORMAT.PRINT, parameters)

You can output to CSV, DOC, XLS, XLSX, HTML, PDF, PRINT, RTF, TXT and XML.

Parameters are very convenient as well, just pass them in something like this (don’ forget to define them in your report as a parameter as well using the same parameter name):

parameters = {'userName': security.getUserName(), 'nameField': foundset.name, 'someVar': someVar}

To change the locale of your report you can add an extra locale parameter. In Servoy Admin under Server plugins specify where your reports are located in the dedicated field for that. That’s it!

19

Omar,

Thanks for your generous information!

I must not be stating this quite well enough: I am asking about how to configure JasperSoft - to communicate with a Servoy foundset or dataset - from within the JasperSoft IDE - e.g. how to configure the JasperSoft IDE to communicate with SERVOY whilst building the reports.

The execution environment inside SERVOY, seems well documented. It is the communication between JasperSoft whilst creating or modifying reports in JasperSoft that I am not finding out how to configure.

Hope this is clearer,

Thanks again for your patience.

Daryl

20

Hi Daryl,

I understand. The way you describe, is the old way of doing it, which gave less control because you had to define long SQL statements to get your data. I guess if you really want to, you can still do that. In that way you don’t communicate with Servoy, just with the database. In the way I described it, Servoy feeds the report the data connections it needs and you test it by running the report from Servoy and not from JasperSoft Studio. Can you explain why you want to do it this way or is your expectation pointing you in the wrong direction?