-
Posts
619 -
Joined
-
Last visited
-
Days Won
4
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Posts posted by Giulio Toffoli
-
-
Hi Shreekrishna, JasperReports Web Studio 3.0 is shipped with JasperReports Library jasperreports-6.21.0.jar and jasperreports-pro-9.0.0.jar
Giulio
-
Hi David, please refer to this post to solve the issue:
javax.net.ssl.SSLHandshakeException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
This error happens if the community.jaspersoft.com certificate cannot be recognised by Java. This is pretty uncommon, since the CA of the certificate is provided by Amazon RSA. To resolve this problem, the certificate can be added to the Java cacerts file.
The instructions may change a little bit depending by the system but in general are these:
1. download the certificate with the browser. The video below shows how to do it in Chrome:
2. import the certificate by using this command:
<JAVA_HOME>/bin/keytool -importcert -alias jaspersoft.com -keystore <JAVA_HOME>/lib/security/cacerts -file _.jaspersoft.com.cer
On Mac you may need to use sudo to run this command as admin:
sudo keytool -importcert -alias jaspersoft.com -keystore <JAVA_HOME>/lib/security/cacerts -file community.jaspersoft.com.cer
community.jaspersoft.com.cer is the certificate downloaded with the browser at point 1.The cert store default password is "changeit".
Hope this helps
Giulio
-
-
Hi Goorweather,
you can download Jaspersoft Studio CE here:
https://community.jaspersoft.com/download-jaspersoft/community-edition/
After the installation, you can refer to this video tutorial to create your first report:What to do with the report you create? The report itself is represented by a jrxml file (and eventually other resources such as images, subreports, etc...). The answer to this question depends by your use case, you may already have an application that requires you to provide a jrxml, or you may want to write your own application by using JasperReports Library.
If you simply plan to run the reports without using other software and without writing your own one, then JasperReports Server is what you need. It is a web application in which you can load your reports and run them (with the ability to create input controls to get parameters that your reports may require to run, and setup all the connections to get the data for your reports). Of course JasperReports server does much more than that.
JasperReports Server can be downloaded here:
https://community.jaspersoft.com/download-jaspersoft/commercial-edition/As you just discovered, it is a commercial product, but you can download a 30 days free trial.
Hope this helps.
Giulio
-
Hi all,
This little guide should help people having issues with the login dialog in Jaspersoft Studio.
javax.net.ssl.SSLHandshakeException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested targetThis error happens if the community.jaspersoft.com certificate cannot be recognised by Java. This is pretty uncommon, since the CA of the certificate is provided by Amazon RSA. To resolve this problem, the certificate can be added to the Java cacerts file.
To do it:
1. download the certificate with the browser. The video below shows how to do it in Chrome:
2. import the certificate by using this command:
<JAVA_HOME>/bin/keytool -importcert -alias jaspersoft.com -keystore <JAVA_HOME>/lib/security/cacerts -file _.jaspersoft.com.cer
On Mac you may need to use sudo to run this command as admin:
sudo keytool -importcert -alias jaspersoft.com -keystore <JAVA_HOME>/lib/security/cacerts -file community.jaspersoft.com.cer
community.jaspersoft.com.cer is the certificate downloaded with the browser at point 1.
org.apache.http.conn.HttpHostConnectException: Connect to community.jaspersoft.com:443 [community.jaspersoft.com/54.192.95.8, community.jaspersoft.com/54.192.95.70, community.jaspersoft.com/54.192.95.116, community.jaspersoft.com/54.192.95.61] failed: Connection timed out: connectThis issue is related to a network being blocked by either a proxy or a firewall, you should check the problem with your system administrator.
To verify the issue, try to ping the community website from a command prompt or terminal.
The result should be something like:
ping community.jaspersoft.com
PING i328763.invisionservice.com (54.192.95.116): 56 data bytes
64 bytes from 54.192.95.116: icmp_seq=0 ttl=244 time=36.161 ms
64 bytes from 54.192.95.116: icmp_seq=1 ttl=244 time=31.265 ms
java.net.UnknownHostException: unknown host (community.jaspersoft.com)
This issue is related to a network with a private DNS which filters hosts resolution.
Can be easily verified by running the command in a command prompt or terminal:
nslookup community.jaspersoft.com
and verify that the domain can be resolved or not.
The issue can be solved by either set (at least temporarily) the DNS of the machine to 8.8.8.8 (Google DNS), or by modifying the file hosts (on mac /etc/hosts, on windows c:\Windows\System32\Drivers\etc\hosts) by adding the following line:
54.192.95.70 community.jaspersoft.com
How to configure Jaspersoft Studio to use a proxy
To specify proxy settings in Jaspersoft Studio, you need to modify the file "Jaspersoft Studio.ini" by setting the following java system properties:
http.proxyHost
http.proxyPort
http.nonProxyHosts
It can by done by adding lines at the end of the INI file with a text editor:
...
-Dhttp.proxyHost=example.proxy.host
-Dhttp.proxyHost=123
-Dhttp.proxyHost=some_host_to_excludeHope this helps,
Giulio
- 3
-
Hi Dušák, are you able to connect to the community with a regular browser from the same machine?
-
Hi Barbara, are you able to access the community website with a browser,? Are you behind a proxy? What OS are you using?
This information would help use to understand the problem.Thank you
Giulio
-
Hi Mlynarek, could you provide some info about your system? OS? Are you using a proxy?
The error is about your java installation not being able to validate the community.jasperosft.com.Giulio
-
Hi Dila, thank you for your message.
You can use the latest version of Jaspersoft Studio to create jrxml compatible with any version of JasperReports. To be sure that the produced jrxml will work with your specific JasperReports version, set the Jaspersoft Studio compatibility from the Preferences:
About the zip version of Jaspersoft Studio CE 6.21.1, this is definitively something we can provide in the set of available downloads.
Hope this helps
Giulio
- 1
-
When you switch to the source tab, you are looking at what the file would look like if saved, not the content of the actual loaded file. The source shown in the tab is generated on the fly based on the current model in the designer. You can easily check this by adding a comment to your jrxml with a text editor and load the jrxml in the designer, you will see that in the tab source your comment is gone.
The comment show in the source tab will be save only if you save the file.
There is currently no reliable way to check with which version of JRL a jrxml or as jasper file has been created. If you need this information, you can still store it in a report property and read it with JasperReports itself. -
Hi Oscar, could you provide some more info about your system/OS? Are you using the JVM shipped with Jaspersoft Studio? Thanks.
-
I know this is an old post, but still worth replying.
In the table section of the properties, you can find two options:
- Fit columns to table element: this will fill the table with your columns
- Resize the columns taking the space from the next one: this prevents to change the table element size while resizing columns
Hope this helps
Giulio- 1
-
Hi Max92
You get an empty report because you did not provide any data to your report. JasperReports requires data to fill the report.
When no data is provided, you can decide what to do. The default behaviour is to produce an empty report, which is what you get.
At report level you have an option to set this behaviour:
You can use All Sections No Detail to print at least the title.
The "detail band" section is repeated for each record of your data, but when no data is provided, this band will be skipped.
To provide data, you need to create first a Data Adapter, JasperReports Web Studio supports a variety of data source types. From the repository, click on New and select New Data Adapter.
I suggest you to start with a simple CSV file, for example.
Once you have created the Data Adapter, you can use it in your report. To do it, go to the Dataset panel in the report designer and select your data adapter.
The report will now use the data adapter to fetch the data, what you still need to do is defining a query (for CSV will be empty), and defining the fields you are going to use in the report: click on the Show Query Editor switch to show the Query Editor. For CSV simply click on Read Fields button, and your fields will be added to the list of fields available for the report.
To get started, I suggest you to watch this Dr. Jasper video:
Hope this helpsGiulio
- 2
-
Another possible error could be the way you are referencing the subreport:
C://xampp//htdocs//gerador_relatorio//gerenciamentoCargas//relatorio_sub.jrxml
You should point to the jasper file, not to the jrxml file (which is the source that needs to be compiled into a jasper file). -
I would try to remove the jasper file of the subreport and recompile it with the same compiler you used to compile the master report.
Be aware that Jaspersoft Studio may not always compile the subreports for you, or simply it does not do it if it is not necessary (i.e. the jasper is up-to-date respect to the jrxml).
Since phpjasper will be your running environment, I would use it also to (re)compile all your jrxml files.Giulio
-
Hi Deadsploid, there is not a way to dynamically specify which data source should be used to run a report in JasperReports Server.
Not sure where you have found this jdbc_datasource parameter, but it may have been part of a more complex example showing how a JDBC datasource can be configured in such a way where attributes of the user profile that runs the report can be used to drive particular behaviours, i.e. by specifying which database the data source should connect to based on that user profile.In general the data source used to run the report (or better a Report Unit), is stored as part of the report unit itself.
Hope this helps,
Giulio
-
The CDATA is the syntax used in XML to escape entire portions of of XML, and it has nothing to do with the error you are getting.
To understand exactly what's the problem with your expression, we would need to check the full stack trace (or test your report in Jaspersoft Studio, as suggested in the previous answer). I don't see any syntactical error (in other words your jrxml is ok), but it could be that the type of the parameter memberid defined in the subdataset is not of type java.util.List (which is how the parameter is defined in the main dataset).
Giulio
-
Hi Vikkumarash, it sounds like you are trying to use a JasperReports (which is a java library) with C# (.NET). This will not work.
An option to use JasperReports with a non-java project is to use JasperReports IO e its REST Api.https://community.jaspersoft.com/project/jasperreports-io
Thank you
Giulio
-
Hi Saiteja, once the report is generated, the result will be a document (i.e. a PDF file) with the same page size as the one you specified in the jrxml. When you print this document, if its size differs from the paper size used by your printer (A4 is slightly higher than Letter, which is wider), usually the system printer dialog will ask you if you want to fit the page.
There is no possibility to "lose" data or change the layout just by printing a document on a different media size, since the report is generated always accordingly to the page size specified at design time.Thank you,
Giulio
-
First of all, iReport will remain always available for download, it is just not getting updated, and it does not support the most recent JasperReports additions. You have two options: keep using iReport (without using the newest features of jasperreports) or move to Jaspersoft Studio, which works as standalone applications or as plugin for Eclipse.
-
Hi Pete,
it is a bug in Jaspersoft Studio, now solved. You can wait for Jaspersoft Studio 6.2.1 or download a snapshot from source forge of a beta release.
Thank you!
Giulio
-
Hi jvmolto,
the syntax of your query seems ok, what's the problem with Jaspersoft Studio? If the syntax highlighting suggests an error, you can ignore it, the query should work normally anyway.
Thanks
Giulio
-
Hi Haidar, the Font extension you are using seems to work well, I was able to produce a report and export it to PDF without problems.
May we see your jrxml?
Thanks
Giulio
-
There is not a plugin for NetBeans of Jaspersoft Studio, and there will not be one. Jaspersoft Studio is based on Eclipse.
Thanks
Giulio
Upgrade from iReport Designer 4.5.1
in Products
Posted
Jaspersoft Studio allows to save jrxml compatible for a specific version of jasperreports:
The version you want be compatible with can be set for both jrxml and .jasper
Jaspersoft Studio is the evolution of iReport, and contains many additional features that will make your life easier, and you can still go back and forward, since the common base for both the tools is the JRXML file format.
Giulio