Giulio Toffoli

Hi David, please refer to this post to solve the issue: https://community.jaspersoft.com/forums/topic/68153-connection-to-the-jaspersoft-studio-community-edition/?do=findComment&comment=162042 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

Check this post if it can help you: https://community.jaspersoft.com/forums/topic/68153-connection-to-the-jaspersoft-studio-community-edition/?do=findComment&comment=162042

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 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. 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: connect This 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_exclude Hope this helps, Giulio get_certificate.mov

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

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 table.mp4

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 helps Giulio

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